cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Start Disp+Work

Former Member
0 Kudos


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

Accepted Solutions (0)

Answers (5)

Answers (5)

JamesZ
Advisor
Advisor
0 Kudos

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

former_member185954
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member207186
Contributor
0 Kudos

Hi,

Please also check the SAP Note

609332 - "Composite note: ORA-12541/ORA-12224"

Regards,

Bíborka

Former Member
0 Kudos

Hi Suryamani,

Do verify your tnsnames.ora and check the

SID_LIST_LISTENER=(SID_LIST =(SID_DESC =(SID_NAME = <SID>)

(ORACLE_HOME = /oracle<SID>/112)))

Also you should have the same file in /sapmnt/<SID>/profile/oracle directory.

Let us know the details.

Regards,

Ram

Former Member
0 Kudos

Hi Biborka,

I have verified as per the note and all seems to be correct.

As of now, i am getting 2 instances as shown below-

Kindly advise.

Regards

Sury

Former Member
0 Kudos

Yes Ram, It is same as per your suggestion.

regards

Sury

Former Member
0 Kudos

B  ***LOG BY0=> ORA-12541: TNS:no listener [dbsh         1246]

Is the listener service up and running?

regards,

pavan

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member207186
Contributor
0 Kudos

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