This discussion is archived
6 Replies Latest reply: Jan 17, 2007 10:20 AM by 247514 RSS

Status BLOCKED for instance - is it bad?

539154 Newbie
Currently Being Moderated
Hi,

1st of all please forgive me if such a topic exists being solved, give me a link then, I could't find...

1) I encountered strange problem when issuing lsnrctl status (the problematic lines are bold):

/home/oracle> lsnrctl status

LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 16-JAN-2007 21:16:16

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.1.0.3.0 - Production
Start Date 03-DEC-2006 07:47:28
Uptime 44 days 13 hr. 28 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/OraHome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/OraHome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=a)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=a)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=a)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "B" has 1 instance(s).
Instance "B", status READY, has 1 handler(s) for this service...
Service "BXDB" has 1 instance(s).
Instance "B", status READY, has 1 handler(s) for this service...
Service "Oracle8" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "d.zone1" has 1 instance(s).
Instance "d", status UNKNOWN, has 1 handler(s) for this service...
Service "a" has 3 instance(s).
Instance "a", status UNKNOWN, has 1 handler(s) for this service...
Instance "a", status READY, has 1 handler(s) for this service...
Instance "a", status BLOCKED, has 1 handler(s) for this service...
Service "aXDB" has 1 instance(s).
Instance "a", status READY, has 1 handler(s) for this service...

The command completed successfully

Is this state ok? I mean: are these three instances at the same time good? And what does it mean?
When, for example, I try to use exp I get error:

EXP-00056: ORACLE error 1033 encountered
ORA-01033: ORACLE initialization or shutdown in progress

and I think the problem is in these 3 instances. My listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/OraHome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = d.zone1)
(ORACLE_HOME = /u01/app/oracle/OraHome_1)
(SID_NAME = d)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /u01/app/oracle/OraHome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = a)
(ORACLE_HOME = /u01/app/oracle/OraHome_1)
(SID_NAME = a)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)

2) And one more: my listener.log is now 1260M big. Can I rename it to e.g. listener.old and create new one (as oracle user: touch listener.log)? Do I have to stop listener?

Thanks in advance, if more info is needed, give me a sign.
Reveler

Message was edited by:
reveler
  • 1. Re: Status BLOCKED for instance - is it bad?
    19426 Guru
    Currently Being Moderated
    I think you don't have a listener problem , 'Status BLOCKED' is only a consequence of
    'ORA-01033: ORACLE initialization or shutdown in progress'. Someone (or something) has issued a shutdown command, which seems to be hanging.
    As always corresponding alert.log for the instance is the first source to analyze the problem.
    Yes, you should clear this big listener.log file. Stop the listener, rename or delete listener.log, start the listener. The latter will create a new listener.log automatically.

    Werner
  • 2. Re: Status BLOCKED for instance - is it bad?
    247514 Expert
    Currently Being Moderated
    1) Check this from Oracle doc.

    Instance
    Specifies the name of the instance associated with the service along with its status and number of service handlers associated with the service

    Status can be one of the following:

    A READY status means that the instance can accept connections.

    A BLOCKED status means that the instance cannot accept connections.
    A READY/SECONDARY status means that this is a secondary instance in an Oracle9i Real Application Clusters primary/secondary configuration and is ready to accept connections.

    An UNKNOWN status means that the instance is registered statically in the listener.ora file rather than dynamically with service registration. Therefore, the status is non known.

    ------------------------
    Looks like your Instance is not open or startup nomount etc.

    2)
    If you are on unix system, rename file will not do the trick. Because unix system file is identified by inode number which will not change after rename.
  • 3. Re: Status BLOCKED for instance - is it bad?
    539154 Newbie
    Currently Being Moderated
    Thank You a lot for your answers (they in fact confused me a little with the listener.log :) rename or not? But it seems stopping lsnrctl, renaming log and starting lsnrctl done the job).

    As I concluded, I have to restart the server - stopping lsnrctl and shutting down the db and then starting it up was not a remedy - afrer all the situation is the same. I'll try to restart server a.s.a.p. and if it works, I'll write it down here. Or maybe You have a clue?

    Thanks a lot,
    Reveler
  • 4. Re: Status BLOCKED for instance - is it bad?
    247514 Expert
    Currently Being Moderated
    No, rename will not work. Even you rename listener.log to listener.old, listener process will still write to the same file. unless you restart the process. However if you gzip the file or remove the file, listener will create a fresh new logfile.

    Can you use "sqlplus / as sysdba" to login to the instance ? Is there any errors in alert<SID>.log file ?
  • 5. Re: Status BLOCKED for instance - is it bad?
    539154 Newbie
    Currently Being Moderated
    Yeap, I've restarted lsnrctl. And I can see the new file is growing, so this problem is solved, thanks again.

    As to sqlplus: it seems to work ok:
    ==========================
    /home/oracle> sqlplus / as sysdba

    SQL*Plus: Release 10.1.0.3.0 - Production on Wed Jan 17 15:17:45 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.


    Connected to:
    Oracle Database 10g Release 10.1.0.3.0 - Production
    ==========================
    The problem occurs if I try eg.:
    ==========================
    /home/oracle> exp

    Export: Release 10.1.0.3.0 - Production on Wed Jan 17 15:19:35 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.


    Username: sys
    Password:

    EXP-00056: ORACLE error 1033 encountered
    ORA-01033: ORACLE initialization or shutdown in progress
    ==========================
    In fact our application connecting to "a" works well, no user has reported a problem. But these 3 instances are still a stone in my eye :) and I'm not sure if in the future other application won't say "sorry", like exp says it now....

    Thanks for help,
    Reveler
  • 6. Re: Status BLOCKED for instance - is it bad?
    247514 Expert
    Currently Being Moderated
    What's the setting of
    ORACLE_SID

    when you issue the command.