troubleshooting Question

Error connecting to Oracle Apex DB Home Page

Avatar of Daniel993
Daniel993Flag for Estonia asked on
Oracle Database
2 Comments1 Solution1283 ViewsLast Modified:
Hi Experts

I’ve been trying to install Oracle XE 11g and I keep receiving the infamous error

could not connect to

I’ve tried a few things and been over what seems most of the internet but I can’t quite get to the bottom of it, so what am I missing?
This seemed to be a similar situation: Oracle Link

After getting the abovementioned error I ran services.msc and started


Then In the command line checked the lsnrctl status

C:\Documents and Settings\Owner>lsnrctl status

LSNRCTL for 32-bit Windows: Version - Production on 17-MAR-2012 17:00

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

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version - Produ
Start Date                17-MAR-2012 13:28:22
Uptime                    0 days 3 hr. 32 min. 34 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\11.2.0\server\network\a
Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\kasutaja-e3f985\li
Listening Endpoints Summary...
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

As you can see the reference to port 8080 is missing, so I did ns lookup
(hostname doesn’ t match ...could that be a problem)

C:\Documents and Settings\Owner>nslookup kasutaja-e3f985
Server:  dsldevice.lan

Name:    kasutaja-e3f985.lan

C:\Documents and Settings\Owner>nslookup
Server:  dsldevice.lan

Name:    dsldevice.lan

I also logged into SQLplus as admin and tried connecting and got the following response

Enter password:
Connected to an idle instance.

SQL> select dbms_xdb.gethttport from dual;
select dbms_xdb.gethttport from dual
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

And below is also the host ping

C:\Documents and Settings\Owner>ping localhost

Pinging kasutaja-e3f985 [] with 32 bytes of data:

Reply from bytes=32 time<1ms TTL=128
Reply from bytes=32 time<1ms TTL=128
Reply from bytes=32 time<1ms TTL=128
Reply from bytes=32 time<1ms TTL=128

Ping statistics for
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

And when trying to start it this is what happened.

Enter password:
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\serv
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2917)
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros