Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]

ysjxjf發表於2013-03-14
OracleDatabaseAIError
Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1][@more@]
To BottomTo BottomOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]
Nov 30, 2012Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]PROBLEMOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]PUBLISHEDOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]3
There are no commentsComments (0)Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]Rate this documentOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]Email link to this documentOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]Open document in new windowOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]Printable PageOracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]
Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]

In this Document

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Oct-2012***

Symptoms


1. When attempting to startup database,the following error occurs.

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA1/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/orcl/spfileorcl.ora
ORA-12547: TNS:lost contact



2. DB alert log:

ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM_pmon_orcl)(ENVS='ORACLE_HOME=/opt/11.2.0/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_26924.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact



3. ASM instance and required diskgroups are online and no error in ASM alert:

crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg ONLINE ONLINE prod
ora.DATA2.dg ONLINE ONLINE prod
ora.asm ONLINE ONLINE prod Started

Cause

The issue is caused by incorrect permission of $GRID_HOME/bin/oracle and $ORACLE_HOME/bin/oracle, which lead to connection failure to ASM instance:

ls -al $GRID_HOME/bin/oracle
-rwxr-x--x 1 grid oinstall 200678464 Feb 28 14:54 oracle

ls -al $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oracle asmadmin 228886191 Feb 28 15:41 oracle


Solution

Oracle binary should have permission of 6751. To correct the permission, as owner of oracle binary:

cd $GRID_HOME/bin
chmod 6751 oracle

cd $ORACLE_HOME/bin
chmod 6751 oracle

After the change, permission should show:

ls -l $GRID_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 203974257 May 11 09:30 oracle

ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232399431 May 14 13:47 oracle

Once the permission is fixed, if database still fails to come up, restart Grid Infrastructure.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/66634/viewspace-1060297/，如需轉載，請註明出處，否則將追究法律責任。

相關文章