Oracle 9i DB taking forever to start up
Hey all
Just a quick Question. I have cloned databases in the past with no problem at all. But I have cloned a DB in this instance and a problem as arisen.
When teh Machine starts up I enter command prompt and enter the follwoing
set oracle_sid=rrprod
sqlplus /nlog
connect / as sysdba
it then says connected to and idle instance. It is supposed to startup automatically.
so i then run
startup
and from here it takes about 5 min to come up with this
ORACLE instance started.
Total System Global Area 101785428 bytes
Fixed Size 454484 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
and then another 8/9 minutes to actually open the database.
Its not a huge problem as i very rarely shut this machine down and once the database is open it runs fine.
Anyone know what could be the prolem here? If you have a solution or a suggection could you please explain to me exactly what to do as Im and Oracle Newbie!
Cheers
Graham