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.

1. Change directories to the admin directory.

   [oracle@vm ~]$ cd /app/oracle/product/11.2.0/dbhome_1/network/admin/

2. 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

3. 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:

   export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1

4. To restart the listener and check its status, enter the following commands:

   /app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl stop
    /app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start
   /app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl status