Link to home
Start Free TrialLog in
Avatar of gram77
gram77Flag for India

asked on

Connecting to database using Pl/Sql Developer ver. 7.1.5.1398

I am trying to connect to the database using pl/sql developer.

I have the following queries:
1. Like in Sql Developer and TOAD, i do not see a way in which i can connect to the database directly without using TNSNAMES.ORA. In Sql Developer and TOAD, I directly provide the connection settings like Hostname, Port, Service Name, Username etc. Is there any way I can provide connection details directly in Pl/Sql developer

2. I have multiple homes configured.
C:\oracle\ora10
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN: TNSNAMES.ORA file present
C:\oracle\product\11.2.0\client_32\NETWORK\ADMIN: TNSNAMES.ORA file present

Against which in Pl/Sql Developer I see Oracle Homes as
Ora920
ORACLE10GODBC
OraClient10g_home1
Client11gR2_32bit

Inspite of having the correct TNSNAMES.ORA file in the above Oracle Homes, I do not see correct entries in Database connection string. Why?
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial