Current location - Quotes Website - Collection of slogans - How does oracle change the port number that listens to Linux servers?
How does oracle change the port number that listens to Linux servers?
Answer: 1. Stop the listener with the command lsnrctl stop.

2. After using the lsnrctl status command to confirm that the listener has stopped, find the file listener.ora under $ORACLE_HOME/network/admin.

3. Open this file with vi or other editors, and change the port number of the listener inside to the value you want, from 1522 to 152 1.

4. Save the modified file.

5. Start sqlplus and log in to the database with the system account sqlplussystem/yourpass @ localhost.

6. Execute the following command in sqlplus:

ALTER SYSTEM SET LOCAL _ LISTENER = "(ADDRESS =(PROTOCOL = TCP)(HOST = Oracle HOST)(PORT = 152 1))"; Change the system register; 7. Execute lsnrctl status to verify the listener status. If the listener is in normal state, the port number has been modified successfully, or it can be judged by netstat -an | grep 15.