Mas Wisnu.. coba recreate EM nya based on step2 berikut: 1. Unlock DBSNMP user in database (change password into the correct one) 2. Drop User SYSMAN (if exist) SQL> DROP USER mgmt_view CASCADE; SQL> DROP ROLE mgmt_user; SQL> DROP USER sysman CASCADE; SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION; 3. Drop EM $ emca -deconfig dbcontrol db -repos drop 4. Delete DB Control Configuration Files Manually Remove the following directories from your filesystem: $ORACLE_HOME/<hostname_sid> $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid> 4. Create EM $ emca -config dbcontrol db -repos create
gud luck.. regards, Dimas ________________________________ From: wisnu dwi hidayat <[email protected]> To: [email protected] Sent: Thu, 10 December, 2009 14:03:46 Subject: [indo-oracle] create enterprise manager Dear Masters & Members, Mohon bantuannya nih.. saya lg clonning database.. Database dah up dan dah bisa connect dari client namun sy mendapatkan error ketika mencreate enterprise manager... berikut selengkapnya; [ora...@archiveserv ~]$ emca -config dbcontrol db -repos recreate STARTED EMCA at Dec 10, 2009 1:51:36 PM EM Configuration Assistant, Version 11.1.0.5.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: PROD Listener port number: 1521 Password for SYS user: Password for DBSNMP user: Invalid username/password. Password for SYSMAN user: Email address for notifications (optional): wisnu_hidayat@ admedika. co.id Outgoing Mail (SMTP) server for notifications (optional): 192.168.210. 7 ------------ --------- --------- --------- --------- --------- - You have specified the following settings Database ORACLE_HOME ............ .... /OraHome/oracle11g/ product/11. 1.0/db_1 Local hostname ............ .... archiveserv Listener port number ............ .... 1521 Database SID ............ .... PROD Email address for notifications ............ ... wisnu_hidayat@ admedika. co.id Outgoing Mail (SMTP) server for notifications ............ ... 192.168.210. 7 ------------ --------- --------- --------- --------- --------- - Do you wish to continue? [yes(Y)/no(N) ]: Y Dec 10, 2009 1:52:19 PM oracle.sysman. emcp.EMConfig perform INFO: This operation is being logged at /OraHome/oracle11g/ cfgtoollogs/ emca/PROD/ emca_2009_ 12_10_13_ 51_36.log. Dec 10, 2009 1:52:21 PM oracle.sysman. emcp.EMConfig perform SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again . Refer to the log file at /OraHome/oracle11g/ cfgtoollogs/ emca/PROD/ emca_2009_ 12_10_13_ 51_36.log for more details. Could not complete the configuration. Refer to the log file at /OraHome/oracle11g/ cfgtoollogs/ emca/PROD/ emca_2009_ 12_10_13_ 51_36.log for more details. Error log /OraHome/oracle11g/ cfgtoollogs/ emca/PROD/ emca_2009_ 12_10_13_ 51_36.log isinya sebagai berikut; Dec 10, 2009 1:52:21 PM oracle.sysman. emcp.EMConfig perform SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again . Refer to the log file at /OraHome/oracle11g/ cfgtoollogs/ emca/PROD/ emca_2009_ 12_10_13_ 51_36.log for more details. Dec 10, 2009 1:52:21 PM oracle.sysman. emcp.EMConfig perform CONFIG: Stack Trace: oracle.sysman. emcp.exception. EMConfigExceptio n: Listener is not up. Start the Listener and run EM Configuration Assistant again . at oracle.sysman. emcp.ParamsManag er.checkListener StatusForDBContr ol(ParamsManager .java:2705) at oracle.sysman. emcp.EMReposConf ig.invoke( EMReposConfig. java:193) at oracle.sysman. emcp.EMReposConf ig.invoke( EMReposConfig. java:147) at oracle.sysman. emcp.EMConfig. perform(EMConfig .java:221) at oracle.sysman. emcp.EMConfigAss istant.invokeEMC A(EMConfigAssist ant.java: 534) at oracle.sysman. emcp.EMConfigAss istant.performCo nfiguration( EMConfigAssistan t.java:1214) at oracle.sysman. emcp.EMConfigAss istant.statusMai n(EMConfigAssist ant.java: 518) at oracle.sysman. emcp.EMConfigAss istant.main( EMConfigAssistan t.java:467) tapi status listener saya ok.. [ora...@archiveserv ~]$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-DEC-2009 14:02:40 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL= TCP)(HOST= archiveserv) (PORT=1521) )) STATUS of the LISTENER ------------ --------- --- Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 10-DEC-2009 13:26:17 Uptime 0 days 0 hr. 36 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /OraHome/oracle11g/ product/11. 1.0/db_1/ network/admin/ listener. ora Listener Log File /OraHome/oracle11g/ product/11. 1.0/db_1/ log/diag/ tnslsnr/archives erv/listener/ alert/log. xml Listening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL= tcp)(HOST= archiveserv) (PORT=1521) )) (DESCRIPTION= (ADDRESS= (PROTOCOL= ipc)(KEY= EXTPROC1521) )) Services Summary... Service "PROD" has 1 instance(s). Instance "PROD", status READY, has 1 handler(s) for this service... Service "PRODXDB" has 1 instance(s). Instance "PROD", status READY, has 1 handler(s) for this service... Service "PROD_XPT" has 1 instance(s). Instance "PROD", status READY, has 1 handler(s) for this service... The command completed successfully Oracle di client dah connect... Mohon saran dan masukkannya. . Regards, WISNU [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
