Universe can't connect to oracle

[Former Member]

Hi ,

On Window x64 , installed oracle 32bit client

oracle DB is 10G, installed on another server

BY ODBC :

32bit ODBC connect to oracle , test connection is ok, TNS can be recognized

But in universe, new connection,

using that ODBC connection , TNS is not recognized

Error message :

DBD: ORA-12154: TNS: could not resolve the connect identifier specified

By Oracle native connection :

in universe, new connection,

using oracle 10G connection , TNS is not recognized

Error message :

DBD: ORA-12154: TNS: could not resolve the connect identifier specified

We have checked/tested in oracle Net Manager,

and window 32bit ODBC, everything seem ok

we have also tried 64bit oracle client,

it is the same

Any solution?

thx

John Kong

[Former Member]

I am not sure if I understand your problem correctly. Please ignore if it didn't work out.

U can try to use the navigation connection called ODBC Connection under Generic ODBC connection.It may ask some credentials

like User ID,password then it shows list of ODBC connections select connection created by u.

Regards!

Pradeep

[Former Member]

Have you tried to tnsping the destination server?

Have you tried logging on to the target database with the universe connection username and password using sql*plus / PL/SQL Developer / TOAD yet?