Oracle 12.1 RAC 系列 – 配置第二个网络和相应的SCAN2

联系:QQ(5163721)

标题:Oracle 12.1 RAC 系列 – 配置第二个网络和相应的SCAN2

作者:Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

在配置ADG或者使用oracle 的集群管理应用的HA时(比如OGG),我们可能希望使用不同的网络,以避免ADG传输日志等对主生产网络的造成影响。
从11.2开始,我们可以使用crs管理多个网络资源(缺省只有network1),但是SCAN只能在多个网络中的一个上活动(缺省是network1,后续可以指定到不同网络上)。
然后,我们通常会配置专门为ADG传输日志的network2网络,但是在配置连接串时,只能使用vip(因为SCAN通常给主生产上的network1使用)。
.
从12.1开始,我们可以配置多个网络上的多个SCAN,比如我们配置ADG时,在network2上配置SCAN2。
具体配置如下:
–检查网卡接口对应的IP地址:

[root@rac1 ~]# ifconfig | egrep 'eth0' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1
192.168.56.61
192.168.56.63
[root@rac1 ~]# ifconfig | egrep 'eth2' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1
192.168.209.61
[root@rac1 ~]# 

[root@rac2 ~]# ifconfig | egrep 'eth0' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1
192.168.56.62
192.168.56.64
192.168.56.65
[root@rac2 ~]# ifconfig | egrep 'eth2' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1
192.168.209.62
[root@rac2 ~]# 

–添加新的public网络

[grid@rac1 ~]$ oifcfg getif
eth0  192.168.56.0  global  public
eth1  192.168.60.0  global  cluster_interconnect
[grid@rac1 ~]$ 
[grid@rac1 ~]$ oifcfg setif -global eth2/192.168.209.0:public
[grid@rac1 ~]$ oifcfg getif
eth0  192.168.56.0  global  public
eth1  192.168.60.0  global  cluster_interconnect
eth2  192.168.209.0  global  public
[grid@rac1 ~]$ 

–检查网络定义,缺省只有一个网络定义:network1

[grid@rac1 ~]$ srvctl config network
Network 1 exists
Subnet IPv4: 192.168.56.0/255.255.255.0/eth0, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
[grid@rac1 ~]$ 

–添加新的网络集群资源(a new network cluster resource)

[root@rac1 ~]# ipcalc -bnm 192.168.209.61 255.255.255.0
NETMASK=255.255.255.0
BROADCAST=192.168.209.255
NETWORK=192.168.209.0
[root@rac1 ~]# 
[root@rac1 ~]# srvctl add network -netnum 2 -subnet 192.168.209.0/255.255.255.0/eth2
[root@rac1 ~]# 
[root@rac1 ~]# srvctl config network
Network 1 exists
Subnet IPv4: 192.168.56.0/255.255.255.0/eth0, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
Network 2 exists
Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
[root@rac1 ~]# 

这时集群的网络资源中已经配置了两个网络(包括新增加的网络),如果使用“crsctl status res -t”查看,可以看到:

[root@rac1 ~]# crsctl status res -t |grep -A 2 network
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net2.network
               OFFLINE OFFLINE      rac1                     STABLE
               OFFLINE OFFLINE      rac2                     STABLE
[root@rac1 ~]# 

–添加vip

[root@rac1 ~]# srvctl add vip -node rac1 -netnum 2 -address rac1-adg-vip/255.255.255.0/eth2
[root@rac1 ~]# srvctl add vip -node rac2 -netnum 2 -address rac2-adg-vip/255.255.255.0/eth2
[root@rac1 ~]# srvctl config vip -n rac1
VIP exists: network number 1, hosting node rac1
VIP Name: rac1-vip
VIP IPv4 Address: 192.168.56.63
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
VIP exists: network number 2, hosting node rac1
VIP Name: rac1-adg-vip
VIP IPv4 Address: 192.168.209.63
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
[root@rac1 ~]# srvctl config vip -n rac2
VIP exists: network number 1, hosting node rac2
VIP Name: rac2-vip
VIP IPv4 Address: 192.168.56.64
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
VIP exists: network number 2, hosting node rac2
VIP Name: rac2-adg-vip
VIP IPv4 Address: 192.168.209.64
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
[root@rac1 ~]# crsctl status res -t |grep -A 2 network
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net2.network
               OFFLINE OFFLINE      rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
[root@rac1 ~]# crsctl status res -t |grep -A 2 vip
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac1_2.vip
      1        OFFLINE OFFLINE                               STABLE
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.rac2_2.vip
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
[root@rac1 ~]# 

–启动vip,查看vip资源

