11 Replies Latest reply on Jul 29, 2008 8:23 AM by mnazim-Oracle

    Problems with creating repository

    541486
      Hello!

      When I tried to create the em-repository using "emca -config dbcontrol db -repos create", I get the following output:

      [...]
      Sie haben die folgenden Einstellungen angegeben

      ORACLE_HOME von Datenbank ................ /opt/oracle/product/10.2.0/db_1

      Datenbank-Host-Name ................ s6704023.drvbsh.rzn.drv
      Listener-Port-Nummer ................ 1521
      Datenbank-SID ................ rznorcl
      E-Mail-Adresse für Benachrichtigungen ...............
      Postausgangs-(SMTP-)Server für E-Mail-Benachrichtungen ...............

      -----------------------------------------------------------------
      Möchten Sie fortfahren? [ja(Y)/nein(N)]: Y
      04.12.2006 14:04:56 oracle.sysman.emcp.EMConfig perform
      INFO: Dieser Vorgang wird in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_2006-12-04_02-04-36-PM.log protokolliert.
      04.12.2006 14:04:57 oracle.sysman.emcp.EMReposConfig createRepository
      INFO: Das EM Repository wird erstellt (dies kann etwas länger dauern)...
      04.12.2006 14:04:57 oracle.sysman.emcp.EMReposConfig invoke
      SCHWERWIEGEND: Fehler beim Erstellen des Repositorys
      04.12.2006 14:04:57 oracle.sysman.emcp.EMReposConfig invoke
      INFO: Weitere Einzelheiten finden Sie in der Log-Datei in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_repos_create_<Datum>.log.
      04.12.2006 14:04:57 oracle.sysman.emcp.EMConfig perform
      SCHWERWIEGEND: Fehler beim Erstellen des Repositorys
      Weitere Einzelheiten finden Sie in der Log-Datei in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_2006-12-04_02-04-36-PM.log.
      Die Konfiguration konnte nicht abgeschlossen werden. Weitere Einzelheiten finden Sie in der Log-Datei in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_2006-12-04_02-04-36-PM.log.


      The generated log-file contains the following:

      Dropped Repository Successfully.

      04.12.2006 13:57:57 oracle.sysman.emcp.util.PlatformInterface executeCommand
      KONFIG: stty: Standardeingabe: Das Argument ist ungültig
      stty: Standardeingabe: Das Argument ist ungültig
      stty: Standardeingabe: Das Argument ist ungültig
      stty: Standardeingabe: Das Argument ist ungültig

      04.12.2006 13:57:57 oracle.sysman.emcp.EMReposConfig invoke
      INFO: Repository erfolgreich gelöscht
      04.12.2006 13:57:57 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      KONFIG: SQLEngine connecting with SID: rznorcl, oracleHome: /opt/oracle/product/10.2.0/db_1, and user: SYS
      04.12.2006 13:57:57 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      KONFIG: SQLEngine created successfully and connected
      04.12.2006 13:57:57 oracle.sysman.emcp.EMReposConfig createRepository
      KONFIG: Spooling to /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_repos_create_2006-12-04_01-57-57-PM.log
      04.12.2006 13:57:57 oracle.sysman.emcp.EMReposConfig createRepository
      INFO: Das EM Repository wird erstellt (dies kann etwas länger dauern)...
      04.12.2006 13:59:32 oracle.sysman.emcp.EMReposConfig createRepository
      KONFIG: ORA-24344: success with compilation error
      ORA-06512: at line 38

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-24344: success with compilation error
      ORA-06512: at line 38

      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
      at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
      at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:306)
      at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:363)
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:185)
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:127)
      at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
      at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
      04.12.2006 13:59:32 oracle.sysman.emcp.EMReposConfig invoke
      SCHWERWIEGEND: Fehler beim Erstellen des Repositorys
      04.12.2006 13:59:32 oracle.sysman.emcp.EMReposConfig invoke
      INFO: Weitere Einzelheiten finden Sie in der Log-Datei in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_repos_create_<Datum>.log.
      04.12.2006 13:59:32 oracle.sysman.emcp.EMConfig perform
      SCHWERWIEGEND: Fehler beim Erstellen des Repositorys
      Weitere Einzelheiten finden Sie in der Log-Datei in /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_2006-12-04_01-55-59-PM.log.
      04.12.2006 13:59:32 oracle.sysman.emcp.EMConfig perform
      KONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException: Fehler beim Erstellen des Repositorys
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:197)
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:127)
      at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
      at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)




      What can I do now? I hope you have a good idea...

      Regards, Sascha
        • 1. Re: Problems with creating repository
          498761
          I'm in a similar situation, ie, need to recreate a repository and decided I'll reinstall the entire OMS clean. I think that in the end it's actually faster.
          • 2. Re: Problems with creating repository
            541486
            Hmm, can you give me a details description how to do this?
            • 3. Re: Problems with creating repository
              498761
              just like any uninstall. I use the oui to uninstall then clean up any remaining files on the os. Then install as if it was never there.
              • 4. Re: Problems with creating repository
                541486
                That can be done without loosing any data of the entire database?
                • 5. Re: Problems with creating repository
                  277993
                  I believe this is DB Control and not Grid Control. I do not think it is a good idea to re-install when y ou can just recreate the dbconsole only.

                  Try to clean the repository first

                  emca -deconfig dbcontrol db -repos drop

                  Then recreate it

                  emca -config dbcontrol db -repos create


                  Also check the errors in the following log files for details:

                  /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_repos_create_2006-12-04_01-57-57-PM.log

                  opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/rznorcl/emca_2006-12-04_01-55-59-PM.log
                  • 6. Re: Problems with creating repository
                    574394
                    It's not that simple. He clearly tried that and the script failed.


                    See metalink note 333567.1
                    • 7. Re: Problems with creating repository
                      Sbarber.Uk-Oracle
                      Have you applied the latest CPU to the database. If you have this has removed execute permissions on utl_smtp, utl_tcp, utl_file.

                      Aside from ensuring the utl_smtp, utl_tcp, utl_file have been granted execute to public, re-run the catproc.sql.

                      Take a look at bug 4963778.
                      • 8. Re: Problems with creating repository
                        624596
                        hi..., I also have problem when recreate the EM.

                        It will hang....when "INFO: Dropping the EM repository "

                        here is my screen:

                        [oracle@rac1 db_1]$ emca -repos recreate

                        STARTED EMCA at Jul 28, 2008 6:36:32 PM
                        EM Configuration Assistant, Version 10.2.0.1.0 Production
                        Copyright (c) 2003, 2005, Oracle. All rights reserved.

                        Enter the following information:
                        Database SID: RAC1
                        Listener port number: 1521
                        Password for SYS user:
                        Password for SYSMAN user:

                        Do you wish to continue? [yes(Y)/no(N)]: Y
                        Jul 28, 2008 6:36:43 PM oracle.sysman.emcp.EMConfig perform
                        INFO: This operation is being logged at /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/RAC/emca_2008-07-28_06-36-32-PM.log.
                        Jul 28, 2008 6:36:44 PM oracle.sysman.emcp.EMReposConfig dropRepository
                        INFO: Dropping the EM repository (this may take a while) ...
                        • 9. Re: Problems with creating repository
                          mnazim-Oracle
                          check dbconsole is down or not ?
                          • 10. Re: Problems with creating repository
                            624596
                            [oracle@rac1 STUPID]$ emctl status dbconsole
                            EM Configuration issue. /opt/oracle/product/10.2.0/db_1/rac1.quamnet.com_STUPID1 not found.

                            and if I try
                            emca -config dbcontrol db -repos recreate
                            and the log is too large, i just give the tail to you:

                            ------------------------------------------------------------------------------------------------------------
                            .0/db_1/lib32:/opt/oracle/product/10.2.0/db_1/lib:/opt/oracle/product/10.2.0/db_1/perl/lib, SHLVL=2, SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass, TERM=xterm, TMP=/tmp, TMPDIR=/tmp, TZ=GMT, USER=oracle, XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt, _=/opt/oracle/product/10.2.0/db_1/jdk/jre/bin/java]
                            Jul 29, 2008 1:49:01 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: Starting execution: /opt/oracle/product/10.2.0/db_1/bin/emctl start dbconsole
                            Jul 29, 2008 1:49:02 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: Exit value of 2
                            Jul 29, 2008 1:49:02 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: EM Configuration issue. /opt/oracle/product/10.2.0/db_1/rac1.quamnet.com_STUPID1 not found.

                            Jul 29, 2008 1:49:02 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            WARNING: Error executing /opt/oracle/product/10.2.0/db_1/bin/emctl start dbconsole
                            Jul 29, 2008 1:49:02 AM oracle.sysman.emcp.EMConfig perform
                            SEVERE: Error starting Database Control
                            Refer to the log file at /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STUPID/emca_2008-07-29_01-28-15-AM.log for more details.
                            Jul 29, 2008 1:49:02 AM oracle.sysman.emcp.EMConfig perform
                            CONFIG: Stack Trace:
                            oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
                            at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:572)
                            at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:184)
                            at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:153)
                            at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:155)
                            at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:485)
                            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1141)
                            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:469)
                            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:418)


                            ------------------------------------------------------------------------------------------------------------

                            I have no idea what is happening....
                            please help
                            thanks.
                            • 11. Re: Problems with creating repository
                              mnazim-Oracle
                              set the oracle_sid and then check the status