Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error connecting to Oracle Apex DB Home Page

Posted on 2012-03-17
2
Medium Priority
?
1,010 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 37732918
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
ID: 37734312
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

722 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