Skip to Content
avatar image
Former Member

Error while starting Standby server using Dataguard

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 12, 2011 at 06:16 AM

    Hi,

    Please have a look on note 443867.

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2011 at 07:25 AM
    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2011 at 01:24 PM

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

    also check listener.ora for EC? entry.

    Add comment
    10|10000 characters needed characters exceeded