oracle modify ip

Oracle database is a widely used relational database management system. In the process of using Oracle database, sometimes we need to modify the IP address of Oracle database. This article will introduce how to modify the IP address of the Oracle database.

Step 1: Back up the database

Modifying the database IP address is a risky operation, so before starting the operation, we need to back up the database. We can use the RMAN tool officially provided by Oracle for backup.

The command to use RMAN to back up the database is as follows:

rman target /
backup database;

Step 2: Modify the listener.ora file

Before modifying the IP address of the Oracle database, we need to first determine the database Which listener.ora file is used for listening? We can view the configuration information of the listener through the following command:

lsnrctl status

This command will output some basic information of the current listening. We can view the listener.ora file path, for example:

Listening Endpoints Summary (:
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.1)(PORT=1521)))
)

From the above In the output, we see that the location of the listener.ora file is in the $ORACLE_HOME/network/admin directory.

Next, we can find the listener.ora file in this directory and open it with a text editor. We can find configuration information similar to the following:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (SID_NAME = ORCL)
      (ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    )
  )

Among them, what we need to modify is the HOST (IP address) and PORT (port number) information corresponding to the TCP protocol, and change the original IP address to the new IP Just the address.

After the modification is completed, we need to restart the listening service. We can use the following command to restart the listening service:

lsnrctl stop
lsnrctl start

Step 3: Modify the tnsnames.ora file

In addition to modifying the listener.ora file, we also need to modify the tnsnames.ora file. The tnsnames.ora file saves the connection information of the Oracle database. We can use the following command to view the path of the tnsnames.ora file:

tnsping <database_name>

Among them, 6b7267f525327f2a23dcb01791a146aa is the name of the database we are currently using.

Next, find the tnsnames.ora file in the corresponding directory and open it with a text editor. We can find configuration information similar to the following:

orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Among them, what we need to modify is the HOST and PORT information, just change the original IP address to the new IP address.

After the modification is completed, we need to restart the Oracle service. We can use the following command to restart the Oracle service:

sqlplus / as sysdba
shutdown immediate;
startup;

Step 4: Test the connection

After completing the above steps, we need to test whether the connection is normal. We can use the following command to test the connection:

sqlplus scott/tiger@<database_name>

Among them, scott/tiger is the user name and password we need to connect to the database, 6b7267f525327f2a23dcb01791a146aa is the name of the database we are currently connected to.

If we can connect to the database normally, then our IP address modification will be successful.

Summary

Modifying the IP address of the Oracle database is a risky operation, so we need to back up the database before starting the operation. Before modifying the IP address, we need to determine the location of the listener.ora file and tnsnames.ora file, and use a text editor to open them for modification. After the modification is completed, we need to restart the Oracle service and listening service, and test whether the connection is normal.

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