Starting the OEM: ================ $ emctl dbconsole start EM Configuration issue. /appl1/home/oracle/10.2/bir-dbs_arcs not found. $ emctl start dbconsole OC4J Configuration issue. /appl1/home/oracle/10.2/oc4j/j2ee/OC4J_DBConsole_bir-dbs_arcs not found. $ ls "emca_repos_create_2010-07-19_12-42-02-PM.log" [Read only] 37 lines, 1219 chara cters [Hit return to continue] 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_TYP E'); new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS'); Create SYSMAN user. No errors. Create core schema.. Creating Types No errors. No errors. No errors. No errors. No errors. BEGIN * ERROR at line 1: ORA-04063: package body "SYS.DBMS_UTILITY" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_UTILITY" ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2830 ORA-06512: at "SYS.DBMS_AQADM", line 58 ORA-06512: at line 2 $ $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 19 12:52:41 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show user USER is "SYS" SQL> alter package SYS.DBMS_UTILITY compile; Package altered. SQL> exit $ $ ORACLE_HOME=/appl1/home/oracle/10.2 $ export ORACLE_HOME $ ORACLE_SID=arcs $ export ORACLE_SID $ pwd /appl1/home/oracle/10.2 $ cd $ORACLE_HOME/bin $ ./emca -config dbcontrol db -repos create STARTED EMCA at Jul 19, 2010 1:39:04 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: arcs Database Control is already configured for the database arcs You have chosen to configure Database Control for managing the database arcs This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: y Listener port number: 1521 Password for SYS user: Password for DBSNMP 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 ................ /appl1/home/oracle/10.2 Database hostname ................ xxx-dbs Listener port number ................ 1521 Database SID ................ dbca Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Jul 19, 2010 1:39:24 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_2010-07-19_01-39-04-PM.log. Jul 19, 2010 1:39:26 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Jul 19, 2010 1:39:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /appl1/home/oracle/10.2/bin/emctl stop dbconsole Jul 19, 2010 1:39:27 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jul 19, 2010 1:39:27 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Jul 19, 2010 1:39:27 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_repos_create_.log for more details. Jul 19, 2010 1:39:27 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_2010-07-19_01-39-04-PM.log for more details. Could not complete the configuration. Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_2010-07-19_01-39-04-PM.log for more details. $ alertbdca.log ------------- ORA-06550: line 1, column 19: PLS-00201: identifier 'DBMS_HA_ALERTS_PRVT.CHECK_HA_RESOURCES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Mon Jul 19 14:45:49 2010 Errors in file /appl1/home/oracle/10.2/admin/bdca/bdump/bdca_mmon_22346.trc: ORA-06550: line 1, column 19: PLS-00201: identifier 'DBMS_HA_ALERTS_PRVT.POST_INSTANCE_UP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored emca_2010-07-19_01-39-04-PM.log ------------------------------- Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /appl1/home/oracle/10.2/bin/emctl stop dbconsole Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode CONFIG: isLocalNodeDone: true localNode: null Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.target.TargetManager listTargets CONFIG: Failed to get targets from home: /appl1/home/oracle/10.2/xxx-dbs_bdca of type: oracle_database oracle.sysman.emSDK.conf.TargetListException: No targets.xml file at /appl1/home/oracle/10.2/xxx-dbs_bdca/sysman/emd/targets .xml at oracle.sysman.emSDK.conf.TargetInstaller.listAllTargets(TargetInstaller.java:2029) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1991) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1966) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1948) at oracle.sysman.emcp.target.TargetManager.listTargets(TargetManager.java:903) at oracle.sysman.emcp.util.DBControlUtil.stopNmccollector(DBControlUtil.java:548) at oracle.sysman.emcp.util.DBControlUtil.stopOMS(DBControlUtil.java:85) at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:731) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:244) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:171) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:170) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419) Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeSgastop CONFIG: Invalid arguments. OH: /appl1/home/oracle/10.2 host: xxx-dbs sid: arcs port: null Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.DBControlUtil stopNmccollector CONFIG: Failed to stop nmc-collector process Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine CONFIG: SQLEngine connecting with SID: arcs, oracleHome: /appl1/home/oracle/10.2, and user: SYS Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine CONFIG: SQLEngine created successfully and connected Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMReposConfig createRepository CONFIG: Value for env var 'ORACLE_HOSTNAME' is '', discarding the same Jul 19, 2010 3:26:53 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray CONFIG: New Env List: [CLASSPATH=/appl1/home/oracle/10.2/jlib/emca.jar:/appl1/home/oracle/10.2/jlib/srvm.jar:/appl1/home/ora cle/10.2/jlib/srvmasm.jar:/appl1/home/oracle/10.2/jlib/emConfigInstall.jar:/appl1/home/oracle/10.2/jlib/ldapjclnt10.jar:/app l1/home/oracle/10.2/jlib/ldap.jar:/appl1/home/oracle/10.2/jlib/share.jar:/appl1/home/oracle/10.2/jlib/srvmhas.jar:/appl1/hom e/oracle/10.2/jlib/netcfg.jar:/appl1/home/oracle/10.2/lib/xmlparserv2.jar:/appl1/home/oracle/10.2/assistants/jlib/assistants Common.jar:/appl1/home/oracle/10.2/sysman/jlib/emCORE.jar:/appl1/home/oracle/10.2/oui/jlib/OraInstaller.jar:/appl1/home/orac le/10.2/oui/jlib/OraPrereq.jar:/appl1/home/oracle/10.2/inventory/prereqs/oui/OraPrereqChecks.jar:/appl1/home/oracle/10.2/oui /jlib/OraPrereqChecks.jar:, DISPLAY=192.168.1.1:0.0, DYLD_LIBRARY_PATH=/appl1/home/oracle/10.2/lib32:/appl1/home/oracle/10.2 /lib:/appl1/home/oracle/10.2/perl/lib, EDITOR=vi, HOME=/export/home/oracle, LC_COLLATE=en_US.ISO8859-15, LC_CTYPE=en_US.ISO8 859-1, LC_MESSAGES=C, LC_MONETARY=en_US.ISO8859-15, LC_NUMERIC=en_US.ISO8859-15, LC_TIME=en_US.ISO8859-15, LD_LIBRARY_PATH=/ appl1/home/oracle/10.2/jdk/jre/lib/sparc/client:/appl1/home/oracle/10.2/jdk/jre/lib/sparc:/appl1/home/oracle/10.2/jdk/jre/.. /lib/sparc:/appl1/home/oracle/10.2/lib32:/appl1/home/oracle/10.2/lib:/appl1/home/oracle/10.2/perl/lib:/appl1/home/oracle/10. 2/lib, LIBPATH=/appl1/home/oracle/10.2/lib32:/appl1/home/oracle/10.2/lib:/appl1/home/oracle/10.2/perl/lib, LOGNAME=oracle, M AIL=/var/mail//oracle, NEED_EXIT_CODE=1, NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat, ORACLE_BASE=/appl1/home/oracle, ORACLE_HOME= /appl1/home/oracle/10.2, ORACLE_SID=arcs, ORACLE_TERM=vt100, ORAENV_ASK=YES, PATH=/appl1/home/oracle/10.2/bin:/usr/ccs/bin:/ usr/openwin/bin:/usr/bin:/usr/ccs/bin:/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/usr/bin:/usr/ucb, SHELL=/bin/sh, SHLIB _PATH=/appl1/home/oracle/10.2/lib32:/appl1/home/oracle/10.2/lib:/appl1/home/oracle/10.2/perl/lib, SSH_CLIENT=172.16.2.54 346 0 22, SSH_CONNECTION=172.16.2.54 3460 172.16.16.73 22, SSH_TTY=/dev/pts/3, TERM=xterm, TZ=Singapore, USER=oracle, XFILESEARC HPATH=/usr/dt/app-defaults/%L/Dt] Jul 19, 2010 3:26:53 PM oracle.sysman.emcp.util.PlatformInterface executeCommand CONFIG: Starting execution: /appl1/home/oracle/10.2/bin/emctl stop dbconsole Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeCommand CONFIG: Exit value of 2 Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeCommand CONFIG: Unable to locate file /appl1/home/oracle/10.2/xxx-dbs_arcs/sysman/config/emd.properties : No such file or directory Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /appl1/home/oracle/10.2/bin/emctl stop dbconsole Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode CONFIG: isLocalNodeDone: true localNode: null Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.target.TargetManager listTargets CONFIG: Failed to get targets from home: /appl1/home/oracle/10.2/xxx-dbs_bdca of type: oracle_database oracle.sysman.emSDK.conf.TargetListException: No targets.xml file at /appl1/home/oracle/10.2/xxx-dbs_bdca/sysman/emd/targets .xml at oracle.sysman.emSDK.conf.TargetInstaller.listAllTargets(TargetInstaller.java:2029) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1991) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1966) at oracle.sysman.emSDK.conf.TargetInstaller.listTargets(TargetInstaller.java:1948) at oracle.sysman.emcp.target.TargetManager.listTargets(TargetManager.java:903) at oracle.sysman.emcp.util.DBControlUtil.stopNmccollector(DBControlUtil.java:548) at oracle.sysman.emcp.util.DBControlUtil.stopOMS(DBControlUtil.java:85) at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:731) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:244) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:171) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:170) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419) Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.PlatformInterface executeSgastop CONFIG: Invalid arguments. OH: /appl1/home/oracle/10.2 host: bir-dbs sid: arcs port: null Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.DBControlUtil stopNmccollector CONFIG: Failed to stop nmc-collector process Jul 19, 2010 3:26:54 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine CONFIG: SQLEngine connecting with SID: arcs, oracleHome: /appl1/home/oracle/10.2, and user: SYS Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine CONFIG: SQLEngine created successfully and connected Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMReposConfig createRepository CONFIG: Spooling to /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_repos_create_2010-07-19_03-26-55-PM.log Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jul 19, 2010 3:26:55 PM 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:1474) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:848) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:267) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:308) at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:422) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:192) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419) Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_repos_create_.log for more details. Jul 19, 2010 3:26:55 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/bdca/emca_2010-07-19_03-26-34-PM.log for more details. Jul 19, 2010 3:26:55 PM 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:204) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)