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]
