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

1. First go to the $ORACLE_HOME/network/admin directory and modify listener.ora

Go to $ORACLE_HOME/network/admin, edit listener.ora

two。 Write static parameters, pay attention to write at the top of the first line, and do not write the following lines.

Write down static configuration

SID_LIST_LISTENER (here should be the same as the listener name, same as listener's name) =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = kingsql_static) (Service_name)

(ORACLE_HOME = / u01/app/oracle/product/11.2.4/dbhome_1)

(SID_NAME=VDEDU) (example)

))

3. Shut down the database

Shut down database

4. Monitor file reload

Reload listener file

Lsnrctl reload

5. If you look at lsnctl status at this time, you can only see static listening.

Now check lsnrctl status, has static listener only

Lsnrctl status

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.