Connecting to a oracle NT server from sun solaris client?
Date: 1995/10/03
Message-ID: <44spq1$691_at_tattoo.twinsun.com>#1/1
Hello,
I am trying to connect from a sun solaris 2.4 box (client) to a Windows NT box running Oracle server. I am running into a lot of problems. It is hard for me to know what the problems are as I am not that familiar with Oracle. Any help or a step-by-step guide will be appreciated. Here are the details..
My loopback test on the NT box works fine. i.e. connect scott/tiger_at_t:kline/7560:ORCL works.
My /etc/services on unix side has
orasrv 7560/tcp
My files on unix look like this:
$ORACLE_HOME/network/admin/listener.ora
LISTENER=orasrv
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=tcp) (HOST=kline) (PORT=7560))
(ADDRESS= (PROTOCOL=IPC) (KEY=kline)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=ORCL)
(ORACLE_HOME=/opt/oracle)
)
)
TRACE_LEVEL_LISTENER = OFF
PASSWORD_LISTENER = (2CCDA1FA29BAD2A4)
I get the following errors when I try connecting from Solaris.
connect scott/tiger_at_t:kline/7560:ORCL,conn-retries=5 ORA-06401: NETCMN: invalid driver designator
connect scott/tiger_at_nt
ORA-12203: TNS:unable to connect to destination
My $ORACLE_HOME/network/admin/tnsnames.ora file looks like:
nt=
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)
(PORT=7560) (HOST=kline))))
Are there any files I missed??
Thanks in advance.
-- -- Burzin N. Engineer |Tel. (310) 524 1800 | email: burzin_at_twinsun.com Twin Sun Inc. |Fax. (310) 524 1818 | MIME OkaY!Received on Tue Oct 03 1995 - 00:00:00 CET