Saturday, October 27, 2007

Enterprise Manager Troubleshooting

Most frequently seen problems with EM console have to do with non properly configured networking environments and skipping the dhcp warning at the installation phase. Proper networking configuration prerequisites have to be met before proceeding with installation.

1. DHCP issues.
Assigning a dynamic IP address makes the EM console to fail. Since the repository is configured with the environment it collects at install time, if a dynamic address is assigned, next time the computer unplugs (most frequently seen on laptop computers) EM stops working.

2. Use of IE with Enhanced Security Option enabled.
This is another issue frequently seen, when IE Enhanced Security option is enabled EM stops working, even though the console can be started.

3. Enterprise Manager can be accessed but Performance and maintenance tab request again for login credentials
This is another issue due to improperly configuring the networking and host name resolution environment. Oracle reads the hosts file to establish both the IP Address and the fully qualified host name. If it fails to properly read the hosts file, or if this doesn't properly identify the host, then the localhost.localdomain will be taken to configure the EM Console. When Attempting to solve the tns entry to access the performance tab or the maintenance tab Oracle won't be able to identify the host declared at the tns entry and it will fail to access, even though the provided credentials and the tns entry seem to be well configured.

4. Changing hostname or fixed IP Address
When networking changes happen then an EM reconfiguration is required.

For further references on HowTo troubleshoot and reconfigure Enterprise Manager I suggest to refer to this link --> Enterprise Manager DB Control Console.

4 comments:

Unknown said...

Hi i read your posts on Oracle forum. I am deeply impressed with your knowledge.



I work for a DWH and BI training and service providing company in India called KEYSOFT solutions.

We have recently started a forum on BI. It would be our pleasure if you could help our forum members find answers for their queries.

The forum is: http://forums.keysoft.co.in/active_users.asp



Thanks and regards

Deepika

Hector R. Madrid said...

I'm flattered after your comments. I'll be glad to assist you with the forum as long as my regular activities allow me to do so.

Thank You.

Mustafa said...

Dear Madrid

The link that you provided to solve EM troubleshooting http://sites.google.com/site/madrid9999/emtroubleshooting

doesn't work, and when i open this link http://download-west.oracle.com/docs/cd/B19306_01/install.102/b14316/reqs.htm#BABGCEAI

it says Invalid URL

The requested URL "/docs/cd/B19306_01/install.102/b14316/reqs.htm", is invalid.

Reference #9.7b51402.1336648514.1b6faec8

Could you provide Link that works for EM troubleshooting

Cou

Hector R. Madrid said...

Thank you for the remarks. By the time this article was published this was a valid link ... I'll update it with a new link.