Home » RDBMS Server » Networking and Gateways » INSTANCE BLOCKED
INSTANCE BLOCKED [message #196271] Wed, 04 October 2006 13:03 Go to next message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

Hi:

I´m having a problem with an instance...

when i try

lsnrctl status

I get an instance BLOCKED anyone knows how change this and where?
Here my lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.3.0 - Production on 30-SEP-2006 13:17
:21

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=demoB)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.3.0 - Produ
ction
Start Date 30-SEP-2006 13:14:06
Uptime 0 days 0 hr. 3 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\infra\network\admin\listener.ora
Listener Log File C:\infra\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=demoB)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "bdinfra.com" has 1 instance(s).
Instance "bdinfra", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully.


Greetings
Alex

[Updated on: Wed, 04 October 2006 13:28]

Report message to a moderator

Re: INSTANCE BLOCKED [message #196331 is a reply to message #196271] Thu, 05 October 2006 00:58 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
"A BLOCKED status means that the instance cannot accept connections."

I guess the trick is to find out why this would be the case. Are there any clues in the listener.log?
Re: INSTANCE BLOCKED [message #197018 is a reply to message #196331] Mon, 09 October 2006 10:05 Go to previous messageGo to next message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

i can´t see nothing strange....

The status in the Windows console is started for both (database and listener) and tnsping is ok.

But if i tried to connectme to the database with SQL*PLUS i get the follow message error...

ORA-01033: ORACLE initialization or shutdown in progress...


I stopped the services and restart the server and i get still the error.... anyone knows why is that??

Greetings
Alex

Re: INSTANCE BLOCKED [message #197032 is a reply to message #196271] Mon, 09 October 2006 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup
Re: INSTANCE BLOCKED [message #197035 is a reply to message #197032] Mon, 09 October 2006 12:06 Go to previous message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

I´m trying to configure my ORACLE_SID to bdinfra, but when i'm trying to log in i have the error:

TNS: protocol adapter error

I'm doing as follow

c:\ORACLE_HOME\BIN> set ORACLE_SID= BDINFRA ---> THIS IS THE ORACLE SID IN MY TNSNAMES.ORA

AND WHEN I'M TRYING WITH SQL*PLUS (not via cmd) i get the error above shown

Thanks anacedent

forget the error... I have many oracle homes for different products... In windows seems that the last product installation get the control for the oracle_sid... i change it and all works...

[Updated on: Mon, 09 October 2006 12:16]

Report message to a moderator

Previous Topic: How to select data throw two dblinks ?
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sat Dec 20 15:36:36 CST 2014

Total time taken to generate the page: 0.09703 seconds