Oracle via TCP/IP

From: Joe Bartling <joe.bartling_at_sqlware.com>
Date: 9 May 93 00:19:00 GMT
Message-ID: <2356.204.uupcb_at_sqlware.com>

OR>Newsgroups: comp.databases.oracle
OR>From: oracle_at_v7.vitro.com
OR>Subject: Oracle via TCP/IP
OR>Message-ID: <1993Apr28.154503.1_at_v7.vitro.com>
OR>Date: Wed, 28 Apr 1993 19:45:03 GMT

OR>I would like any information about connecting to an Oracle database using SQL
OR>via TCP/IP.  I have installed ORACLE Tools and configured the I/O card for my

OR>TCP/IP address but have been unable to connect to the Database. Any comments OR>or suggestions would be helpful. I am getting error message 6120. Thanks

Are you loading SQLTCP on the DOS side? You need to load SQLTCP on the DOS side and connect using the connect string as in:

      SQLPLUS SCOTT/TIGER_at_t:hostname:A

Make sure the exact hostname is in the /etc/hosts file on the pc and that the pc /etc/services file has an entry for the tcp listener process, usually 1526.

Good luck, Joe

---
 . OLX 2.1 TD . My reality check just bounced.
                                                                                                                             
----
+--------------------------------------------------------------------------+


| SQLWare BBS  703-771-4158 (HST V.32BIS-Specializing in ORACLE and other  |


| RDBMS topics.  Sponsored by SQLWare Inc., Leesburg,VA-300 conferences.   |


+--------------------------------------------------------------------------+

Received on Sun May 09 1993 - 02:19:00 CEST