9 Replies Latest reply on Oct 12, 2013 1:08 AM by abigail818

    SEVERE: Error creating the repository

    abigail818

      Ugh help, been at this for hours! I messed up my oracle dbconsole and now the dbconsole service itself is gone! (I checked services.msc on my windows xp pro) I'm on oracle 11gR2

       

      So I dropped and recreate em repo but got the ff error msg:

       

      C:\Documents and Settings\abigail>emca -repos create

       

       

      STARTED EMCA at Oct 11, 2013 5:17:51 AM

      EM Configuration Assistant, Version 11.2.0.0.2 Production

      Copyright (c) 2003, 2005, Oracle.  All rights reserved.

       

       

      Enter the following information:

      Database SID: orcl

      Listener port number: 1521

      Password for SYS user:

      Password for SYSMAN user:

       

       

      Do you wish to continue? [yes(Y)/no(N)]: y

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.util.EMCALogManager addLogFileInterna

      l

      WARNING: Adding log file E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not connected

      \emca_2013_10_11_05_17_51.log failed. Messages will not be logged in this file.

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMConfig perform

      INFO: This operation is being logged at E:\app\abigail\cfgtoollogs\emca\SP2-0640

      : Not connected\emca_2013_10_11_05_17_51.log.

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig createRepository

      INFO: Creating the EM repository (this may take a while) ...

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig invoke

      SEVERE: Error creating the repository

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig invoke

      INFO: Refer to the log file at E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not con

      nected\emca_repos_create_<date>.log for more details.

      Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMConfig perform

      SEVERE: Error creating the repository

      Refer to the log file at E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not connected

      \emca_2013_10_11_05_17_51.log for more details.

      Could not complete the configuration. Refer to the log file at E:\app\abigail\cf

      gtoollogs\emca\SP2-0640: Not connected\emca_2013_10_11_05_17_51.log for more det

      ails.

       

       

      My Log file

       

      CONFIG: Spooling to E:\app\abigail\cfgtoollogs\emca\orcl\emca_repos_create_2013_10_11_05_13_56.log

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig createRepository

      INFO: Creating the EM repository (this may take a while) ...

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig createRepository

      CONFIG: ORA-20001: SYSMAN already exists..

      ORA-06512: at line 17

       

       

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..

      ORA-06512: at line 17

       

       

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)

        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)

        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)

        at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig invoke

      SEVERE: Error creating the repository

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig invoke

      INFO: Refer to the log file at E:\app\abigail\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMConfig perform

      SEVERE: Error creating the repository

      Refer to the log file at E:\app\abigail\cfgtoollogs\emca\orcl\emca_2013_10_11_05_13_31.log for more details.

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMConfig perform

      CONFIG: Stack Trace:

      oracle.sysman.emcp.exception.EMConfigException: Error creating the repository

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:241)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

      Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

      CONFIG: Restoring oracle.installer.oui_loc to E:\app\abigail\product\11.2.0\dbhome_1\oui

        • 1. Re: SEVERE: Error creating the repository
          Fran

          ORA-20001: SYSMAN already exists



          DROP USER sysman CASCADE;

          DROP PUBLIC SYNONYM setemviewusercontext;

          DROP ROLE mgmt_user;

          DROP PUBLIC SYNONYM mgmt_target_blackouts;

          DROP USER mgmt_view;

           

          Later you can use "emca -config dbcontrol db -repos create"

          • 2. Re: SEVERE: Error creating the repository
            abigail818

            I've done this earlier before after googling, but it still gave me errors.. Let me try it again

            • 3. Re: SEVERE: Error creating the repository
              abigail818

              Okay I did those again and still get the SEVERE: Error creating the repository error however, the log file shows a new ORA err msg (in BOLD), what does this mean and how to resolve it?

               

               

              LOG FILE:

               

              Check if repos user already exists.

               

               

              old   6:    WHERE username=UPPER('&EM_REPOS_USER');

              new   6:    WHERE username=UPPER('SYSMAN');

              old   8:   IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN

              new   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN

              old  11:       raise_application_error(-20000, '&EM_REPOS_USER does not exists..');

              new  11:       raise_application_error(-20000, 'SYSMAN does not exists..');

              old  14:   ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN

              new  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN

              old  17:       raise_application_error(-20001, '&EM_REPOS_USER already exists..');

              new  17:       raise_application_error(-20001, 'SYSMAN already exists..');

              old  21:       raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');

              new  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');

               

               

              Create SYSMAN user.

               

               

              No errors.

               

               

              Script to revoke DBA role from SYSMAN and grant required privileges

               

               

              No errors.

               

              ##########DELETED a bunch of SUCCESFUL CREATION######

               

              Type body created.

               

               

              No errors.

              CREATE PUBLIC SYNONYM MGMT_AVAILABILITY FOR MGMT_AVAILABILITY

                                    *

              ERROR at line 1:

              ORA-00955: name is already used by an existing object

              • 4. Re: SEVERE: Error creating the repository
                Fran

                DROP USER sysman CASCADE;

                DROP PUBLIC SYNONYM setemviewusercontext;

                DROP ROLE mgmt_user;

                DROP PUBLIC SYNONYM MGMT_AVAILABILITY;

                DROP PUBLIC SYNONYM mgmt_target_blackouts;

                DROP USER mgmt_view;

                 

                and try again

                1 person found this helpful
                • 5. Re: SEVERE: Error creating the repository
                  abigail818

                  Thank you. Sorry it's taking so long, but every time I do this, another public synonym pops up.. Is there any way to drop all public synonyms? Or view them?

                   

                  So far I have to drop the ff as well: I'm afraid there might be more, but its taking so long since it's coming up one by one after i recreate the repo

                   

                  DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY;

                  DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;

                  DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;

                  • 6. Re: SEVERE: Error creating the repository
                    Fran

                    You don't have to drop all synonyms of database, you only have to drop which references to sysman (the owner of repository)

                     

                    DECLARE

                    CURSOR c1 IS

                    SELECT owner, synonym_name name

                    FROM dba_synonyms

                    WHERE table_owner = 'SYSMAN';

                    BEGIN

                    FOR r1 IN c1 LOOP

                    IF r1.owner = 'PUBLIC' THEN

                    EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;

                    ELSE

                    EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;

                    END IF;

                    END LOOP;

                    END; /

                    1 person found this helpful
                    • 7. Re: SEVERE: Error creating the repository
                      abigail818

                      Thanks! Now I'm gettin a new error, this seems neverending

                       

                       

                      My log file after getting rid of those and recreating the repo...

                       

                       

                       

                      BEGIN

                      *

                      ERROR at line 1:

                      ORA-25153: Temporary Tablespace is Empty

                      ORA-06512: at line 37

                      • 8. Re: SEVERE: Error creating the repository
                        Fran

                        Alter YOUR_TEMPORARY_TABLESAPCE add tempfile XXXXX reuse;

                        • 9. Re: SEVERE: Error creating the repository
                          abigail818

                          *EDITED*

                           

                          Since the repository has been successfully created, I will mark this as answered! I have a separate issue, so I'll post it on a new thread

                           

                          Thank you for all your help!