Hello,
I've recently installed fresh copy of Oracle XE 11g 64-bit on Windows 7. After I ran the install everything was working wonderfully - I was able to connect to the new instance locally via jdbc. However, I noticed that after I restarted my computer I started to see some issues. After I restart I see that the OracleServiceXE and OracleXETNSListener are both running. Running lsnrctl status command produces the following results (I edited my computer name to localhost below):
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(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...
Everything appears to be running fine. However, when I attempt to connect to the db via jdbc (from localhost) I receive a TimeoutException. The only thing that has been able to fix this issue for me is setting the services to startup manually and then start the database using the Start Database utility. How do I actually get the services to automatically start up and work? Is there some sort of dependency I'm missing?
Thanks for any help!