on 03-17-2015 10:33 AM
Hello Experts,
I have a problem starting Disp+Work after system restart(Windows server 2008R2/Oracle 11.2.0.3.0). please find the excerpt from the dev_disp & dev_W0 as below-
Dev_Disp-
***LOG Q0I=> NiIRead: P=127.0.0.1:49206; L=127.0.0.1:65000: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 5087]*** ERROR => NiIRead: SiRecv failed for hdl 57/sock 1056
(SI_ECONN_BROKEN/10054; I4; ST; P=127.0.0.1:49206; L=127.0.0.1:65000) [nixxi.cpp 5087]
DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN
Dev_W0-
Mar 17 15:14:51 2015
C Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DTG on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])
C Attaching to database server DTG (con=0, svchp=07DB0870, srvhp=07DB0F50)
C Tue Mar 17 15:14:54 2015
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12541:
C ORA-12541: TNS:no listener
C *** ERROR => CONNECT failed with SQL error '12541'
[dbsloci.c 15797]
C SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12541.
B ***LOG BY2=> sql error 12541 performing CON [dbsh 1246]
B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh 1246]
B ***LOG BY2=> sql error 12541 performing CON [dblink 544]
B ***LOG BY0=> ORA-12541: TNS:no listener [dblink 544]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1524]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11535]
I have verfied and can see all the services & Oracle is running fine.
Kindly advise.
Regards
Sury
Hi Sury,
Please check the tnsnames.ora and listener.ora with matrix below:
TNSNAMES.ORA init*.ora LISTENER.ORA
SERVICE_NAME SERVICE_NAMES GLOBAL_DBNAME
SID/ORACLE_SID INSTANCE_NAME SID_NAME
Please note SAP <sid>adm user will first find the environment TNS_ADMIN to find tnsnames.ora, then goes to oracle directory to find the tnsnames.ora. So you have to verify the tns_admin environment variables.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Was the listener configuration modified after starting DB ? Check the listener log, switch on ADMIN trace on listener to see whats happening.
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Yadav,
execute this if your TNS works fine:
tnsping SID
Check both:
/oracle/SID/112*/network/admin/tnsnames.ora
/sapmnt/SID/profile/oracle/tnsnames.ora
Regards,
Serhat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh 1246]
Is the listener service up and running?
regards,
pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suryamani,
As mentioned by Pavan and the ORa error 12541 refer to Listener issue.
C Tue Mar 17 15:14:54 2015
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12541:
C ORA-12541: TNS:no listener
C *** ERROR => CONNECT failed with SQL error '12541'
Do check the Listner is up and running, And your able to do tnsping <SID> from sidadm.
do let us know the status of same.
Regards,
Ram
Yes, Listerner is up & Running.
Please find the output of Tnsping SID as below-
Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = sap.world) (PROTOCOL = TCP) (Host = *********) (Port = 1521)) (CONNECT_DATA = (SID = ***) (GLOBAL_NAME = ***.WORLD)))
OK (20 msec)
Also find the output of R3trans.log file-
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 20 0.085589
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 379 0.085968
4 ETW000 [ dev trc,00000] Connecting as /@DTG on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])
4 ETW000 44 0.086012
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=03CE4730) 35 0.086047
4 ETW000 [ dev trc,00000] Allocating server context handle 30 0.086077
4 ETW000 [ dev trc,00000] Attaching to database server DTG (con=0, svchp=03CE4730, srvhp=03CE48D0)
4 ETW000 82 0.086159
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 31875 0.118034
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12505: 1945 0.119979
4 ETW000 [ dev trc,00000] ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
4 ETW000 66 0.120045
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '12505' 42 0.120087
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12505) 34 0.120121
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 12505 152 0.120273
4 ETW000 [ dev trc,00000] ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Please advise.
Regards
Sury
Hi,
Regarding this "TNS:listener does not currently know of SID given in connect descriptor" issue, please also refer to SAP Note 576919 - "Composite SAP note ORA-12505"
Regards,
Bíborka
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.