Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.