Oracle listener 的作用作用主要是提供Client 端與Database 的連線, 一旦Client 端與Database 建立好連線後, listener就不再介入Client 端和Database 的溝通.
1. Display Oracle Listener Status
透過 lsntctl status 指令可以知道 listener 目前的狀況
■ Listner Start Date and Time.
■ Uptime of listner - How long the listener has been up and running.
■ Listener Parameter File - Location of the listener.ora file. Typically located under $ORACLE_HOME/network/admin
■ Listener Log File - Location of the listener log file. i.e log.xml
listener 沒有執行時的訊息
$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:39 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory
listener 執行時的訊息
$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:02 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 29-APR-2009 18:43:13 Uptime 6 days 21 hr. 43 min. 49 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.1.0/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Services Summary... Service "devdb" has 1 instance(s). Instance "devdb", status UNKNOWN, has 1 handler(s) for this service... Service "devdb.thegeekstuff.com" has 1 instance(s). Instance "devdb", status READY, has 1 handler(s) for this service... Service "devdbXDB.thegeekstuff.com" has 1 instance(s). Instance "devdb", status READY, has 1 handler(s) for this service... Service "devdb_XPT.thegeekstuff.com" has 1 instance(s). Instance "devdb", status READY, has 1 handler(s) for this service... The command completed successfully
2. Start Oracle Listener
listener start 執行指令 lsnrctl start [listener-name]
$ lsnrctl start LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:42 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.1.0/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.1.0.6.0 - Production System parameter file is /u01/app/oracle/product/11.1.0/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 04-APR-2009 16:27:42 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.1.0/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Services Summary... Service "devdb" has 1 instance(s). Instance "devdb", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
3. Stop Oracle Listener
listener stop 執行指令 lsnrctl stop [listener-name]
$ lsnrctl stop LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:37 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))) The command completed successfully
4. Restart Oracle Listener
listener restart 指令 lsnrct reload , 這個指令只會重新載入listener.ora ,並不會真的重啟listener
$ lsnrctl reload LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 17:03:31 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))) The command completed successfully
Oracle Listener Help
1. View Available Listener Commands
■ start - Start the Oracle listener
■ stop - Stop the Oracle listener
■ status - Display the current status of the Oracle listener
■ services - Retrieve the listener services information
■ version - Display the oracle listener version information
■ reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
■ save_config - This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message "No changes to save for LISTENER"
■ trace - Enable the tracing at the listener level. The available options are 'trace OFF', 'trace USER', 'trace ADMIN' or 'trace SUPPORT'
■ spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
■ change_password - Set the new password to the oracle listener (or) change the existing listener password.
■ show - Display log files and other relevant listener information.
$ lsnrctl help LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:12:09 Copyright (c) 1991, 2007, Oracle. All rights reserved. The following operations are available An asterisk (*) denotes a modifier or extended command: start stop status services version reload save_config trace spawn change_password quit exit set* show*
2. Get More help on Specific Listener Command
$ lsnrctl help show LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:22:28 Copyright (c) 1991, 2007, Oracle. All rights reserved. The following operations are available after show An asterisk (*) denotes a modifier or extended command: rawmode displaymode rules trc_file trc_directory trc_level log_file log_directory log_status current_listener inbound_connect_timeout startup_waittime snmp_visible save_config_on_stop dynamic_registration
留言列表
學習筆記 (8)
