11 Replies Latest reply: Mar 28, 2013 6:37 PM by jgarry RSS

    EMCA ERROR PLEASE HELP

    801959
      Hi,

      OS: Oracle Linux 5.4 x32
      DB: Oracle 11g R2 11.2.0.3 x32

      I have create database manually, but when I try create EM whit emca I get error.

      My envroments:
      export ORACLE_SID=db11
      export ORACLE_UNIQNAME=db11
      export ORACLE_BASE=/u01/app/oracle
      export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
      export PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin

      My init file:
      *.db_name='db11'
      *.db_recovery_file_dest_size=21474836480
      *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
      *.db_unique_name='db11'
      *.job_queue_processes=10
      *.memory_max_target=1400M
      *.memory_target=1200M
      *.open_cursors=1500
      *.processes=400
      *.sessions=300
      *.undo_management='auto'

      When I try Create Em I get this:   emca -config dbcontrol db -repos create

      INFO: Creating the EM repository (this may take a while) ...
      Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMReposConfig createRepository
      WARNING: ORA-01000: maximum open cursors exceeded
      ORA-06512: at "SYS.DBMS_STATS", line 27377
      ORA-06512: at "SYS.DBMS_STATS", line 27402
      ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1093
      ORA-06512: at "SYS.DBMS_REGISTRY", line 578
      ORA-06512: at line 1

      Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error creating the repository
      Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_repos_create_<date>.log for more details.
      Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMConfig perform
      SEVERE: Error creating the repository
      Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2013_03_27_11_53_14.log for more details.
      Mar 27, 2013 11:56:29 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:252)
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:160)
      at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
      at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
      Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
      CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
      cat: for: No such file or directory

      Edited by: 798956 on 27.03.2013 1:12

      Edited by: 798956 on 27.03.2013 1:16
        • 1. Re: EMCA ERROR PLEASE HELP
          Kh$n
          login as sys as sysdba and than execute.
          sqlplus / as sysdba

          sql> begin
          dbms_registry.loaded('EM');
          end;
          /

          Edited by: Asad99 on Mar 27, 2013 3:32 AM

          Edited by: Asad99 on Mar 27, 2013 3:35 AM

          Edited by: Asad99 on Mar 27, 2013 3:38 AM
          • 2. Re: EMCA ERROR PLEASE HELP
            801959
            hi Asad,

            after I get error I have done this procedure.

            sql> begin
            dbms_registry.loaded('EM');
            end;
            /
            PL/SQL procedure successfully completed.


            emctl start dbconsole started successfully.

            but when I try connect with web I get this error

            503 Service Unavailable

            Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.
            • 3. Re: EMCA ERROR PLEASE HELP
              Kh$n
              what ineternet explorer you are using?.
              • 4. Re: EMCA ERROR PLEASE HELP
                John Stegeman
                Browsers don't cause HTTP 5xx errors, it's a server-side problem...
                • 5. Re: EMCA ERROR PLEASE HELP
                  801959
                  chrome

                  with chrome I can connect other DB's whitout any problems
                  • 6. Re: EMCA ERROR PLEASE HELP
                    Kh$n
                    john you are right problem is on server side.

                    try these commands in sequence as mention

                    step1: emca -repos drop
                    dtep2: emca -deconfig dbcontrol db
                    step3:emca -repos create
                    step4: emca -config dbcontrol db


                    if repository is having problem in doping than you need to drop repository through rep manager.

                    Edited by: Asad99 on Mar 28, 2013 12:31 AM

                    Edited by: Asad99 on Mar 28, 2013 12:33 AM

                    Edited by: Asad99 on Mar 28, 2013 1:41 AM
                    • 7. Re: EMCA ERROR PLEASE HELP
                      801959
                      I tried drop repo and get error:

                      SEVERE: Error dropping the repository
                      Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/db11/emca_2013_03_28_11_50_55.log for more details.


                      Dropping Repository failed. Please check file /u01/app/oracle/cfgtoollogs/emca/db11/emca_repos_drop_2013_03_28_11_51_06.log for detailed errors.

                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                      CONFIG: stty: standard input: Invalid argument
                      stty: standard input: Invalid argument
                      ORA-24008: queue table SYSMAN.MGMT_TASK_QTABLE must be dropped first
                      ORA-06512: at line 155

                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                      WARNING: Error executing /u01/app/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db11.ritn1.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/cfgtoollogs/emca/db11/emca_repos_drop_2013_03_28_11_51_06.log
                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.EMReposConfig invoke
                      SEVERE: Error dropping the repository
                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.EMReposConfig invoke
                      INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/db11/emca_repos_drop_<date>.log for more details.
                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.EMConfig perform
                      SEVERE: Error dropping the repository
                      Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/db11/emca_2013_03_28_11_50_55.log for more details.
                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.EMConfig perform
                      CONFIG: Stack Trace:
                      oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
                      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
                      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:160)
                      at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                      at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
                      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
                      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
                      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
                      Mar 28, 2013 11:51:13 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                      CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui

                      Edited by: 798956 on Mar 28, 2013 12:56 AM
                      • 8. Re: EMCA ERROR PLEASE HELP
                        Kh$n
                        check for Qtbale using statments and if exist
                        select owner||' - '||queue_table from dba_queue_tables order by owner;

                        follow below link for how to drop qtables

                        http://nadvi.blogspot.com/2010/12/recreate-em-dbconsole.html

                        Edited by: Asad99 on Mar 28, 2013 1:56 AM
                        • 9. Re: EMCA ERROR PLEASE HELP
                          Justin_Mungal
                          From your first post:

                          INFO: Creating the EM repository (this may take a while) ...
                          Mar 27, 2013 11:56:29 AM oracle.sysman.emcp.EMReposConfig createRepository
                          WARNING: ORA-01000: maximum open cursors exceeded
                          ORA-06512: at "SYS.DBMS_STATS", line 27377
                          ORA-06512: at "SYS.DBMS_STATS", line 27402
                          ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1093
                          ORA-06512: at "SYS.DBMS_REGISTRY", line 578
                          ORA-06512: at line 1

                          Did you check to see if you're going over your cursor limit?

                          Regarding dropping the repository, if using the automatic drop commands aren't working you may need to manually drop the repository. Please see +Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment [ID 1099271.1]+ for details on this. The note also has a good amount of information on troubleshooting the console.
                          • 10. Re: EMCA ERROR PLEASE HELP
                            801959
                            Hi,

                            I think problem is BUG in 11.2.0.3 version.

                            Because I have done same procedure in 11.2.0.2.0 version, create repos done. it works.
                            • 11. Re: EMCA ERROR PLEASE HELP
                              jgarry
                              There are many possible things that can go wrong. There is a real problem with generic plans to drop the repository, which is that they don't account for everything that can go wrong. In particular, a messed up environment variable can propagate in all sorts of weird ways. There are also bugs.

                              Sometimes looking at the OS processes running will show extra java processes that weren't able to be killed. You may have to kill those off manually from the OS.