Re: syntax of connecting to a remote DB in sqlplus?

Well, of course, that is what Oracle Names is for.

But if you insist:

connect scott/tiger@(description=(address=(protocol=tcp) (host=aaa.bbb.ccc.com) (port=1527))(connect_data=(sid=TTTT)))

Grace Tsai wrote:

> I have the sqlplus in my Oracle client machine, I like to let users have
> the freedom to connect to any remote database as long as they have the
> valid user account. So I dont want to configure the remote databases in
> the tnsnames.ora or any other .ora files.
>
> So my question here is : What is the syntax of sqlplus to access a
> remote database if I have the valid username/password, remote machine
> name, and the instance name? Should be something like sqlplus
> scott/tiger@<instance>. But where should I specify the machine name.
>
> Thanks very much in advance.
>
> Grace Tsai
> Brookhaven National Lab
Received on Tue May 04 1999 - 23:20:45 CDT