cancel
Showing results for 
Search instead for 
Did you mean: 

Error while starting Standby server using Dataguard

Former Member
0 Kudos

Hi ,

Db opened successfully, but SAP MMC not starting, pls find below dev_w0 log

M

M Tue Apr 12 12:00:56 2011

M calling db_connect ...

C Prepending K:\usr\sap\EC6\DVEBMGS00\exe to Path.

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000013F150B0 000000000982F0D0 0000000006E3A0B8

C Attaching to DB Server EC6 (con_hdl=0,svchp=0000000006E39F78,svrhp=0000000013F25108)

C

C Tue Apr 12 12:01:05 2011

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 4172]

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 10933]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000013F150B0 000000000982F0D0 0000000006E3A0B8

C Detaching from DB Server (con_hdl=0,svchp=0000000006E39F78,srvhp=0000000013F25108)

C Attaching to DB Server EC6 (con_hdl=0,svchp=0000000006E39F78,svrhp=0000000013F25108)

C

C Tue Apr 12 12:01:14 2011

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 4172]

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 10933]

B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]

B ***LOG BY2=> sql error 12154 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1411]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10169]

M

M Info for wp 0

M

Our's is Win2K3, ERP2005, Oracle 10.2.0.2

Pls suggest

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member204746
Active Contributor
0 Kudos

file tnsnames.ora does not have an entry to EC6.

also check listener.ora for EC? entry.

Former Member
0 Kudos
ERROR => CONNECT failed with sql error '12154'

These errors generally comes when listener.ora and tnsnames.ora settings are not proper.Please check your tnsping and listener.You can also check trans.log for more error details.

Thanks..

Mohit

Former Member
0 Kudos

Hi,

Please have a look on note 443867.

Regards

Vinod