Today, I plan to enable the Database Control for Oracle Database 11 GB and find that the database is not installed initially:
[Oracle @ test126 ~] $ Emctl start
Em configuration issue./opt/Oracle/product/11.1.0/test126.hurray.com.cn _ Dodd not found.
In this case, you can re-configure the EM configuration file:
[Oracle @ test126 11.1.0] $ emca-config dbcontrol DB-repos recreate
Started emca at Aug 28,200 7 11:54:40 AM
Em configuration assistant, version 11.1.0.5.0 Production
Copyright (c) 2003,200 5, 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 communications (optional): eygle@eygle.com
Outgoing mail (SMTP) server for communications (optional ):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ....../opt/Oracle/product/11.1.0
Local hostname... test126.hurray.com.cn
Listener port number... 1521
Database Sid ......
Email Address for communications .......... eygle@eygle.com
Outgoing mail (SMTP) server for communications ...............
-----------------------------------------------------------------
Do you wish to continue? [Yes (y)/NO (n)]: Y
Aug 28,200 7 11:56:58 am oracle. sysman. emcp. emconfig perform
Info: this operation is being logged at/opt/Oracle/export toollogs/emca/Dodd/emca_2007_08_28_11_54_40.log.
Aug 28,200 7 11:57:01 am oracle. sysman. emcp. emreposconfig invoke
Info: dropping the EM repository (this may take a while )...
Aug 28,200 7 11:57:16 am oracle. sysman. emcp. emreposconfig invoke
Info: Repository successfully dropped
Aug 28,200 7 11:57:16 am oracle. sysman. emcp. emreposconfig createrepository
Info: creating the EM repository (this may take a while )...
Aug 28,200 7 12:08:35 oracle. sysman. emcp. emreposconfig invoke
Info: Repository successfully created
Aug 28,200 7 12:08:47 oracle. sysman. emcp. emreposconfig uploadconfigdatatorepository
Info: Uploading configuration data to Em repository (this may take a while )...
Aug 28,200 7 12:11:45 oracle. sysman. emcp. emreposconfig invoke
Info: uploaded configuration data successfully
Aug 28,200 7 12:11:51 PM oracle. sysman. emcp. util. dbcontrolutil configuresoftwarelib
Info: software library configured successfully.
Aug 28,200 7 12:11:51 PM oracle. sysman. emcp. emdbpostconfig configuresoftwarelibrary
Info: deploying provisioning archives...
Aug 28,200 7 12:12:13 PM oracle. sysman. emcp. emdbpostconfig configuresoftwarelibrary
Info: Provisioning archives deployed successfully.
Aug 28,200 7 12:12:13 PM oracle. sysman. emcp. util. dbcontrolutil securedbconsole
Info: securing Database Control (this may take a while )...
Aug 28,200 7 12:12:39 PM oracle. sysman. emcp. util. dbcontrolutil securedbconsole
Info: Database Control secured successfully.
Aug 28,200 7 12:12:39 oracle. sysman. emcp. util. dbcontrolutil startoms
Info: Starting Database Control (this may take a while )...
Aug 28,200 7 12:14:04 PM oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Info: Database Control started successfully
Aug 28,200 7 12:14:04 PM oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Info: >>>>>>>>>> the Database Control URL is https://test126.hurray.com.cn: 1158/EM <
Aug 28,200 7 12:14:16 PM oracle. sysman. emcp. emdbpostconfig invoke
Warning:
* *********************** Warning *************** *********
Management repository has been placed in secure mode wherein Enterprise Manager data will 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 is backed up as the encrypted data will become unusable if this file is lost.
**************************************** *******************
Enterprise Manager Configuration completed successfully
Finished emca at Aug 28,200 7 12:14:16
In Oracle 10 Gb, the configuration method is the same.
After the configuration is complete, you can start EM:
[Oracle @ test126 11.1.0] $ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996,200 7 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
In a Linux environment, you may need to open port 1158 in iptables and add 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 use IE to remotely connect to the EM 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]