| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: how to connect to multiple instances on Solaris
G'Day,
In article <3994711c$0$19472_at_wodc7nh6.news.uu.net>,
"Sajnish Gupta" <sajnish_gupta_at_yahoo.com> wrote:
> We have multiple oracle instances on the same Solaris machine.
Currently I
> have to keep changing $ORACLE_SID for that particular instance if I
want to
> connect to sqlplus or perform svrmgrl functions. Is there a way that
I don't
> edit the .profile and still connect to svrmgrl for a differenct
instance?
For SQLPLUS, you can connect to any database with:
sqlplus scott/tiger_at_SID
no matter what ORACLE_SID is set to (as long as your listener.ora and
tnsnames.ora files are correct, of course).
AFAIK you can only specify databases to SVRMGRL with the ORACLE_SID environment variable. One easy thing to do is to create a small shell file to change this for you, ie:
sid DB1
to change the ORACLE_SID to DB1 and then run . oraenv
Easy to do, saves you typing and you can set it to show the status
of all databases when it is run with no parameters :-)
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Brad van Eps vaneps_at_my-deja.com
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Aug 14 2000 - 22:17:43 CDT
 |
 |