ITPub博客

首页 > 数据库 > Oracle > oracle 添加多个scan ip方式以及问题处理

oracle 添加多个scan ip方式以及问题处理

原创 Oracle 作者:wanglinghua0907 时间:2024-05-28 18:10:00 0 删除 编辑

如果发现解析有问题,只认第一个 scan ip

默认是 multi on 的(可多个 scan ip ),如果 off 的话会导致该问题

d  0.20.43.22  g.com gjys-scan.zrtg.com gj  gjys-scan.zrtg.com gj  [oracle@gjysdbadm02 cat /etc/host.conf  MODIFY  #### BEGIN Generated b  # Lookup names in /etc/hosts then DNS.  order hosts ,bind  # Return only the first match from /etc/hosts and not alt the addres  on  #-Try-i prevent spoofing by look up of both name and address and che  f warn  Look up name and address to ensure they match each other to prevent  *wspoof on  Warn if there is spoof attempt for rsh and rlogin  #spoofalert on  El # DO not order the addresses from gethostbyname to have locat addresses  reorder off  #### Eto Generated by Exadata ####  [oracleegjysdbadmØ2

 

1. 修改 hosts

[ rootßnodel  more fetc/hosts  127.0 e  localhost localhost . localdomain localhost4 localhost4. localdomain4  localhost localhost . localdomain localhost6 localhost6 . localdomain6  192.168.83.191  192.168.83.192  192.168 .83. 193  192.168.83.194  1B.1a.11.191  1€.10.11.192  192.168.83.190  #add scan  192.168.83.189  192.168 .83. 188  node 1  node2  nodel -vip  node2-vip  nodel -priv  node2-priv  node-scan  node-scan  node-scan

 

2. 确认 sacn 信息

srvctl config scan

srvctl status scan

srvctl status scan_listener

 

[gridßnodel —IS srvctl config scan  SCAN name: node-scan, Network  . 1/192.168.83.a/255.255.255.uetha  SCAN VIP name: scanl, IP:  [gridßnodel srvctl status scan  SCAN VIP scanl is enabled  SCAN VIP scanl is running on node node2  [grid@nodel srvctl status scan_listener  SCAN Listener LISTENER_SCANI is enabled  SCAN listener LISTENER_SCANI is running on node node2

 

3. 关闭 scan 监听、 scan 服务

srvctl stop scan_listener

srvctl stop scan

 

[gridßnodel —IS srvctl stop scan_listener  [gridßnodel srvctl stop scan

 

4. 修改 scan 配置

找 srvctl 位置

which srvctl

 

[gridßnodel —IS which srvctl  'oracle/ grid/crs_l /bin/srvctl

 

root 执行( node-scan 是 scan 的别名)

/oracle/grid/crs_1/bin/srvctl modify scan -n node-scan

 

5. 更新 scan 监听

root 跑

/oracle/grid/crs_1/bin/srvctl modify scan_listener -u

 

6. 起 scan 监听、 scan 服务

srvctl start scan

srvctl start scan_listener

(grid@nodel —IS srvctl start scan  —IS srvctl start scan_listener  [grid@nodel

 

7. 查看 scan 信息

srvctl config scan

[gridOnode1  —IS srvctl config scan  SCAN  SCAN  SCAN  SCAN  name: node-scan,  VIP name:  VIP name:  VIP name:  scanl ,  scan2,  scan3,  Network: 1/192.168.83.e/255.255.255.e/ethe  168.83. 190  168.83. 189  168.83. 188  IP:  IP:  IP:  / node-scan/ 192.  / node-scan/ 192.  / node-scan/ 192.

 

8. 确认集群信息

有了 3 个 scan 监听和 scan 服务(两个 1 节点上,一个 2 节点上)

 

Cluster Resources  ora . LISTENER_SCANI . Isnr  ONLINE ONLINE  ora . LISTENER_SCAN2. Isnr  ONLINE ONLINE  ora . LISTENER_SCAN3. Isnr  OFFLINE OFFLINE  OFFLINE OFFLINE  ora .b1j . XI .SVC  OFFLINE OFFLINE  OFFLINE OFFLINE  OFFLINE OFFLINE  2  ora . cvu  ora . mm. db  2  ora . nodel . vip  ora . node2. vip  ora . oc4j  ora . orc1. db  ora . scanl . vip  ora . scan2. vip  ora . scan3. vip  ora . xx  2  ONL INE  ONLINE  ONLINE  ONL INE  ONLINE  ONLINE  ONLINE  ONLINE  ONLINE  ONL INE  ONL INE  ONL INE  ONLINE  ONLINE  OFFLINE  OFFLINE  ONLINE  ONLINE  ONLINE  ONLINE  ONLINE  ONLINE  ONLINE  ONLINE  nodel  node2  nodel  node2  nodel  node2  node2  nodel  node2  nodel  nodel  node2  Instance Shutdown  Instance Shutdown  Open  Open

 

 


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69980685/viewspace-3016990/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle ACE、sql server、oceanbase数据库专家,拥有7年以上的大型数据库运维经验,主方向oracle,擅长故障排除、诊断,大体量(TB)迁移,异常故障修复等。拥有丰富主导大型项目经验。服务行业包括:运营商、银行、金融业、政府单位、医疗、制造业、高校等等。

注册时间:2020-07-31

  • 博文量
    116
  • 访问量
    88773