Enterprise Manager -em konsolü hata verdiğinde gerektiğinde konsol drop edilip tekrar create edilebilir;
cmd>emca -config dbcontrol db
cmd>emctl start dbconsole em
Environment variable ORACLE_SID not defined. Please define it.
cmd>set oracle_sid=orcl
———————————————————————-
cmd>emctl start dbconsole em
cmd>emca -deconfig dbcontrol db -repos drop
cmd>emca -config dbcontrol db -repos create
cmd>emca -config dbcontrol db -repos recreate
—————————-örnek——————————–
Microsoft Windows XP [Sürüm 5.1.2600]
(C) Telif Hakkı 1985-2001 Microsoft Corp.
C:\Documents and Settings\oeripek>emca -config dbcontrol db -repos recreate
STARTED EMCA at 17.Nis.2008 16:15:18
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
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 ……………. D:\oracle\product\10.2.0\db_1
Database hostname ……………. ETFBITA22
Listener port number ……………. 1521
Database SID ……………. orcl
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
17.Nis.2008 16:15:32 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\ORCL\emca_2008-04-17_04-15-18-PM.log.
17.Nis.2008 16:15:34 oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …
17.Nis.2008 16:16:32 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
17.Nis.2008 16:16:32 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
17.Nis.2008 16:19:17 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
17.Nis.2008 16:19:21 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
17.Nis.2008 16:20:01 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
17.Nis.2008 16:20:01 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ETFBITA22:1158/em <<<<<<<<<
<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 17.Nis.2008 16:20:01
C:\Documents and Settings\oeripek>
———–for unix————-
örneğin orcl database’inin dışında bir de sonradan eklenen test database’i ile birlikte her iki instance’ın Enterprise Manager (em) ‘ini açmak için;
bash-3.00$ export ORACLE_SID=orcl
bash-3.00$ ./emctl status dbconsole
bash-3.00$ ./emctl stop dbconsole
bash-3.00$ ./emctl start dbconsole
bash-3.00$ .. http://ordba:1158/em…
bash-3.00$ export ORACLE_SID=test
bash-3.00$ ./emctl status dbconsole
bash-3.00$ ./emctl stop dbconsole
bash-3.00$ ./emctl start dbconsole
bash-3.00$ .. http://ordba:5500/em…
Orhan Eripek's Oracle Blog 