Dear Masters & Members, Saya dapet kendala nih saat sedang create Enterprise Manager Oracle di Server Development saya; Padahal waktu saya buat production gak rumit seperti sekarang.. ada aja errornya..
Berikut yg saya lakukan.. [ora...@development db_1]$ cd $ORACLE_HOME/bin [ora...@development bin]$ ./emca -config dbcontrol db -repos create STARTED EMCA at Nov 26, 2009 3:21:48 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: Password for SYSMAN user: Email address for notifications (optional): [email protected] Outgoing Mail (SMTP) server for notifications (optional): disamarkan ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /OraHome/oracle11g/product/11.1.0/db_1 Local hostname ................ development Listener port number ................ 1521 Database SID ................ PROD Email address for notifications ............... [email protected] Outgoing Mail (SMTP) server for notifications ............... disamarkan ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Nov 26, 2009 3:23:01 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_21_48.log. Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_create_<date>.log for more details. Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_21_48.log for more details. Could not complete the configuration. Refer to the log file at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_21_48.log for more details. Nah dalam log tersebut saya mendapati salah satu kejanggalan Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD))): ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin) Saya sudah googling dan saya coba beberapa saran dan saya malah dapat error demikian Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand CONFIG: Enter SYS user's password : Getting temporary tablespace from database... Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD))): ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin) Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand CONFIG: stty: standard input: Invalid argument stty: standard input: Invalid argument Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /OraHome/oracle11g/product/11.1.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD))) -repos_user SYSMAN -action drop -verbose -output_file /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_drop_2009_11_26_15_34_27.log Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error dropping the repository Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_drop_<date>.log for more details. Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error dropping the repository Refer to the log file at /OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_34_05.log for more details. Nov 26, 2009 3:34:27 PM 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:208) 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) atoracle.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) Mohon bantuan dari Masters dan Members skalian.. Regards, Wisnu [Non-text portions of this message have been removed]
