Forum Stats

  • 3,741,750 Users
  • 2,248,473 Discussions
  • 7,861,976 Comments

Discussions

Running XE on Port 80 on Linux

Dietmar Aust
Dietmar Aust Member Posts: 1,939 Bronze Badge
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
[[email protected] bin]# chown root tnslsnr
[[email protected] 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.

Comments

  • 22852
    22852 Member Posts: 9
    Seems to be the root issue with ports<1024
    Yup, as usual (on most unixes) regular users cant bind ports below 1024.
    /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bi
    n/tnslsnr: error while loading shared libraries:
    libclntsh.so.10.1: cannot open shared object file: No
    such file or directory
    You need to set the environment variables for root (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh) so libclntsh.so can be found.
  • 51082
    51082 Member Posts: 427
    You could you try to use the standard apache to reverse proxy to the web listener
  • Dietmar Aust
    Dietmar Aust Member Posts: 1,939 Bronze Badge
    Hi,

    thanks both for your input.

    I believe using the Apache http server is the best bet. I don't like the idea of running the Oracle listener as root at all anyway (although it would be necessary since it is needed to establish the connection to the embedded plsql gateway).

    Thanks,
    ~Dietmar.
This discussion has been closed.