PreviousNextJavaScript must be enabled to correctly display this content
Change the Oracle Database Listener Configuration File
Edit the Listener to ensure the Oracle database software is
accessible remotely by BI Publisher, edit the listener.ora file.
Change directories
to the admin directory.
[oracle@vm ~]$ cd /app/oracle/product/11.2.0/dbhome_1/network/admin/
Change the value of
the HOST parameter from "localhost" to the hostname of your server.
[oracle@vm admin]$ sed -i s/localhost/`hostname`/ listener.ora
Use the export
ORACLE_HOME variable to restart the listener. Ensure that this variable
identifies (set to equal) the directory path on which you installed the Oracle
database software. For example: