Pak andes, repository mungkin sudah dicreate kemarin dan ternyata error kan. solusinya, coba drop dan create ulang lagi repositorinya.
$ emca -repos recreate --> drop dan create ulang repository Enter the following information: Database SID: cobadeh Listener port number: 1521 Password for SYS user: xxxx Password for SYSMAN user: xxxx Password for SYSMAN user: xxxx tunggu konfigurasi selama 10-15 menit. $ emca -config dbcontrol db $ export ORACLE_SID=cobadeh $ emctl start dbconsole 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]
