Re: Help: SQL*NET V2 Please Help !!!!

<> wrote:

>I'm trying to make a connection from a client
>running win-nt 3.51 to a win-nt 3.51 server.
 [snipped]
>Is the Tnsnames.ora file created on both the client and server,
>or only on server, or only on client????

tnsnames.ora is needed on each client machine. Keep in mind that a server can also be a client if it ever connects to another server.

You also need a file called listener.ora. That's the flip side of tnsnames.ora and tells the oracle listener what port # to listen on and what SIDs (instance names) incoming connections can connect to. Client-only machines don't need this file. Only servers need it. Like tnsnames.ora, it goes in $ORACLE_HOME/network/admin.

>I'm able to ping to the server using the ip address.
>How should I define my connect string???

You should basically follow the example files. Just change the host names (or you can use IP addresses if you like) and the SID names. If you'd like, I can email you a copy of my listener.ora and tnsnames.ora files which are set up for both SPX and TCP/IP.

You might also look for a program called "Network Manager" or something like that. It steps you through the creation of these network files with a GUI interface. Then you FTP or copy the files it generates to the appropriate directories on the appropriate machines and it should work.

>If I reinstall oracle 7.1 on the server, what are the files
>to be deleted from the windows registry.

Can't help you there. I'm a unix type. Don't know much about NT.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!