It's possible to logon without tnsnames.ora?

[giga]

Hi, how can I logon using DOA to database without add record in tnsnames.ora? It's possible to logon using IP address, port, and service name or SID?

Thx V.

 

[Marco Kalter]

Yes, you can use the EZCONNECT method. This has to be declared in the sqlnet.ora file in the TNS_ADMIN directory. For example:

NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES)

Now you can connect with a host/database notation. For more detailed information, see:

http://www.orafaq.com/wiki/EZCONNECT