Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

* emersonr Problems getting 10g XE HTTP server to work

590409Jul 30 2007 — edited Aug 1 2007
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2007
Added on Jul 30 2007
1 comment
271 views