Oracle 9i DB taking forever to start up
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Oracle 9i DB taking forever to start up

  1. #1
    Join Date
    Aug 2007
    Posts
    4

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Aug 2007
    Posts
    4
    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

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    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

  5. #5
    Join Date
    Aug 2007
    Posts
    4
    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

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Quote 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

  8. #8
    Join Date
    Aug 2007
    Posts
    4
    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 09:48 AM.

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  10. #10
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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 08: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
  •  


Click Here to Expand Forum to Full Width