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

Static registration

Change port 1521 in listener.ora and tnsnames.ora to 1421. It's very simple.

Dynamic registration

2.1 change the port in the listener.ora file to 1421

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS= (PROTOCOL = IPC) (KEY=EXTPRO1)

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1421))

)

)

2.3 add the following to the server-side tnsnames.ora because PMON cannot find the listener. we

You can add specific information to the server's TNSNAMES.ORA to tell PMON where the listener is.

Note that the information is not added to the TNSNAME.ORA of the client, but to the TNSNAMES.ORA of the server. Because of

This message is for PMON to see, that is, for the server to see. Not for the client program to see.

LISTEN1421 =

(DESCRIPTION =

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1421))

)

2.4 modify system parameters:

Alter system set local_listener=listen1421

2.5 restart the listener

Lsnrctl stop

Lsnrctl start

Configuration complete.

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.