Connecting to database using Pl/Sql Developer ver. 7.1.5.1398

[gram77]

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?

 

[Marco Kalter]

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

If you enable EZCONNECT in the sqlnet.ora file:

NAMES.DIRECTORY_PATH=(ezconnect, tnsnames)

then you can use a host[ort]/service_name notation in the database field during logon. For example lsv812:1523/chicago will connect to service chicago on host lsv812 through port 1523. The default port is 1521.

2. Inspite of having the correct TNSNAMES.ORA file in the above Oracle Homes, I do not see correct entries in Database connection string. Why?

Can you go to Help > Support Info and let me know the information from the "Info" tab page?