Re: Connecting to a oracle NT server from sun solaris client?

Burzin Engineer (burzin_at_twinsun.com) wrote:

: 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!

You need named pipes to talk to an NT DB install named pipes on both ends and connect p:kline:orcl

Good Luck !

--
John D. (JD) White Client/Server Consultant Inventor of the ATM
Whiteline Design, Inc. 7812 Blackwing Ct.Raleigh, NC  27615  USA