Skip to Content
0

ORA-12154: TNS:could not resolve the connect identifier specified shadow system

Mar 06, 2017 at 08:37 AM

661

avatar image
Former Member

hi ,

During SAP upgrade i am stuck in . below Stage .

Please find the Screen short

and In SAP mmc Shadow instance Dispatcher is Down.

Please Trans.log for Shadow Instance .

4 ETW000 r3trans version 6.24 (release 722 - 18.01.17 - 20:17:01). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 06.03.2017 - 12:32:35 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: r3trans -d 4 ETW000 trace at level 1 opened for a given file pointer 4 ETW000 [ dev trc,00000] Mon Mar 06 12:32:35 2017 4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "722.00", patchlevel (0.202) 4 ETW000 [ dev trc,00000] dbs/ora/stmt_cache_size = 250 4 ETW000 [ dev trc,00000] Register application info. 4 ETW000 [ dev trc,00000] Mon Mar 06 12:32:36 2017 4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.4.0, (dbsl 722 290616, UNICODE[2]) 4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' 4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 4 ETW000 [ dev trc,00000] Connecting as /@R55 on connection 0 (nls 0) ... (dbsl 722 290616, UNICODE[2]) 4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=03F40D30 created, rc=0 4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified 4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=03F40D30): Error 12154 attaching new srv=03F410E0 to 'R55' 4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=03F410E0 freed. 4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=03F40D30 freed (i=0). 4 ETW000 [ dev trc,00000] rc=12154 -> Trying to reattach to server 'R55' 4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=03F40D30 created, rc=0 4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified 4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=03F40D30): Error 12154 attaching new srv=03F410E0 to 'R55' 4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=03F410E0 freed. 4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=03F40D30 freed (i=1). 4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '12154' 4 ETW000 [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12154. 4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 12154 performing CON 4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'R55'"

untitled.jpg (114.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Paul Secunde Mar 06, 2017 at 03:38 PM
0

This error is occurring in the source SAP instance for the upgrade so the status of the shadow instance is not really relevant. You should review the OSS note indicated in the error message (1705774), specifically the scenario A cause and resolution sections, to remove the pending updates with SM13 and related transactions/reports. Then you should be able to select Next to repeat the phase.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks for solution its work

0