The following is the steps needed to clear down a failed 11.2.0.3 RAC install, the root.sh part of the install can cause numerious issue so these steps have been used on several occasions Run the rootcrs.pl to deconfig the cluster Run on the first node root@testnode1)$ ./rootcrs.pl -deconfig -verbose -force Using configuration parameter file: ./crsconfig_params […]
Disk Group Information set pages 1000 lines 120 col NAME for a15 select GROUP_NUMBER DG#, name, ALLOCATION_UNIT_SIZE AU_SZ, STATE, TYPE, TOTAL_MB, FREE_MB, OFFLINE_DISKS from v$asm_diskgroup; DG# NAME AU_SZ STATE TYPE TOTAL_MB FREE_MB OFFLINE_DISKS ———- ————— ———- ———– —— ———- ———- ————- 1 DATA 1048576 MOUNTED EXTERN 5114 3353 0 2 FRA 1048576 MOUNTED EXTERN 5114 […]
To install a Management Agent using the agentDeploy script, follow these steps: 1. On the OMS host, from the OMS home, log in to the EMCLI client. EMCLI Client is available by default with every OMS installation, so you need not install the client separately. oracle@oms-1 /u01/app/oracle/product/12.0.2/midware/oms/bin $ ./emcli login -username=sysman -password=xxxxxx 2. Synchronize EMCLI: […]
In a 11gR2 RAC cluster a VIP was showing as INTERMEDIATE and the listener was running fine on both node the actions i took to move the resource back to the correct node Checking the status The output from crsctl status resource -t ora.rac2.vip 1 ONLINE INTERMEDIATE rac1 FAILED OVER Moving the VIP back to […]
Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [oracle@rac1 ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager […]
How to generate the DLL for a table or a view from sqlplus, useful if you’ve not got a GUI tool. So as the schema owner connect and run the following, in this example the table is called TEST_TABLE set long 1000 select DBMS_METADATA.GET_DDL(‘TABLE’,’TEST_TABLE’) from dual; output view example set long 1000 select DBMS_METADATA.GET_DDL(‘VIEW’,’TEST_VIEW’)from dual; output
Just stumbled on the shrink command for the temp tablespace, I normally just do a reisze of the datafile but just tested the command and it works great! Test SYS@testdb1> Select tablespace_name, file_name, bytes/1024/1024 “Size MB”,AUTOEXTENSIBLE, MAXBYTES/1024/1024 “Auto MB” from dba_temp_files; TABLESPACE_NAME FILE_NAME […]
In Oracle10g and onwards, we have the option to shrink a segment that helps to manage space more efficiently. Shrink operations can be performed only on segments in locally managed tablespaces with ASSM. The segment advisor will highlight any segments that can be shrunk and then you can do the following steps to shrink the object to […]
Got this error after session was killed whilst doing a index rebuild and then trying to rebuild the index again, its seems the cause is – A session failure during an online index rebuild can leave the data dictionary in a state reflecting a rebuild is ongoing when in fact it is not – see metalink […]
The steps to perform a switch over using dataguard broker are very simple you just need to do the following: 1. Connect to dgmgrl and make sure the configuration status = SUCCESS 2. Connect to the standby database as sys using the SID 3. Then use the command switchover to “XXXXX” where XXXXX is your […]
For the Love of Data 