Question Re: Oracle database connection error: OCI returned error code -1 in Technology Q&A

Oracle database connection error: OCI returned error code -1

Former Member — Wed, 05 Apr 2017 13:37:58 GMT

Hi,

I am having problems to set connection between Solman 7.2 ABAP system with sybase DB and managed system's Oracle database. It appears the following error when I execute ADBC_TEST_CONNECTION report:

Could not open connection <ID>.
sql error 1- occured:
con=1(<ID>): OCI returned error code -1.

I also check the connection from OS using tnsping having the following error:

I installed oracle instant client in solman abap system and I also defined those enviroment variables:

LD_LIBRARY_PATH=/usr/sap/<SID>/SYS/global/syb/linuxx86_64/sybodbc:/sybase/OSP/ASE-16_0/lib:/sybase/<DBID>/OCS-16_0/lib:/sybase/<DBID>/OCS-16_0/lib3p64:/sybase/<DBID>/OCS-16_0/lib3p:/usr/sap/<SID>/SYS/exe/run:/usr/sap/OSP/SYS/exe/uc/linuxx86_64:/oracle/instantclient_11203

TNS_ADMIN=/usr/sap/<SID>/SYS/profile/oracle

tnsnames.ora file contains

It seems that it can't find the TNS file when it is trying to do the connection but <sid>adm user has suficient permissions.

I have been trying for a long time to find the solution but I haven't gotten anything.

Any idea about the solution for this error?

Thanks.

Regards.

Re: Oracle database connection error: OCI returned error code -1

JamesZ — Wed, 05 Apr 2017 23:50:06 GMT

Hi,

Have you checked SAP note :

1261329 - DBA Cockpit: Oracle as a remote database

I am very confident the issue will be solved if the note is strictly followed.

Best regards,
James

Re: Oracle database connection error: OCI returned error code -1

Former Member — Thu, 06 Apr 2017 08:57:41 GMT

I have followed the note, but still I am having the same error.

Regards.

Re: Oracle database connection error: OCI returned error code -1

JamesZ — Mon, 10 Apr 2017 00:34:27 GMT

Since you followed the note 1261329, please repdouce this issue once and attach the corresponding SAP dev_w* trace.

Re: Oracle database connection error: OCI returned error code -1

Former Member — Mon, 10 Apr 2017 06:24:17 GMT

This is what appears in dev_w trace when I try to connect to Oracle DB.

Re: Oracle database connection error: OCI returned error code -1

JamesZ — Tue, 11 Apr 2017 00:57:15 GMT

Hi Urtzi,

This means oracle client is not successfully loaded, please do verify the client installation as per note 1261329 or note 819829.

Or you can share with us about the details how note 1261329 was applied. As mentioned previously, as long as the note 1261329 is strictly followed, it should work, because this note has been proved years without issues for remote connection setting.

Best regards,
James

Re: Oracle database connection error: OCI returned error code -1

former_member205280 — Thu, 27 Apr 2017 05:27:03 GMT

Hi,

Just to make sure, after you've installed the Oracle instantclient and created the tnsnames.ora file, did you also create sqlnet.ora file at the same directory, for example:

sqlnet.ora

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

SQLNET.EXPIRE_TIME = 10

DEFAULT_SDU_SIZE=32768

Did you also check if the SAP Kernel for Oracle database library dboraslib.so is also available? And after all the configuration, you'll need to restart the Solution Manager ABAP system.

Regards,

Michael