ORA-12154: TNS Could not resolve the connect identifier specified.

[kishorependyala]

Hi,

I'm having the following error ORA-12154: TNS Could not resolve the connect identifier specified.

With SQL developer with same TNS I'm able to connect but with PLSQL developer I'm having the issue. Please help me in resolving the issue.

Thanks,
Kishore

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[kishorependyala]

I have sent an email... please let me know the next steps..

 

[Marco Kalter]

Thanks. Can you start C:\Oracle\ora112\bin\sqlplus.exe and check if it allows you to connect to the same database?

C:\Oracle\ora112\bin\sqlplus.exe

Enter user-name: @
Enter password:

 

[kishorependyala]

Hi,

Here is the result

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

 

[kishorependyala]

Hey,

I did not do any thing but now, I'm able to connect.

Thanks,
Kishore