This content has been marked as final. Show 2 replies
Connect as SYSDBA and try following commands
select status, database_status from v$instance;
select open_mode from v$database;
Ideally, you should have INSTANCE STATUS as STARTED, database status as active and open_mode (2nd query as READ WRITE).
Go to RUN-CONTROL ADMINTOOLS-EVENT VIEWER-ACTION-CLEAR ALL EVENTS
Now just restart the listener service from services.msc
Do try this and let me know u need any more help.