Oracle Application DBA

tmp folder 100 percent full in Linux Applies to: I am using:  Red Hat Enterprise Linux 5.5 Oracle Application Install - Version: 11.5.10.0 and later Description: I recently came across a problem where the /tmp folder was listed as 100% full: [root@prodapps01 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/cciss/c0d0p2     9.7G  4.2G  5.1G  46% / /dev/cciss/c0d0p8     2.0G  152M  1.7G   9% /home /dev/cciss/c0d0p7     3.9G  3.9G  0M  100% /tmp /dev/cciss/c0d0p6     7.8G  334M  7.1G   5% /var /dev/cciss/c0d0p5      12G  3.2G  7.9G  29% /usr /dev/cciss/c0d0p1     494M   32M  437M   7% /boot Strangely, there were no files in the /tmp folder. This is how it happens. If you delete files from a folder and they still show up when you check a df -h disk status, then the deleted files are linked to currently running processes. You will have to stop or restart the processes that had those files open in the first place. lsof | g

Adapcctl.Sh: Exiting With Status 1 Applies to: Oracle Applications Technology Stack - Version: 11.5.10.2 Description: When attempting to stop Apache using adapcctl.sh, the following error occurs: ERROR Service can not be stopped using this script After doing some research work I found that the issue is caused by the following setup: $IAS_ORACLE_HOME/Apache/Apache/logs/ directory contained both httpd.pid and apache_runmode.properties Files httpd.pid and httpd_pls.pid gets created when Apache is started in NORMAL mode. File apache_runmode.properties gets created when Apache is started in RESTRICTED mode. As both kind of files are present in Logs directory, adapcctl.sh script thinks Apache cannot be started in both modes and fails to stop. Solution: To implement the solution, please execute the following steps: 1. Stop Apache / Kill all httpd processes if exists any. 2. Backup $IAS_ORACLE_HOME/Apache/Apache/logs 3. Delete all files under $IAS_OR

All Receiving Transactions Fail with rvtptcontrol Error Applies to: Oracle Application Install - Version: 11.5.10.0 and later. Oracle Inventory Management - Version: 11.5.1 to 12.1.3 Description: All Receiving transactions fail with rvtptcontrol. After some research work I found that the error occurs when many transactions fail with same error it is usually because the receiving executables (RVCTP and RCVOLTM) are out of sync. Solution: 1.       Resolve INVALID Objects 1.1   Set environment 1.2   cd $ORACLE_HOME/rdbms/admin 1.3   sqlplus / as sysdba 1.4   SQL>@utlrp.sql 2.       Relink Receiving executables 2.1   cd $AD_TOP/bin 2.2   sh adrelink.sh force=y ranlib=y "PO RCVOLTM" 2.3   sh adrelink.sh force=y ranlib=y "PO RVCTP" 3         Bounce Receiving Transaction Manager: 3.1   (System Administrator > Concurrent > Manager > Administer) 3.2   Deactivate Receiving Transaction Manager 3.3   ps -ef | grep

Adcfgclone.pl dbTier Failed: RC-00110 Applies to: Oracle Application Install - Version: 11.5.10.0 and later. Description: On Applications 11.5.10.2, when attempting to clone using rapidclone the following error occurs: ERROR: -------- Log file located at ORACLE_HOME/appsutil/log/$SID_$HOSTNAME/ApplyDBTechStack_22472575.log RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack \ 40% completed ERROR while running Apply... ERROR: Failed to execute $RDBMS_ORACLE_HOME/appsutil/clone/bin/adclone.pl-- Found the following in Cloning log file: dest : $ORACLE_HOME/oui/bin/runInstaller.sh backup : $ORACLE_HOME/oui/bin/runInstaller.sh to $ORACLE_HOME/appsutil//out/$SID_$HOSTNAME/runInstaller.sh DEBUG : The destination file does not have write permission $ORACLE_HOME/oui/bin/runInstaller.sh DEBUG : Changing the permission of the file failed AC-00444: Unable to write to file: java.io.FileNotFoundException: $ORACLE_HOME/oui/bin/runInstaller.sh (

ORA-19909: Datafile 1 belongs to an orphan incarnation  Applies to:  Oracle Database 10gR2 Description: I have faced the error ORA-19909 while creating physical standby database through RMAN backup. When start recovery MRP process terminated with error.After doing some research work I found the following solution: Solution: After some research I have found the following solution: The Problem occurs because the Primary Database has different incarnation with standby database. On the Primary site: Set environment > rman  target / RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1       1       PROD     143178490        PARENT  5988067599851 02-OCT-10 2       2       PROD     143178490        CURRENT 5988067601797 02

RESIZE REDO LOGS ON PRIMARY AND STANDBY Applies to:  Oracle Database 10gR2 Description: Need to increase the size of existing Redo Logs. In current environment there is one physical standby database. Solution: SQL> SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;   SQL> select group#, status from v$log;       GROUP# STATUS ---------- ----------------          1 CURRENT          2 INACTIVE          3 INACTIVE   SQL> alter system switch logfile; SQL> alter system switch logfile; SQL> select group#, status from v$log;       GROUP# STATUS ---------- ----------------          1 INACTIVE          2 INACTIVE          3 CURRENT   -- To make primary redo log changes on primary and standbys: set -- STANDBY_FILE_MANAGEMENT to MANUAL so file changes not transferred to standby   SQL> alter system set STANDBY_FILE_MANAGEMENT=MANUAL scope=both; To stop Redo Apply, issue the following SQL statem

MRP: Background Media Recovery process shutdown on Physical standby Dataguard Applies to:  Oracle Database 10gR2 Description: RFS process successfully running, archive logs successfully shipped from Primary server to standby, but archive logs did not apply. MRP process going to shutdown automatically. After doing some research work I found the following solution: Solution: SQL> alter database recover managed standby database cancel; SQL> alter database recover managed standby database cancel; alter database recover managed standby database cancel * ERROR at line 1: ORA-16136: Managed Standby Recovery not active SQL> alter database recover managed standby database disconnect from session; Alert log: alter database recover managed standby database disconnect from session Sat Jun  9 09:51:56 2012 Attempt to start background Managed Standby Recovery process (PROD) MRP0 started with pid=18, OS id=6591 Sat Jun  9 09:51:56 2012 MRP0:

ORA-00474: SMON process terminated with error Applies to:  Oracle Database 10gR2 Description: I am going to clone database using RMAN backup. Backup has been successfully restored. When I am going to recover the database it ask me more archive logs to recover the database, then I did open resetlogs to but unable to open the database. Following error appear in the alert log file: “ORA-00474: SMON process terminated with error” and database going to crash. After doing some research work I found the following solution: Solution: Shutdown the database and set the following parameters in init.ora parameter file: *.undo_management='MANUAL' #*.undo_tablespace='UNDOTBS2'                 -- comment the existing parameter *._allow_resetlogs_corruption=true *._allow_error_simulation=true Mount the database in restrict mode using pfile: startup restrict mount pfile='/d01/oracle/proddb/10.2.0/dbs/initEBSTEST.ora'; Drop the undo