DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: cannot open oracle DB

  1. 07-02-2007, 04:47 PM #1
    Camacho
    Camacho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    2

    cannot open oracle DB

    Hello every one
    I need to open my oracle DB. but just get to the following stages and the it freezes

    SQL> startup
    ORACLE instance started.
    Total System Global Area 110033940 bytes

    Fixed Size 76820 bytes
    Variable Size 76230656 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 172032 bytes
    Database mounted.

    and no more.
    is there any help on this?
    Reply With Quote Reply With Quote
  2. 07-02-2007, 05:02 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Did it come down clean when it was shutdown?
    Have you made any configuration changes?
    What can you see in the Alertlog?
    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.
    Reply With Quote Reply With Quote
  3. 07-02-2007, 05:07 PM #3
    Camacho
    Camacho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    2
    No.
    Oracle shutdown was abrupt. and I have not done any changes.

    There is not record in may server the last line in my alert log file is

    DATABASE OPEN

    en freezes.

    I you need me to send the tail lines, please wait until my server restarts...
    Reply With Quote Reply With Quote
  4. 07-03-2007, 09:03 AM #4
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    try alter database open
    and let us now the error message and the text

    Regards
    Reply With Quote Reply With Quote
  5. 07-03-2007, 10:55 AM #5
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Still it freezes then,

    shutdown immediate
    Startup force
    shutdown immediate
    startup

    should solve your issue.
    Reply With Quote Reply With Quote
  6. 07-04-2007, 12:05 AM #6
    abhi_my
    abhi_my is offline Junior Member
    Join Date
    Jul 2007
    Posts
    2
    may be you can try,

    startup restrict
    shutdown immediate
    startup
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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