Linux-Oracle-Configuration-Listener

Linux-Oracle-Configuration-Listener

查询命令

Listener_Path: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/

1.	//查询全局数据库名称  
2.	select name from v$database;  
3.	//查询实例名称  
4.	select instance_name from v$instance;  
5.	//输出路径及实例名  
6.	[oracle@210 ~]$ echo $ORACLE_HOME  
7.	/u01/app/oracle/product/11.2.0/dbhome_1  
8.	[oracle@210 ~]$ echo $ORACLE_SID  
9.	orcl  

监听常用命令

1.	[oracle@210 ~]$ lsnrctl start  --启动监听
2.	LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-AUG-2018 20:02:12  
3.	Copyright (c) 1991, 2013, Oracle.  All rights reserved.  
4.	Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
5.	TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
6.	System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora  
7.	Log messages written to /u01/app/oracle/diag/tnslsnr/210/listener/alert/log.xml  
8.	Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1522)))  
9.	Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))  
10.	Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))  
11.	STATUS of the LISTENER  
12.	------------------------  
13.	Alias                     LISTENER  
14.	Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
15.	Start Date                22-AUG-2018 20:02:12  
16.	Uptime                    0 days 0 hr. 0 min. 0 sec  
17.	Trace Level               off  
18.	Security                  ON: Local OS Authentication  
19.	SNMP                      OFF  
20.	Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora  
21.	Listener Log File         /u01/app/oracle/diag/tnslsnr/210/listener/alert/log.xml  
22.	Listening Endpoints Summary...  
23.	  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1522)))  
24.	  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))  
25.	The listener supports no services  
26.	The command completed successfully  
27.	  
28.	[oracle@210 ~]$ lsnrctl status  --查看监听状态
29.	LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-AUG-2018 20:07:11  
30.	Copyright (c) 1991, 2013, Oracle.  All rights reserved.  
31.	Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))  
32.	STATUS of the LISTENER  
33.	------------------------  
34.	Alias                     LISTENER  
35.	Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
36.	Start Date                22-AUG-2018 20:02:12  
37.	Uptime                    0 days 0 hr. 4 min. 58 sec  
38.	Trace Level               off  
39.	Security                  ON: Local OS Authentication  
40.	SNMP                      OFF  
41.	Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora  
42.	Listener Log File         /u01/app/oracle/diag/tnslsnr/210/listener/alert/log.xml  
43.	Listening Endpoints Summary...  
44.	  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1522)))  
45.	  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))  
46.	The listener supports no services  
47.	The command completed successfully  
48.	[oracle@210 ~]$ lsnrctl stop  --停止监听
49.	LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-AUG-2018 20:07:16  
50.	Copyright (c) 1991, 2013, Oracle.  All rights reserved.  
51.	Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))  
52.	The command completed successfully  

动态监听netca命令

1.	[oracle@210 ~]$ netca  --启动图形化监听配置界面
2.	Oracle Net Services Configuration:  
3.	Stopping Oracle Net Listener:  
4.	    Running Listener Control:   
5.	      /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl stop LISTENER  
6.	    Listener Control complete.  
7.	    Listener stop failed.  
8.	    Deleted listener: LISTENER  
9.	Oracle Net Services configuration terminated by user.  The exit code is -1 

静态监听

listener.ora监听配置文件（*）

1.	# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora  
2.	# Generated by Oracle configuration tools.  
3.	  
4.	LISTENER =  
5.	  (DESCRIPTION_LIST =  
6.	    (DESCRIPTION =  
7.	      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.100.210)(PORT = 1521))  
8.	      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  
9.	    )  
10.	  )  
11.	SID_LIST_LISTENER =  
12.	  (SID_LIST =  
13.	    (SID_DESC =  
14.	      (SID_NAME = orcl)  
15.	      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)  
16.	      (PROGRAM = extproc)  
17.	    )  
18.	    (SID_DESC =  
19.	      (SID_NAME = orcl)  
20.	      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)  
21.	      (GLOBAL_DBNAME=ORCL)  
22.	    )  
23.	  )  

###备注：
**LISTENER ：**监听名，可以修改
GLOBAL_DBNAME 标识全局数据库名称。本项应该与当前Oracle服务的init.ora文件中的SERVICE_NAMES项一致
ORACLE_HOME 给出服务器上Oracle可执行程序的位置
SID_NAME 含有用于本Oracle实例的Oracle SID的名称
SID_DESC 描述每个Oracel SID

tnsnames.ora网络配置（可选）

1.	# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora  
2.	# Generated by Oracle configuration tools.  
3.	ORCL =  
4.	  (DESCRIPTION =  
5.	    (ADDRESS_LIST =  
6.	      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.100.210)(PORT = 1521))  
7.	    )  
8.	    (CONNECT_DATA =  
9.	      (SERVICE_NAME = ORCL)  
10.	    )  
11.	  )  

###备注：
远程主机连接数据库时，先通过sqlnet验证，sqlnet赋予验证的网络方式后，按顺序验证到tnsnames.ora。

sqlnet.ora限制客户端的访问（可选）

1.	// nts用于Windows NT本机身份验证
2.	SQLNET.AUTHENTICATION_SERVICES=(nts)  --linux可以屏蔽掉这句话  
3.	NAMES.DIRECTORY_PATH=(tnsnames, onames,ezconnect)