Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Logging to database through OEM 11g shows error: Listener refused the connection with the following

edited Jun 10, 2018 5:37PM in Managing Databases using Enterprise Manager (MOSC) 4 commentsAnswered
Hi,
Every time I access the 'Performance' or 'Server (tab) > Storage > Tablespaces' on the Enterprise Manager console, it provides me a log-in page to the database. Upon log-in, the error is shown:

Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I'm confused because on the Home tab, it says that Host, DB, Listener and Agent are all running and connected properly. Furthermore if I access the db, with the same username and password,  using sqlplus or sqldeveloper, I can successfully log-in.

What might be the cause that I couldn't log-in on the database using the OEM 11g console?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center