Re: how to connect to specific database instance

Hy

Did you create an alias(service) for the Oracle instances in tnsnames.ora file?
If you did it, you can use the syntax: username/password_at_alias(service), otherwise you need to run the "Net8 Easy Config" tool to create an alias(service) for each instances.

Hope this helps

Ciao Gennaro

"Steve ." wrote:

> I have an Oracle 8i database. There are two database instances on the
> system called k5ent1 and k5ent2. I want to run a sql script on
> k5ent2. How do I make sure once I open up sqlplus that I'm viewing
> the right database? When I type connect I just type in my username
> and password. It never asks for specifics.
>
> Tried connect username/password_at_machine_name:1521:k5ent2 but it didn't
> seem to like that format.
>
> Thanks.
>
> Steve
> Remove nospam when replying thru email.
Received on Fri May 12 2000 - 00:00:00 CDT