Oracle學(xué)習(xí)筆記之第五節(jié)網(wǎng)絡(luò)介紹

《網(wǎng)絡(luò)部分介紹》

oracle數(shù)據(jù)庫服務(wù)器是客戶端

windows上

建兩個(gè)數(shù)據(jù)庫orcl用zhs16gpk和utforcl用al32utf8

服務(wù)oracleServiceORCL和oracleServiceutforcl開啟

cmd

oradim 幫助

lsnrctl service

1、配置監(jiān)聽

2、配置別名

3、配置連接時(shí)故障轉(zhuǎn)移

4、控制監(jiān)聽器

tnsping 測(cè)試網(wǎng)絡(luò)

linux客戶端或者服務(wù)器的網(wǎng)絡(luò)配置文件都在這個(gè)目錄

/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

如果換端口改這個(gè)配置文件

/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))

    )

  )

  然后復(fù)制到/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

crsctl start res ora.LISTENER.lsnr 重啟監(jiān)聽

lsnrctl services 查看監(jiān)聽

  SQL> show parameter local_lis 

  SQL> alter system set local_listener="FOR15210";

lsnrctl services 查看監(jiān)聽

  需要把這個(gè)文件拷貝到grid目錄下，這個(gè)目錄是dbca創(chuàng)建的默認(rèn)路徑，單用戶雙HOME

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

  進(jìn)行修改后在拷貝！

  FOR15210 =

  (DESCRIPTION =

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

)

lsnrctl services