Saturday, March 2, 2013

ORACLE - Reconfigure Oracle Restart

Issue - Error messages:
NOTE: client jdatabase01:jdatabase01 registered, osid 21900, mbr 0x1
Wed Jan 30 20:13:56 2013
2013-01-30 20:13:56.686
[USER(19635)]CRS-2317:Fatal error: cannot get local GPnP security keys (wallet).
2013-01-30 20:13:56.686
[USER(19635)]CRS-2316:Fatal error: cannot initialize GPnP, CLSGPNP_ERR (Generic GPnP error).
NOTE: failed to discover disks from gpnp profile asm diskstring
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_19635.trc:
ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR]

Soultion:
1. Remove Oracle Restart configuration (as root)
$ sudo /u01/app/oracle/product/11.2.0/grid/crs/install/roothas.pl -deconfig -forceUsing configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Delete failed, or completed with errors.
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
You must kill ohasd processes or reboot the system to properly
cleanup the processes started by Oracle clusterware
Either /etc/oracle/olr.loc does not exist or is not readable
Make sure the file exists and it has read and execute access
Successfully deconfigured Oracle Restart stack


2. Reconfigure Oracle Restart (as root):
$ sudo /u01/app/oracle/product/11.2.0/grid/crs/install/roothas.plUsing configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'dba'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node hqmidb02 successfully pinned.
Adding Clusterware entries to upstart

hqmidb02     2013/01/30 22:19:35     /u01/app/oracle/product/11.2.0/grid/cdata/hqmidb02/backup_20130130_221935.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server


3.Add ASM back to Oracle Restart configuration and  Start up ASM instance  (grid owner):
>srvctl add asm
>srvctl start asm
>crs_stat -t

Name           Type           Target    State     Host
------------------------------------------------------------
ora.MWDATA1.dg ora....up.type ONLINE    ONLINE    hqmidb02
ora.asm        ora.asm.type   ONLINE    ONLINE    hqmidb02
ora.cssd       ora.cssd.type  ONLINE    ONLINE    hqmidb02
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    ONLINE    hqmidb02
ora.ons        ora.ons.type   OFFLINE   OFFLINE


4.Restart HAS :
crsctl stop has
crsctl start has


5. Add components back to Oracle Restart Configuration like database, listener and other components: srvctl add database -d <db_unique_name>
srvctl add listener

Note: init+ASM.ora
+ASM.__oracle_base='/u01/app/oracle'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
*.ASM_DISKGROUPS ='DBDATA1'

Ref : How to Reconfigure Oracle Restart (Doc ID 986740.1)


No comments:

Post a Comment