| database start up priority [message #131514] |
Sun, 07 August 2005 23:55  |
owais303
Messages: 19
Registered: July 2005
Location: India
|
Junior Member |
|
|
hi,
I have two databases A and B residing on same machine,when i connect using following string
sqlplus /nolog
connect / as sysdba
startup
and then check SHOW PARAMETER command the paths etc are displayed corresponding to dtatabase B
and when i connect as
sqlplus username@A
Password ******
and then check SHOW PARAMETER command the paths are displayed
corresponding to A
In order to start database A issued following commands
sqlplus /nolog
connect / as sysdba
startup pfile='path of database A init.ora' but following error is returned "cannot mount database in EXCLUSIVE mode"
Kindly help me out
|
|
|
|
| Re: database start up priority [message #131520 is a reply to message #131514] |
Mon, 08 August 2005 00:35  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi,
if u want to start database A with the following option
connect / as sysdba
without specifying a service name then u hav to set an environment variable ORACLE_SID that will point to the name of ur database A rather than database B.
Simply u can do that
right click on my computer --> go properties --> Advanced tab --> U wil find Environment variables button ( click on it ) --> there u wil find two text boxes one for system variables and other for user variables --> Edit ur ORACLE_SID to the name of ur database A and save
now try to connect.
rgrds,
tarun
|
|
|
|
| Re: database start up priority [message #131956 is a reply to message #131520] |
Wed, 10 August 2005 02:51 |
edcas
Messages: 38
Registered: July 2005
|
Member |
|
|
hi tarun,
I also hav the similar problem here. but I can't find the ORACLE_SID as u mention in the environment variable setting. Do i have to create a new one? if so, what is the path name?
|
|
|
|
| Re: database start up priority [message #131960 is a reply to message #131956] |
Wed, 10 August 2005 02:58 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Yea u can create a new one.
Simply u can do that
right click on my computer --> go properties --> Advanced tab --> U wil find Environment variables button ( click on it ) --> there u wil find two text boxes one for system variables and other for user variables --> add ur ORACLE_SID to the name of ur database A and save.
After that now database A has most priority.
so if u use
usname/psswd then u wil connect to database A.
and if u wil use
usrname/passwd@B then u wil connect to database B.
regards,
tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
