SQL*Net connection WITHOUT a tnsnames.ora file ? How?

From: <atraber_at_bigfoot.com>
Date: 1997/08/13
Message-ID: <871482912.7088@dejanews.com>#1/1

Environment: SUN Solaris 2.5, Oracle 7.3.., SQL*Net 2.3... Task:
I need to check a database connection BEFORE a tnsnames.ora file is available on the client workstation.

Can all the stuff normally located in the tnsnames.ora somehow be specified on the command line for example for sqlplus ?

I tried something like:
sqlplus scott/tiger@(ADDRESS=(COMMUNITY=TCP_com)(HOST=...)(Port=..)... but no matter what i specify: in the end there is always a result like  ...cannot resolve service name etc...

Anybody knows how to get around this tnsnames.ora ?

---

Arnold Traber
Union Bank of Switzerland
Postfach
CH-8021 Zurich
Switzerland

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Wed Aug 13 1997 - 00:00:00 CDT