Oracle 12cR1 RAC 在VMware Workstation上安装(中)

爱是王道

[oracle@raclhr-12cR1-N1 bin]$ crsctl stat res -t

　　--------------------------------------------------------------------------------
　　Name           Target  State        Server                   State details      
　　--------------------------------------------------------------------------------
　　Local Resources
　　--------------------------------------------------------------------------------
　　ora.DATA.dg
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.FRA.dg
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.LISTENER.lsnr
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.OCR.dg
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.asm
　　ONLINE  ONLINE       raclhr-12cr1-n1          Started,STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          Started,STABLE
　　ora.net1.network
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.ons
　　ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　--------------------------------------------------------------------------------
　　Cluster Resources
　　--------------------------------------------------------------------------------
　　ora.LISTENER_SCAN1.lsnr
　　1        ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.MGMTLSNR
　　1        ONLINE  ONLINE       raclhr-12cr1-n2          169.254.166.174 192.
　　168.2.101,STABLE
　　ora.cvu
　　1        ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ora.lhr12crac.db
　　1        ONLINE  ONLINE       raclhr-12cr1-n1          Open,STABLE
　　2        ONLINE  ONLINE       raclhr-12cr1-n2          Open,STABLE
　　ora.mgmtdb
　　1        OFFLINE OFFLINE                               Instance Shutdown,ST
　　ABLE
　　ora.oc4j
　　1        ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.raclhr-12cr1-n1.vip
　　1        ONLINE  ONLINE       raclhr-12cr1-n1          STABLE
　　ora.raclhr-12cr1-n2.vip
　　1        ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　ora.scan1.vip
　　1        ONLINE  ONLINE       raclhr-12cr1-n2          STABLE
　　--------------------------------------------------------------------------------

[oracle@raclhr-12cR1-N1 bin]$

[oracle@raclhr-12cR1-N1 bin]$ crsctl check cluster

　　CRS-4537: Cluster Ready Services is online
　　CRS-4529: Cluster Synchronization Services is online
　　CRS-4533: Event Manager is online

[oracle@raclhr-12cR1-N1 bin]$ srvctl status database -d lhr12crac

　　Instance lhr12cra1 is running on node raclhr-12cr1-n1
　　Instance lhr12cra2 is running on node raclhr-12cr1-n2

[oracle@raclhr-12cR1-N1 bin]$ srvctl status nodeapps

　　VIP raclhr-12cr1-n1-vip is enabled
　　VIP raclhr-12cr1-n1-vip is running on node: raclhr-12cr1-n1
　　VIP raclhr-12cr1-n2-vip is enabled
　　VIP raclhr-12cr1-n2-vip is running on node: raclhr-12cr1-n2
　　Network is enabled
　　Network is running on node: raclhr-12cr1-n1
　　Network is running on node: raclhr-12cr1-n2
　　ONS is enabled
　　ONS daemon is running on node: raclhr-12cr1-n1
　　ONS daemon is running on node: raclhr-12cr1-n2

[oracle@raclhr-12cR1-N1 bin]$ srvctl config nodeapps

　　Network 1 exists
　　Subnet IPv4: 192.168.59.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:
　　VIP exists: network number 1, hosting node raclhr-12cr1-n1
　　VIP Name: raclhr-12cr1-n1-vip
　　VIP IPv4 Address: 192.168.59.162
　　VIP IPv6 Address:
　　VIP is enabled.
　　VIP is individually enabled on nodes:
　　VIP is individually disabled on nodes:
　　VIP exists: network number 1, hosting node raclhr-12cr1-n2
　　VIP Name: raclhr-12cr1-n2-vip
　　VIP IPv4 Address: 192.168.59.163
　　VIP IPv6 Address:
　　VIP is enabled.
　　VIP is individually enabled on nodes:
　　VIP is individually disabled on nodes:
　　ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
　　ONS is enabled
　　ONS is individually enabled on nodes:
　　ONS is individually disabled on nodes:

[oracle@raclhr-12cR1-N1 bin]$ srvctl config database -d lhr12crac -a

　　Database unique name: lhr12crac
　　Database name: lhr12cra
　　Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
　　Oracle user: oracle
　　Spfile: +DATA/LHR12CRAC/PARAMETERFILE/spfile.278.933512629
　　Password file: +DATA/LHR12CRAC/PASSWORD/pwdlhr12crac.266.933512143
　　Domain:
　　Start options: open
　　Stop options: immediate
　　Database role: PRIMARY
　　Management policy: AUTOMATIC
　　Server pools:
　　Disk Groups: DATA,FRA
　　Mount point paths:
　　Services:
　　Type: RAC
　　Start concurrency:
　　Stop concurrency:
　　Database is enabled
　　Database is individually enabled on nodes:
　　Database is individually disabled on nodes:
　　OSDBA group: dba
　　OSOPER group: oinstall
　　Database instances: lhr12cra1,lhr12cra2
　　Configured nodes: raclhr-12cr1-n1,raclhr-12cr1-n2
　　Database is administrator managed

[oracle@raclhr-12cR1-N1 bin]$ srvctl status asm

　　ASM is running on raclhr-12cr1-n2,raclhr-12cr1-n1

[oracle@raclhr-12cR1-N1 bin]$ srvctl config asm -a

　　ASM home: <CRS home>
　　Password file: +OCR/orapwASM
　　ASM listener: LISTENER
　　ASM is enabled.
　　ASM is individually enabled on nodes:
　　ASM is individually disabled on nodes:

[oracle@raclhr-12cR1-N1 bin]$ srvctl status listener

