After installation of SAP system or in support phase, the requirement comes to change the oracle listener port number or even some time it is needed to rename the LISTENER to LISTENER_SID or something.
LETS FIRST SEE HOW TO CHANGE LISTENER PORT.
To change the port you need to modify 3 files. two tnsnames.ora and one listener.ora file.
The location of tnsnames.ora will be at below two locations
- /sapmnt/<SID>/profile/oracle/tnsnames.ora
- $ORACLE_HOME/network/admin/tnsnames.ora
3. $ORACLE_HOME/network/admin/listener.ora
- Stop sap application
- Stop listener
- No need to stop your database.
Now you can change the port numbers in the 3 files mentioned above, The port number is marked with red line can be changed with another number which is permissible as per your scenario.
Now you can start the listener, and your database is running then you can check connectivity from your application server by
R3trans -d it should work now.
You can also do the telnet from Database server or application server to the new port, it should connect.
telnet <DB hostname> <listener port>
No comments:
Post a Comment