Hello,
I installed XE, Weblogic and Zend and everything worked fine until a few days ago. I tried everything I found online until finally deleting and reinstalling everything all over, but to no avail.
The problem is I cannot connect to the database from an\any IDE. I can connect from sqlplus. Also, the apex link on 8080 is not working. It should not be a firewall issue since tnsping works (and I turned off the FW service). The problem is, it used to work fine. I tried JDeveloper and TOAD and same thing as the page: it hangs and doesn't connect. This problem happened "over night" but I am not sure when. Today when I wanted to create a few tables and write a program, I was amazed to see the connection attempt to end up in a freeze (and was forced to bring up the task manager)
(the setup is on my Windows XP SP 3 desktop, locally so it is not a network issue)
I use sys as sysdba on sqlplus and it works (select returns rows, for example), but I can't login from an IDE with any other user including sys.
All previous settings are identical to the ones here after the re-installation:
listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.4)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
tns
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 05-AUG-2012 16:42:57
Uptime 0 days 0 hr. 5 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File F:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File F:\oraclexe\app\oracle\diag\tnslsnr\eastfrontiers04\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.4)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=eastfrontiers04)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", 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 "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 05-AUG-2012 16:49:06
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: EASTFRONTIERS04, pid: 588>
(ADDRESS=(PROTOCOL=tcp)(HOST=eastfrontiers04)(PORT=1636))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully
SGA:
SQL> show sga
Total System Global Area 644468736 bytes
Fixed Size 1385488 bytes
Variable Size 192941040 bytes
Database Buffers 444596224 bytes
Redo Buffers 5545984 bytes
SQL>
Output in the listener log:
Trying to login from TOAD without auth-ing just hangs, I am forced to end the process:
Sun Aug 05 16:52:47 2012
05-AUG-2012 16:52:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Program?Files\Quest?Software\Toad?for?Oracle?10.6\Toad.exe)(HOST=192.168.50.4)(USER=User))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.4)(PORT=1653)) * establish * XE * 0
Sun Aug 05 16:54:14 2012
05-AUG-2012 16:54:14 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Program?Files\Quest?Software\Toad?for?Oracle?10.6\Toad.exe)(HOST=192.168.50.4)(USER=User))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.4)(PORT=1656)) * establish * XE * 0
Logging from sqlplus with auth:
Sun Aug 05 16:54:26 2012
05-AUG-2012 16:54:26 * service_update * xe * 0
Sun Aug 05 16:55:11 2012
05-AUG-2012 16:55:11 * service_update * xe * 0
Any ideas ? This is really annoying...
I am a relative beginner to the whole DBA scene, but this is too weird for me ... Apparently any "outside" application trying to connect seems to hang, but not get denied with an error message.
Curious if anyone else had this before.
Minor note: before reinstalling, I even tried a shutdown immediate\startup mount and lsnrctl stop\start, but nothing changed...