cannot connect to oracle 10g xe database admin page

sparrott · 03-19-2006, 01:40 PM

Hi,

I'm very new to Linux so please be gentle!

I've installed Oracle 10g express edition on my pc running redhat 9. The first thing it says to do is to use the 'Go to database homepage' link.

When I do that it loads Mozilla with the following address: 127.0.0.1:%httpport%/apex
and I get 'The connection was refused when attempting to contact 127.0.0.1'.

It seems wierd to me that the pc isn't allowed to contact itself!

Please help!

Thanks in advance,
Sparrott

peter_robb · 03-19-2006, 02:17 PM

The next thing you need to do is make sure it's listening..
do netstat -tlnp and look for it..
Also check which port it's using, then use that in your url..

sparrott · 03-19-2006, 02:47 PM

It gives me 4 ports that that ip is listening on. I've tried them all.
One gives: SPAMD/1.0 76 Bad header line: GET /apex HTTP/1.1
One gives: The document contains no data.
One gives: Not Found The requested resource was not found on this server.
and the other one gives: Access to the port number given has been disabled for security reasons.

...?

peter_robb · 03-19-2006, 03:35 PM

The very right hand column of the netstat -tlnp output will give the PID & name of the running programme..
It should match the PID and name from the output of ps ax

Make sure oracle is actually listening on 127.0.0.1..

sparrott · 03-20-2006, 02:46 PM

Oracle isn't listening coz the lsitener won't start. When I try /etc/init.d/oracle-xe start I get:

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.
Failed to start Oracle Net Listener using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr and Oracle Express
Database using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus.

The files are definitely there... any ideas?
Cheers