Solved

Error connecting to Oracle Apex DB Home Page

Posted on 2012-03-17
2
954 Views
Last Modified: 2012-03-18
Hi Experts

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

could not connect to 127.0.0.1:8080

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

OracleServiceXE
OracleXEClrAgent
OracleXETNSListener


Then In the command line checked the lsnrctl status

C:\Documents and Settings\Owner>lsnrctl status

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

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

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 - Produ
ction
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
dmin\listener.ora
Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\kasutaja-e3f985\li
stener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kasutaja-e3f985)(PORT=1521)))
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

Open in new window


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
Address:  192.168.1.254

Name:    kasutaja-e3f985.lan
Address:  192.168.1.71

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

Name:    dsldevice.lan
Address:  127.0.0.1

Open in new window


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

Enter password:
Connected to an idle instance.

SQL>
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

Open in new window


And below is also the host ping

C:\Documents and Settings\Owner>ping localhost

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

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

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

Open in new window



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
er\dbs/spfileXE.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2917)

Open in new window

0
Comment
Question by:Daniel993
2 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
try reinstalling,  there's no good reason that you'd get the ORA-27046 error unless something happened during the XE install process.

Have you tried altering any settings?  If so, put them back or simply start over.
0
 

Author Comment

by:Daniel993
Comment Utility
well...this is a bit awkward :)
I did the reinstall and everything works, I also upgraded APEX from 4.0 to 4.1.1 and encountered no errors. Nevertheless this was my third reinstall but this time I did the uninstall, system restore, and ran CCleaner just to be safe also allowed Windows to run it's updates restarted the PC and then reinstalled...so I guess a little spring cleaning was in order:)

Thanks sdstuber
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now