Not Able to connect to Database

[soumik]

Hi,
Please tell where I have to make TNS entries.
In My system, I have Oracle 10g Rel.2 Database. Oracle 10g Client and Oracle 6i Forms and Reports.

Thnks and Rgds
Soumik

 

[soumik]

I am trying to connect to database using PL/SQL developer tool. Please let me know where i hv to maintain neccesary TNS entries...

 

[Marco Kalter]

If you start PL/SQL Developer without connecting and go to Help > Support Info, you can see which tnsnames.ora file PL/SQL Developer is using. You can either modify this tnsnames file, or use the preferences to force PL/SQL Developer to use a different Oracle Home.

 

[Rajasekar]

Hi,

First check these two thing in Pl/Sql developer:

Tools -> Preferences - > Options:

Check Oracle Home and OCI library is empty or not

It both are empty then,
set those two locations:

i.e

Oracle Home = C:\oracle\product\10.1.0\db_1\BIN
OCI Library = C:\oracle\product\10.1.0\db_1\BIN\oci.dll

These location may differ. For Oracle Home find BIN directory..For OCI Library find oci.dll location and set these two values and reopen the pl/sql developer 'll take tnsname file from the default location(i.e C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\tnsnames.ora).

The default location may differ just see ....NETWORK\ADMIN\tnsnames.ora path