Re: Service Names

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/10/15
Message-ID: <01bcd949$e2e48b80$f3040059@billyv.vslabs.co.za>#1/1

Steeve Boulanger <steeve_boulanger_at_berclain.com> wrote in article <3443BBEB.A17CB16A_at_berclain.com>...
> Does someone know how to configure a service name on a server to connect
> via SQL*PLUS to another server?
>
> We have an application that starts a sql*plus session directly on the
> server and try to connect to another oracle server.

Create (or update) the TNSNAMES.ORA file in $ORACLE_HOME/network/admin to contain a new TNS name for the other server. Test this entry using the tnsping command.

To connect to that server via SQL*Plus use sqlplus user/password_at_tnsname

Alternatively, create a public/private database link in your server that points to the other server and access that server using distributed sql, e.g. select * from table_at_tnsname.

regards,
Billy Received on Wed Oct 15 1997 - 00:00:00 CDT