1. Installation Guide for Oracle Fusion Middleware 19c
  2. Install the Oracle Database Software
  3. Change the Oracle Database Listener Configuration File

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/19.3.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 theHow to Start, Stop, and Check the Status of the Oracle Database Listeners section for more information regarding the Oracle Database listener that you configured here.