on 03-05-2009 6:52 AM
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.