-
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
-
Hi
Did you notice anything unusual in the alert log when you start the instance .
Can you post the alert log here as a attachement
regards
Hrishy
-
Hey
Thank you for your reply!
Fogive me, but as I said I am a total oracle newbie. how do access the alert log?
are we talking about the event log that can be accessed through windows in admin tools or something else
Cheers
Graham
-
Hi
Your are working in which platform linux or windows.
If u dont know the path of the alert log file.
the alert lof file is in the bdump directory.
to get the path of the bdump directory path.
issue the command in the sql prompt
SQL>show parameter background_
then inside the bdump directory you can see the alert log sid_alert.log
gopu
-
Hey
I have managed to fix the problem due to your help.
when I cloned the Database I did not copy the bdump folder over in the admin folder.
with the result that there was no log file. I have created the bdump folder and the log file and shut down and started up the database again to fill the log file with data for you.
but because the log file was there this time the Database started up properly
thank a million buddy i really appriciate this
Graham
-
I'm sorry but I don't think that was the case.
If background_dump_dest is not available Oracle would try to write the *sid*alert.log file into $ORACLE_HOME/rdbms/log
My guess is database started faster this time just because of it shutdown nice and clean prompting a clean startup.
On the other hand, you did the right thing by creating the bdump folder.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
I'm sorry but I don't think that was the case.
If background_dump_dest is not available Oracle would try to write the *sid*alert.log file into $ORACLE_HOME/rdbms/log
My guess is database started faster this time just because of it shutdown nice and clean prompting a clean startup.
On the other hand, you did the right thing by creating the bdump folder.
This is what is suspected and was interested in looking at the alert log for possible rollback that was happening while the database was being opened.
regards
Hrishy
-
FYI
there is no log file or folder under D:\oracle\ora92\rdbms on my machine
where else would the log file be stored?
I want to find a copy of the log file to show it to you guys!
AND
in the past shutting down the DB manually (clean) and then starting it back up again did not fix the problem. it still took ages to start back up.
Graham
Last edited by grahambo; 08-22-2007 at 08:48 AM.
-
please open sqlplus session and do...
show parameter background_dump_dest
What's the location Oracle points you?
Please check first and last entries on alert.log and correlate with the timing of your startup/shutdown activity.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
My guess is database started faster this time just because of it shutdown nice and clean prompting a clean startup.
Why would an unclean shutdown make the instance to take about 5 minutes to start?I think the problem is rooted deeper than it looks.
Last edited by simply_dba; 08-24-2007 at 07:25 AM.
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|