Skip to Content
0
Former Member
Nov 22, 2011 at 01:34 AM

Work process is in running state

55 Views

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