Dynamic registration: After the instance is started, Pmon automatically registers the service name into the listener per minute, or it can register the alter system register manually; The system has a listener by default ; You do not need a Listener.ora file or you can start listening, and the instance must boot to mount to start listening.
Actual combat: Add 1522-Port dynamic registration
Add Listener.ora content such as
Add Tnsnames.ora content such as
Alter system set local_listener= ' JW ';
Start listening lsnrctl start Niceman
Execute Sqlplus/as SYSDBA
Alter SYSTEM Register
Static registration: Static registration must be set Listener.ora, but the instance does not need to start, after the start of static listening, you can listen to the remote startup database by static.
Actual Combat static Registration:
Empty the contents of the previously dynamically registered
Alter system set local_listener= ';
Set static register content such as, note, this configuration do not shelf write, otherwise will error, the author encountered this problem studied for several hours only to find this pit;
Initiates a static registration listen, if the discovery status is unknown, then it is static registration.
At this point the instance is shutdown, but does not affect the static registration listening boot
Demonstrates statically registering a remote startup database
The static registration port that you just demonstrated is the 1523;WIN7 computer client configuration
Discovery can successfully start the database.
Note that tnsping This tool can only test tnsnames configuration is normal, listening is smooth, but not necessarily tnsping can connect to the database, if the database does not start an instance, tnsping can not connect to the database.
Easy Connection Method:
Sqlplus User/Password @ip address: Port number/service name
Oracle dynamic registration and static registration