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

Thread: Enterprise manager shows wrong status.

  1. #1
    Join Date
    Apr 2006
    Posts
    16

    Enterprise manager shows wrong status.

    Hello!

    EM is giving me this status:

    The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation.

    -----
    While,I can see from SQL plus as a sysdba from v$instance that the database staus is open.

    I try to startup the database from EM,but it throws an SQL exception and tells me to shutdown the database.

    I say yes.

    I get an error: Premature EOF encountered, no trailer found.

    ---
    I try again,this time,selecting a forced startup.I get the following message:

    SQL> Connected to an idle instance.
    SQL> ORACLE instance started.

    Total System Global Area 1207959552 bytes
    Fixed Size 778856 bytes
    Variable Size 334241176 bytes
    Database Buffers 872415232 bytes
    Redo Buffers 524288 bytes
    Database mounted.
    Database opened.
    SQL>
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
    With the Partitioning, OLAP and Data Mining options

    Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
    Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
    EMD recompute dynprops completed successfully

    -----

    But the "The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation."
    message is still there.I can no longer logon to the database through EM.

    Can anyone help me on this?Thanks.

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    Are you using Grid Control or database control?

    If you are using database control have you checked out notes 309687.1 and 315299.1 on metalink? If not, please check them and if you still have an issue update the thread accordingly.

    Regards,
    Bazza

  3. #3
    Join Date
    Apr 2006
    Posts
    16
    Thank you bazza.
    I dont have access to that resource,but I was able to get past the problem.I figured out that I needed to run catalog.sql & catproc.sql to rebuild data dictionary & some pl/sql .Things worked fine after this-but I have no idea how data dictionary or pl/sql stuff got affected.

    I'm using database access btw.
    Last edited by dereliction; 04-14-2006 at 04:10 PM.

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