Pak andes, sudah berhasil create repository nya?? berikut ini saya contohkan hasil recreate repository EM punya saya, untuk memberi inspirasi. saya coba jadikan perintahnya jadi satu. Waktu yang dibutuhkan dari jam 8:38:25 AM sd 8:44:13 AM, di mesin IBM x3650 Single Processor 3.2 GHz, memory 2 GHz, dengan datafile "development" 70 GB.
############################################################################################## $ emca -config all db -repos recreate STARTED EMCA at Sep 14, 2007 8:38:25 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: stby10 Central agent home: /opt/app/oracle/product/10.2.0/db_1 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 ................ /opt/app/oracle/product/10.2.0/db_1 Database hostname ................ stby10 Listener port number ................ 1521 Database SID ................ stby10 Central agent home ................ /opt/app/oracle/product/10.2.0/db_1 Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: yes Sep 14, 2007 8:38:49 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /opt/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/stby10/emca_2007-09-14_08-38-25-AM.log. Sep 14, 2007 8:38:50 AM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... Sep 14, 2007 8:39:42 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Sep 14, 2007 8:39:42 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Sep 14, 2007 8:42:07 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Sep 14, 2007 8:42:27 AM oracle.sysman.emcp.util.CentralAgentUtil registerWithCentralAgents INFO: Registering target(s) with central agent(s) (this may take a while)... Sep 14, 2007 8:42:37 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Sep 14, 2007 8:44:13 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Sep 14, 2007 8:44:13 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is http://stby10:5500/em <<<<<<<<<<< Enterprise Manager configuration completed successfully FINISHED EMCA at Sep 14, 2007 8:44:13 AM ############################################################################################## saya mohon maaf jika apa yang saya berikan belum menyelesaikan masalah pak andes. mungkin rekan-rekan indo-oracle ada yang bisa membantu .... regard, subekti ----- Original Message ----- From: Andes Febrian To: [email protected] Sent: Thursday, September 13, 2007 3:29 PM Subject: Re: [indo-oracle] Tanya : OC4J Configuration issue pak subekti, ternyata yg saya kirim ketika database blm up, tp biarpun db sudah up sama jg sie masih eror ketika saya coba ketik : $ emca -repos create $ emca -config dbcontrol db dan menurut eror dibawah, repository sudah ada, tp saya gak ngerti apa yg harus di perbaiki ?? terima kasih :D $ emca -repos create STARTED EMCA at Thu Sep 13 22:30:57 WIT 2007 Enter the following information about the database to be configured Listener port number: 1521 Database SID: orcl Service name: orcl Email address for notification: Email gateway for notification: Password for dbsnmp: Password for sysman: Password for sys: ---------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/10.1.0 Enterprise Manager ORACLE_HOME ................ /u01/app/oracle/product/10.1.0 Database host name ................ andes.info Listener port number ................ 1521 Database SID ................ orcl Service name ................ orcl Email address for notification ............... Email gateway for notification ............... ---------------------------------------------------------- Do you wish to continue? [yes/no]: yes Sep 13, 2007 10:31:17 PM oracle.sysman.emcp.EMConfig checkConfiguration SEVERE: Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode. Could not complete the configuration. Refer to the log file for details $ emca -config dbcontrol db Incorrect usage: oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters] Options: -a :configure for an ASM database -b :configure for automatic backup -c :configure a cluster database -d :run EMCA from within the development view -e <node> :remove a node from the cluster -f <file> :specify the file name that contains parameter values -h :help -m :configure for central mode -n <node> :add a new node to the cluster -r :skip creation of repository schema -s :silent mode (no user prompts -x <db> :deletion of a SID or DB The script will prompt for any required data that is not specified in a configuration file. The script always prompts for all required passwords. If you use a configuration file, the file may contain any of the following specifications, as shown, with the specified values correctly filled in: Parameters for single instance databases: HOST=<Database hostname> SID=<Database SID> PORT=<Listener port number> ORACLE_HOME=<Database ORACLE_HOME> LISTENER=<Listener name> HOST_USER=<Host user name for automatic backup> HOST_USER_PWD=<Host user password for automatic backup> BACKUP_HOUR=<Automatic backup hour in number> BACKUP_MINUTE=<Automatic backup minute in number> ARCHIVE_LOG=<Archive log> EMAIL_ADDRESS=<Email address for automatic notification> MAIL_SERVER_NAME=<Email gateway for automatic notification> ASM_OH=<ASM ORACLE_HOME> ASM_SID=<ASM SID> ASM_PORT=<ASM port> ASM_USER_ROLE=<ASM user role> ASM_USER_NAME=<ASM user name> ASM_USER_PWD=<ASM user password> EM_HOME=<Enterprise Manager ORACLE_HOME> DBSNMP_PWD=<Password for dbsnmp> SYSMAN_PWD=<Password for sysman> SYS_PWD=<Password for sys> Parameters for cluster databses: HOST=<Database Instance hostname> PORT=<Listener port number> LISTENER=<Listener name> ORACLE_HOME=<Database ORACLE_HOME> CLUSTER_NAME=<Cluster name> DB_NAME=<Database name> SERVICE_NAME=<Service name> HOST_USER=<Host user name for automatic backup> HOST_USER_PWD=<Host user password for automatic backup> BACKUP_HOUR=<Automatic backup hour in number> BACKUP_MINUTE=<Automatic backup minute in number> ARCHIVE_LOG=<Archive log> EMAIL_ADDRESS=<Email address for automatic notification> MAIL_SERVER_NAME=<Email gateway for automatic notification> ASM_OH=<ASM ORACLE_HOME> ASM_PORT=<ASM port> ASM_USER_ROLE=<ASM user role> ASM_USER_NAME=<ASM user name> ASM_USER_PWD=<ASM user password> EM_HOME=<Enterprise Manager ORACLE_HOME> DBSNMP_PWD=<Password for dbsnmp> SYSMAN_PWD=<Password for sysman> SYS_PWD=<Password for sys> On 9/13/07, Subekti Pranoto <[EMAIL PROTECTED]> wrote: > > PAk andes, > > informasi yang tertera dapat bapak baca lagi dan saya kira cukup jelas. > a. shared_pool_size harus dibesarkan minimal 80M. > b. job_queue_processes harus bernilai lebih dari 0 > > $ locate init.ora > /opt/app/oracle/admin/stby10/pfile/init.ora.842007101943 > /opt/app/oracle/product/10.2.0/db_1/dbs/init.ora > /opt/app/oracle/product/10.2.0/db_1/srvm/admin/init.ora > > (pada contoh ini, database saya adalah "stby10". coba bapak cari lokasi > yang sesuai, yang mengandung kata (sid) bapak... yaitu andes. pada contoh, > saya pilih "/opt/app/oracle/admin/stby10/pfile/init.ora.842007101943" ) > > $ nano /opt/app/oracle/admin/stby10/pfile/init.ora.842007101943 > tambahkan nilai sebgai berikut: > > ########################################### > # Job Queues > ########################################### > job_queue_processes=10 > > ########################################### > # Pools > ########################################### > shared_pool_size=104857600 > > $sqlplus /nolog > SQL> conn / as sysdba > SQL> shutdown abort > SQL> shartup > pfile=/opt/app/oracle/admin/stby10/pfile/init.ora.842007101943 -----> > sesuaikan dengan pfile bapak. > SQL> exit > > $ emca -repos create > $ emca -config dbcontrol db > > regard, > subekti > > ----- Original Message ----- > From: Andes Febrian > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Thursday, September 13, 2007 10:04 AM > Subject: Re: [indo-oracle] Tanya : OC4J Configuration issue > > pak subekti, saya sudah coba lakukan "emca -repos create" tp tetep gak > bisa, > seperti dibawah ini : > > [EMAIL PROTECTED] ~]$ emca -repos create > > STARTED EMCA at Thu Sep 13 17:12:16 WIT 2007 > Enter the following information about the database to be configured > Listener port number: 1521 > Database SID: orcl > Service name: orcl > Email address for notification: > Email gateway for notification: > Password for dbsnmp: > Password for sysman: > Password for sys: > > ---------------------------------------------------------- > > You have specified the following settings > > Database ORACLE_HOME ................ /u01/app/oracle/product/10.1.0 > Enterprise Manager ORACLE_HOME ................ > /u01/app/oracle/product/10.1.0 > > Database host name ................ andes.info > Listener port number ................ 1521 > Database SID ................ orcl > Service name ................ orcl > Email address for notification ............... > Email gateway for notification ............... > > ---------------------------------------------------------- > Do you wish to continue? [yes/no]: yes > Sep 13, 2007 5:12:41 PM oracle.sysman.emcp.EMConfig checkConfiguration > WARNING: 'shared_pool_size' must be greater than or equal to 80 MB. > Sep 13, 2007 5:12:41 PM oracle.sysman.emcp.EMConfig checkConfiguration > SEVERE: 'job_queue_processes' must be greater than or equal to 1. Fix the > error(s) and run EM Configuration Assistant again in standalone mode. > Could not complete the configuration. Refer to the log file for details > > kira2 apanya lg ?? > > On 9/12/07, Subekti Pranoto <[EMAIL PROTECTED] <sub3xt1%40gmail.com>> > wrote: > > > > Pak Andes, > > > > saya bulan lalu juga mengalami hal yang sama, pak andes. habis install > > add/remove program custom, terus konfigurasi dbconsole error. ini > > konfigurasi yang saya pake: > > > > OS: CentOS v5.0 (final) > > DB: Oracle 10g R2 (10.2.0.1.0) > > > > $ emca -repos create > > $ emca -config dbcontrol db > > > > masukan parameter yang cocok: > > Listener port number: 1521 > > Database SID: cobadeh > > Service name: cobadeh > > Email address for notification: (enter) > > Email gateway for notification: (enter) > > Password for dbsnmp: xxxxxxx > > Password for sysman: xxxxxxx > > Password for sys: xxxxxxx > > > > tunggu konfigurasi selama 10-15 menit. > > > > $ export ORACLE_SID=cobadeh > > $ emctl start dbconsole > > > > alhamdulillah, dbconsole sudah bisa start dan jalan sampai sekarang > > > > regard, > > subekti > > > > ----- Original Message ----- > > From: Andes Febrian > > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com> > > Sent: Tuesday, September 11, 2007 11:49 AM > > Subject: [indo-oracle] Tanya : OC4J Configuration issue > > > > Dear all, > > > > sewaktu saya coba start emctl muncul pesan eror seperti dibawah ini : > > > > emctl start dbconsole > > TZ set to Asia/Jakarta > > OC4J Configuration issue. > > /u01/app/oracle/product/10.1.0/oc4j/j2ee/OC4J_DBConsole_andes.info_orcl > > not > > found. > > > > knp ya, adakah yg bisa bantu, terima kasih. > > > > FYI, saya install Oracle 10.1.0 di CentOS 5 > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
