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 /home/oracle/app/oracle/product/12.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. If you desire, refer to the How to Start, Stop, and Check the Status of the Oracle Database Listener section for more information regarding the Oracle Database listener that you configured here.