第二章 Oracle使用

 

 OEM 修复

[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
OC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_oraserv_orcl not found.
[oracle@oraserv db_1]$ emca -repos recreate
 
STARTED EMCA at Feb 18, 2011 4:30:11 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: orcl
Listener port number: 1521
Password for SYS user: oracle
Password for SYSMAN user: oracle
Password for SYSMAN user: 
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 18, 2011 4:30:26 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2011-02-18_04-30-11-AM.log.
Feb 18, 2011 4:30:26 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
                                                                                                    Feb 18, 2011 4:32:34 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Feb 18, 2011 4:32:35 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
 
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 18, 2011 4:37:47 AM
 
 
[oracle@oraserv db_1]$ emca -config dbcontrol db
 
STARTED EMCA at Feb 18, 2011 4:40:13 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: orcl
Listener port number: 1521
Password for SYS user: oracle
Password for DBSNMP user: oracle
Password for SYSMAN user: oracle
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
 
You have specified the following settings
 
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
 
Database hostname ................ oraserv
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
Feb 18, 2011 4:40:42 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2011-02-18_04-40-13-AM.log.
Feb 18, 2011 4:40:43 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB. 
                                                                                                    Feb 18, 2011 4:40:52 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for oraserv
Feb 18, 2011 4:40:57 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
 
Feb 18, 2011 4:42:47 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 18, 2011 4:42:47 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://oraserv:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 18, 2011 4:42:47 AM
 
修复后
 
[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
 - An instance of Oracle Enterprise Manager 10g Database Control is already running.
[oracle@oraserv db_1]$ emctl stop dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
 ... Stopped.
[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control ..................... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/oraserv_orcl/sysman/log
[oracle@oraserv db_1]$