Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle 10g Listener status blocked on Database Instance

Posted on 2008-10-06
7
Medium Priority
?
7,912 Views
Last Modified: 2013-12-18
Need assistance with resolving "status blocked" message from listener for Oracle 10g database.
This is Oracle 10g on Windows 2003 server

Have tried ASM installed on different and same homes with no difference.
Understand that is normal for ASM blocked report. Concerned that database instance is also blocked.


C:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 06-OCT-2008 11:29
:44
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date                06-OCT-2008 09:59:01
Uptime                    0 days 1 hr. 30 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File         C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orgdatabase1)(PORT=1521)))
Services Summary...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm", status BLOCKED, has 1 handler(s) for this service...
Service "+asm" has 1 instance(s).
  Instance "+asm", status BLOCKED, 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 "database1" has 1 instance(s).
  Instance "database1", status BLOCKED, has 1 handler(s) for this service...
Service "database1_XPT" has 1 instance(s).
  Instance "database1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

Open in new window

0
Comment
Question by:planetborn2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 18

Accepted Solution

by:
sk_raja_raja earned 600 total points
ID: 22652248
0
 
LVL 8

Assisted Solution

by:LindaC
LindaC earned 900 total points
ID: 22652527
Inrease PROCESSES.

Cause
By way of instance registration, PMON is responsible for updating the listener
with information about a particular instance such as load and dispatcher
information. Maximum load for dedicated connections is determined by the
PROCESSES parameter. The frequency at which PMON provides SERVICE_UPDATE
information varies according to the workload of the instance. The maximum
interval between these service updates is 10 minutes.

The listener counts the number of connections it has established to the instance
but does not immediately get information about connections that have terminated.
Only when PMON updates the listener via SERVICE_UPDATE is the listener
informed of current load. Since this can take as long as 10 minutes, there can be
a difference between the current instance load according to the listener
and the actual instance load.

When the listener believes the current number of connections has reached maximum
load, it may set the state of the service handler for an instance to "blocked"
and begin refusing incoming client connections with either of the following
errors:

TNS-12516 TNS:listener could not find instance with matching protocol stack
TNS-12519 TNS:no appropriate service handler found

Additionally, an ORA-12520 error may appear in the listener log.

The output of the LSNRCTL services command will likely show that the service handler is "blocked".

e.g. '"DEDICATED" established:1 refused:0 state:blocked'
Solution
Increase the pfile or spfile setting for PROCESSES.
0
 

Author Comment

by:planetborn2
ID: 22653431
Thanks for the responses so far.  The problem may have a different root cause since the suggestions provided have not lead to an answer.  The attached file shows that the cause may be related to the database not mounting.  Can you provide assistance with this area as a possible cause for this situation?

Thanks in advance.

planetborn2
logfile.doc
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 8

Assisted Solution

by:LindaC
LindaC earned 900 total points
ID: 22653516
This is the problem.  If you are not the System Admin, talk to her/him:
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup




ORA-00202: control file: '+DATA/database1/controlfile/current.265.662393849'
ORA-17503: ksfdopn:2 Failed to open file +DATA/database1/controlfile/current.265.662393849
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup

Mon Oct 06 09:41:53 2008
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
0
 

Author Comment

by:planetborn2
ID: 22658735
So now that the problem - or question is clear -  I still don't know how to fix it. Why would the diskgroup mount and then unmount so that it is unavailable?  

planetborn2
0
 
LVL 8

Assisted Solution

by:LindaC
LindaC earned 900 total points
ID: 22658767
It is obvious you are not the System Admin.  Talk to him/her.  Where I work after rebooting some server I have to talk to the Sys admin, telling that a filesystem is not mounted, is missing, they do soething which I don't know what it is and then I can see the filesystem again.
0
 

Author Comment

by:planetborn2
ID: 22687837
Several days of additional troubleshooting have not resolved the root problem causing the listener error, that being that the database will not function with the disk as indicated in the log snippet previously provided.  Thanks for the assistance to date but no solution can be accepted as this has not lead to problem resolution.

planetborn2
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question