Question Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db in Technology Q&A

Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 20:03:17 GMT

We must connect our SAP production system to an external oracle database that has the following characteristics: PARAMETER -------------------------------------------------- -------------- VALUE -------------------------------------------------- -------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CHARACTERSET WE8ISO8859P15 ***************** We have configured the connection with the TCODE DB02 and we get the following connection error: "Errore -- ERROR Database connection "MAGIAP": SQL error 12737 ORA- 12737: Instant Client Light: unsupported server character set WE8ISO8859P15" We applied the following SAP notes: 808505 - Secondary connections to Oracle database 998004 - Update the Oracle Instant Client on Windows After applying this notes we reconfigured the connection parameters (tcode DB02) as follows: connection parameter: "SFA.DBSFA.risogallo.it:WE8ISO8859P15" we now have this connection error: -- ERROR Database connection MAGIAP: SQL error 2- OCI returned error code -2.

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

Former Member — Sun, 29 Dec 2013 21:49:55 GMT

Hi Silvana

From your details above , I assume that you are connecting to the database using tnsnames.ora

From your SAP system , can you test tnsping to the remote Oracle DB.

tnsping MAGIAP

As I understand , you have upgraded your oracle instant - after that you can use the connection as MGIAP as you were doing earlier.

Please correct me if I did not assume something correctly.

Thanks

Rishi

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

Former Member — Sun, 29 Dec 2013 21:58:41 GMT

Also from the initial part of the error description , it looks like that the issue is with the Oracle instant client light present on the SAP System as it might not support the mentioned character-set of the remote system.

Please try as per previous comment - and let us know. You might want to upgrade the oracle client to the Oracle Instant Client Full and then try ..

Thanks

Rishi

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 22:03:19 GMT

Magiap is the connection name, tns is sfa.dba.risogallo.it... I have just tried to tnsping sfa.dbsfa.risogallo.it .. what else could I check?

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

Former Member — Sun, 29 Dec 2013 22:29:47 GMT

Can you please share the output of the TNSPING to the connection sfa.dbsfa.risogallo.it

Also please share the tnsnames entry and the output from the above DB Connection.

Thanks

Rishi

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

Reagan — Sun, 29 Dec 2013 23:09:39 GMT

Hello

Can you share the tnsnames.ora file ?

Regards

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 23:16:59 GMT

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 23:18:14 GMT

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 23:20:09 GMT

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 23:24:33 GMT

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

former_member822355 — Sun, 29 Dec 2013 23:26:02 GMT

I have attached some informations... Tell me please if they area enough for your answer

Re: Database connection error: SQL error 2- OCI returned error while connecting to an external oracle db

Former Member — Sun, 29 Dec 2013 23:28:29 GMT

Hi Silvana

Thanks for your screen shots ..

from your SAP System - are you able to normally logon to the Oracle Database using SQLPLUS utility from the command prompt.

Thanks

Rishi