Oracle学习笔记之第五节网络介绍

《网络部分介绍》

oracle数据库服务器是客户端

windows上

建两个数据库orcl用zhs16gpk和utforcl用al32utf8

服务oracleServiceORCL和oracleServiceutforcl开启

cmd

oradim 帮助

lsnrctl service

1、配置监听

2、配置别名

3、配置连接时故障转移

4、控制监听器

tnsping 测试网络

linux客户端或者服务器的网络配置文件都在这个目录

/u01/app/oracle/product/11.2.0/grid/network/admin

crs_stat -p | grep lsnr

NAME=ora.LISTENER.lsnr

crsctl stop res ora.LISTENER.lsnr

如果换端口改这个配置文件

/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15210))

    )

  )

  然后复制到/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

crsctl start res ora.LISTENER.lsnr 重启监听

lsnrctl services 查看监听

  SQL> show parameter local_lis 

  SQL> alter system set local_listener="FOR15210";

lsnrctl services 查看监听

  需要把这个文件拷贝到grid目录下，这个目录是dbca创建的默认路径，单用户双HOME

  /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

  进行修改后在拷贝！

  FOR15210 =

  (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15210))

)

lsnrctl services