redhat系统oracle11安装部署（3）

配置监听重读

在CRT中切换到oracle用户
配置

listen  (/u01/app/oracle/product/11.2.0/db/network/admin/listener.ora)

填写自己的IP
注意：根据每个人的路径不同，配置文件所在位置也不同

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  	(SID_LIST =
    	(SID_DESC =
     	 (GLOBAL_DBNAME = orcl)
      	(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
     	 (SID_NAME = orcl)
   		)
 	 )
LISTENER =
    (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.114)(PORT = 1521))
      )
    )

配置服务器名

在CRT中切换到oracle用户 配置 ``` listen (/u01/app/oracle/product/11.2.0/db/network/admin/tnsname.ora) ``` 填写自己的IP

注意：根据每个人的路径不同，配置文件所在位置也不同

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.114)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

起监听

关闭防火墙

service iptables stop

切换到oracle用户

su - oracle

重新启动监听

lsnrctl reload

查看远程lisitener是否启动

tnsping orcl

查看链接状态

lsnrctl status

连接数据库