With out TNS connecting

[sumanamara]

Hi All

is there any option in pl/sql tool without using TNS manual process like a
user/pwd/hostname/servername/port name like SQL Developer tool manual connection

 

[fabrice]

Hi,
you can try tu put your database like this
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))(CONNECT_DATA = (SID = BDD_SID)))

 

[Marco Kalter]

If you will not be using tnsnames, you can perhaps enable EZCONNECT in your sqlnet.ora file and use this method. It uses the following format:

host[ort]/database

The default port number is 1521, in which case it can be omitted:

host/database

See also:
https://www.orafaq.com/wiki/EZCONNECT