Author Archives: compitionpoint - Page 6
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
ORA-01940: cannot drop a user that is currently connected
SQL>drop user MY_USER cascade; drop user username cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected SQL>select , #, , from v$session s, v$process…
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora
PROBLEM: Encounter the following error when running autoconfig on the Application Tier. ERROR: Updating s_tnsmode to ‘generateTNS’ UpdateContext exited with status: 0 AC-50480: Internal error occurred: : Error while generating…
ADCTRL – SKIPPING A WORKER
Sometimes we need to skip the worker via adctrl then we can use the below steps to do the same. Run adctrl utility We can only see option till 7…
ERROR: OPatch failed because of Inventory problem
I was trying to apply EBS R12 patch on ORACLE_HOME() application node and got the below issue because of inventory issue. ERROR: opatch lsinventory Oracle Interim Patch Installer version Copyright…
ERROR: OPatch failed because of Inventory problem
I was trying to apply EBS R12 patch on ORACLE_HOME() application node and got the below issue because of inventory issue. ERROR: opatch lsinventory Oracle Interim Patch Installer version Copyright…
ADOP – EBS R12.2
ADOP – Applications DBA Online Patching Tool ADOP: Oracle E-Business introduced new patching mechanism that allow the application of patches while your environment is up and running which is called…
R12.2 ADOP PATCH LOG FILES
It is advisable to review the relevant log files after any patching operation. The adop log files are located on the non-editioned file system (fs_ne), under: s_ne_base/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log For example, if…