Re: Running Oracle remotely

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Sat, 20 Mar 2004 03:08:19 GMT
Message-ID: <DAO6c.220030$A12.123144@edtnps84>

Larry Doan wrote:
> Oracle 8i running on Solaris 8, hostA
>
> On another Sun Solaris 8, hostB, I mount hostA:/oracle
>
> I have the same user name/group on both machines.
>
> What do I need to do more in order to run sqlplus on hostB?

The ORACLE_HOME stuff is useful in pointing at the right binaries and libraries.

>
> Anything need to be done in tnsname.ora, listerner.ora, init.ora?

listener.ora = Net8 listener config.
init.ora = database config.
You don't need the above on the client, 'cause you don't run that software on client.

tnsnames.ora = client config. Make sure it is set up right.

FYI: Most people would run the installer to install the client, because there are frequently a few setup issues. G'luk

/Hans Received on Fri Mar 19 2004 - 21:08:19 CST