Oracle重建企业管理器（重建控制文件 oracle）

1.首先创建监听 [root@primary ~]# xhost + access control disabled, clients can connect from any host [root@primary ~]# su - oracle [oracle@primary ~]$ netca 批注：此处创建的监听名字LISTENER，database_ID=orcl查看企业管理器的网页浏览方式所在目录参考，如下： [root@primary ~]# su - oracle [oracle@primary ~]$ cd $ORACLE_HOME [oracle@primary db_1]$ cd install [oracle@primary install]$ more readme.txt The following J2EE Applications have been deployed and are accessible at the URL s listed below. iSQL*Plus URL: iSQL*Plus DBA URL: /dba 2.打开数据库 [oracle@primary install]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 17 08:33:17 2014 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select instance_name,status from V$instance; INSTANCE_NAME    STATUS ---------------- ------------ orcl             OPEN 3.查看监听状态，必须是运行状态 [oracle@primary install]$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JUN-2014 08:35:40 Copyright (c) 1991, 2005, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=primary)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date                17-JUN-2014 08:29:31 Uptime                    0 days 0 hr. 6 min. 8 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /u01/oracle/db_1/network/admin/listener.ora Listener Log File         /u01/oracle/db_1/network/log/listener.log Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Services Summary... Service "PLSExtProc" has 1 instance(s).   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s).   Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s).   Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl_XPT" has 1 instance(s).   Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully 查看监听端口号，如下： [oracle@primary install]$ cd $ORACLE_HOME/network/admin/ [oracle@primary admin]$ lslistener.ora  samples  shrept.lst  tnsnames.ora [oracle@primary admin]$ more listener.ora # listener.ora Network Configuration File: /u01/oracle/db_1/network/admin/listen er.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /u01/oracle/db_1)       (PROGRAM = extproc)     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )   ) 4.查看/etc/hosts里边的IP地址和主机名必须与实际一致 [root@primary ~]# hostnameprimary [root@primary ~]# ifconfig eth0 eth0      Link encap:Ethernet  HWaddr 00:0C:29:DA:7E:F0           inet addr:192.168.10.10  Bcast:192.168.10.255  Mask:255.255.255.0           inet6 addr: fe80::20c:29ff:feda:7ef0/64 Scope:Link           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1           RX packets:6392 errors:0 dropped:0 overruns:0 frame:0           TX packets:10621 errors:0 dropped:0 overruns:0 carrier:0           collisions:0 txqueuelen:1000           RX bytes:458467 (447.7 KiB)  TX bytes:1665793 (1.5 MiB)           Interrupt:59 Base address:0x2024 [root@primary ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1               localhost192.168.10.10           primary #::1                    localhost6.localdomain6 localhost6 5.关闭企业管理器 emctl stop dbconsole [oracle@primary ~]$ emctl stop dbconsole TZ set to PRC Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved. /console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control ...  ...  Stopped. 6.删除em资料库  emca –repos drop [oracle@primary ~]$ emca -repos drop STARTED EMCA at Jun 17, 2014 8:44:08 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: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y Jun 17, 2014 8:44:19 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/oracle/db_1/cfgtoollogs/emca/orcl/emca_2014-06-17_08-44-08-AM.log. Jun 17, 2014 8:44:20 AM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... Jun 17, 2014 8:46:27 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Jun 17, 2014 8:46:28 AM 7.创建em资料库 emca -repos create [oracle@primary ~]$ emca -repos create STARTED EMCA at Jun 17, 2014 8:47:23 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: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y Jun 17, 2014 8:47:34 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/oracle/db_1/cfgtoollogs/emca/orcl/emca_2014-06-17_08-47-23-AM.log. Jun 17, 2014 8:47:34 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jun 17, 2014 8:50:33 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Enterprise Manager configuration completed successfully FINISHED EMCA at Jun 17, 2014 8:50:33 AM 8.配置em ：emca –config dbcontrol db首先在实体机上添加一块网卡： 批注：此处设置的第二块网卡应与虚拟机中的网卡在同一个网段，然后虽然实体机的IP和虚拟机不在同一个网段，也能够通过刚刚设置的第二块网卡和之相通。 [oracle@primary ~]$ emca -config dbcontrol db STARTED EMCA at Jun 17, 2014 8:55:23 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 Database Control is already configured for the database orcl You have chosen to configure Database Control for managing the database orcl This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: y 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 ................ /u01/oracle/db_1 Database hostname ................ primary 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 Jun 17, 2014 8:55:43 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/oracle/db_1/cfgtoollogs/emca/orcl/emca_2014-06-17_08-55-23-AM.log. Jun 17, 2014 8:55:44 AM oracle.sysman.emcp.DatabaseChecks performReposChecks WARNING: 'shared_pool_size' must be greater than or equal to 80 MB. Jun 17, 2014 8:55:46 AM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Jun 17, 2014 8:55:56 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Jun 17, 2014 8:57:33 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Jun 17, 2014 8:57:33 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is <<<<<<<<<<< Enterprise Manager configuration completed successfullyFINISHED EMCA at Jun 17, 2014 8:57:33 AM 9.查看em状态emctl status dbconsole [oracle@primary ~]$ emctl status dbconsole TZ set to PRC Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved. /console/aboutApplicationOracle Enterprise Manager 10g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/oracle/db_1/primary_orcl/sysman/log 10.简单测试 测试前的准备工作，如下： 1)检测实体机能否ping通虚拟机（虚拟机能ping通实体机，这个没得说） 2)检测虚拟机中设置的端口能否连接： 出现如下界面表示能够连通： 3)浏览器中输入 http://192.168.10.10:1158/em 测试 成功登陆之后显示如下界面表示em重置成功：