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
Make sure that the port number is updated in the "Configure Database Instance: Properties" page, which is accessible by clicking the Monitoring Configuration link in the Related Links section of the database homepage.
Can you please do the following steps:
- Perform a test connection from the "Configure Database Instance: Properties" page to see if the test is successful? If not, post the error message.
- Check if the value of the ConnectDescriptor property is correct and matches with what you see in the "Configure Database Instance: Properties" page?
The connection test was successful.
Information from Review Screen:
Oracle home path /u01/app/oracle/product/11.2.0/dbhome_1
Monitor Username dbsnmp
Monitor Password ******
Listener Machine Name urora2t.unioncentral.com
Database SID finapp1t
Preferred Connect String
Edited by: sawright on Mar 29, 2012 11:24 AM