Oracle EM(Enterprise Manager) 是基于B/S的web界面oracle数据库管理工具
EM安装:
1`.root 用户登录服务器
2.切换到oracle用户
#su - oracle
3.删除旧的EM
#emca -deconfig dbcontrol db -repos droporacle@linux-hxmo:~> emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Jan 11, 2018 5:29:11 PM
EM Configuration Assistant, Version 11.2.0.0.2 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
Jan 11, 2018 5:29:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /home/oracle/app/cfgtoollogs/emca/orcl/emca_2018_01_11_17_29_11.log.
Jan 11, 2018 5:29:59 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Jan 11, 2018 5:29:59 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Jan 11, 2018 5:29:59 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jan 11, 2018 5:31:21 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 11, 2018 5:31:21 PM
oracle@linux-hxmo:~>
4.删除旧的用户,避免在配置的时候会出错
SQL> drop user SYSMAN cascade;
drop user SYSMAN cascade
*
ERROR at line 1:
ORA-01918: user 'SYSMAN' does not exist
SQL> drop user MGMT_VIEW cascade;
drop user MGMT_VIEW cascade
*
ERROR at line 1:
ORA-01918: user 'MGMT_VIEW' does not exist
SQL> drop role MGMT_USER;
drop role MGMT_USER
*
ERROR at line 1:
ORA-01919: role 'MGMT_USER' does not exist
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym MGMT_TARGET_BLACKOUTS
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym SETEMVIEWUSERCONTEXT
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist
SQL> exit
ITPUB个人空间'Ju"e:D5i0\*D+A hITPUB个人空间#OM5uT \SITPUB个人空间!zD6~E yi$O_ITPUB个人空间?e$q6q5^+`|删除的时候会报错,用户不存在,不需要理会
5.重安装EM
在oracle用户下,执行安装命令,并填写相应的内容即可
emca -deconfig dbcontrol db -repos create
oracle@linux-hxmo:~> emca -config dbcontrol db -repos create
STARTED EMCA at Jan 11, 2018 5:33:43 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /home/oracle/app/oracle/product/11.2.0/dbhome_1 ]: /home/oracle/app/oracle/product/11.2.0/dbhome_1
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 ................ /home/oracle/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ linux-hxmo
Listener ORACLE_HOME ................ /home/oracle/app/oracle/product/11.2.0/dbhome_1
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
Jan 11, 2018 5:34:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /home/oracle/app/cfgtoollogs/emca/orcl/emca_2018_01_11_17_33_43.log.
Jan 11, 2018 5:34:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 11, 2018 5:39:20 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 11, 2018 5:40:11 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jan 11, 2018 5:41:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 11, 2018 5:41:55 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jan 11, 2018 5:41:55 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jan 11, 2018 5:46:23 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jan 11, 2018 5:46:23 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 11, 2018 5:47:10 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jan 11, 2018 5:47:10 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 11, 2018 5:51:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 11, 2018 5:51:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://linux-hxmo:1158/em <<<<<<<<<<<