Dave,
I have TCP/IP working. I can ping the server with the data base. As I said, my
tnsnames.ora file was copied from the NT box. Oracle is up and running on the NT
box and I can login from an NT box. TCP/IP is setup in the tnsnames.ora file.
The question is, how do I login from the Linux box so that the NT server will do
the proper authentication so I can use sqlplus to connect to the database.
Thanks.
Rick Bilonick
> CHeck the protocol entry. I have no problem going the other way. nt-> linux.
> Youo need to have an entry in the nt box that looks something like like this:
> <oracle_sid> =
> (DESCRIPTION =
> (HS = OK)
> (SOURCE_ROUTE = OFF)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = <oracle_host>)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = <SID or service name>)
> (ORACLE_HOME = <full path to oracle home durectory>)
> (SRVR = DEDICATED)
> )
> )
> Note the protocol = TCP entry. I believe on NT you need to have the listener
> service registered and running also. With a TCP listener on the 1521 port and
> a client on the linux box the only authentication that will take place is the
> DB authentication. If I remember right, be carcul about CASE on all NT stuff.
> If this doesn't help, will ask my buddy that is running a NT server how he gets
> UNIX boxes to connect.
> > The tnsnames.ora file has already been copied from the NT server to the Linux
> > box. Running Net8 on the Linux box shows the items in the tnsnames.ora file.
> > Having the tnsnames.ora file is not enough.
> > The problem is with the OS Authentication that the NT server is doing. I need
> > to be "logged in" to the network (a particular domain). I think that I can use
> > the smbmount and/or the smbclient to do the login. I have used these commands
> > to access files in windows shares on the network. I can't try this until
> > Monday. I believe when I tried to use sqlplus I wasn't logged into the Windows
> > network. Can anyone confirm that this will work? I need to get the OS
> > authentication on the NT server side to work when I start sqlplus.
> > Rick Bilonick
> > > You need to setup a tnsnames.ora file on the Linux box to describe the
> > > connection
> > > to the oracle database. Generally the tnslistener on the Oracle box has a
> > > port at 1521 setup. Check for the tnsnames.ora on the NT platform and make
> > > the Linux box look similar. Make sure the NT platform has support for
> > > TCP/IP enables.
> > > Oracle is great but not easy for a first time setup.
> > > > I need to access an Oracle data base that (unfortunately) resides on an
> > > > NT server. I have set up sqlplus on Linux (from Oracle 8i for Linux). I
> > > > can get to the windows network (using smbclient and smbmount). I have an
> > > > NT logon id and password that work (I tested them on an NT box and I use
> > > > them with smbclient and smbmount) and can get to the data base by typing
> > > > Unfortunately I cannot get this to work from the Linux box. Somehow I
> > > > need to login to the windows network (so that windows sees my id and
> > > > password). I think I need to install Samba to set up the login but am
> > > > not sure. (I have smbclient and smbmount without having installed
> > > > Samba.)
> > > > I can ping the server (using it's name) and everything else seems to be
> > > > working just fine.
> > > > Any information would be greatly appreciated.
> > > > Rick
> > > > --
> > --
> > Statistical Consulting for Business & Industry
> > "Where statistics help is as close as the Internet."
> > http://www.nauticom.net/usrs/rab/
--
Statistical Consulting for Business & Industry
"Where statistics help is as close as the Internet."
http://www.nauticom.net/usrs/rab/
by