Hi Experts,
Our ECC6.0 is in MSCS clusters Oracle 10.2.0.4 database. When I saw the 3 to 4 work processes of both nodes are in running state then I checked the developer trace of perticular work process. dev_w0, dev_w1 etc
I found the below Error-
C Tue Nov 22 08:36:12 2011
C Application info callback registered.
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@IIP on connection 0 (nls 0) ... (dbsl 701 170611, UNICODE[2])
C Detaching from DB Server (con_hdl=0,svchp=000000001A2B3768,srvhp=000000001A2B3E38)
C Attaching to DB Server IIP (con_hdl=0,svchp=000000001A2B3768,srvhp=000000001A2B3E38)
C
C Tue Nov 22 08:36:21 2011
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
C ORA-12154: TNS:could not resolve the connect identifier specified
C *** ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 11330]
C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154.
B reconnect failed for connection 0
M *** ERROR => ThHdlReconnect: db_reconnect failed (2048) [thxxhead.c 17596]
B db_con_reconnect: reconnecting to connection 0:
B 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
B reco = YES, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
B opening connection 0 ...
Please let me know what mat be the issue
Regards,
Nilesh