linux 系統中oracle lsnrctl 及service啟動【轉】
		
          
		
          

          對于DBA來說，啟動和關閉oracle監聽器是很基礎的任務，但是Linux系統管理員或者程序員有時也需要在開發數據庫中做一些基本的DBA操作，因此了解一些基本的管理操作對他們來說很重要。
          

                本文將討論用LSNRCTL命令啟動、關閉和查看監聽器的狀態的方法。
          

          怎樣啟動、關閉和重新啟動oracle監聽器
          

          在啟動、關閉或者重啟oracle監聽器之前確保使用lsnrctl status命令檢查oracle監聽器的狀態。除了得到監聽器的狀態之外，你還可以從lsnrctl status命令的輸出中得到如下的信息：
          

          監聽器的啟動時間 
          監聽器的運行時間 
          監聽器參數文件listener.ora的位置，通常位于$ORACLE_HOME/network/admin目錄下 
          監聽器日志文件的位置 
          如果oracle監聽器沒用運行，你將得到如下的信息
          

           
          

          view plaincopy to clipboardprint?
          $ 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  
          

           
          

          

          如果oracle監聽器正在運行，你將得到如下信息
          

           
          

           
          

          view plaincopy to clipboardprint?
          $ 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.啟動oracle監聽器
          

          如果oracle監聽器沒用運行，你可以用lsnrctl start命令啟動oracle監聽器，該命令將啟動所有的監聽器，如果你只想啟動特定的監聽器，可以再start后面指定監聽器的名字，例如：lsnrctl start [listener-name]。
          

           
          

          view plaincopy to clipboardprint?
          $ 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  
          $ 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.關閉oracle監聽器
          

           
          

          如果oracle監聽器正在運行，可以使用lsnrctl stop命令關閉oracle監聽器，該命令將關閉所有的監聽器，如果你只想關閉特定的監聽器，可以再stop后面指定監聽器的名字，例如：lsnrctl stop [listener-name]
          

           
          

           
          

          view plaincopy to clipboardprint?
          $ 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.重啟oracle監聽器
          

          用lsnrctl reload重啟監聽器，此命令可以代替lsnrctl stop和lsnrctl start。重啟將會在不需要關閉和啟動監聽器的情況下讀取listener.ora的配置。
          

           
          

           
          

          view plaincopy to clipboardprint?
          $ 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監聽器幫助
          

          1.查看所有的監聽器命令
          

          lsnrctl hep命令可以顯示所有可用的監聽器命令。在oracle11g中其輸出如下：
          

          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.
          

           
          

           
          

          view plaincopy to clipboardprint?
          $ 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.得到指定監聽器命令的詳細幫助信息
          

          可以使用lsnrctl help得到指定的命令的詳細幫助信息。如下所示
          

           
          

          view plaincopy to clipboardprint?
          $ 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 
          

          

           
          

           
          

          本文來自CSDN博客，轉載請標明出處：http://blog.csdn.net/zjliu1984/archive/2009/06/16/4273304.aspx
          
		
          
			posted on 2011-12-21 16:46 DHC 閱讀(2563) 評論(0)  編輯  收藏  
		
          
	
          
	
	


	


          
	    
    




          





          


          

	
          
		
          
				
		
	
		
          
		
		
          只有注冊用戶登錄后才能發表評論。
          
		
          
			
		
          
			
		
          
		
		
          
		


          

		          		
		
          
		
          			
		
		
		
		
          
		
          
		
		
          
		
          
			網站導航:
		
		
          
		
          
			
		
          	
		
          
			 
		
          
		
          
			
		
          
		
          
			
				
		
          		
	
          	

          



          

				
				

			
          
			
          
				
					
          
	
          
		
          <2025年6月>
          
	
          日一二三四五六
          25262728293031
          1234567
          891011121314
          15161718192021
          22232425262728
          293012345
          

          

					

          導航
          

					

          統計
          
	
					

          公告
          
	
          THE TRUTH IS OUT THERE.
          
本博客純屬摘錄
          
若有雷同
          
實屬正常
          
只為記錄
          
不為其它
          
望原創作者見諒
          


					

          常用鏈接
          


          留言簿
          


		
          隨筆檔案
          
		
				
			
	
		
          文章分類
          
		
				
			
	
		
          文章檔案
          
		
				
			
	



          搜索
          



          最新評論
	
          

          
	

          


          閱讀排行榜
          



          評論排行榜
          


				
			
          
			
			
			
			
			 

	

    







          
        
	




主站蜘蛛池模板：
远安县|
当涂县|
巢湖市|
佛教|
井陉县|
增城市|
南京市|
龙胜|
红桥区|
河曲县|
深水埗区|
新泰市|
开化县|
开原市|
伊金霍洛旗|
金乡县|
安吉县|
朝阳市|
隆子县|
贵港市|
年辖：市辖区|
龙门县|
凤城市|
凤山市|
禹州市|
神池县|
南雄市|
彭阳县|
郎溪县|
沙坪坝区|
万全县|
余庆县|
云林县|
西乌珠穆沁旗|
福泉市|
剑川县|
鄯善县|
旬邑县|
剑阁县|
开江县|
贵州省|