Issue with Oracle ASM
For a standalone database which is setup with ASM, if Database startup failed mentioning " cannot access control file see alert log for more details." Check for the below mentioned entries in alert log and trace file around that time.
Error codes in Oracle Alert log and trace file:
Fatal NI connect error 12547, connecting to:
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
WARNING: failed to start ASMB (connection failed) state=0x1 sid='+<asm_sid>'
DDE encountered the following error:
ORA-49204: Recursive DDE invocation at Phase I
ORA-00202: control file: '+<controlfile>'
ORA-17503: ksfdopn:2 Failed to open file +<controlfile>
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-12547: TNS:lost contact
ORA-12547: TNS:lost contact
One of the probable cause is the permission issue on oracle binary.
Login with grid user and do the following:
cd $GRID_HOME/binls -ll oracle-rwxrwx--- <----- oracle
change the permission :chmod 6751 oraclels -ll oracle-rwsr-s--x < -- oracle
Now try to start the database and it should be able to start the ASMB connection.
Best Wishes!!
No comments:
Post a Comment
If you have any queries/ any suggestion please do comment and let me know.