　　Listener LISTENER is enabled
　　Listener LISTENER is running on node(s): raclhr-12cr1-n2,raclhr-12cr1-n1

[oracle@raclhr-12cR1-N1 bin]$ srvctl config listener -a

　　Name: LISTENER
　　Type: Database Listener
　　Network: 1, Owner: grid
　　Home: <CRS home>
　　/u01/app/12.1.0/grid on node(s) raclhr-12cr1-n2,raclhr-12cr1-n1
　　End points: TCP:1521
　　Listener is enabled.
　　Listener is individually enabled on nodes:
　　Listener is individually disabled on nodes:

[oracle@raclhr-12cR1-N1 bin]$ srvctl config nodeapps -a -g -s -l

　　PRKO-2207 : Warning:-gsdonly option has been deprecated and will be ignored.
　　Warning:-listener option has been deprecated and will be ignored.
　　Network 1 exists
　　Subnet IPv4: 192.168.59.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:
　　VIP exists: network number 1, hosting node raclhr-12cr1-n1
　　VIP Name: raclhr-12cr1-n1-vip
　　VIP IPv4 Address: 192.168.59.162
　　VIP IPv6 Address:
　　VIP is enabled.
　　VIP is individually enabled on nodes:
　　VIP is individually disabled on nodes:
　　VIP exists: network number 1, hosting node raclhr-12cr1-n2
　　VIP Name: raclhr-12cr1-n2-vip
　　VIP IPv4 Address: 192.168.59.163
　　VIP IPv6 Address:
　　VIP is enabled.
　　VIP is individually enabled on nodes:
　　VIP is individually disabled on nodes:
　　ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
　　ONS is enabled
　　ONS is individually enabled on nodes:
　　ONS is individually disabled on nodes:
　　Name: LISTENER
　　Type: Database Listener
　　Network: 1, Owner: grid
　　Home: <CRS home>
　　/u01/app/12.1.0/grid on node(s) raclhr-12cr1-n2,raclhr-12cr1-n1
　　End points: TCP:1521
　　Listener is enabled.
　　Listener is individually enabled on nodes:
　　Listener is individually disabled on nodes:

[oracle@raclhr-12cR1-N1 bin]$ srvctl status scan

　　SCAN VIP scan1 is enabled
　　SCAN VIP scan1 is running on node raclhr-12cr1-n2

[oracle@raclhr-12cR1-N1 bin]$ srvctl config scan

　　SCAN name: raclhr-12cR1-scan, Network: 1
　　Subnet IPv4: 192.168.59.0/255.255.255.0/eth0, static
　　Subnet IPv6:
　　SCAN 0 IPv4 VIP: 192.168.59.164
　　SCAN VIP is enabled.
　　SCAN VIP is individually enabled on nodes:
　　SCAN VIP is individually disabled on nodes:

[oracle@raclhr-12cR1-N1 bin]$ cluvfy comp clocksync -verbose

　　Verifying Clock Synchronization across the cluster nodes
　　Checking if Clusterware is installed on all nodes...
　　Oracle Clusterware is installed on all nodes.
　　Checking if CTSS Resource is running on all nodes...
　　Check: CTSS Resource running on all nodes
　　Node Name                             Status                  
　　------------------------------------  ------------------------
　　raclhr-12cr1-n1                       passed                  
　　CTSS resource check passed
　　Querying CTSS for time offset on all nodes...
　　Query of CTSS for time offset passed
　　Check CTSS state started...
　　Check: CTSS state
　　Node Name                             State                  
　　------------------------------------  ------------------------
　　raclhr-12cr1-n1                       Active                  
　　CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
　　Reference Time Offset Limit: 1000.0 msecs
　　Check: Reference Time Offset
　　Node Name     Time Offset               Status                  
　　------------  ------------------------  ------------------------
　　raclhr-12cr1-n1  0.0                       passed                  
　　Time offset is within the specified limits on the following set of nodes:
　　"[raclhr-12cr1-n1]"
　　Result: Check of clock time offsets passed
　　Oracle Cluster Time Synchronization Services check passed
　　Verification of Clock Synchronization across the cluster nodes was successful.

[oracle@raclhr-12cR1-N1 bin]$ ORACLE_SID=lhr12cra1

[oracle@raclhr-12cR1-N1 bin]$ sqlplus / as sysdba

　　SQL*Plus:>　　Copyright (c) 1982, 2014, Oracle.  All rights reserved.
　　Connected to:

　　Oracle Database 12c Enterprise Edition>　　With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
　　Advanced Analytics and Real Application Testing options
　　SQL> set line 9999
　　SQL> show parameter cluster
　　NAME                                 TYPE                   VALUE
　　------------------------------------ ---------------------- ------------------------------
　　cluster_database                     boolean                TRUE
　　cluster_database_instances           integer                2
　　cluster_interconnects                string
　　SQL> col host_name format a20  
　　SQL> set linesize 200  
　　SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;
　　INSTANCE_NAME                    HOST_NAME            VERSION                            STARTUP_TIME        STATUS                   ACTIVE_STATE       INSTANCE_ROLE
　　-------------------------------- -------------------- ---------------------------------- ------------------- ------------------------ ------------------ ------------------------------------
　　DATABASE_STATUS
　　----------------------------------
　　lhr12cra1                        raclhr-12cR1-N1      12.1.0.2.0                         2017-01-17 13:05:14 OPEN                     NORMAL             PRIMARY_INSTANCE
　　ACTIVE
　　lhr12cra2                        raclhr-12cR1-N2      12.1.0.2.0                         2017-01-17 13:05:59 OPEN                     NORMAL             PRIMARY_INSTANCE
　　ACTIVE
　　SQL>