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_at_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 Sat Mar 20 2004 - 04:08:19 CET

This message: [ Message body ]
Next message: Mark C. Stock: "Re: How to use an array in the IN clause?"
Previous message: sui generis: "Can a function() be used to change parameter value in stored procedures ?"
In reply to: Larry Doan: "Running Oracle remotely"
In reply to Larry Doan: "Running Oracle remotely"
Next in thread: Mark C. Stock: "Re: How to use an array in the IN clause?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message