Yes, the night is still young

Oracle 10g, Enterprise Manager give “Page Not Found” Error

System:
OS: Windows Server 2003 Sp1
Database: Oracle 10g (10.2.3.0)

Problem:
There are two Oracle databases, one of them gives “Page Not Found” when accessed from Oracle Enterprise Manager. This server was upgraded from Windows 2000 and Oracle 9i.

Solution:
pre-requisites:
SYS, SYSMAN, and DBSNMP password. Oracle_SID, and Listener port number.

Steps:
Drop existing EM configuration:
C:\Data> set ORACLE_SID=
C:\Data> emca -deconfig dbcontrol db -repos drop

Recreate the EM environment:
C:\Data> emca -config dbcontrol db -repos create

Note: if the above steps is failed, you might need to drop SYSMAN user manually before continue. Refer to here for more information. In my case, I do not need to drop the SYSMAN.

Once it completed, you will find a new shortcut for the EM in the Start -> Program Files -> Oracle Orahome

If your user unable to log on to database using EM with the following Error message:
“The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information.”

Add the following role to that user:
– SELECT_CATALOG_ROLE
– SELECT ANY DICTIONARY

Hope this helps someone out there!

References:
1. MacLochlainss Weblog
2. Emre Baransel – Oracle Blog

About these ads

One response

  1. guru

    Hi
    it’s greate. i have checked out.it’s working fine.
    thanks for that

    May 14, 2010 at 3:37 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.