Question Re: Database Upgrade Error- *** ERROR => CONNECT failed with sql error '12537' in Technology Q&A

Database Upgrade Error- *** ERROR => CONNECT failed with sql error '12537'

Former Member — Thu, 05 Mar 2009 06:52:19 GMT

Dears,

We have Upgraded Oracle 9.2.0.6 to Oracle 10.2 on Windows.

As per Upgrade document we have completed all steps but now my SAP system is not getting up and Work processes are ending with error:

ERROR => OCI-call 'OCIServerAttach' failed: rc = 12537

[dboci.c 4289]

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

[dbsloci.c 11395]

C Try to connect with default password

C Connecting as SAPSOL/<pwd>@SOL on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 046D3BA8 046D9224 046D8AAC

C Detaching from DB Server (con_hdl=0,svchp=046D89F8,srvhp=09752A14)

C Attaching to DB Server SOL (con_hdl=0,svchp=046D89F8,srvhp=09752A14)

C Thu Mar 05 12:15:54 2009

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

[dboci.c 4289]

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

[dbsloci.c 11395]

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

B ***LOG BY0=> ORA-12537: TNS:connection closed [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 12537 performing CON [dblink#3 @ 428] [dblink 0428 ]

B ***LOG BY0=> ORA-12537: TNS:connection closed [dblink#3 @ 428] [dblink 0428 ]

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

M in_ThErrHandle: 1

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

According to error my SAP system is not connecting with databse.

I have also set all env variables.

Shivam

Re: Database Upgrade Error- *** ERROR => CONNECT failed with sql error '12537'

Former Member — Thu, 05 Mar 2009 07:40:35 GMT

Hi,

You can get the ORA-12537 error if you listed 10g database SID with 9i listener.

The ORA-12537 error sometimes relates configuration issues in the sqlnet.ora, tnsnames.ora and listener.ora files. Verify that you service names match between your listener and remote client connect strings.

Please check SAP note 1185271 - Error: "ORA-12537: TNS: connection closed:- 12537" when attempting to refresh a report based on an Oracle universe

Try starting SAP again., if it fails then please provide contents of startdb.log

Try this command

R3trans -d & provide resulting trans.log

Hope this helps.

Thanks,

Sushil

Re: Database Upgrade Error- *** ERROR => CONNECT failed with sql error '12537'

Former Member — Thu, 05 Mar 2009 11:18:48 GMT

Issue resolved by

Creating the Oracle TNSListener Service for 10g by

<complete_path_to_new_Oracle_Home>\bin\lsnrctl start

Shivam

Re: Database Upgrade Error- *** ERROR => CONNECT failed with sql error '12537'

Former Member — Wed, 24 Feb 2016 03:56:45 GMT

Hello Susil ,

SAP note 1185271 - Error: "ORA-12537: TNS: connection closed:- 12537" is NOT visible / Publish for customer. Then what exactly you have seen in the SAP Note.

Thanks

Kushal