error when applying PI_BASIS patch SAPKIPYM03 on ECC 6

[Former Member]

Dear Gurus,

I have ECC 6 running on Oracle 10.2.0.4 and my OS is SUSE LINUX ENT 1. My Kernel patch level also the latest one 236.

I am getting the following transport errors when i applying PI_BASIS patch SAPKIPYM03 via SPAM. Appreciate if someone can help me to resolve this issue.

S_LOG (i grep only the ERRORS in the log):-

/usr/sap/trans/log/SAPPIPYM03.NAG:4 ETW000 TRACE-INFO: 39: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

/usr/sap/trans/log/SAPPIPYM03.NAG:4 ETW000 TRACE-INFO: 41: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 19 0.182340

/usr/sap/trans/log/SAPPIPYM03.NAG:4 ETW000 TRACE-INFO: 57: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

/usr/sap/trans/log/SAPPIPYM03.NAG:4 ETW000 TRACE-INFO: 59: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 36 0.253573

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1089 in stmt_execute() from oci_execute_stmt(), orpc=0

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1089 occurred when executing SQL stmt (parse error offset=0)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCITransRollback' failed with rc=3114

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 TRACE-INFO: 41: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 TRACE-INFO: 43: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 80 3.439127

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 TRACE-INFO: 59: [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12537

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 TRACE-INFO: 61: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537' 34 3.543518

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1089 in stmt_fetch() from oci_execute_stmt(), orpc=0

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1089 occurred when executing SQL stmt (parse error offset=0)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 3114 in stmt_fetch() from oci_execute_stmt(), orpc=1

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-3114 occurred when executing SQL stmt (parse error offset=0)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCITransRollback' failed with rc=3114

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1089 in stmt_execute() from oci_execute_stmt(), orpc=0

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1089 occurred when executing SQL stmt (parse error offset=0)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCITransRollback' failed with rc=3114

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1089 in stmt_fetch() from oci_execute_stmt(), orpc=0

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1089 occurred when executing SQL stmt (parse error offset=0)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => Error 3114 in stmt_execute() from oci_execute_stmt(), orpc=1

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-3114 occurred when executing SQL stmt (parse error offset=7)

/usr/sap/trans/log/SAPIIPYM03.NAG:4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCITransRollback' failed with rc=3114

Thanks & Regards,

Kalyan.

[former_member204746 · Accepted solution]

read the following link:

http://www.dba-oracle.com/t_ora_12537_tns_error.htm

[Former Member]

Resolved..

[Former Member]

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

Could you make sure that DB and listener run well? Please also log in OS as SIDADM and run r3trans -d

Regards,