Question Re: ERROR => CONNECT failed with sql error '12518' in Technology Q&A

ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 05:17:28 GMT

Hi All,

OS Win 2003 - 32 Bit, Database - Oracle 10.2.0.2 , I am facing this from yesterday, suddenly SAP was done and when i am checking the logs it is not able to connect to the database.

I have checked the services for oracle - service was down, i have started the oracleService<SID> and also i have restarted the listener.. after this when i am trying to start the SAP through MMC again the problem is face.. and also the oracle service is stopped. when i tried starting the database from OS level it was giving me error like

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-03113: end-of-file on communication channel

again the Oracle service is stopped i am not getting why the oracle service is stopping..

dev_w*.log

Thu Apr 09 10:33:50 2009

M calling db_connect ...

C Prepending D:\usr\sap\SID\DVEBMGS01\exe to Path.

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@SID on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05C84528 05C89AC4 05C8934C

C Attaching to DB Server SID (con_hdl=0,svchp=05C89298,svrhp=05C9AB64)

C Thu Apr 09 10:33:51 2009

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12518

[dboci.c 4172]

C *** ERROR => CONNECT failed with sql error '12518'

[dbsloci.c 10933]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@SM3 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05C84528 05C89AC4 05C8934C

C Detaching from DB Server (con_hdl=0,svchp=05C89298,srvhp=05C9AB64)

C Attaching to DB Server SID (con_hdl=0,svchp=05C89298,svrhp=05C9AB64)

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12518

[dboci.c 4172]

C *** ERROR => CONNECT failed with sql error '12518'

[dbsloci.c 10933]

B ***LOG BY2=> sql error 12518 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-12518: TNS:listener could not hand off client connection [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 12518 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-12518: TNS:listener could not hand off client connection [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1411]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10156]

M Info for wp 16

M stat = 4

M reqtype = 6

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M vm = V-1

M *****************************************************************************

M *

M * LOCATION SAP-Server hostname_SM3_01 on host tcs042619 (wp 16)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Apr 09 10:33:51 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10354

M * COUNTER 1

M *

M *****************************************************************************

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc16 7988) [dpnttool.c 327]

Any suggestions pls

Mahesh

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 05:35:04 GMT

ERROR => CONNECT failed with sql error '12518'

Indicates problem with listener service check this link for that [http://download-east.oracle.com/docs/cd/B10501_01/network.920/a96580/listener.htm]

Was there any activity done at database side ? was there any heavy load on the server at that time ?

Regards

Uday

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 05:46:06 GMT

hello Mahesh,

do the following:

open the command prompt as <sid>adm

sqlplus / as sysdba

shutdown immediate

startup

do you receive any errors?please let us know

If no then do R3trans -d

and tell us the error code

Rohit

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 05:55:52 GMT

Hi Rohit,

Oracle is down.. and when itried to start the oracle from the os i am getting the following the error.

SQL> startup;

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-03113: end-of-file on communication channel

during the startup the oracleService is stopped .. after starting the oracleService again then i am getting the following the error..

SQL> startup;

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

Listener service is running...

Any work around pls

Mahesh

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 06:02:01 GMT

Can you post the startdb.log file. You can find it in /oracle/SID directory

Lokesh

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 06:06:58 GMT

Mahesh

Can you check if the environment varaibles PATH, ORACLE_HOME are set

Also refer to note 619172,it might be useful

Rohit

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 14:11:15 GMT

Hi Rohit,

Sorry for the late reply I have crossed check the env variables .. but they are all ok.. I am not getting why the oracle service is stopping when i execute the startup command.. is there any logs we can for the services?

Mahesh

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 14:16:30 GMT

Hi Rohit,

when i check in the sqlnet.log

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SM2\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 04-SEP-2007 15:09:30

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS

ns secondary err code: 0

nt main err code: 530

TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:16:32

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:16:46

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:19:27

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:19:28

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:19:29

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 19:26:38

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12518, connecting to:

(DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=hostname)(PORT=1527))(CONNECT_DATA=(SID=SID)(GLOBAL_NAME=SID.WORLD)(CID=(PROGRAM=D:\usr\sap\SID\SYS\exe\uc\NTI386\R3trans.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 20:35:23

Tracing not turned on.

Tns error struct:

ns main err code: 12564

TNS-12564: TNS:connection refused

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12518, connecting to:

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 08-APR-2009 20:35:23

Tracing not turned on.

Tns error struct:

ns main err code: 12564

TNS-12564: TNS:connection refused

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 09-APR-2009 09:15:43

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=SID)(CID=(PROGRAM=E:\oracle\SID\102\bin\sqlplus.exe)(HOST=hostname)(USER=SIDadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 09-APR-2009 09:17:28

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

This error occured when the oracle service was not started..

Mahesh..

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 20:46:08 GMT

Hi,

please first of all have a look to the alert log file ($ORACLE_HOME/saptrace/background/alert<SID>.log)Also check the Metalink note for some work arounds: 550859.1.

For metalink user credentilas use the SAP Note: 758563.

http://www.orafaq.com/forum/t/38256/0/

Hope this helps.

Thanks,

Sushil

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Thu, 09 Apr 2009 21:58:53 GMT

Mahesh,

Version 10.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 04-SEP-2007 15:09:30

Above oracle version is not supported. Try to upgrade to 10.2.0.2.0.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=839187]

http://service.sap.com/pam

Hope this helps.

Manoj

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Fri, 10 Apr 2009 08:47:31 GMT

Hi All,

I have rebooted the server and it is working fine now..

Thanks for all your support

Mahesh

Re: ERROR => CONNECT failed with sql error '12518'

Former Member — Fri, 10 Apr 2009 08:47:33 GMT

Hi All,

I have rebooted the server and it is working fine now..

Thanks for all your support

Mahesh