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

Sangeeta Pandey

Hello Experts,

I uploaded my RPD at OAC server (through OAC console) and can see my RPD listed in Analytics page. However when I am trying to create report (drag fields for analysis report and click on results), getting error in below.

Is it due to missing TNS entry at tnsnames.ora file at OAC server?

Any Idea what is this page? I guess I do not need to create connection in this page if I need to use RPD with connections specified at it's connection pool?

Thanks,

Gianni Ceresa

You can't use a TNS name in OAC because you don't have access to the tnsnames.ora file on OAC (it's cloud!).

Remove the TNS name and enter a full connection string pointing to your database.

The DV connections have nothing to do with the RPD.

Sangeeta Pandey

https://community.oracle.com/tech/apps-infra/discussion/comment/16804542#Comment_16804542

Thanks Gianni !!!

Kindly help me -what do you mean by full connection string pointing to your database?

Currently I am using below connection in connection pool at RPD:

testhostname.us.oracle.com:1521/ndtpa_pol

Here testhostname.us.oracle.com is host name and 1521 is port number and ndtpa_pol is service name for database.

Is full connection string pointing to your database below?

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =testhostname.us.oracle.com)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ndtpa_pol)))

Thanks,

Sangeeta Pandey

After using full connection string as above, below error is not occurring:

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

However now query is getting timed out.

I guess I am facing some issue in connection my OAC server with DB/Data Mart server.

Thanks,

Gianni Ceresa

Ask your sysadmin to check your settings and look into network connectivity, firewalls etc.