i have 2 databases 'oracle' and 'praveen' on same server.
operating system is windows NT.
when i startup the database it is giving the error
ora-01102 cannot mount the database in exclusive mode.
is this problem because of two databases or any other problem?.
what is exclusive mode?.
should i have to change the mode to startup the database?.
where i should i have to change?.
can i open 2 databases at a particular point of time by giving startup pfile='.....................' for differnet init.ora files of different databases?.
is it possible.
give me the solution .
i will thankfull.
This error occurs if some other instance has the database mounted exclusive or shared. You can have two databases running on the same machine but you should have sufficient real memory for SGAs of both the databases.
Is the problem because Instance names are same? Do you have different init.ora files (with different names) for both databases?
thank u for reply,
but i have same name 'init.ora' for 2 different database 'oracle' and 'praveen'.
can i change the name os the file 'init.ora' now?.
if so how is it?.
i have sufficient rel memory for sga's of both databases.
i want to run the 2 databases at a time.
Specify the init file name when starting up the db
Since you have two instances, you will need to specify the pfile (initfile) when starting the database. If you do this then you shouldn't get that error.
STARTUP PFILE=PATH\FILENAME (this will be path/name of init file for that instance)
Since the parameter DB_NAME is different, you cannot have same init.ora for both databases. Copy your init.ora with OS commands, change the required parameters in the second init.ora and then open both databases one by one with pfile=' '.
Click Here to Expand Forum to Full Width