Monday, September 14, 2009

TNS NAME BLOCKED - SOLUTION

When lsnrctl status result as follows:
Instance "music", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

Solution:
Connect as sysdba

SELECT STATUS FROM V$INSTANCE;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;


No comments:

Post a Comment