Long running Concurrent Requests:- 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID =…
Read MoreIntroduction: There are different methods to upgrade an Oracle database from a lower version to a higher version. Oracle provides multiple methods to upgrade based on the version. A few…
Read MoreGroup Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS…
Read MoreCategory 12.1 12.2 Forms & Reports, Developer Home, Tools Home 10.1.2 – ORACLE_HOME 10.1.2 ORACLE_HOME OC4J/OHS/OPMN 10.1.3 – IAS-ORACLE_HOME OPMN, oacore-oc4j, oafm-oc4j, forms-oc4j, etc Fusion Middleware – OHS/WLS OHS –…
Read Morea. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent Successfully Setup Software. Gold Image location: /u03/database19c/db_home_2018-02-26_22-47-54PM.zip…
Read MoreIntroduction: There are many times where DBA has to run tkprof for multiple trace files at one time and get them uploaded in Oracle SR. Here, I will be sharing…
Read MoreWhat is snapshot standby database? It allows to perform read-write operation on the standby database.ie converting the physical standby to snapshot standby database. On that, we can do all types…
Read MoreIntroduction to Nid Utility: NID is an utility which is used to change the database internal name and dbname of a database. The utility is placed in the $ORACLE_HOME/bin directory.…
Read MoreDatabase Migration from Non-ASM to ASM We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance…
Read MoreWhile trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…
Read More