1. Listener Overview:
Processes running on the database server are used to detect and accept the queried network. You can use listener to monitor the control and interact with the listener. the listener's job is to listen to the network, when a request is detected, the listener will take effect of the request, register the customer to the database, and then send the customer a server process. Once a connection listener is set up, it does not assume any role and is connected through TCP/IP. The default port is 1521. When multiple users connect, it is automatically allocated to multiple ports, avoid the load on port 1521.
2. Start the listener through the service and syntax.
Use the service: Start-run-service. msc to find the corresponding listener to start or stop.
Command Line Method:
Lsnrctl status -- view the status
Lsnrctl startlistener_name -- open
Lsnrctl stoplistener_name -- stop
3. Add a listener to the service and add it to the service through the syntax www.2cto.com
Add Configuration tool:
-- Start-Oracle directory-configuration and migration tool-Net Manager
It will not be refreshed in the service list immediately after it is added. You need to manually start it.
Lsnrctl start listener_name -- open
You can also add them manually. Find the location of the file, the following location:
Location of the listener Configuration File: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ ADMIN \ listener. ora
5. Add the tnsnames Service
Configure to add tnsname: Start-Oracle directory-configure and port tool-Net configurationAssistant
Maintenance Method (ADD, modify, rename, etc.)-Confirm Server Name-select protocol-select host name and port number-complete.
You can also add them manually. Find the location of the file, the following location:
Tnsnames configuration file location: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ ADMIN \ tnsnames. ora
6. Description:
As shown in the following figure: different access server names are replaced by one server. However, different listeners and port numbers. So that different listening programs and port numbers can be connected to the same server.
ORA = -- Name of the accessed Server
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = FREESKYC-DF543C) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb) -- Name of the replaced Server
)
)
TESTDB = -- Name of the accessed Server
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = FREESKYC-DF543C) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb) -- Name of the replaced Server
)
)
From the column zhang6622056