Oracle 11.2
New 11g DBMS_SCHEDULER jobs
1. ORA$AUTOTASK_CLEAN The job is created by the 11g script catmwin.sql which mentions that this job is an autotask repository data ageing job. It runs the procedure ora$age_autotask_data. 2. HM_CREATE_OFFLINE_DICTIONARY The job is created by the 11g script catmwin.sql which mentions that this is a job for creation of offline dictionary for Database Repair Advisor. […]
Shutting down 11.2 Clusterware
In 11gR2 RAC, you need to follow below steps to shutdown cluster 1. srvctl stop database -d dbname 2. srvctl stop nodeapps -n nodename 3. crsctl stop cluster (to shutdown asm and crs) 4. crsctl stop cluster -all (to shutdown cluster on all nodes) The command ‘crsctl stop crs’ will stop the databases, ASM, all […]