Re: Installation on NT

1. If it is your own private network, you can make up the IP address you use between the Client (Win95) and Server (WinNT).
2. Configure the IP addresses at the operating system level.
3. Configure Oracle to use the hostnames of the system.
4. Both WinNT and Win95 have a hosts file. This can be used to may computer names to IP addresses.

the TCP/IP Loopback address is only used for the local system (i.e. it loops back on to itself, you can only use this from a client that exists on the same oracle db server. )

Do the Following:

1. Give your Winnt and Win95 IP addresses each, say 194.6.199.100 and 194.6.199.101 respectivily. This is done at the operating system level.
2. After rebooting the machines, see if they can see each other by pinging them. Ping the client from the server and vice versa.
3. If they can see each other, you need to do two things.
4. Configure the Listener.ora file on the Server (WinNT).
5. Configure the Client using Net8 Easy Config to point to the Server. (Use the IP address of the server as the HOST string).
6. You should be able to establish an SQL*Plus session from the client to the server.

I hope this helps. If you have questions pls ask.

Regards

Hassan Abba
Oracle DBA/Developer

Hessel H.J. de Haan wrote:

> Hello,
> - I've installed Oracle server version 8 on my Windows NT 4 server.
> - On this file-server I've created the standard ORCL database and I've
> modified the TNSNAMES.ORA and the LISTENER.ORA so I can reach the
> database (as
> system/manager, on the server). This goes OK
> - I've installed the Oracle 8 client on my Windows 95 workstation
> - The windows workstation/username has an account on the NT server (I
> can login / map /
> etcetera)
> - I've modified the TNSNAMES.ORA file in G:\ORAWIN95\NET80\ADMIN and
> changed the HOST name, so now it's:
>
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = my_nt_server)
> (PORT = 1521)
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
> BUT: I can't reach the server from the workstation. I think I have to
> install the
> TCP/IP part of both the NT server and the Win95 workstation, but how,
> where
> and what? I dont have a real TCP/IP adress, so is there some sort of
> fake adress
> one can use? Please help me.
>
> Thanks in advance.
>
> Hessel de Haan
Received on Mon Feb 02 1998 - 00:00:00 CET