[root@rac1 ~]# su - grid
[grid@rac1 ~]$ srvctl start vip -vip rac1-adg-vip
[grid@rac1 ~]$ srvctl start vip -vip rac2-adg-vip
[grid@rac1 ~]$ srvctl status vip -n rac1
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac1-adg-vip is enabled
VIP rac1-adg-vip is running on node: rac1
[grid@rac1 ~]$ srvctl status vip -n rac2
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
VIP rac2-adg-vip is enabled
VIP rac2-adg-vip is running on node: rac2
[grid@rac1 ~]$ 
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 network
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net2.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 vip
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac1_2.vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.rac2_2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
[grid@rac1 ~]$ 

–检查新创建的vip是否运行了:

[grid@rac1 ~]$ /sbin/ifconfig eth2:1
eth2:1    Link encap:Ethernet  HWaddr 08:00:27:17:79:3C  
          inet addr:192.168.209.63  Bcast:192.168.209.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

[grid@rac1 ~]$ 
[root@rac2 ~]# /sbin/ifconfig eth2:1
eth2:1    Link encap:Ethernet  HWaddr 08:00:27:74:C7:94  
          inet addr:192.168.209.64  Bcast:192.168.209.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

[root@rac2 ~]# 

–添加网络2上的监听:

[grid@rac1 ~]$ srvctl add listener -listener LISTENER_ADG -netnum 2 -endpoints "TCP:1522"
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_ADG.lsnr
               OFFLINE OFFLINE      rac1                     STABLE
               OFFLINE OFFLINE      rac2                     STABLE
--
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ 

在network2上配置SCAN:

[root@rac1 ~]# srvctl add scan -scanname racadg-scan -netnum 2
[root@rac1 ~]# srvctl config scan -netnum 2
SCAN name: racadg-scan, Network: 2
Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static
Subnet IPv6: 
SCAN 0 IPv4 VIP: 192.168.209.65
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes: 
SCAN VIP is individually disabled on nodes: 
[root@rac1 ~]# srvctl status scan -netnum 2
SCAN VIP scan1_net2 is enabled
SCAN VIP scan1_net2 is not running
[root@rac1 ~]# crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_ADG.lsnr
               OFFLINE OFFLINE      rac1                     STABLE
               OFFLINE OFFLINE      rac2                     STABLE
--
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[root@rac1 ~]# crsctl status res -t |grep -A 1 SCAN
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
[root@rac1 ~]#  

–启动network2上的监听

[grid@rac1 ~]$ srvctl start listener -listener LISTENER_ADG
[grid@rac1 ~]$ srvctl status listener -listener LISTENER_ADG
Listener LISTENER_ADG is enabled
Listener LISTENER_ADG is running on node(s): rac1,rac2
[grid@rac1 ~]$ srvctl status listener -listener LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2
[grid@rac1 ~]$ 
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_ADG.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ 

–在network2上启动SCAN

[root@rac1 ~]# srvctl start scan -netnum 2
[root@rac1 ~]# srvctl config scan -netnum 2
SCAN name: racadg-scan, Network: 2
Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static
Subnet IPv6: 
SCAN 0 IPv4 VIP: 192.168.209.65
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes: 
SCAN VIP is individually disabled on nodes: 
[root@rac1 ~]# srvctl status scan -netnum 2
SCAN VIP scan1_net2 is enabled
SCAN VIP scan1_net2 is running on node rac1
[root@rac1 ~]# crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_ADG.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[root@rac1 ~]# crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[root@rac1 ~]# 

–在network2上添加SCAN LISTENER

[grid@rac1 ~]$ srvctl add scan_listener -netnum 2 -listener racadg-scanlsnr -endpoints "TCP:1522"
[grid@rac1 ~]$ srvctl start scan_listener -netnum 2
[grid@rac1 ~]$ srvctl status scan_listener -netnum 2
SCAN Listener RACADG-SCANLSNR_SCAN1_NET2 is enabled
SCAN listener RACADG-SCANLSNR_SCAN1_NET2 is running on node rac1
[grid@rac1 ~]$ srvctl config scan_listener -netnum 2
SCAN Listener RACADG-SCANLSNR_SCAN1_NET2 exists. Port: TCP:1522
Registration invited nodes: 
Registration invited subnets: 
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes: 
SCAN Listener is individually disabled on nodes: 
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_ADG.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.MGMTLSNR
--
ora.RACADG-SCANLSNR_SCAN1_NET2.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.cvu
[grid@rac1 ~]$ 

–检查监听状态

