| multiple databases [message #131528] |
Mon, 08 August 2005 01:44  |
owais303
Messages: 19
Registered: July 2005
Location: India
|
Junior Member |
|
|
hi,
I have two databases A and B installed on my machine
when i connect to the database using the following commands
sqlplus /nolog
connect / as sysdba
startup
and issue SHOW PARAMETER command i get the details of parameters present in init.ora of database B,however when i shutdown the database and reconnect as
sqlplus
connect user_name@A
password *********
and issue SHOW PARAMETER command i get parameter details corresponding to init.ora of database A
but when i shutdown again and start up as
startup pfile='path of init.ora of database A'
i get an error of could not mount database in exclusive mode
Kindly tell me how to start the database A by default by using startup command
|
|
|
|
| Re: multiple databases [message #131569 is a reply to message #131528] |
Mon, 08 August 2005 05:39  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
IF OS is windows, Check for services configured on machine. Make oracle related services specifically ORACLESERVICE<SID> & oracle listener to start automatically.
Regds
Girish
|
|
|
|
| Re: multiple databases [message #131588 is a reply to message #131528] |
Mon, 08 August 2005 08:16 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
What about setting as follows:
1. windows system
set oracle_sid=a
2. unix
export oracle_sid=a
then log in as sysdba and startup pfile='init-from-database-A'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
