当前位置：首页 -> AI编程基础 -> 数据库编程

Add a Node to Oracle 12cR1 RAC on RHEL 6(十)

2014-11-24 17:01:04 · 作者: · 浏览: 11
标签: Add Node Oracle 12cR1 RAC RHEL
tance -d zwc -i zwc3 [oracle@zhongwc3 ~]$ [oracle@zhongwc3 ~]$ srvctl status databse -d zwc -v Usage: srvctl [] commands: enable|disable|export|import|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config|convert|upgrade|downgrade|predict objects: database|instance|service|nodeapps|vip|network|asm|ioserver|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns|cvu|havip|exportfs|gridhomeserver|gridhomeclient|mgmtdb|mgmtlsnr|volume For detailed help on each command and object and its options use: srvctl -help [-compatible] or srvctl -help [-compatible] PRKO-2001 : Invalid command line syntax [oracle@zhongwc3 ~]$ [oracle@zhongwc3 ~]$ srvctl status database -d zwc -v Instance zwc1 is running on node zhongwc1 with online services crm. Instance status: Open. Instance zwc2 is running on node zhongwc2 with online services erp. Instance status: Open. Instance zwc3 is running on node zhongwc3. Instance status: Open. [oracle@zhongwc2 ~]$ scp $ORACLE_HOME/network/admin/tnsnames.ora zhongwc3:$ORACLE_HOME/network/admin The authenticity of host 'zhongwc3 (192.168.1.33)' can't be established. RSA key fingerprint is 24:78:f8:dc:52:f4:36:5a:e6:ae:77:2e:2d:40:6a:33. Are you sure you want to continue connecting (yes/no) yes Warning: Permanently added 'zhongwc3,192.168.1.33' (RSA) to the list of known hosts. tnsnames.ora 100% 333 0.3KB/s 00:00 [oracle@zhongwc3 admin]$ sqlplus sys@zwc as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Mon Oct 21 22:16:24 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SQL>
col host_name format a11 SQL> set line 300 SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; Session altered. 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_ST INSTANCE_ROLE DATABASE_STATUS ---------------- ----------- ----------------- ------------------- ------------ --------- ------------------ ----------------- zwc3 zhongwc3 12.1.0.1.0 2013-10-21 22:12:58 OPEN NORMAL PRIMARY_INSTANCE ACTIVE zwc2 zhongwc2 12.1.0.1.0 2013-10-21 17:34:04 OPEN NORMAL PRIMARY_INSTANCE ACTIVE zwc1 zhongwc1 12.1.0.1.0 2013-10-21 17:29:16 OPEN NORMAL PRIMARY_INSTANCE ACTIVE [root@zhongwc3 ~]# crsctl query crs activeversion Oracle Clusterware active version on the cluster is [12.1.0.1.0] [root@zhongwc3 ~]# [root@zhongwc3 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 6cafa9cf7bcb4f25bf51469905ac8ef9 (/dev/asm-diskb) [SYSDG] Located 1 voting disk(s). [root@zhongwc3 ~]# [root@zhongwc3 ~]# srvctl status nodeapps VIP zhongwc1-vip is enabled VIP zhongwc1-vip is running on node: zhongwc1 VIP zhongwc2-vip is enabled VIP zhongwc2-vip is running on node: zhongwc2 VIP zhongwc3-vip is enabled VIP zhongwc3-vip is running on node: zhongwc3 Network is enabled Network is running on n