Skip to Content
0
Former Member
Apr 09, 2009 at 05:17 AM

ERROR => CONNECT failed with sql error '12518'

717 Views

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

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

M Info for wp 16

M

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 *

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

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