I changed the port that Oracle was using from 1523 to the default 1521. The database is running on the correct port now. I can connect on 1521 and run queries.
However the Enterprise Manager is still showing that the port is 1523, and that the database is down.
Why doesn't the OEM know that I'm using the new port? How do I fix this?
Edit: I think I changed the port the wrong way. I changed the listener.ora file, the tnsnames.ora file and ran alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))";
Best Answer
Sometimes it helps to de-install the enterprise manager and then re-install it using the
emca
command. We'll leave that for the worst case.Using EMCA After Changing the Database Listener Port
(emphasis mine)
Reference: Enterprise Manager Advanced Configuration (Oracle Docs 10g)
In your case you would run the following commands:
You might have to provide various pieces of information when re-configuring the Enterprise Manager:
If this doesn't reconfigure the database control for your instance you might have to re-create the repository containing all the Entrprise Management Console configuration settings. You would achieve this be adding a parameter to the previous command:
This will de-configure the EM Console settings for a database (not for a cluster installation) and then recreate the repository.
The additional information I listed above will be required for a re-configuration to work.