Re: how to connect to specific database instance

When starting sqlplus

sqlplus username/password_at_k5ent2

or from sqlplus

SQL>connect username/password_at_k5ent2 ;

In article <o5vmhscmbs1r26jipkerf4fvp82jhpokif_at_4ax.com>, syarbrou_at_nospam.enteract.com says...
> 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.
>
 

-- 
Regards,


William.
 
EuroNet*Internet BV, http://www.euronet.nl/
Wm. G. Urquhart, Oracle DBA
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam
T:+31 20 5355263, F:+31 20 5355400, E: williamu_at_nl.euro.net
M:+31 06 28206038 ICQ: 56047340