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!

Running XE on Port 80 on Linux

Dietmar AustNov 1 2005 — edited Nov 2 2005

Hi,

what steps are necessary to run XE on port 80 on a Linux system?

exec dbms_xdb.sethttpport('80');
didn't work.

I have already tried to change the port using
exec dbms_xdb.sethttpport('8081');

and it worked immediately.
Seems to be the root issue with ports<1024

Have already tried the usual Apache stuff with the tnslsnr binary
[root@daust bin]# chown root tnslsnr
[root@daust bin]# chmod 6750 tnslsnr

But this only lead me to the following errors when restarting the listener:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
www:oraclexe[XE]> lsnrctl start

Is this possible?
How can I do it?

Thanks,
~Dietmar.

715399

Hi Brian,

Do you still get the exception if you remove the DISTINCT keyword or add the ORDER BY variable to the select list?

Cheers,
Vladimir

715399

Hi Brian,

I just noticed you were using Jena 2.0. You also might want to try using the latest version of the Jena Adaptor (works with Oracle 11.1.0.7 and 11.2)

Cheers,
Vladimir

1 - 2

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2005

Added on Nov 1 2005

3 comments

423 views

Oracle Database Express Edition (XE)

Running XE on Port 80 on Linux

Comments

Post Details