OBIEE 12c: How to change the Listener port in OBIEE RCU Schemas from 1522 to 1521:

Solution:

Steps to change the database listener port:

DB Part:

Step 1: Stop the listener.

Step 2: Change the port value in tnsnames.ora file

Step 3: Change the local_listener parameter in db and ASM.

Step 4: Start the listener.

Application Part:

Step 5: Stop all the services.

Step 6: Navigate to (<MW_HOME>/user_projects/domains/bi/config/jdbc) location. Take a backup and Change all datasoure connection pool port (Only OBIEE RCU schemas) in JDBC directiory.

Step 7: Navigate to (<MW_HOME>/user_projects/domains/bi/config/fmwconfig) location. Take the backup and Change the connection pool port in jps-config.xml and jps-config-jse.xml files.

Step 8: Navigate to (<MW_HOME>/user_projects/domains/bi/bidata/components/core/serviceinstances/ssi/oracl edb) location. Take a backup and Change the connection pool port in tnsnames.ora file.

Step 9: Navigate to (<MW_HOME>/user_projects/domains/bi/config/fmwconfig/bienv/core) location. Take a backup and change the connection pool port in odbc.ini and datasource.properties files.

Step 10: Open the current RPD file using Admin tool and Update the connection pool port number in the Oracle Data Warehouse and Usage Tracking Pool.

Step 11: Save the file.

Step 12: Start all the services.

Step 13: Upload the updated RPD file. <MW_HOME>/user_projects/domains/bi/bitools/bin/datamodel.sh uploadrpd -Iobiee_patch.rpd -SI ssi -U weblogic

Step 14: Stop the bi_service (./stop.sh -i bi_server1)

Step 15: Start the bi_service. (./start.sh -i bi_server1)