1 2 Previous Next 24 Replies Latest reply: Mar 3, 2013 1:02 AM by Osama_Mustafa RSS

    Enterprise Manager Recovery Message

    Maahjoor
      Dear all,

      i have windows server 2003 32 bit, oracle database 10gr2 32bit.
      when i try to open my enterprise manager with the following link
      http://regadminsrv.hct.org:5500/em/
      it change the url like below
      http://regadminsrv.hct.org:5500/em/console/database/instance/repDown

      it show a page saying
      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.
      but my database is up and running fine.
      this is my production database,
      any idea how to fix it?

      Thanks
        • 1. Re: Enterprise Manager Recovery Message
          asahide
          Hello,

          What is SYSMAN user's status ?
          Locked or Not?


          What is your oracle version? pls, 4 digit.

          Regards,
          • 2. Re: Enterprise Manager Recovery Message
            TSharma-Oracle
            Is it dbcontrol or an enterprise manager? Is it on the same server where your oracle database is?
            • 3. Re: Enterprise Manager Recovery Message
              Maahjoor
              SQL> select * from v$version
                2  ;
              
              BANNER
              ----------------------------------------------------------------
              Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
              PL/SQL Release 10.1.0.2.0 - Production
              CORE    10.1.0.2.0      Production
              TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
              NLSRTL Version 10.1.0.2.0 - Production
              how to check the status for sysman? what is the default password of sysman?

              Thanks.
              • 4. Re: Enterprise Manager Recovery Message
                Maahjoor
                yes it is on the same server where my database is.

                and i suppose http://regadminsrv.hct.org:5500/em to be the address use to open ENTERPRISE MANAGER.
                if there is a difference , kindly guide me.

                besides, when i try to close my dbconsole service from services.msc utility
                it is not closed. there is a problem with it.

                Regards.
                • 5. Re: Enterprise Manager Recovery Message
                  TSharma-Oracle
                  1) connect as sys
                  2) select username,account_status from dab_users where owner = 'SYSMAN'

                  Post the result.

                  Cause

                  The DB COntrol console process is unable to connect to the database it self from various reasons:

                  1. the listener is not started

                  2. the database is not registered with the given listener

                  3. the DB Console configuration is incorrect for some reason

                  4. Database is not opened or accessible for client connections.

                  Solution

                  Verify if the DB Console process is able to connect to the database with:

                  1. the listener is started and the database instance is registered: lsnrctl status <listener name>

                  2. The SYSMAN account is unlocked nd the password is not expired.

                  3. Open ORACLE_HOME/<hostname>_<SID>/sysman/log/emoms.trc for connection errors.
                  • 6. Re: Enterprise Manager Recovery Message
                    Maahjoor
                    SQL> select username,account_status from dba_users where USERNAME       = 'SYSMAN';
                    
                    USERNAME   ACCOUNT_STATUS
                    ---------- --------------------------------
                    SYSMAN     LOCKED(TIMED)
                    1.
                    C:\Documents and Settings\Administrator> lsnrctl status LISTENER
                    
                    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 02-ع╟╤╙  -2013 12
                    :29:19a$ى↕
                    
                    Copyright (c) 1991, 2004, Oracle.  All rights reserved.
                    
                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias                     LISTENER
                    Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
                    ction
                    Start Date                02-ع╟╤╙  -2013 08:04:29
                    Uptime                    0 days 4 hr. 24 min. 49 sec
                    Trace Level               off
                    Security                  ON: Local OS Authentication
                    SNMP                      OFF
                    Listener Parameter File   G:\oracle\product\10.1.0\db_1\network\admin\listener.o
                    ra
                    Listener Log File         G:\oracle\product\10.1.0\db_1\network\log\listener.log
                    
                    Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.153.4.194)(PORT=1521)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=regadminsrv.hct.org)(PORT=8080))(Pre
                    sentation=HTTP)(Session=RAW))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=regadminsrv.hct.org)(PORT=2100))(Pre
                    sentation=FTP)(Session=RAW))
                    Services Summary...
                    Service "ORCL" has 2 instance(s).
                      Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
                      Instance "orcl", status READY, has 5 handler(s) for this service...
                    Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "RAMAN" has 1 instance(s).
                      Instance "RMAN", status UNKNOWN, has 1 handler(s) for this service...
                    The command completed successfully
                    2.
                    SQL> alter user sysman account unlock;
                    
                    User altered.
                    i am trying to locate the files you menioned.
                    thanks.

                    Edited by: Maahjoor on 02-Mar-2013 00:31
                    • 7. Re: Enterprise Manager Recovery Message
                      TSharma-Oracle
                      Check now. Refresh your link. See if that works?
                      • 8. Re: Enterprise Manager Recovery Message
                        Maahjoor
                        i referesh the link, but result is the same.
                        could we reconfigure the dbconsole?
                        • 9. Re: Enterprise Manager Recovery Message
                          asahide
                          3. Open ORACLE_HOME/<hostname>_<SID>/sysman/log/emoms.trc for connection errors.
                          Show this logfile .
                          could we reconfigure the dbconsole?
                          It's OK, But do you know SYSMAN's password?

                          Regards,
                          • 10. Re: Enterprise Manager Recovery Message
                            TSharma-Oracle
                            You can configure but for that you need to know sysman and dbsnmp password
                            • 11. Re: Enterprise Manager Recovery Message
                              Maahjoor
                              the logfile is very big, the last few lines are below
                              [HttpRequestHandler-1693320] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-28000: the account is locked
                              
                              2013-03-02 13:05:17,397 [HttpRequestHandler-1693320] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://regadminsrv.hct.org:1830/emd/main)(ERROR = INTERNAL_ERROR)
                              i dont know the sysman password, but i could alter it.
                              • 12. Re: Enterprise Manager Recovery Message
                                Maahjoor
                                i could alter the password sharma ji.
                                • 13. Re: Enterprise Manager Recovery Message
                                  asahide
                                  Hi,

                                  Account status was LOCK(TIMED) , and after you unlocked but now still ORA-28000: the account is locked.
                                  Then, I think that SYSMAN password is difference between EM config and DB.
                                  So, maybe, You will connect EM by reconfigration..

                                  Regards,
                                  • 14. Re: Enterprise Manager Recovery Message
                                    Maahjoor
                                    yes , i think some weeks before i alter the password.
                                    you seemed correct.
                                    but reconfiguration also failed.
                                    i am unable to re-configure.
                                    1 2 Previous Next