Problems getting Oracle 10xe HTTP server to work

Installation and support for Oracle DB on CentOS.
emersonr
Posts: 5
Joined: 2007/07/29 00:37:47

Problems getting Oracle 10xe HTTP server to work

Post by emersonr » 2007/07/29 01:15:54

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.

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/07/30 14:01:47

You probably know that CeonOS 5 is not supported by Oracle XE.

My expierence is that it installs, and webpage could be accessed, but I did not play further. I use it on CentOS 4.5 without problems.

Maybe you could search on Oracle XE forums (hosted on oracle site).

Do you have all services running?

MAybe you could disable selinux and install again....

emersonr
Posts: 5
Joined: 2007/07/29 00:37:47

Re: Problems getting Oracle 10xe HTTP server to work

Post by emersonr » 2007/07/30 14:36:51

Thanks for the info...

I know that Centos is not supported for Oracle 10 XE. I thought that, once it's based on RHEL, it'd work in a snap... I was wrong :)

SELinux is already disabled...

I have a Centos 4.4 set of disks on me... If it worked on your 4.5 box, it'll probably work on a 4.4.
How far apart is version 4.4 to 5.0? Is it *very* out of date?

Another option is to install mod_plsql on my apache server. Some people say it is advisible anyway.
I have no idea how to do it though... I've looked for some docs without success...

Does anyone know how to do it ??

Thanks
Emerson

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Re: Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/07/30 16:53:55

[quote]
emersonr wrote:
Thanks for the info...

I know that Centos is not supported for Oracle 10 XE. I thought that, once it's based on RHEL, it'd work in a snap... I was wrong :)
[/quote]
http://www.oracle.com/technology/products/database/xe/index.html

is your main source of information

RHEL 4.x(CEntOS 4.x) 32-bit are supported
[quote]

SELinux is already disabled...

I have a Centos 4.4 set of disks on me... If it worked on your 4.5 box, it'll probably work on a 4.4.
How far apart is version 4.4 to 5.0? Is it *very* out of date?
[/quote]
Define out of date ?!

4.x is based on older kernel, but still supported (actually even 3.x is supported)
[quote]

Another option is to install mod_plsql on my apache server. Some people say it is advisible anyway.
I have no idea how to do it though... I've looked for some docs without success...
[/quote]
If you use php you need to install zend core
[quote]

Does anyone know how to do it ??

Thanks
Emerson[/quote]

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Re: Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/07/30 19:28:15

I can confirm that it is working on centos 5

nothing tricky default installation....

Remove your current installation and reinstall

emersonr
Posts: 5
Joined: 2007/07/29 00:37:47

Re: Problems getting Oracle 10xe HTTP server to work

Post by emersonr » 2007/07/30 20:40:05

Just did it... no luck...
Database goes up fine. http://localhost:8080/apex fail...

Which instalation option did you use? Server? Server GUI? Workstation?

Emerson

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Re: Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/07/31 15:03:31

I used minimal installation and added developpment tools and sytem administration tools.

Edit: RHEL 5 is now certified for Oracle 10gR2
check my blog I've posted there some of the steps.

[url=http://blog.hbcom.info/archives/48]Installing Oracle XE on CentOS 5[/url]

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Re: Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/07/31 17:00:30

Here is the list of groups installed:
[code]
Installed Groups:
Development Libraries
System Tools
Dialup Networking Support
Network Servers
Mail Server
Server Configuration Tools
Administration Tools
Available Groups:
.........
[/code]

Edit:

Maybe some of them are not needed....?

emersonr
Posts: 5
Joined: 2007/07/29 00:37:47

Re: Problems getting Oracle 10xe HTTP server to work

Post by emersonr » 2007/08/01 13:47:45

Ok.. I get it... man.. it was hard...

Here is the deal:

The whole problem was about hostname. Oracle 10g XE somehow doesnt like full qualified hostnames.
The name of my machine was server01.berrd.org. Everything else on this machine (the other apache server, subversion server, etc...) understands that server01.beerd.org is IN the lan. Oracle 10g XE goes out to the internet to look for this machine. Obviously, doesn't find it...

I just alter the hostname to server01 (without .berrd.org) and voila...

Thanks everybody for the time spent.

Emerson

foxb
Posts: 1924
Joined: 2006/04/20 19:03:33
Location: Montreal/QC

Re: Problems getting Oracle 10xe HTTP server to work

Post by foxb » 2007/08/01 14:23:18

You do not have DNS entry for this machine...that's why.

If you do not have DNS server enter it in hosts file.

Post Reply

Return to “CentOS 4 - Oracle Installation and Support”