Opening port 80 in oracle 10g

Its a simple way to opening port 80 in oracle 10g.

#STEP 01
Log in as Oracle
Edit the Apache configuration file:
1. $ORACLE_HOME/Apache/Apache/httpd.conf
port 7777
Listen 7777
Listen 80  <- new line

2. Save and close the file.

#Step 02
Log in as root.
1. Run the following commands :
cd ORACLE_HOME/Apache/Apache/bin
chown root .apachectl
chmod 6750 .apachectl

2. Stop and start opmn :
# export DISPLAY=10.10.1.0.10:0.0
# opmnctl stopall
# opmnctl startall

Sometime, error message raised after executing command opmn startall if we following content in /opmn/log/Http_Server~1. It show You :

...execing httpd ld.so.1: httpd: fatal: libdms2.so: open failed...

So, what should we do now?
Don’t worry Vladimir M. Zakharychevhas already answered this problem :

This is due to the fact that setuid programs lose the current environment and execute with that of the owner. ld complains that it can’t find libdms2.so library – this is because root doesn’t have it in LD_LIBRARY_PATH. Additionally, at least on some platforms, LD_LIBRARY_PATH is simply ignored for setuid programs and default search path is used instead. One solution on Solaris (at least 8 and later) is to add necessary library paths to the global ld configuration file /var/ld/ld.config (or /var/ld/64/ld.config for 64- bit libraries) using crle utility, like this:

# crle -l /usr/lib -l [oracle library path] 

[oracle library path] is depend on file .so location it may $ORACLE_HOME/lib or $ORACLE_HOME/lib32

This will create or update /var/ld/ld.config file with new default library search path of /usr/lib:$ORACLE_HOME/lib (with $ORACLE_HOME expanded.) Note that normally crle -l overwrites the search path so it’s important to include original path in the command as well (/usr/ lib is the default search path when no /var/ld/ld.config exists.) crle without arguments will print current search path (crle -64 will print the path for 64-bit environment.) I am not sure libdms2.so is actually in $ORACLE_HOME/lib, so look for it in $ORACLE_HOME subdirectories and add the directory where it is to the default search path with crle (if you have it, that is.) If you don’t have crle, reading man pages on ld on your platform may give clues on how to configure its default search path. For example, on Linux the library search path is in /etc/ ld.so.conf.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s