SOA 11g/12c: How to change the Listener port in SOA 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/<domain_name>/config/jdbc) location. Take a backup and Change all datasoure connection pool port (Only SOA RCU schemas) in JDBC directiory.

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

Step 8: Start all the services.