| INSTANCE BLOCKED [message #196271] |
Wed, 04 October 2006 13:03  |
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  |
Frank Naude
Messages: 4579
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 #197035 is a reply to message #197032] |
Mon, 09 October 2006 12:06 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
