Text box

Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .

Sunday 16 February 2014

Applying patch set update manually on Oracle Grid Infrastructure/Real Application cluster and Database 11.2.0.2.



The steps below helps you to manually apply patch set update for 11.2.0.2:
Patch Number:
Bug 17272753 - 11.2.0.2.12 (Oct 2013) Grid Infrastructure Patch Set Update (GI PSU) (Doc ID 17272753.8) - This is the latest PSU on top 11..2.0.2

Please download the patch and follow the below steps:

Make sure that you stopped the EM agent Processes running from the database home before patching the Oracle RAC or Oracle RAC one Node database or grid infrastructure home.
To Stop the EM agent processes  please execute:
<ORACLE_HOME>/bin/emctl stop dbconsole

Execute the following on each node of the cluster to apply the patch:
Stop the CRS managed resources running from DB homes.
As the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
In case of Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>
1.    Run the pre root script.
In the   GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -unlock
In case of Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -unlock
2.   Apply the CRS patch using.
As the GI home owner execute:
$ <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/16459322
As the GI home owner execute:
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/17082367

4-Run the pre script for DB component of the patch.
As the database home owner execute:
$ <UNZIPPED_PATCH_LOCATION>/16459322/custom/server/16459322/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
3-Apply the DB patch.
As the database home owner execute:
$ <ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/16459322/custom/server/16459322
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/17082367
4-Run the post script for DB component of the patch.
As the database home owner execute:
$ <UNZIPPED_PATCH_LOCATION>/16459322/custom/server/16459322/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>
5-Run the post script.
As the root user execute:
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
In  the GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -patch
In case of Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -patch
6-Start the CRS managed resources that were earlier running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
In case of Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location>

Real Example:

1-The Pre Root Script.
root@svprtldb02:~# >/crs/install/rootcrs.pl -unlock
-bash: /crs/install/rootcrs.pl: No such file or directory
root@svprtldb02:~# cd /app/grid/
root@svprtldb02:/app/grid# cd crs/install/
root@svprtldb02:/app/grid/crs/install# ./rootcrs.pl -unlock
defined(@array) is deprecated at crsconfig_lib.pm line 2134.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 2134.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 2212.
(Maybe you should just omit the defined()?)
Using configuration parameter file: ./crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'svprtldb02'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'svprtldb02'
CRS-2673: Attempting to stop 'ora.diskmon' on 'svprtldb02'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'svprtldb02'
CRS-2673: Attempting to stop 'ora.gipcd' on 'svprtldb02'
CRS-2677: Stop of 'ora.cssdmonitor' on 'svprtldb02' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'svprtldb02' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'svprtldb02' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'svprtldb02'
CRS-2677: Stop of 'ora.diskmon' on 'svprtldb02' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'svprtldb02' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'svprtldb02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /app/grid

2-Apply CRS Patch in order to patch the grid Infrastructure:
grid@svprtldb02:~/patchsetupdate$ /app/grid/OPatch/opatch napply -oh /app/grid -local /home/grid/patchsetupdate/16459322
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /app/grid
Central Inventory : /app/11.2.0/oraInventory
from : /app/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.2.0
Log file location : /app/grid/cfgtoollogs/opatch/opatch2014-02-09_19-47-10PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 16459322

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '16459322' to OH '/app/grid'
Patching component oracle.crs, 11.2.0.2.0...
Patching component oracle.usm, 11.2.0.2.0...
Verifying the update...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
make: Warning: Too many rules defined for target libsrvm11.so
ld: warning: output object option (-o, --output) appears more than once, first setting taken
ld: warning: symbol '_init' not found, but .init section exists - possible link-edit without using the compiler driver
ld: warning: symbol '_fini' not found, but .fini section exists - possible link-edit without using the compiler driver
Patch 16459322 successfully applied.
OPatch Session completed with warnings.
Log file location: /app/grid/cfgtoollogs/opatch/opatch2014-02-09_19-47-10PM_1.log
OPatch completed with warnings.
Based on the info given in the note Opatch Warning During Patch Apply : "ld: warning: option -YP appears more than once, first setting taken" (Doc ID 1571550.1) I will jump to next step.


