Oracle Listener Management

1 Enabling a set listener

The listener name is taken as "LDJ", configuring the listening address, listening service has two "orcl.com, Weina".

650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M02/72/DC/wKioL1Xu6cLB11dLAADFzacN-jQ580.jpg " Style= "Float:none;" title= "1.png" alt= "Wkiol1xu6clb11dlaadfzacn-jq580.jpg"/>

To view the listener status:

lsnrctl> status

Lsnrctl> Status LDJ

650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M00/72/E0/wKiom1Xu6PzRU_TkAAJ9a0i_fms704.jpg " Title= "2.png" alt= "Wkiom1xu6pzru_tkaaj9a0i_fms704.jpg"/>

Two executions of the command, with the same result. The displayed effect shows that the configured listener "LDJ" does not work at all. However, if the configured listener does not work, you can actually connect to two databases "orcl.com, Weina".

> Sqlplus system/[email protected]:1521/orcl.com > Sqlplus system/[email protected]_03:1521/orcl.com

Unable to connect Can actually connect

The reason is that the configured listener service is not turned on, and the deleted listener service is still working. Although the original configuration option was not found in the network manager. However, the listener will read the default values while working. All monitoring services are still running and provide a normal service.

Enable the newly configured listener, and then start the service in system services (manually started by default):

lsnrctl> Start LDJ

Lsnrctl> Stop LISTENER

650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M00/72/E0/wKiom1Xu6-3R3OzdAAEzF6VXdhM207.jpg " Title= "3.png" alt= "wkiom1xu6-3r3ozdaaezf6vxdhm207.jpg"/> make necessary changes ...

Check the listener status again and find that the newly configured listener "LDJ" is starting to work properly.

Lsnrctl> Status LDJ

Lsnrctl> Status LISTENER

> Sqlplus system/[email protected]:1521/orcl.com > Sqlplus system/[email protected]_03:1521/orcl.com

Connection OK The default connection mode is disabled

_______________________

2 Query Information

2.1 Listeners run as a service process and consume approximately 20M of memory

Lsnrctl> Show PID Ldj

Lsnrctl> Show PID

Cmd> tasklist | Findstr 1136

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/DD/wKioL1Xu82nBcJpmAABCEAOkZ40514.jpg "title=" 4.png " alt= "Wkiol1xu82nbcjpmaabceaokz40514.jpg"/>

Cmd> Tasklist/svc | Findstr Oracle

Cmd> tasklist | Findstr 1196

Cmd> tasklist | Findstr 1224

Cmd> tasklist | Findstr Oracle

Two database services, each occupying 1GB of memory.

2.2 See Oracle_home

Lsnrctl> Show Oracle Ldj

2.3 View Current Listener

Lsnrctl> Show Current_

The display is the basis for the top and bottom display

Lsnrctl> Set Current_ LDJ

2.4 Viewing log information

Lsnrctl> Show Log_file

Lsnrctl> Show Log_dir

Lsnrctl> Show Log_status

2.5 View server operating mode

Lsnrctl> Show Dis

2.6 See how to register a server

Lsnrctl> Show Dyna

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/72/DD/wKioL1Xu_Q_DTQFvAABm5lAGjro335.jpg "title=" Logo.jpg "alt=" Wkiol1xu_q_dtqfvaabm5lagjro335.jpg "/>

This article from "Little Cui's experimental notes" blog, declined to reprint!

Oracle Listener Management