bhtech.com
Blue Hills Technology Corporation
http://www.bhtech.com/oracle.htm
Oracle Online Support Page. Oracle DBA Online Forum. Oracle Corporation FTP Site. Oracle Technet FTP site. Oracle Technet Software Download. Documentation and Tech Resources. Try Our Web-Based Database Object Sizing Tool. Blue Hills Technology Corporation. Milton, MA 02186. Tel: 617.696.2422 webmaster@bhtech.com.
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: Migrate AOL objects from one environment to another environment using FNDLOAD
http://dbafix.blogspot.com/2013/09/migrate-aol-objects-from-one.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Migrate AOL objects from one environment to another environment using FNDLOAD. To FNDLOAD Concurrent Programs. FNDLOAD apps/$CLIENT APPS PWD O Y DOWNLOAD $FND TOP/patch/115/import/afcpprog.lct XX CUSTOM ORACLE INTERFACE PROG.ldt PROGRAM APPLICATION SHORT NAME="XXGMS" CONCURRENT PROGRAM NAME="XX CUSTOM ORACLE INTERFACE PROG". XX CUSTOM ORACLE INTERFACE PROG. Well, lets be clear here, the a...
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: Unable to determine SMTP server to use: set FND_SMTP_HOST
http://dbafix.blogspot.com/2014/03/unable-to-determine-smtp-server-to-use.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Unable to determine SMTP server to use: set FND SMTP HOST. Outpost Processor has encountered the below error. This error can be found in OPP logs:. GC 14000K- 8905K(20284K), 0.0074280 secs]. ProcessorException: Unable to determine SMTP server to use: set FND SMTP HOST. At oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66). 2 Navigate to Profile - System.
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: Oracle 11.2.0.3 Upgrade from 10.2.0.4 Database
http://dbafix.blogspot.com/2013/03/oracle-11203-upgrade-from-10204-database.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Oracle 11.2.0.3 Upgrade from 10.2.0.4 Database. Oracle 11.2.0.3 Upgrade from 10.2.0.4 Database. Current database version is 10.2.0.4.0 64 Bit. Install 11.2.0.3 Software on current server. Direct upgrade to 11.2.0.3 Patch Set 2. 2 Download 11.2.0.3 software. Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER. P10404530 112030 Linux-x86-64 1of7.zip 1.3 GB. 4 Set Oracle Inventory.
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: ORACLE RAC ON/RAC OFF
http://dbafix.blogspot.com/2010/01/oracle-rac-onrac-off.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. ORACLE RAC ON/RAC OFF. Oracle's RAC: ON and OFF. Use the following steps to disable RAC (known as RAC OFF):. 1 Log in as the Oracle software owner (which is typically the UNIX account oracle) in all nodes. 2 Shut down all the instances from all the nodes using a NORMAL or IMMEDIATE option. 3 Change the working directory to $ORACLE HOME/rdbms/lib: cd $ORACLE HOME/rdbms/lib. 1 Log in as the...
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: sys.utl_recomp.recomp_parallel(20); is failing with "ORA-00955: name is already used by an existing object"
http://dbafix.blogspot.com/2012/02/sysutlrecomprecompparallel20-is-failing.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Sysutl recomp.recomp parallel(20); is failing with "ORA-00955: name is already used by an existing object". The utl recomp package errors out trying to compile invalids. SQL exec sys.utl recomp.recomp parallel(20);. BEGIN SYS.UTL RECOMP.RECOMP PARALLEL;END;. ERROR at line 1:. ORA-00955: name is already used by an existing object. ORA-06512: at "SYS.UTL RECOMP", line 662. Oracle DBA - Wait...
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: Find out APPS/SYSADMIN password in Oracle Apps R12 if you lost or forgotten
http://dbafix.blogspot.com/2014/04/find-out-appssysadmin-password-in.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Find out APPS/SYSADMIN password in Oracle Apps R12 if you lost or forgotten. Step to Find APPS PASSWORD :. Sqlplus sqlplus system/system password. Sqlplus / as sysdba. Create Function to decrypt the encrypted password. Set linesize 200 long 300. SQL select ENCRYPTED FOUNDATION PASSWORD from apps.fnd user where USER NAME='GUEST';. Get the Apps password using encrypted guest password. 2 3 (...
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: What is High Water Mark in Oracle?
http://dbafix.blogspot.com/2009/01/what-is-high-water-mark-in-oracle.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. What is High Water Mark in Oracle? What is High Water Mark in Oracle? 1 High water mark is the maximum amount of database blocks used so far by a segment. This mark cannot be reset by delete operations. 2 Delete Table operation won't reset HWM. 3 TRUNCATE will reset HWM. 4 The high water mark level is just a line separate the used blocks and free blocks. Subscribe to: Post Comments (Atom).
dbafix.blogspot.com
Oracle DBA - Oracle Apps DBA Instant Solutions: "Error Occurred While Attempting to Establish an Applications File Server Connection"
http://dbafix.blogspot.com/2010/08/error-occurred-while-attempting-to.html
Oracle DBA - Oracle Apps DBA Instant Solutions. Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA. Error Occurred While Attempting to Establish an Applications File Server Connection". An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running on. 1 Is this a Multinode Install or a Single Node Install. Ps -ef grep tnslsnr. That is the Database Listener. The FNDFS listener n...