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
