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

Dynamic registration: after the instance is started, pmon automatically registers the service name with the listener every minute, or manually registers the alter system register; system. By default, there is a listener; that does not need a listener.ora file to start listening. The instance must be started under mount to start listening.

Practice: add dynamic registration of port 1522

Add listener.ora content as shown below

Add tnsnames.ora content as shown below

Alter system set local_listener='jw'

Start listening lsnrctl start niceman

Execute sqlplus / as sysdba

Alter system register

Static registration: listener.ora must be set for static registration, but the instance does not need to be started. After starting static listening, you can start the database remotely by static listening.

Practical static registration:

Clear the content that was previously registered dynamically

Alter system set local_listener=''

Set the static registration content as shown in the following figure. Note that this configuration is not overridden, otherwise an error will be reported. The author has been studying this problem for several hours before discovering this pit.

Start static registration listening, and if it is found that the status is UNKNOWN, it is static registration.

In this case, the instance is shutdown, but it does not affect the startup of static registration listening.

Demonstrate static registration of remote startup database

The static registration port demonstrated just now is 1523X Win7 computer client configuration.

Found that the database could be started successfully.

Note that tnsping can only test whether the tnsnames configuration is normal and whether the listening is smooth, but it is not necessarily possible to connect to the database through tnsping. If the database does not start the instance, tnspingtong cannot connect to the database.

Simple connection method:

Sqlplus user / password @ IP address: Port number / service name

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.