After modifying parameter file(pfile)which was created from current spfile,again created spfile from pfile and placed entries in dbs location,when trying to bring up db was getting error as below,randomly sometimes instance runs on first node sometimes on second node
Error:
Database is administrator managed
[oracle@node100 dbs]$ srvctl start database -d devdb1
PRCR-1079 : Failed to start resource ora.devdb1.db
CRS-5017: The resource action "ora.devdb1.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DEVDB1_DATA/DEVDB1/PARAMETERFILE/spfile.458.896116873'
ORA-17503: ksfdopn:2 Failed to open file +DEVDB1_DATA/DEVDB1/PARAMETERFILE/spfile.458.896116873
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DEVDB1_DATA/devdb1/parameterfile/spfile.458.896116873
ORA-15173: entry 'spfile.458.896116873' does not exist in directory 'parame. For details refer to "(:CLSN00107:)" in "/opt/oracle/product/grid/11.2.0.3/log/node100/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.devdb1.db' on 'node100' failed
CRS-2632: There are no more servers to try to place resource 'ora.devdb1.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.devdb1.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DEVDB1_DATA/DEVDB1/PARAMETERFILE/spfile.458.896116873'
ORA-17503: ksfdopn:2 Failed to open file +DEVDB1_DATA/DEVDB1/PARAMETERFILE/spfile.458.896116873
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DEVDB1_DATA/devdb1/parameterfile/spfile.458.896116873
ORA-15173: entry 'spfile.458.896116873' does not exist in directory 'parame. For details refer to "(:CLSN00107:)" in "/opt/oracle/product/grid/11.2.0.3/log/node101/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.devdb1.db' on 'node101' failed
[oracle@node100 dbs]$
Solution:
=====================
First solution tried :
Tried to fix the solution by setting the paramterfile by using srvctl but no use
srvctl modify database -d devdb1 -p '+DEVDB1_DATA/DEVDB1/PARAMETERFILE/spfile.265.863448433';
second Solution tried:
check parameter cluster_Database
it was issue with cluster_database parameter false just made it to true and brought up db on both nodes successfully
No comments:
Post a Comment