1 2 3 Previous Next 40 Replies Latest reply: May 10, 2012 9:02 AM by karthiksingh_india Go to original post RSS
      • 30. Re: Oracle EM does not loading properly shows DATABASE Instance down
        karthiksingh_india
        Hi,

        Previously I have 4 services running in my services

        OracledbconsoleVESS -- it seems to be missing now

        OracleJobSchedulerVESS

        OracleOraDb11g_home1TNSListener

        OracleServiceVESS
        • 31. Re: Oracle EM does not loading properly shows DATABASE Instance down
          karthiksingh_india
          Hi,

          Can anyone help about the password encryption of DBSNMP why because as I run

          select username from dba_users where username='SYSMAN';

          USERNAME
          ---------------
          SYSMAN

          then,

          emca -deconfig dbcontrol db -repos drop
          STARTED EMCA at May 4, 2012 6:56:13 PM
          EM Configuration Assistant, Version 11.1.0.7.0 Production
          Copyright (c) 2003, 2005, Oracle. All rights reserved.

          Enter the following information:
          Database SID: VESS
          Listener port number: 1521
          Password for SYS user:
          Password for SYSMAN user:
          Password for SYSMAN user:
          Do you wish to continue? [yes(Y)/no(N)]: yes
          May 4, 2012 6:56:37 PM oracle.sysman.emcp.EMConfig perform
          INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_04_18_56_13.log.
          May 4, 2012 6:56:38 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
          INFO: Stopping Database Control (this may take a while) ...
          May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
          WARNING: Error initializing SQL connection. SQL operations cannot be performed
          May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig invoke
          WARNING: Unable to remove DBMS jobs.
          May 4, 2012 6:56:39 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
          WARNING: Error initializing SQL connection. SQL operations cannot be performed
          May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig invoke
          INFO: Dropping the EM repository (this may take a while) ...
          May 4, 2012 6:56:40 PM oracle.sysman.emcp.EMReposConfig invoke
          INFO: Repository successfully dropped
          Enterprise Manager configuration completed successfully
          FINISHED EMCA at May 4, 2012 6:56:46 PM

          After that I have tried
          emca -config dbcontrol db -repos create

          STARTED EMCA at May 4, 2012 6:58:45 PM
          EM Configuration Assistant, Version 11.1.0.7.0 Production
          Copyright (c) 2003, 2005, Oracle. All rights reserved.

          Enter the following information:
          Database SID: VESS
          Listener port number: 1521
          Password for SYS user:
          Password for DBSNMP user:
          Password for DBSNMP user: Invalid username/password.
          Password for DBSNMP user:
          Password for DBSNMP user: Invalid username/password.
          Password for DBSNMP user:
          Password for DBSNMP user: Invalid username/password.
          Password for DBSNMP user:

          It says repeatedly invalid since i have given DBSNMP or dbsnmp or <return> but now what to do?? please help me...
          • 32. Re: Oracle EM does not loading properly shows DATABASE Instance down
            sb92075
            ALTER USER SYSMAN IDENTIFIED BY NEWPASSWORD1;
            • 33. Re: Oracle EM does not loading properly shows DATABASE Instance down
              karthiksingh_india
              Hi,

              As per my status of previous post my OEM doesn't started still.. Please help me.. as I have dropped and tried to create it says

              C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

              STARTED EMCA at May 7, 2012 11:15:09 AM
              EM Configuration Assistant, Version 11.1.0.7.0 Production
              Copyright (c) 2003, 2005, Oracle. All rights reserved.

              Enter the following information:
              Database SID: VESS
              Listener port number: 1521
              Password for SYS user:
              Password for DBSNMP user:
              Password for DBSNMP user: Invalid username/password.
              Password for DBSNMP user:
              Password for DBSNMP user: Invalid username/password.
              oracle
              Password for SYSMAN user:
              Password for SYSMAN user: Email address for notifications (optional): sagoks.3@gmail.com
              Outgoing Mail (SMTP) server for notifications (optional):
              -----------------------------------------------------------------

              You have specified the following settings

              Database ORACLE_HOME ................ C:\app\SKS\product\11.1.0\db_1

              Local hostname ................ computer
              Listener port number ................ 1521
              Database SID ................ VESS
              Email address for notifications ............... sagoks.3@gmail.com
              Outgoing Mail (SMTP) server for notifications ...............

              -----------------------------------------------------------------
              Do you wish to continue? [yes(Y)/no(N)]: yes
              May 7, 2012 11:16:18 AM oracle.sysman.emcp.EMConfig perform
              INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_11_15_09.log.
              May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig createRepository
              INFO: Creating the EM repository (this may take a while) ...
              May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig invoke
              SEVERE: Error creating the repository
              May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_<date>.log for more details.
              May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMConfig perform
              SEVERE: Error creating the repository
              Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_11_15_09.log for more details.
              Could not complete the configuration. Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_
              11_15_09.log for more details.

              and log file says

              http://oraclekarthik.blogspot.in/2012/05/emca20120507111509.html

              Please help me struggling a lot for a week..

              Thanks in advance...
              • 34. Re: Oracle EM does not loading properly shows DATABASE Instance down
                karthiksingh_india
                Hi,

                Since i have followed the steps and i have dropped the repos and tried to create but no use.... and now I have lost my link which is present in

                start-> Programs-> Oracle - OracleDB11g_home1-> Database control - vess (http://computer:1158/em) -- I have lost this also now...

                I have to regain with EM please legends help me..

                Karthik..
                • 35. Re: Oracle EM does not loading properly shows DATABASE Instance down
                  Fran
                  use: emctl status dbconsole and you will see the link
                  • 36. Re: Oracle EM does not loading properly shows DATABASE Instance down
                    karthiksingh_india
                    Hi Fran,

                    Sorry its showing
                    OC4J Configuration issue. C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_computer_VESS not found.

                    Please help me to recreate or what to do...Struggling a lot as a beginner DBA
                    Karthik..
                    • 37. Re: Oracle EM does not loading properly shows DATABASE Instance down
                      Fran
                      check if oracle_sid, oracle_home and oracle_unqname are set.

                      another trick is rename "C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_XXXXXXX" into "C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_computer_VESS"
                      then go to your services from control panel and RESTART your service dbconsole again.
                      • 38. Re: Oracle EM does not loading properly shows DATABASE Instance down
                        880461
                        Hi ,

                        You can use DBCA to configure your OEM by selecting "Configure database options".
                        To answer to your original question, you should have checked the host file in C:\Windows\System32\drivers\etc\ folder for proper machine name and ip address.
                        on which database and oem is configured

                        Regards,
                        Imran
                        • 39. Re: Oracle EM does not loading properly shows DATABASE Instance down
                          karthiksingh_india
                          Hi,

                          I have tried through DBCA but it shows an error

                          Failed to unlock all EM-related accounts
                          • 40. Re: Oracle EM does not loading properly shows DATABASE Instance down
                            karthiksingh_india
                            Hi please help me

                            C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

                            STARTED EMCA at May 10, 2012 1:47:51 PM
                            EM Configuration Assistant, Version 11.1.0.7.0 Production
                            Copyright (c) 2003, 2005, Oracle. All rights reserved.

                            Enter the following information:
                            Database SID: vess
                            Listener port number: 1521
                            Password for SYS user:
                            Password for DBSNMP user:
                            Password for SYSMAN user:
                            Password for SYSMAN user: Email address for notifications (optional):
                            Outgoing Mail (SMTP) server for notifications (optional):
                            -----------------------------------------------------------------

                            You have specified the following settings

                            Database ORACLE_HOME ................ C:\app\SKS\product\11.1.0\db_1

                            Local hostname ................ computer
                            Listener port number ................ 1521
                            Database SID ................ vess
                            Email address for notifications ...............
                            Outgoing Mail (SMTP) server for notifications ...............

                            -----------------------------------------------------------------
                            Do you wish to continue? [yes(Y)/no(N)]: y
                            May 10, 2012 1:48:08 PM oracle.sysman.emcp.EMConfig perform
                            INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_13_47_51.log
                            May 10, 2012 1:48:10 PM oracle.sysman.emcp.EMReposConfig createRepository
                            INFO: Creating the EM repository (this may take a while) ...
                            May 10, 2012 1:58:05 PM oracle.sysman.emcp.EMReposConfig invoke
                            INFO: Repository successfully created

                            and it shows created but for a long time the cursor blinks for nearly 7hours... I dont know what to do now...

                            Please help legends..
                            1 2 3 Previous Next