How to reconfigure Oracle's em Database control____oracle

Source: Internet
Author: User
Tags iptables
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-

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.