linux 系統(tǒng)中oracle lsnrctl 及service啟動(dòng)【轉(zhuǎn)】
		
          
		
          

          對(duì)于DBA來(lái)說(shuō)，啟動(dòng)和關(guān)閉oracle監(jiān)聽(tīng)器是很基礎(chǔ)的任務(wù)，但是Linux系統(tǒng)管理員或者程序員有時(shí)也需要在開(kāi)發(fā)數(shù)據(jù)庫(kù)中做一些基本的DBA操作，因此了解一些基本的管理操作對(duì)他們來(lái)說(shuō)很重要。
          

                本文將討論用LSNRCTL命令啟動(dòng)、關(guān)閉和查看監(jiān)聽(tīng)器的狀態(tài)的方法。
          

          怎樣啟動(dòng)、關(guān)閉和重新啟動(dòng)oracle監(jiān)聽(tīng)器
          

          在啟動(dòng)、關(guān)閉或者重啟oracle監(jiān)聽(tīng)器之前確保使用lsnrctl status命令檢查oracle監(jiān)聽(tīng)器的狀態(tài)。除了得到監(jiān)聽(tīng)器的狀態(tài)之外，你還可以從lsnrctl status命令的輸出中得到如下的信息：
          

          監(jiān)聽(tīng)器的啟動(dòng)時(shí)間 
          監(jiān)聽(tīng)器的運(yùn)行時(shí)間 
          監(jiān)聽(tīng)器參數(shù)文件listener.ora的位置，通常位于$ORACLE_HOME/network/admin目錄下 
          監(jiān)聽(tīng)器日志文件的位置 
          如果oracle監(jiān)聽(tīng)器沒(méi)用運(yùn)行，你將得到如下的信息
          

           
          

          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監(jiān)聽(tīng)器正在運(yùn)行，你將得到如下信息
          

           
          

           
          

          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.啟動(dòng)oracle監(jiān)聽(tīng)器
          

          如果oracle監(jiān)聽(tīng)器沒(méi)用運(yùn)行，你可以用lsnrctl start命令啟動(dòng)oracle監(jiān)聽(tīng)器，該命令將啟動(dòng)所有的監(jiān)聽(tīng)器，如果你只想啟動(dòng)特定的監(jiān)聽(tīng)器，可以再start后面指定監(jiān)聽(tīng)器的名字，例如：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.關(guān)閉oracle監(jiān)聽(tīng)器
          

           
          

          如果oracle監(jiān)聽(tīng)器正在運(yùn)行，可以使用lsnrctl stop命令關(guān)閉oracle監(jiān)聽(tīng)器，該命令將關(guān)閉所有的監(jiān)聽(tīng)器，如果你只想關(guān)閉特定的監(jiān)聽(tīng)器，可以再stop后面指定監(jiān)聽(tīng)器的名字，例如：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監(jiān)聽(tīng)器
          

          用lsnrctl reload重啟監(jiān)聽(tīng)器，此命令可以代替lsnrctl stop和lsnrctl start。重啟將會(huì)在不需要關(guān)閉和啟動(dòng)監(jiān)聽(tīng)器的情況下讀取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監(jiān)聽(tīng)器幫助
          

          1.查看所有的監(jiān)聽(tīng)器命令
          

          lsnrctl hep命令可以顯示所有可用的監(jiān)聽(tīng)器命令。在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.得到指定監(jiān)聽(tīng)器命令的詳細(xì)幫助信息
          

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

           
          

          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 
          

          

           
          

           
          

          本文來(lái)自CSDN博客，轉(zhuǎn)載請(qǐng)標(biāo)明出處：http://blog.csdn.net/zjliu1984/archive/2009/06/16/4273304.aspx
          
		
          
			posted on 2011-12-21 16:46 DHC 閱讀(2562) 評(píng)論(0)  編輯  收藏  
		
          
	
          
	
	


	


          
	    
    




          





          


          

	
          
		
          
				
		
	
		
          
		
		
          只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。
          
		
          
			
		
          
			
		
          
		
		
          
		


          

		          		
		
          
		
          			
		
		
		
		
          
		
          
		
		
          
		
          
			網(wǎng)站導(dǎo)航:
		
		
          
		
          
			
		
          	
		
          
			 
		
          
		
          
			
		
          
		
          
			
				
		
          		
	
          	

          



          

				
				

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

          

					

          導(dǎo)航
          

					

          統(tǒng)計(jì)
          
	
					

          公告
          
	
          THE TRUTH IS OUT THERE.
          
本博客純屬摘錄
          
若有雷同
          
實(shí)屬正常
          
只為記錄
          
不為其它
          
望原創(chuàng)作者見(jiàn)諒
          


					

          常用鏈接
          


          留言簿
          


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



          搜索
          



          最新評(píng)論
	
          

          
	

          


          閱讀排行榜
          



          評(píng)論排行榜
          


				
			
          
			
			
			
			
			 

	

    







          
        
	




主站蜘蛛池模板：
菏泽市|
那曲县|
光山县|
黄山市|
十堰市|
荔浦县|
会昌县|
沙河市|
富川|
资溪县|
阿拉善右旗|
沿河|
金山区|
东平县|
华宁县|
德保县|
雅安市|
治多县|
桦川县|
武鸣县|
阿图什市|
读书|
台安县|
沿河|
合作市|
阿克陶县|
江油市|
九龙坡区|
双柏县|
金溪县|
台东市|
合山市|
哈巴河县|
邵东县|
昌图县|
铁力市|
桐梓县|
柳林县|
延安市|
车险|
贵溪市|