*
emersonr
Problems getting 10g XE HTTP server to work
590409Jul 30 2007 — edited Aug 1 2007Hi,
I have installed Oracle 10.2 xe on a Centos 5 box. The database seems to go up fine, but the http server doesnt wanna play... meaning, when I access http://localhost:8080/apex, it gives me an HTTP 404 (file not found) error.
I just installed Centos and firewall/SELinux are disabled.
The Oracle log file (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/log/server1/client/css.log) show this error:
[ OCRUTL][3086456512]u_set_comp_error: Parameter was NULL
[ OCRUTL][3086456512]u_set_ocr_error: Parameter was NULL
2007-07-28 21:20:39.387: [ OCROSD][3086456512]utgdv:2:ocr loc file cannot be opened
2007-07-28 21:20:39.387: [ OCROSD][3086456512]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3086456512]u_set_gbl_comp_error: Parameter was NULL
2007-07-28 21:20:39.387: [ OCRRAW][3086456512]proprinit: Could not open raw device
2007-07-28 21:20:39.388: [ default][3086456512]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3086456512]u_set_ocr_error: Parameter was NULL
2007-07-28 21:20:39.388: [ CSSCLNT][3086456512]clsssinit: error(33 ) in OCR initialization
I've tried several different ports but got no lucky.
I changed ports using the following sql code (in SqlPlus as system):
SQL> begin
2 dbms_xdb.sethttpport('8081');
3 dbms_xdb.setftpport('0');
4 end;
5 /
and got this error:
*
ERROR at line 1:
ORA-31112: fail to unregister for HTTP port using xdb configuration
ORA-06512: at "XDB.DBMS_XDB", line 382
ORA-06512: at "XDB.DBMS_XDB", line 521
ORA-06512: at line 1
About this error, Oracle says:
ORA-31112: fail to string for string port using xdb configuration
Cause: port number for the defined presentation is not valid
Action: Either the port number is already in use or it is protected. Specify another port number.
I even wrote a Pl/Sql script trying every port ranging from 80 to 65000... None of them worked :(
Then, I had a look at netstat:
[root@server1 tmp]# netstat -a | grep oracle
unix 2 [ ACC ] STREAM LISTENING 10404 /var/tmp/.oracle/sEXTPROC_FOR_XE
unix 2 [ ACC ] STREAM LISTENING 10406 /var/tmp/.oracle/s#3103.1
unix 2 [ ACC ] STREAM LISTENING 10409 /var/tmp/.oracle/s#3103.2
The http port is not there...
Googling around didn't help.. All I found was a couple people facing the same problem...
I tried changing this kernel parameter:
File: /etc/sysctl.conf
net.ipv4.ip_local_port_range = 1024 65000
and then sysctl -p to make it effective.
No lucky again...
I'm out of guesses.... Any idea??
Thanks in advance.