6 Replies Latest reply: Mar 29, 2012 2:05 PM by 921861 RSS

    OEM Can't get to database after changing the port on the database

    921861
      Hello OEM Gurus!

      I had to change the port on a database(11g) from 1521 to 1526. I adjusted the listeners to include the SID (finapp1t) in the listener listening on port 1526. I removed the SID from OEM (10g btw) and rediscovered it. It successfully rediscovered.

      Now I receive the following when I attempt to go into "tablespaces" or "tables" on the FINAPP1T database page:

      Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: (description=(address=(host=urora2t.unioncentral.com)(protocol=tcp)(port=1521))(connect_data=(sid=finapp1t)(server=dedicated)))

      I then clean started the Agent on the server but I get the same results.

      OEM seems to think that that database FINAPP1T is still using port 1521. I can connect to the database on port 1526 from my Desktop so I know the listener sees this database.

      How do I tell OEM to update the port ?

      Thanks for you help!

      Edited by: sawright on Mar 29, 2012 10:33 AM