Oracle dynamic registration and static registration listeners
The difference between oracle dynamic registration and static registration: dynamic monitoring does not need to record any information about the data in the listener.ora file, just write the listener's configuration information to the file. For example:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS= (PROTOCOL = IPC) (KEY=EXTPRO1)
(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
)
The tnsnames.ora configuration information of the client needs to be added to each service_name, and nothing else needs to be changed, such as
YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)
Dynamic monitoring steps:
The server-side configuration is as follows:
Set up the service_names:
Alter system set service_names=test1,test2,test3
two。 Write a listener.ora file:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS= (PROTOCOL = IPC) (KEY=EXTPRO1)
(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
)
3. Restart the oracle instance for service_names to take effect. (only if oracle is in open state)
Conn / as sysdba
Shutdown immediate
Startup
Client configuration:
1. Edit tnsnames.ora, effective immediately after saving.
YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)
The above dynamic registration configuration is complete. The above is changed to the static registration step.
You only need to modify listener.ora on the server side
