You'll have to setup tnsnames.ora which usually lives
in $ORACLE_HOME/network/admin or
$ORACLE_HOME/net80/admin. In this file (which u can
edit with ur fav. editor) you have to specifiy the
following thins:
1. Service Name -- this is the connection name (eg.
my_connection)
2. HOST (or its ip address),
3. PORT (usually 1521) and
4. oracle SID (default ORCL, but may depend upon your
Solaris Oracle setup).
The exact syntax is there in the file with
preconfigured examples.
Once you've set it up, you can connect to the server
using:
sqlplus username/password@my_connection
Have Fun!
Vicky
--- "Soumeyndu S. Mohapatra"
<[EMAIL PROTECTED]> wrote:
> dear friends;
> I have setuped a Linux Box and want users of linux
> to connect to Oracle
> database running in another Solaris m/c.Comments and
> Suggestions welcomed.
> your's [EMAIL PROTECTED]
>
>
>
> ----------------------------------------------
> LIH is all for free speech. But it was created
> for a purpose. Violations of the rules of
> this list will result in stern action.
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
----------------------------------------------
The mailing list archives are available at
http://lists.linux-india.org/cgi-bin/wilma/LIH
