How to reconfigure the EM Database control for OracleAuthor: eygle | Chinese Version "Copyright notice: Reprint, please be sure to hyperlink form to indicate the original source and author information and this statement"
Link: http://www.eygle.com/archives/2007/09/em_database_control_config.html
Today we are going to enable database control for Oracle Database 11g and found that it was not initially installed:
[oracle@test126 ~]$ emctl start
EM Configuration issue. /opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd not found.
If you encounter this type of problem, you can reconfigure it to create an EM profile:
[oracle@test126 11.1.0]$ emca-config Dbcontrol Db-repos recreate
Started EMCA at Aug, 2007 11:54:40 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, +, Oracle. All rights reserved.
Enter the following information:
Database sid:dodd
Listener Port number:1521
Password for SYS User:
Password for DBSNMP User:
Password for Sysman User:
Password for Sysman User:email address for notifications (optional): eygle@eygle.com
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
The Database oracle_home .../opt/oracle/product/11.1.0. .......
Local hostname ... ... test126.hurray.com.cn. .......
Listener port number .......... 1521
Database SID ... Dodd, ........
Email address for notifications ... eygle@eygle.com. ......
Outgoing Mail (SMTP) server for notifications ........
-----------------------------------------------------------------
Do your wish to continue? [Yes (y)/no (N)]: Y
Aug, 2007 11:56:58 AM Oracle.sysman.emcp.EMConfig perform
Info:this operation is being logged at/opt/oracle/cfgtoollogs/emca/dodd/emca_2007_08_28_11_54_40.log.
Aug, 2007 11:57:01 AM Oracle.sysman.emcp.EMReposConfig invoke
Info:dropping the EM repository (this may take a while) ...
Aug, 2007 11:57:16 AM Oracle.sysman.emcp.EMReposConfig invoke
Info:repository successfully dropped
Aug, 2007 11:57:16 AM Oracle.sysman.emcp.EMReposConfig createrepository
Info:creating the EM repository (this may take a while) ...
Aug, 2007 12:08:35 PM Oracle.sysman.emcp.EMReposConfig invoke
Info:repository successfully created
Aug, 2007 12:08:47 PM Oracle.sysman.emcp.EMReposConfig uploadconfigdatatorepository
Info:uploading configuration data to EM repository (this could take a while) ...
Aug, 2007 12:11:45 PM Oracle.sysman.emcp.EMReposConfig invoke
info:uploaded Configuration Data successfully
Aug, 2007 12:11:51 PM Oracle.sysman.emcp.util.DBControlUtil configuresoftwarelib
Info:software Library configured successfully.
Aug, 2007 12:11:51 PM Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary
Info:deploying Provisioning Archives ...
Aug, 2007 12:12:13 PM Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary
Info:provisioning Archives deployed successfully.
Aug, 2007 12:12:13 PM Oracle.sysman.emcp.util.DBControlUtil securedbconsole
Info:securing Database Control (this may take-a while) ...
Aug, 2007 12:12:39 PM Oracle.sysman.emcp.util.DBControlUtil securedbconsole
Info:database Control secured successfully.
Aug, 2007 12:12:39 PM Oracle.sysman.emcp.util.DBControlUtil startoms
Info:starting Database Control (this may take-a while) ...
Aug, 2007 12:14:04 PM Oracle.sysman.emcp.EMDBPostConfig performconfiguration
Info:database Control started successfully
Aug, 2007 12:14:04 PM Oracle.sysman.emcp.EMDBPostConfig performconfiguration
INFO: >>>>>>>>>>> The Database control URL is Https://test126.hurray.com.cn:1158/em <<<<<<<<<<<
Aug, 2007 12:14:16 PM Oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data would be encrypted. The encryption key has been placed in the file:/opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd/sysman/config/ Emkey.ora. Please ensure this file was backed up as the encrypted data would become unusable if this file is lost.
***********************************************************
Enterprise Manager Configuration completed successfully
Finished EMCA at Aug 2007 12:14:16 PM
In Oracle 10g, the configuration method is the same.
After the configuration is complete, you can start em up:
[oracle@test126 11.1.0]$ emctl start Dbconsole
Oracle Enterprise Manager 11g Database Control release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Https://test126.hurray.com.cn:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database control ... started.
------------------------------------------------------------------
Logs are generated in Directory/opt/oracle/product/11.1.0/test126.hurray.com.cn_dodd/sysman/log
If it is a Linux environment, you may also need to open 1158 ports in Iptables, adding the following line:
-A rh-firewall-1-input-m State--state new-m tcp-p TCP--dport 1158-j ACCEPT
After restarting the firewall, you can connect em via IE at the remote end of the database control:
[root@test126 sysconfig]# Service iptables restart
Flushing firewall rules: [OK]
Setting chains to Policy Accept:filter [OK]
Unloading iptables modules: [OK]
Applying iptables firewall rules: [OK]
Loading additional iptables Modules:ip_conntrack_netbios_ns [OK]
-the end-