-->

03 December 2012

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



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

Here I am going to discuss about the specific error”ORA-12154: TNS:could not resolve the connect identifier specified” when user tries to connect to the database from 10g FORMS & REPORTS DEVELOPER.The problem can be solved by doing a little work, in a few steps, as illustrated below. 

After installing the oracle developer suite 10g, I tried to connect to the local database(10g) previously installed on my pc,but I end with the error”ORA12154:TNS:could not resolve the connect identifier specified” and can`t connect to the database,it was because when we install the database 10g a net service name “orcl” is automatically created and is used to connect to database through listener,the listener identifies the specific net service name(connect identifier) and establishes theconnection from where it is initialized, but what happen when we try to connect to database through FORMS & REPORTS DEVELOPER SUITE is the listener cannot identify the net service name(connect identifier),because it is being initialized from and by the FORMS & DEVELOPER SUITE ,To solve the problem and to connect to the database there are two ways

1) To Reconfigure the NET SERVICE NAME from the developer suite 10g.
2) To follow the following steps.

STEP 1
Navigate to the path where you installed database 10g >oracle>product>10.2.0(version)>db_1>network>admin

Eg: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 
(Note here C:\ is my installation drive) 

There you will find a file named atnsnames.ora” copy that file



STEP 2

Navigate to the path where you have installed 10g developer suite>network>admin
Eg: C:\DevSuiteHome_1\NETWORK\ADMIN

and paste the file “tnsnames.ora” 



Then try to connect to the database

Connected