cannot connect to oracle 10g xe database admin page
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! :confused: Please help! Thanks in advance, Sparrott :) |
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.. |
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. ...? |
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.. |
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 :) |
All times are GMT -5. The time now is 08:01 AM. |