Re: SQLDBA on NT: multiple instances?

You can use at the command line:
set oracle_sid=sid_name

or

From the server use:
connect user_name/password_at_2:SID
connect user_name/password_at_DB_Alias

Then select * from v$datafile;
the datafile will have sys1orcl.ora or sys1sid2.ora the sid_name on the datafile is the DB your connected to.

-- 
Matt Arrocha
marrocha_at_bellsouth.net
----------------------------------------------------------------------------
---------
The views and opinions expressed are mostly my own.

Simon Mayeski <smayeski_at_dbc.com> wrote in article
<328CD4B1.4292_at_dbc.com>...


> Does anybody out there know how to "point" sqldba72 to one of several

> instances on a single NT (3.51) server? It seems sqldba depends on the

> (damn) Registry: whichever's instance SID is registered at the time is

> the one that sqldba uses; only by changing that can I "choose" which

> instance I can use sqldba on.

>