Home  >  Article  >  Database  >  oracle port modification

oracle port modification

WBOY
WBOYOriginal
2023-05-11 11:47:361352browse

Oracle is a popular relational database management system that uses ports to communicate within a computer network. A port is an address that identifies an application and allows the server to communicate with other computers over the network. Oracle database uses port 1521 for communication by default. However, in some cases, you may need to change the port settings of your Oracle database. In this article, we will introduce how to modify the Oracle port.

  1. Stop the listener in the Oracle database

You need to stop the Oracle listener before modifying the Oracle port. Because if the listener is running, changing the port will not take effect. To stop the Oracle listener, open a command prompt and enter the following command:

lsnrctl stop

This command will stop the Oracle listener, enabling you to change the default port.

  1. Modify Oracle port settings

After stopping the listening program, you can modify the Oracle port settings. For this operation, you need to find the listener.ora file in your Oracle home directory. Please note that the location of the Oracle home directory depends on your operating system and Oracle version. Normally, it is located under the path $ORACLE_HOME/network/admin.

Open the listener.ora file and you will see the following:

SID_LIST_LISTENER =
(SID_LIST =

(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:ppOracleproduct    .2.0dbhome_1)
  (PROGRAM = extproc)
)

)

LISTENER =
(DESCRIPTION_LIST =

(DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)

)

In the above code, you need to change "PORT = 1521" to the port number you want to use. For example, if you want to change the port to 2048, the code should look like this:

SID_LIST_LISTENER =
(SID_LIST =

(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:ppOracleproduct    .2.0dbhome_1)
  (PROGRAM = extproc)
)

)

LISTENER =
(DESCRIPTION_LIST =

(DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2048))
  (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 2048))
)

)

After modifying the listener.ora file, please save and close the file.

  1. Restart the Oracle listener

After completing the above changes, you need to restart the Oracle listener. To do this, open a command prompt and enter the following command:

lsnrctl start

This command will start the Oracle listener and make your changes effective.

  1. Verify the modified Oracle port

To verify that the change to the Oracle port was successful, start SQL Plus using the following command:

sqlplus sys as sysdba

Then, please enter the following command to view the Oracle port:

select dbms_xdb.gethttpport from dual;

This command will display the port number being used by the database. Make sure it's updated with the port number you just changed.

Summary

When modifying the Oracle port settings, please stop the listening program first and modify the listener.ora file. Afterwards, restart the listener and verify that your changes were successful. Note that port changes may have an impact on your application, so be sure to consider this before modifying the port. If you are unsure about the impact of these changes, please consult Oracle Technical Support.

The above is the detailed content of oracle port modification. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:sql tutorial oracleNext article:sql tutorial oracle