This discussion is archived
11 Replies Latest reply: Mar 28, 2013 4:37 PM by jgarry RSS

EMCA ERROR PLEASE HELP

801959 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    what ineternet explorer you are using?.
  • 4. Re: EMCA ERROR PLEASE HELP
    John Stegeman Oracle ACE
    Currently Being Moderated
    Browsers don't cause HTTP 5xx errors, it's a server-side problem...
  • 5. Re: EMCA ERROR PLEASE HELP
    801959 Newbie
    Currently Being Moderated
    chrome

    with chrome I can connect other DB's whitout any problems
  • 6. Re: EMCA ERROR PLEASE HELP
    Kh$n Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points