Trace file location 12.1.0.2
/u01/app/grid/diag/crs/orars12/crs/trace
[root@orars12 Desktop]# crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE orars12 STABLE
ora.LISTENER.lsnr ONLINE ONLINE orars12 STABLE
ora.asm ONLINE ONLINE orars12 Started,STABLE
ora.ons OFFLINE OFFLINE orars12 STABLE
***** Cluster Resources: *****
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.cssd 1 ONLINE ONLINE orars12 STABLE
ora.diskmon 1 OFFLINE OFFLINE - STABLE
ora.evmd 1 ONLINE ONLINE orars12 STABLE
ora.ors4.db 1 ONLINE ONLINE orars12 Open,STABLE
[oracle@orars12 ~]$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 10236 8702 0 8702 0 N DATA/
Create an ASM Spfile
[oracle@orars12 ~]$ asmcmd spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.857645183
SQL> create pfile='/tmp/init+ASM.ora' from spfile='+DATA/ASM/ASMPARAMETERFILE/registry.253.857645183';
File created.
SQL> !cat /tmp/init+ASM.ora
+ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
*.asm_diskgroups='DATA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
Deconfigure and Reconfigure HAS stack
Stop HAS stack as grid user
[oracle@orars12 ~]$ crsctl stop has
[oracle@orars12 ~]$ crsctl check has
CRS-4639: Could not contact Oracle High Availability Services
As root user : Deconfigure HAS stack
[root@orars12 Desktop]# env | grep GRID_HOME
GRID_HOME=/u01/app/1202/grid
[root@orars12 Desktop]# $GRID_HOME/crs/install/roothas.pl -deconfig -force
Using configuration parameter file: /u01/app/1202/grid/crs/install/crsconfig_params
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Delete failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
2014/09/08 16:30:05 CLSRSC-337: Successfully deconfigured Oracle Restart stack
As root user : Add back the OHAS configuration
# $GRID_HOME/crs/install/roothas.pl
Using configuration parameter file: /u01/app/1202/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node orars12 successfully pinned.
2014/09/08 16:32:46 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'
orars12 2014/09/08 16:34:09 /u01/app/1202/grid/cdata/orars12/backup_20140908_163409.olr 0
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'orars12'
CRS-2673: Attempting to stop 'ora.evmd' on 'orars12'
CRS-2677: Stop of 'ora.evmd' on 'orars12' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'orars12' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2014/09/08 16:36:12 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
Resource status after reconfigure HAS
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.ons OFFLINE OFFLINE orars12 STABLE
***** Cluster Resources: *****
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.cssd 1 OFFLINE OFFLINE - STABLE
ora.diskmon 1 OFFLINE OFFLINE - STABLE
ora.evmd 1 ONLINE ONLINE orars12 STABLE
Note :
Don't use "AUTO_START=1" use AUTO_START=always instead !
[oracle@orars12 ~]$ crsctl modify resource "ora.cssd" -attr "AUTO_START=1"CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.
[oracle@orars12 ~]$ crsctl status resource "ora.cssd" -f | grep AUTO_START
AUTO_START=never
[oracle@orars12 ~]$ crsctl modify resource ora.cssd -init -attr "AUTO_START=always"
Add back ASM resource and start HAS stack
[oracle@orars12 ~]$ srvctl add asm -p '+DATA/ASM/ASMPARAMETERFILE/registry.253.857645183'
[oracle@orars12 ~]$ crsctl stop has
[oracle@orars12 ~]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.asm OFFLINE OFFLINE orars12 Instance Shutdown,ST ABLE
ora.ons OFFLINE OFFLINE orars12 STABLE
***** Cluster Resources: *****
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.cssd 1 ONLINE ONLINE orars12 STABLE
ora.diskmon 1 OFFLINE OFFLINE - STABLE
ora.evmd 1 ONLINE ONLINE orars12 STABLE
Start ASM instance and verify that DG +DATA get mounted successfully
Either create and ASM SPILE or better just reuse SPFILE we have created earlier
[oracle@orars12 ~]$ cat /tmp/init+ASM.ora
+ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
*.asm_diskgroups='DATA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
SQL> startup pfile=/tmp/init+ASM.ora
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
[oracle@orars12 ~]$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 10236 8702 0 8702 0 N DATA/
Check HAS stack
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE orars12 STABLE
ora.asm ONLINE ONLINE orars12 STABLE
ora.ons OFFLINE OFFLINE orars12 STABLE
***** Cluster Resources: *****
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.cssd 1 ONLINE ONLINE orars12 STABLE
ora.diskmon 1 OFFLINE OFFLINE - STABLE
ora.evmd 1 ONLINE ONLINE orars12 STABLE
Note: During the ASM instance startup, the ASM diskgroups (specified in the ASM_DISKGROUP parameter) are/were mounted and also those diskgroups
are automatically populated as resources in the SIHA/OHAS/Restart stack.
==> SRVCTL Command Reference for Oracle Restart
<< There is no srvctl add command for Oracle ASM disk groups. Disk groups are automatically added to the Oracle Restart configuration when they
are first mounted. If you remove a disk group from the Oracle Restart configuration and later want to add it back, connect to the Oracle ASM instance
with SQL*Plus and use an ALTER DISKGROUP ... MOUNT command.
Restart CRS stack
[oracle@orars12 ~]$ crsctl stop has
[oracle@orars12 ~]$ crsctl start has
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE orars12 STABLE
ora.asm ONLINE ONLINE orars12 Started,STABLE
Add the database and GRID listener resource
ASMCMD> find --type PARAMETERFILE +data *
+data/ORS4/PARAMETERFILE/spfile.266.857557289
+data/ORS4/spfileORS4.ora
[oracle@orars12 ~]$ env | grep ORA
ORACLE_HOME=/u01/app/oracle/product/11204/ors
Use 11.2.0.4 srvctl :
[oracle@orars12 ~]$ srvctl add database -d ORS4 -n ORS4 -o /u01/app/oracle/product/11204/ors -p +data/ORS4/spfileORS4.ora
-s OPEN -y AUTOMATIC -a "DATA" -t IMMEDIATE
[oracle@orars12 ~]$ srvctl config database -d ORS4
Database unique name: ORS4
Database name: ORS4
Oracle home: /u01/app/oracle/product/11204/ors
Oracle user: oracle
Spfile: +data/ORS4/spfileORS4.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: ORS4
Disk Groups: DATA
Services:
[oracle@orars12 ~]$ crs
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.ors4.db 1 OFFLINE OFFLINE - STABLE
--> DB resource still in OFFLINE mode
[oracle@orars12 ~]$ sqlplus / as sysdba
SQL> startup
[oracle@orars12 ~]$ crs
ora.ors4.db 1 ONLINE ONLINE orars12 Open,STABLE
Add back GRID listener and start the listener a fist timeUse 12.1.0.2 srvctl :
[oracle@orars12 ~]$ srvctl add listener -p TCP:1521 -l LISTENER -o $GRID_HOME
[oracle@orars12 ~]$ srvctl start listener
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.LISTENER.lsnr ONLINE ONLINE orars12 STABLE
Restart crs and check that all resource get started
[oracle@orars12 ~]$ crsctl stop has
[oracle@orars12 ~]$ crsctl start has
[oracle@orars12 ~]$ crs
***** Local Resources: *****
Rescource NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE orars12 STABLE
ora.LISTENER.lsnr ONLINE ONLINE orars12 STABLE
ora.asm ONLINE ONLINE orars12 Started,STABLE
ora.ons OFFLINE OFFLINE orars12 STABLE
***** Cluster Resources: *****
Resource NAME INST TARGET STATE SERVER STATE_DETAILS
--------------------------- ---- ------------ ------------ --------------- -----------------------------------------
ora.cssd 1 ONLINE ONLINE orars12 STABLE
ora.diskmon 1 OFFLINE OFFLINE - STABLE
ora.evmd 1 ONLINE ONLINE orars12 STABLE
ora.ors4.db 1 ONLINE ONLINE orars12 Open,STABLE
Reference
One thought on “Reconfigure 12.1.0.2 HAS stack running 11.2.0.4 database”
One thought on “Reconfigure 12.1.0.2 HAS stack running 11.2.0.4 database”