[grid@rac1 ~]$ netstat -an |grep 1521|grep LISTEN
tcp        0      0 169.254.242.79:1521         0.0.0.0:*                   LISTEN      
tcp        0      0 192.168.60.61:1521          0.0.0.0:*                   LISTEN      -----rac1-priv
tcp        0      0 192.168.56.63:1521          0.0.0.0:*                   LISTEN      -----rac1-vip
tcp        0      0 192.168.56.61:1521          0.0.0.0:*                   LISTEN      -----rac1
[grid@rac1 ~]$ netstat -an |grep 1522|grep LISTEN
tcp        0      0 192.168.209.65:1522         0.0.0.0:*                   LISTEN      -----rac-scan
tcp        0      0 192.168.209.63:1522         0.0.0.0:*                   LISTEN      -----rac1-adg-vip
[grid@rac1 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-FEB-2016 21:41:54

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                16-FEB-2016 17:59:39
Uptime                    0 days 3 hr. 42 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.1.0.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.61)(PORT=1521)))      -----rac1
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.63)(PORT=1521)))      -----rac1-vip
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac1)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/lunar/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "lunar" has 1 instance(s).
  Instance "lunar1", status READY, has 1 handler(s) for this service...
Service "lunarXDB" has 1 instance(s).
  Instance "lunar1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ 
[grid@rac1 ~]$ lsnrctl status LISTENER_ADG

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-FEB-2016 21:41:59

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ADG)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_ADG
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                16-FEB-2016 21:13:48
Uptime                    0 days 0 hr. 28 min. 11 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.1.0.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener_adg/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ADG)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.209.63)(PORT=1522)))     
The listener supports no services
The command completed successfully
[grid@rac1 ~]$ 

配置ORACLE数据库实例支持多个网络:

LUNARRAC1_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)))
LUNARRAC1_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-adg-vip)(PORT = 1522)))

LUNARRAC2_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)))
LUNARRAC2_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-adg-vip)(PORT = 1522)))

LUNARRAC_REMOTE_NET1 =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))))
LUNARRAC_REMOTE_NET2 =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racadg-scan)(PORT = 1522))))
[oracle@rac1 admin]$ ss

SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 18 21:58:50 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SYS@lunar1>
SYS@lunar1>alter system set listener_networks='((NAME=network1)(LOCAL_LISTENER=LUNARRAC1_LOCAL_NET1)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET1))','((NAME=network2)(LOCAL_LISTENER=LUNARRAC1_LOCAL_NET2)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET2))' sid='lunar1';

System altered.

Elapsed: 00:00:00.36
SYS@lunar1>alter system set listener_networks='((NAME=network1)(LOCAL_LISTENER=LUNARRAC2_LOCAL_NET1)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET1))','((NAME=network2)(LOCAL_LISTENER=LUNARRAC2_LOCAL_NET2)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET2))' sid='lunar2';

System altered.

Elapsed: 00:00:00.19
SYS@lunar1>alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))))' sid='lunar1';

System altered.

Elapsed: 00:00:00.03
SYS@lunar1>alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))))' sid='lunar2';

System altered.

Elapsed: 00:00:00.80
SYS@lunar1>

配置客户端连接串
—检查数据库是否可以登录:

[oracle@lunarrac ~]$ ss

SQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 19 08:57:30 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SYS@lunar1>conn sys/oracle@//lunarrac-scan:1521/lunar as sysdba
Connected.
SYS@//lunarrac-scan:1521/lunar>conn sys/oracle@//lunaradg-scan:1522/lunar as sysdba
Connected.
SYS@//lunaradg-scan:1522/lunar>conn system/oracle@//lunarrac-scan:1521/lunar
Connected.
SYSTEM@//lunarrac-scan:1521/lunar>conn system/oracle@//lunaradg-scan:1522/lunar
Connected.
SYSTEM@//lunaradg-scan:1522/lunar>conn sys/oracle@lunarrac.vip as sysdba
Connected.
SYS@lunarrac.vip>conn sys/oracle@lunarrac.scanip as sysdba
Connected.
SYS@lunarrac.scanip>conn sys/oracle@lunaradg.vip as sysdba
Connected.
SYS@lunaradg.vip>conn sys/oracle@lunaradg.scanip as sysdba
Connected.
SYS@lunaradg.scanip>conn sys/oracle@rac1adg as sysdba
Connected.
SYS@rac1adg>conn sys/oracle@rac2adg as sysdba
Connected.
SYS@rac2adg>conn sys/oracle@racadg.vip as sysdba
Connected.
SYS@racadg.vip>conn sys/oracle@racadg.scanip as sysdba
Connected.
SYS@racadg.scanip>conn sys/oracle@rac1 as sysdba
Connected.
SYS@rac1>conn sys/oracle@rac2 as sysdba
Connected.
SYS@rac2>conn sys/oracle@racdb.vip as sysdba
Connected.
SYS@racdb.vip>conn sys/oracle@racdb.scanip as sysdba
Connected.
SYS@racdb.scanip>

至此已经全部完成。
Oracle 12.1 RAC 系列:
Oracle 12.1 RAC 系列-安装新主机,识别老存储和恢复数据库
Oracle 12.1 RAC 系列 – 配置第二个网络和相应的SCAN2

此条目发表在 Installation and Deinstall, Linux, network, ORACLE 12C, RAC 分类目录,贴了 , , , , , 标签。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>