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): [email protected] 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 ............... [email protected] 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.EMConfigException: Listener is not up. Start the Listener and run EM Configuration Assistant again . at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2705) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:193) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:221) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:534) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1214) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:518) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.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/archiveserv/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]
