SAP Knowledge Base Article - Preview

2498036 - Database connection fails with "OCI returned error code -1"


SAP system can not connect to oracle database.
In work process trace file dev_w.txt or "R3trans -d" log file trans.log, it contains the following log information:


4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/<SID>/SYS/exe/run/' ...           
4 ETW000  [     dev trc,00000]  Library '/usr/sap/<SID>/SYS/exe/run/' loaded                
4 ETW000                                                                                               
4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error -1     performing CON                              
4 ETW000  [    dblink  ,00000]  ***LOG BY0=>OCI returned error code -1.                                   
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = '<SID>"

->Work Process Trace

B  ***LOG BY2=> sql error -1     performing CON [dbsh         1246]
B  ***LOG BY0=> OCI returned error code -1. [dbsh         1246]
B  ***LOG BY2=> sql error -1     performing CON [dblink       544]
B  ***LOG BY0=> OCI returned error code -1. [dblink       544]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1599]



ORACLE Database


TABSPC_PREP, start fail, connection, connectivity, R3trans, OCI, sql error -1, R3trans -d, OCI, performing, CON, trans.log, WP, dev_w, work process, startsap, sapcontrol , KBA , BC-DB-ORA , Oracle , BC-CST-STS , Startup Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.