grid@svprtldb02:~/patchsetupdate$ /app/grid/OPatch/opatch apply -oh /app/grid -local /home/grid/patchsetupdate/17082367
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /app/grid
Central Inventory : /app/11.2.0/oraInventory
from : /app/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.2.0
Log file location : /app/grid/cfgtoollogs/opatch/opatch2014-02-09_20-05-10PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13696224 13923804 14275621 14727315 16056267 16619893 17082367
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13696224' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] , [ oracle.rdbms.dv, 11.2.0.2.0 ] , [ oracle.sysman.plugin.db.main.repository, 11.2.0.2.0 ] , [ oracle.network.cman, 11.2.0.2.0 ] , [ oracle.precomp.common, 11.2.0.2.0 ] , [ oracle.precomp.lang, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.ldap.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.sdo.locator, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '13923804' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Patching component oracle.network.listener, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '14275621' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.network.client, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.rdbms.util, 11.2.0.2.0......
Patching component oracle.dbjava.jdbc, 11.2.0.2.0...
Patching component oracle.dbjava.ic, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '14727315' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.2.0 ] , [ oracle.precomp.lang, 11.2.0.2.0 ] , [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.util,

3-Make sure to run the pre database home patching step:
oracle@svprtldb02:~$ /home/oracle/patchsetupdate/16459322/custom/server/16459322/custom/scripts/prepatch.sh -dbhome /app/oracle/product/11.2.0/dbhome_1
Unable to determine value for ORACLE_BASE. Ignoring...
/home/oracle/patchsetupdate/16459322/custom/server/16459322/custom/scripts/prepatch.sh completed successfully.


4-Apply database patch:
oracle@svprtldb02:~$ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -oh /app/oracle/product/11.2.0/dbhome_1 -local /home/grid/patchsetupdate/16459322/custom/server/16459322
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /app/oracle/product/11.2.0/dbhome_1
Central Inventory : /app/11.2.0/oraInventory
from : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.2.0
Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-02-09_20-22-09PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 16459322
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '16459322' to OH '/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.2.0...
Verifying the update...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
make: Warning: Too many rules defined for target libsrvm11.so
ld: warning: output object option (-o, --output) appears more than once, first setting taken
ld: warning: symbol '_init' not found, but .init section exists - possible link-edit without using the compiler driver
ld: warning: symbol '_fini' not found, but .fini section exists - possible link-edit without using the compiler driver
Patch 16459322 successfully applied.
OPatch Session completed with warnings.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-02-09_20-22-09PM_1.log
OPatch completed with warnings.



grid@svprtldb02:~/patchsetupdate$ /app/grid/OPatch/opatch apply -oh /app/grid -local /home/grid/patchsetupdate/17082367
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /app/grid
Central Inventory : /app/11.2.0/oraInventory
from : /app/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.2.0
Log file location : /app/grid/cfgtoollogs/opatch/opatch2014-02-09_20-05-10PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13696224 13923804 14275621 14727315 16056267 16619893 17082367
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13696224' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] , [ oracle.rdbms.dv, 11.2.0.2.0 ] , [ oracle.sysman.plugin.db.main.repository, 11.2.0.2.0 ] , [ oracle.network.cman, 11.2.0.2.0 ] , [ oracle.precomp.common, 11.2.0.2.0 ] , [ oracle.precomp.lang, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.ldap.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.sdo.locator, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '13923804' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Patching component oracle.network.listener, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '14275621' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.network.client, 11.2.0.2.0...
Patching component oracle.network.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.rdbms.util, 11.2.0.2.0...
Patching component oracle.dbjava.jdbc, 11.2.0.2.0...
Patching component oracle.dbjava.ic, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '14727315' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.2.0 ] , [ oracle.precomp.lang, 11.2.0.2.0 ] , [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.rman, 11.2.0.2.0...
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.util, 11.2.0.2.0...
Patching component oracle.sdo.locator, 11.2.0.2.0...
Verifying the update...
Applying sub-patch '16056267' to OH '/app/grid'
ApplySession: Optional component(s) [ oracle.network.cman,


5-Make sure to apply post patch step:
/home/oracle/patchsetupdate/16459322/custom/server/16459322/custom/scripts/postpatch.sh -dbhome /app/oracle/product/11.2.0/dbhome_1
Reading /app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Reading /app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Parsing file /app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Parsing file /app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Parsing file /app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Parsing file /app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Verifying file /app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Verifying file /app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Verifying file /app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Verifying file /app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/diskmon.bin
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/lsnodes
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/osdbagrp
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/rawutl
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/srvm/admin/ractrans
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/srvm/admin/getcrshome
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/gnsd
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/bin/crsdiag.pl
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libhasgen11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libclsra11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libdbcfg11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libocr11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libocrb11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libocrutl11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libuini11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/librdjni11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libgns11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libgnsjni11.so
Reapplying file permissions on /app/oracle/product/11.2.0/dbhome_1/lib/libagfw11.so
oracle@svprtldb02:~$

6-Run the post script.
In my case it was not progressing and hanged as per below and I got the below issue:
It is not progressing any more as below:
root@svprtldb02:/app/grid/crs/install# /usr/bin/perl rootcrs.pl -patch
defined(@array) is deprecated at crsconfig_lib.pm line 2194.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 2194.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 2272.
(Maybe you should just omit the defined()?)
Using configuration parameter file: ./crsconfig_params
Use of uninitialized value $u in concatenation (.) or string at /app/grid/lib/osds_acfslib.pm line 368.
/app/grid/bin/clsecho[270]: exec: /app/grid/bin/clsecho.bin: cannot execute [Permission denied]
/app/grid/bin/crsctl[270]: exec: /app/grid/bin/crsctl.bin: cannot execute [Permission denied]

I couldnot start the crs as per below:
root@svprtldb02:/app/grid/bin# ls -ltr crsctl.bin
-rw-r--r-- 1 grid oinstall 75558408 Apr 9 2013 crsctl.bin
root@svprtldb02:/app/grid/bin# chmod +x crsctl.bin
root@svprtldb02:/app/grid/bin# ls -ltr crsctl.bin
-rwxr-xr-x 1 grid oinstall 75558408 Apr 9 2013 crsctl.bin
root@svprtldb02:/app/grid/bin# ./crsctl stop crs -f
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
root@svprtldb02:/app/grid/bin# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.



[ohasd(1257)]CRS-5828:Could not start agent '/app/grid/bin/oraagent'. Details at (:CRSAGF00126:) {0:0:2} in /app/grid/log/svprtldb02/ohasd/ohasd.log.
2014-02-09 23:36:10.030
[ohasd(1257)]CRS-2758:Resource 'ora.gpnpd' is in an unknown state.
2014-02-09 23:45:18.905
[client(2986)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2014-02-09 23:45:36.249
[client(2986)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in /app/grid/log/svprtldb02/client/ocrdump_2986.log.
2014-02-09 23:45:41.084
[client(3087)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
It was a permission issue and was fixed by doing the below:
ls -l GIHOME/bin

crsctl stop crs -f

cd GIHOME/bin
chmod 755

chmod 6751 oracle


Now start crs
root@svprtldb02:/app/grid/bin# ./crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS 
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE OFFLINE 
ora.crf
1 ONLINE ONLINE svprtldb02 
ora.crsd
1 ONLINE OFFLINE 
ora.cssd
1 ONLINE OFFLINE STARTING 
ora.cssdmonitor
1 ONLINE ONLINE svprtldb02 
ora.ctssd
1 ONLINE OFFLINE 
ora.diskmon
1 ONLINE ONLINE svprtldb02 
ora.evmd
1 ONLINE OFFLINE 
ora.gipcd
1 ONLINE ONLINE svprtldb02 
ora.gpnpd
1 ONLINE ONLINE svprtldb02 
ora.mdnsd
1 ONLINE ONLINE svprtldb02

7-Stop and start the cluster :
Stopping and starting it should be working properly.Feel free to repeat the same steps on the other nodes.

No comments:

Post a Comment