login as: oracle Using keyboard-interactive authentication. Password: Last login: Wed Jul 21 08:38:16 2010 from 111.11.1.11 Sun Microsystems Inc. SunOS 5.10 Generic January 2005 ORACLE_SID = [crmpos] ? $ $ lsnrctl stat LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 21-JUL-2010 08:42:16 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production Start Date 10-JUL-2010 17:04:16 Uptime 10 days 15 hr. 38 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /appl1/home/oracle/10.2/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bir-dbs)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW)) Services Summary... Service "arcs" has 1 instance(s). Instance "arcs", status READY, has 1 handler(s) for this service... Service "arcs_XPT" has 1 instance(s). Instance "arcs", status READY, has 1 handler(s) for this service... $ $ $ ORACLE_HOME=/appl1/home/oracle/10.2 $ export ORACLE_HOME $ ORACLE_SID=arcs $ export ORACLE_SID $ echo $ORACLE_SID arcs $ . oraenv ORACLE_SID = [arcs] ? $ cd $ORACLE_HOME/bin $ pwd /appl1/home/oracle/10.2/bin $ $ ./emca -config dbcontrol db -repos recreate STARTED EMCA at Jul 21, 2010 8:57:11 AM 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 ................ bir-dbs Listener port number ................ 1521 Database SID ................ arcs Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Jul 21, 2010 8:58:06 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs/emca_2010-07-21_08-57-10-AM.log. Jul 21, 2010 8:58:08 AM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Jul 21, 2010 8:58:09 AM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /appl1/home/oracle/10.2/bin/emctl stop dbconsole Jul 21, 2010 8:58:09 AM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... Jul 21, 2010 8:58:10 AM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /appl1/home/oracle/10.2/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=bir-dbs)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=arcs))) -repos_user SYSMAN -action drop -verbose -output_file /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs/emca_repos_drop_2010-07-21_08-58-09-AM.log Jul 21, 2010 8:58:10 AM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error dropping the repository Jul 21, 2010 8:58:10 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs/emca_repos_drop_.log for more details. Jul 21, 2010 8:58:10 AM oracle.sysman.emcp.EMConfig perform SEVERE: Error dropping the repository Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs/emca_2010-07-21_08-57-10-AM.log for more details. Could not complete the configuration. Refer to the log file at /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs/emca_2010-07-21_08-57-10-AM.log for more details. $ $ cd /appl1/home/oracle/10.2/cfgtoollogs/emca/arcs $ view emca_2010-07-21_08-57-10-AM.log $ $ emctl start dbconsole Unable to locate file /appl1/home/oracle/10.2/bir-dbs_arcs/sysman/config/emd.properties : No such file or directory cd $ORACLE_HOME $ pwd /appl1/home/oracle/10.2 $ ls admin css jre oraInst.loc sqlj arcs_db ctx ldap ord sqlnet.log assistants DBA lib oui sqlplus bin dbs lib32 owm srvm **bir-dbs_arcs** demo log perl startup.log bir-dbs_birtcvd diagnostics md plsql sysman bir-dbs_crmpos flash_recovery_area mesg precomp tg4ifmx bir-dbs_eledger has mgw racg tg4ingr bir-dbs_etcvd hs network rdbms tg4sybs bir-dbs_lamn install nls relnotes tg4tera bir-dbs_onet install.platform oc4j root.sh uix ccr instantclient32 odbc root.sh.old wwg $