Re: connecting to Oracle without using TNSNAMES.ORA

Doubt it - Net8 needs other information that is found in its config files. Or more accurately; when you need Net8 to do some sophisticated work for you (e.g. Advanced Networking Option (ANO)) then it stores most of its config parameters in these files.

Besides - these files offer you another 'abstraction layer' above your actual IP addresses etc.

Basically you can create your own naming system for oracle databases, through the use of service names / connect strings.

This may not sound like much but anything that avoids you having to hard-code things like IP addresses on the client side will always be worth it.

David P.

Oracle Certified DBA.

George Meltser wrote:
>
> Is it possible to connect to Oracle by specifying the connection description
> (host, port, instance_name etc) rather than connect string?
> If yes, what is the correct syntax to do it?
> Many thanks in advance.
  Received on Thu May 18 2000 - 00:00:00 CDT