#acl merlyn:read,write All:read <> = VSAN poweron = I. poweron ESXi host I. exit ESXi maintenanceMode: esxcli system maintenanceMode set -e false I. poweron PSC&vCenter. = VSAN poweroff = == poweroff all VMs except vCenter VM. == == 确认没有有vSAN组件处于同步状态 == == SSH登录2.5主机关闭vCenter == {{{ [root@vSAN-ESXi05-5:~] vim-cmd vmsvc/getallvms Vmid Name File Guest OS Version Annotation 13 VMware vCenter Server Appliance-6.5U1E-CB09-2.251 [vsanDatastore] 3640745a-001d-47e1-b35e-90e2baf64a54/VMware vCenter Server Appliance-6.5U1E-CB09-2.251.vmx other3xLinux64Guest vmx-10 VMware vCenter Server Appliance 16 VMware vCenter Server Appliance-6.5U1e-SSO-PSC-2.252 [vsanDatastore] 3c98745a-7443-df14-53a4-90e2baf64a54/VMware vCenter Server Appliance-6.5U1e-SSO-PSC-2.252.vmx other3xLinux64Guest vmx-10 VMware vCenter Server Appliance 19 CIM_MB_D9_50 [vsanDatastore] 5353755a-a650-7cce-a2cc-90e2baf6520c/CIM_MODBUS_SVR08.vmx windows7Server64Guest vmx-08 20 EM_D9_50 [vsanDatastore] 8f1f755a-a802-f3d5-bab8-90e2baf652d4/EM_APP_PRO28_1.vmx windows7Server64Guest vmx-08 9栋6楼 9 NFS-FOR-vSAN-LOGS [vsanDatastore] 9795705a-bd1e-55ed-dd98-90e2baf652d4/NFS-FOR-vSAN-LOGS.vmx oracleLinux6_64Guest vmx-13 [root@vSAN-ESXi05-5:~] [root@vSAN-ESXi05-5:~] vim-cmd vmsvc/power.shutdown 13 [root@vSAN-ESXi05-5:~] vim-cmd vmsvc/power.shutdown 16 [root@vSAN-ESXi05-5:~] vim-cmd vmsvc/power.getstate 16 Retrieved runtime info Powered off [root@vSAN-ESXi05-5:~] vim-cmd vmsvc/power.getstate 13 Retrieved runtime info Powered off }}} == ssh登录ESXi每台主机运行进入维护模式 == esxcli system maintenanceMode set -e true -m noAction == 最后依次关闭所有ESXi主机 == poweroff = Embedded to External Platform Services Controller Instance = {{{ # /usr/lib/vmware-vmdir/bin/vdcrepadmin -f createagreement -h localhost -H 10.97.2.252 -u administrator /usr/lib/vmware-vmdir/bin/vdcrepadmin -f createagreement -2 -h 192.168.16.27 -H 10.97.2.252 -u administrator /usr/lib/vmware-vmdir/bin/vdcrepadmin -f showpartners -h 10.97.2.252 -u administrator /usr/lib/vmware-vmdir/bin/vdcrepadmin -f showpartners -h 192.168.16.27 -u administrator cmsso-util reconfigure --repoint-psc 10.97.2.252 --username administrator --domain-name vsphere.local --passwd ZSmlscb@09 }}} = Orace parameters = /u01/app/11.2.0/grid/bin/ocrconfig -add +HR_DATA 木林森数据库参数配制。 == ASM == {{{ [grid@mls-rac01 ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 409530 339629 102399 118615 0 N ARCH/ MOUNTED HIGH N 512 4096 1048576 10230 8256 2046 2070 0 Y CRS/ MOUNTED EXTERN N 512 4096 1048576 204732 159842 0 159842 0 N EAS_ARCH/ MOUNTED EXTERN N 512 4096 1048576 819056 455470 0 455470 0 N EAS_DATA/ MOUNTED NORMAL N 512 4096 1048576 511896 343518 102399 120559 0 N HR_DATA/ MOUNTED EXTERN N 512 4096 1048576 204732 196583 0 196583 0 N M_ARCH/ MOUNTED EXTERN N 512 4096 1048576 2047805 1741551 0 1741551 0 N M_DATA/ MOUNTED NORMAL N 512 4096 1048576 122778 100686 20479 40103 0 N REDO/ }}} == show bonding status == {{{ [root@mls-rac01 network-scripts]# cat /proc/net/bonding/bond0 Ethernet Channel Bonding Driver: v3.7.1 (April 27, 2011) Bonding Mode: fault-tolerance (active-backup) Primary Slave: eth1 (primary_reselect always) Currently Active Slave: eth1 MII Status: up MII Polling Interval (ms): 100 Up Delay (ms): 0 Down Delay (ms): 0 Slave Interface: eth0 MII Status: up Speed: 1000 Mbps Duplex: full Link Failure Count: 0 Permanent HW addr: e0:4f:43:07:2d:84 Slave queue ID: 0 Slave Interface: eth1 MII Status: up Speed: 1000 Mbps Duplex: full Link Failure Count: 0 Permanent HW addr: e0:4f:43:07:2d:85 Slave queue ID: 0 }}} {{{ [root@mls-rac02 ~]# cat /proc/net/bonding/bond0 Ethernet Channel Bonding Driver: v3.7.1 (April 27, 2011) Bonding Mode: fault-tolerance (active-backup) Primary Slave: eth0 (primary_reselect always) Currently Active Slave: eth0 MII Status: up MII Polling Interval (ms): 100 Up Delay (ms): 0 Down Delay (ms): 0 Slave Interface: eth0 MII Status: up Speed: 1000 Mbps Duplex: full Link Failure Count: 0 Permanent HW addr: e0:4f:43:07:25:4c Slave queue ID: 0 Slave Interface: eth1 MII Status: up Speed: 1000 Mbps Duplex: full Link Failure Count: 0 Permanent HW addr: e0:4f:43:07:25:4d Slave queue ID: 0 }}} == Archivelog delete == === mls-rac01 === {{{ [oracle@mls-rac01 ~]$ crontab -l 20 7 * * * /home/oracle/autojobs/lunch_rman_delete_MDB.sh 25 7 * * * /home/oracle/autojobs/lunch_rman_delete_HRDB.sh 30 7 * * * /home/oracle/autojobs/lunch_rman_delete_EASDB.sh }}} === mls-rac02 === {{{ [oracle@mls-rac02 ~]$ crontab -l # Failback USE IT. #20 7 * * * /home/oracle/autojobs/lunch_rman_delete_MDB.sh #25 7 * * * /home/oracle/autojobs/lunch_rman_delete_HRDB.sh #30 7 * * * /home/oracle/autojobs/lunch_rman_delete_EASDB.sh }}} == Database Version == SQL> select * from gv$version; INST_ID BANNER ---------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 1 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 1 PL/SQL Release 11.2.0.4.0 - Production 1 CORE 11.2.0.4.0 Production 1 TNS for Linux: Version 11.2.0.4.0 - Production 1 NLSRTL Version 11.2.0.4.0 - Production 2 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 2 PL/SQL Release 11.2.0.4.0 - Production 2 CORE 11.2.0.4.0 Production 2 TNS for Linux: Version 11.2.0.4.0 - Production 2 NLSRTL Version 11.2.0.4.0 - Production 10 rows selected. == Set the parameter value in the parameter file (init.ora or spfile) and restart the database. == {{{ SQL> alter system set session_cached_cursors= scope=spfile sid='*'; }}} {{{ Status on HRDB: WARNING => Consider increasing the value of the session_cached_cursors database parameter DATA FOR HRDB FOR SESSION_CACHED_CURSORS PARAMETER SESSION_CACHED_CURSORS: Current Value = 50 Usage = 99 Percentage Usage = 198% }}} {{{ Status on MDB: WARNING => Consider increasing the value of the session_cached_cursors database parameter DATA FOR MDB FOR SESSION_CACHED_CURSORS PARAMETER SESSION_CACHED_CURSORS: Current Value = 50 Usage = 96 Percentage Usage = 192% }}} {{{ Status on EASDB: WARNING => Consider increasing the value of the session_cached_cursors database parameter DATA FOR EASDB FOR SESSION_CACHED_CURSORS PARAMETER SESSION_CACHED_CURSORS: Current Value = 50 Usage = 381 Percentage Usage = 762% }}} == EM CONSOLE == {{{ [root@mls-rac01 ~]# cat /etc/rc.local #!/bin/sh # # This script will be executed *after* all the other init scripts. # You can put your own initialization stuff in here if you don't # want to do the full Sys V style init stuff. su - oracle -c 'export ORACLE_UNQNAME=MDB; emctl start dbconsole' su - oracle -c 'export ORACLE_UNQNAME=HRDB; emctl start dbconsole' su - oracle -c 'export ORACLE_UNQNAME=EASDB; emctl start dbconsole' touch /var/lock/subsys/local }}} == NOAUDIT == {{{ SQL>NOAUDIT ALL; }}} == sga_target == * We can Disable our automatic SGA tuning by setting the parameter SGA_TARGET to value digit 0. SQL> alter system set sga_target=0; 原數據庫的物理內存總量和比率爲： {{{ EASDB 102GB PLM DB 12GB HR DB 32GB }}} 新服務器的內存配制爲256GB 因此計算出來的內存分配參考值爲: {{{ EASDB: 256*(102/(102+12+32))=178GB PLM DB: 256*(12/(102+12+32))=21GB HR DB: 256*(32/(102+12+32))=56GB }}} == Processes setting == {{{ # processes=x sessions=x*1.1+5 transactions=sessions*1.1 select name, value from v$parameter where name in ('sessions','processes','transactions'); alter system set processes=6000 scope=spfile sid='*'; alter system set sessions=6655 scope=spfile sid='*'; alter system set transactions=7300 scope=spfile sid='*'; }}} == EASDB(AIX) == # 半自动 {{{ alter system set sga_max_size=62g sid='*' scope=spfile; alter system set sga_target=62G sid='*' scope=spfile; alter system set pga_aggregate_target=20G sid='*' scope=spfile; }}} {{{ SGA: (178*0.8)*0.7=98GB PGA: (178*0.8)*0.3=32GB NAME VALUE ------------- ---------------------------------------------------------------- LANGUAGE AMERICAN TERRITORY AMERICA CHARACTER SET AL32UTF8 }}} Current DB size is 616GB. === Processes === export ORACLE_SID=EASDB1 {{{ 2000*1.1+5=2205.0 (2000*1.1+5)*1.1=2425.50 alter system set processes=2000 scope=spfile sid='*'; alter system set sessions=2205 scope=spfile sid='*'; alter system set transactions=2425 scope=spfile sid='*'; }}} == HR DB == {{{ alter system set sga_max_size=30g sid='*' scope=spfile; alter system set sga_target=30G sid='*' scope=spfile; alter system set pga_aggregate_target=10G sid='*' scope=spfile; }}} {{{ SGA: (21*0.8)*0.7=11GB PGA: (21*0.8)*0.3=5GB LANGUAGE SIMPLIFIED CHINESE TERRITORY CHINA CHARACTER SET AL32UTF8 }}} Current DB size is 154GB. === Processes === export ORACLE_SID=HRDB1 {{{ 300*1.1+5 = 335.0 (300*1.1+5)*1.1=368.50 alter system set processes=1000 scope=spfile sid='*'; alter system set sessions=1105 scope=spfile sid='*'; alter system set transactions=1216 scope=spfile sid='*'; }}} == PLM DB( MDB Linux) == {{{ alter system set sga_max_size=38g sid='*' scope=spfile; alter system set sga_target=38G sid='*' scope=spfile; alter system set pga_aggregate_target=12G sid='*' scope=spfile; }}} {{{ SGA: (12*0.8)*0.8=8GB PGA: (12*0.8)*0.2=2GB LANGUAGE AMERICAN TERRITORY AMERICA CHARACTER SET AL32UTF8 }}} Current DB size is 80GB. export ORACLE_SID=MDB1 === Processes === export ORACLE_SID=MDB1 {{{ 300*1.1+5 = 335.0 (300*1.1+5)*1.1=368.50 alter system set processes=1000 scope=spfile sid='*'; alter system set sessions=1105 scope=spfile sid='*'; alter system set transactions=1216 scope=spfile sid='*'; }}} = Huawei S5700S 配制 = == S5700S-SW1 == {{{ system-view interface range GigabitEthernet 0/0/13 to GigabitEthernet 0/0/14 port default vlan 16 }}} == S5700S-SW2 == {{{ system-view interface range GigabitEthernet 0/0/13 to GigabitEthernet 0/0/14 port default vlan 16 }}} = RAC operations = == REDO log == === EASDB === * select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log; * SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 ('+REDO') SIZE 200M, GROUP 6 ('+REDO') SIZE 200M, GROUP 7 ('+REDO') SIZE 200M, GROUP 8 ('+REDO') SIZE 200M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 9 ('+REDO') SIZE 200M, GROUP 10 ('+REDO') SIZE 200M, GROUP 11 ('+REDO') SIZE 200M, GROUP 12 ('+REDO') SIZE 200M; }}} {{{ alter system switch logfile; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE ADD LOGFILE thread 1 GROUP 1 ('+REDO') SIZE 200M, GROUP 2 ('+REDO') SIZE 200M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 3 ('+REDO') SIZE 200M, GROUP 4 ('+REDO') SIZE 200M; }}} === 20170706 add plan === {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 13 ('+REDO') SIZE 5G, GROUP 14 ('+REDO') SIZE 5G, GROUP 15 ('+REDO') SIZE 5G, GROUP 16 ('+REDO') SIZE 5G; ALTER DATABASE ADD LOGFILE thread 2 GROUP 17 ('+REDO') SIZE 5G, GROUP 18 ('+REDO') SIZE 5G, GROUP 19 ('+REDO') SIZE 5G, GROUP 20 ('+REDO') SIZE 5G; }}} === MDB === * select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log; * SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 ('+REDO') SIZE 500M, GROUP 6 ('+REDO') SIZE 500M, GROUP 7 ('+REDO') SIZE 500M, GROUP 8 ('+REDO') SIZE 500M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 9 ('+REDO') SIZE 500M, GROUP 10 ('+REDO') SIZE 500M, GROUP 11 ('+REDO') SIZE 500M, GROUP 12 ('+REDO') SIZE 500M; }}} {{{ alter system switch logfile; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE ADD LOGFILE thread 1 GROUP 1 ('+REDO') SIZE 500M, GROUP 2 ('+REDO') SIZE 500M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 3 ('+REDO') SIZE 500M, GROUP 4 ('+REDO') SIZE 500M; }}} ALTER DATABASE DROP LOGFILE GROUP 4; === MESDB === ==== ARCHIVE LOG ENABLE ==== {{{ alter system set log_archive_dest_1='LOCATION=+MES_ARCH' scope = spfile; }}} * select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log; * SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 ('+MES_REDO') SIZE 500M, GROUP 6 ('+MES_REDO') SIZE 500M, GROUP 7 ('+MES_REDO') SIZE 500M, GROUP 8 ('+MES_REDO') SIZE 500M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 9 ('+MES_REDO') SIZE 500M, GROUP 10 ('+MES_REDO') SIZE 500M, GROUP 11 ('+MES_REDO') SIZE 500M, GROUP 12 ('+MES_REDO') SIZE 500M; }}} {{{ alter system switch logfile; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE ADD LOGFILE thread 1 GROUP 1 ('+MES_REDO') SIZE 500M, GROUP 2 ('+MES_REDO') SIZE 500M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 3 ('+MES_REDO') SIZE 500M, GROUP 4 ('+MES_REDO') SIZE 500M; }}} ALTER DATABASE DROP LOGFILE GROUP 4; === HRDB === ==== 20170830 add plan ==== {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 13 ('+REDO') SIZE 2G, GROUP 14 ('+REDO') SIZE 2G, GROUP 15 ('+REDO') SIZE 2G; ALTER DATABASE ADD LOGFILE thread 2 GROUP 16 ('+REDO') SIZE 2G, GROUP 17 ('+REDO') SIZE 2G, GROUP 18 ('+REDO') SIZE 2G; }}} == impdp errors == {{{ [oracle@mls-rac02 HRDB]$ grep ORA- expdp_HRDB_EXPDP_LSHR.log | awk -F":" '{ print $1 }' | sort | uniq -c 4 ORA-00604 11 ORA-01711 Doc ID 1282277.1 is confirmed ! 4 ORA-04052 Doc ID 1301472.1 use impdp PARALLEL=1 or create missing database link 4 ORA-12154 same as above.is OK? 1 ORA-31684 can ignore. is OK! 1 ORA-39034 Doc ID 420121.1 is no OK? 54 ORA-39082 15 ORA-39083 }}} == RMAN DUPLICATE == === 1 stop another instance === [grid@mls-rac02 ~]$ srvctl stop instance -d HRDB -i HRDB1 === db parameters === {{{ alter system set db_name=HRDB scope=spfile; alter system set cluster_database=false scope=spfile; alter system set db_create_file_dest='+HR_DATA'; alter system set db_create_online_log_dest_1='+REDO'; shutdown immediate startup nomount }}} === Enable status registration for HRDB1 to run LISTENER === Add the following entries into listener.ora file in GI_HOME. Edit /apps/grid/11.2.0/network/admin/listener.ora and add the following lines: {{{ SID_LIST_LISTENER = (SID_LIST = ) (SID_DESC = (SID_NAME = HRDB1) (ORACLE_HOME = /apps/oracle/product/11.2.0/db_1) (GLOBAL_DBNAME = HRDB) ) ) }}} Make sure that ORACLE_HOME in this entry points to correct home, which is the home from which HRDB database runs. === 4- Ceate a password file for auxiliary instance HRDB1 on prd-db-01: === cd $ORACLE_HOME/dbs * orapwd password=123456 file=orapwHRDB1 === 5- Test connectivity to auxiliary and target instances from BOTH hosts using TNS: === * sqlplus sys/sys@HRDB1 as sysdba * sqlplus sys/sys@pritest as sysdba === 6- On the auxiliary host, start RMAN and run the DUPLICATE command: === * rman target sys/sys@HRDEV auxiliary sys/sys@hrprd1 {{{ RMAN>run{ DUPLICATE TARGET DATABASE TO HRDB FROM ACTIVE DATABASE; } }}} rman target sys/123456@pritest auxiliary sys/Systec36@NEWHRDB {{{ run{ allocate auxiliary channel aux1 device type disk; allocate auxiliary channel aux2 device type disk; set newname for datafile 6 to '+HR_DATA'; set newname for datafile 5 to '+HR_DATA'; set newname for datafile 4 to '+HR_DATA'; set newname for datafile 3 to '+HR_DATA'; set newname for datafile 2 to '+HR_DATA'; set newname for datafile 1 to '+HR_DATA'; set newname for tempfile 1 to '+HR_DATA'; duplicate target database to HRDB logfile group 1 ('+REDO') SIZE 50M reuse, group 2 ('+REDO') SIZE 50M reuse; release channel aux1; release channel aux2; } }}} * select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log; * SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 ('+REDO') SIZE 50M, GROUP 6 ('+REDO') SIZE 50M, GROUP 7 ('+REDO') SIZE 50M, GROUP 8 ('+REDO') SIZE 50M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 9 ('+REDO') SIZE 50M, GROUP 10 ('+REDO') SIZE 50M, GROUP 11 ('+REDO') SIZE 50M, GROUP 12 ('+REDO') SIZE 50M; }}} {{{ alter system switch logfile; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE ADD LOGFILE thread 1 GROUP 1 ('+REDO') SIZE 50M, GROUP 2 ('+REDO') SIZE 50M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 3 ('+REDO') SIZE 50M, GROUP 4 ('+REDO') SIZE 50M; }}} === MDB(PLM) === ==== emctl ==== {{{ ^C[oracle@mls-rac02 ~]$ emca -config dbcontrol db -repos create -cluster STARTED EMCA at May 19, 2017 5:41:56 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database unique name: MDB Service name: MDB Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: mls-rac-cluster Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: ASM user password: May 19, 2017 5:43:52 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1 Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Cluster name ................ mls-rac-cluster Database unique name ................ MDB Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/11.2.0/grid ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: n }}} {{{ grid $ SQL> show parameter remote NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ remote_listener string remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean FALSE SQL> alter system set remote_listener='scan:1521' scope=both sid='*'; alter system set remote_listener='scan:1521' scope=both sid='*' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132: syntax error or unresolved network name 'scan:1521' SQL> alter system set remote_listener='rac-scan:1521' scope=both sid='*'; System altered. SQL> show parameter remote NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ remote_listener string rac-scan:1521 remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean FALSE SQL> }}} {{{ [oracle@mls-rac01 oracle]$ emca -config dbcontrol db -repos create -cluster STARTED EMCA at May 19, 2017 6:18:17 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database unique name: MDB Service name: MDB Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: mls-rac-cluster Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1 Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Cluster name ................ mls-rac-cluster Database unique name ................ MDB Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/11.2.0/grid ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y May 19, 2017 6:18:58 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/MDB/emca_2017_05_19_18_18_17.log. May 19, 2017 6:19:00 PM oracle.sysman.emcp.DatabaseChecks performReposChecks SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode. }}} {{{ [oracle@mls-rac01 oracle]$ emca -config dbcontrol db -repos create -cluster STARTED EMCA at May 19, 2017 6:18:17 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database unique name: MDB Service name: MDB Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: mls-rac-cluster Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1 Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Cluster name ................ mls-rac-cluster Database unique name ................ MDB Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/11.2.0/grid May 19, 2017 6:21:22 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/MDB/emca_2017_05_19_18_20_46.log. May 19, 2017 6:21:25 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... May 19, 2017 6:24:11 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped May 19, 2017 6:24:12 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... May 19, 2017 6:29:12 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created May 19, 2017 6:29:19 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... May 19, 2017 6:30:36 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully May 19, 2017 6:30:37 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_mls-rac01_MDB to remote nodes ... May 19, 2017 6:30:39 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_mls-rac02_MDB to remote nodes ... May 19, 2017 6:30:44 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/mls-rac01_MDB to remote nodes ... May 19, 2017 6:30:47 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/mls-rac02_MDB to remote nodes ... May 19, 2017 6:30:51 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... May 19, 2017 6:31:33 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... May 19, 2017 6:31:46 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://mls-rac01:5501/em <<<<<<<<<<< May 19, 2017 6:31:49 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage INFO: **************** Current Configuration **************** INSTANCE NODE DBCONTROL_UPLOAD_HOST ---------- ---------- --------------------- MDB mls-rac01 mls-rac01 MDB mls-rac02 mls-rac01 May 19, 2017 6:31:49 PM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: ************************ WARNING ************************ Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/mls-rac01_MDB/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. *********************************************************** May 19, 2017 6:31:49 PM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: Error starting Database Control on nodes mls-rac02. Execute the following command(s) on nodes: mls-rac02. 1) Set the environment variable ORACLE_UNQNAME to Database unique name 2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole Error starting Database Control on nodes mls-rac02. Execute the following command(s) on nodes: mls-rac02. 1) Set the environment variable ORACLE_UNQNAME to Database unique name 2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole }}} * select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log; * SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; {{{ ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 ('+REDO') SIZE 100M, GROUP 6 ('+REDO') SIZE 100M, GROUP 7 ('+REDO') SIZE 100M, GROUP 8 ('+REDO') SIZE 100M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 9 ('+REDO') SIZE 100M, GROUP 10 ('+REDO') SIZE 100M, GROUP 11 ('+REDO') SIZE 100M, GROUP 12 ('+REDO') SIZE 100M; }}} {{{ alter system switch logfile; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE ADD LOGFILE thread 1 GROUP 1 ('+REDO') SIZE 100M, GROUP 2 ('+REDO') SIZE 100M; ALTER DATABASE ADD LOGFILE thread 2 GROUP 3 ('+REDO') SIZE 100M, GROUP 4 ('+REDO') SIZE 100M; }}} == RAC01 == {{{ ansible -v mls-rac -m shell -a 'mount -o loop /media/systec.oracle/OracleLinux-R6-U7-Server-x86_64-dvd.iso /mnt/iso' ansible -v mls-rac -m shell -a 'echo "vm.min_free_kbytes = 1048576" >> /etc/sysctl.conf' ansible -v mls-rac -m shell -a 'echo "HISTFILESIZE=50000" >> /home/oracle/.bash_profile' $ ansible -v 192.168.17.161 -m shell -a 'mkfs.ext4 -L oracle-data /dev/sda8' Using /etc/ansible/ansible.cfg as config file 192.168.17.161 | SUCCESS | rc=0 >> Filesystem label=oracle-data OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 21315584 inodes, 85242880 blocks 4262144 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=4294967296 2602 block groups 32768 blocks per group, 32768 fragments per group 8192 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968 Allocating group tables: done Writing inode tables: done Creating journal (32768 blocks): done Writing superblocks and filesystem accounting information: donemke2fs 1.43-WIP (20-Jun-2013) $ ansible -v 192.168.17.162 -m shell -a 'mkfs.ext4 -L oracle-data /dev/sda8' Using /etc/ansible/ansible.cfg as config file 192.168.17.162 | SUCCESS | rc=0 >> Filesystem label=oracle-data OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 21315584 inodes, 85242880 blocks 4262144 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=4294967296 2602 block groups 32768 blocks per group, 32768 fragments per group 8192 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968 Allocating group tables: done Writing inode tables: done Creating journal (32768 blocks): done Writing superblocks and filesystem accounting information: donemke2fs 1.43-WIP (20-Jun-2013) }}} == MDB (PLM) == === Collect users === {{{ SQL> select USERNAME, DEFAULT_TABLESPACE from DBA_USERS; USERNAME DEFAULT_TABLESPACE ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ SPATIAL_WFS_ADMIN_USR USERS SPATIAL_CSW_ADMIN_USR USERS APEX_PUBLIC_USER USERS DIP USERS MDDATA USERS XS$NULL USERS ORACLE_OCM USERS SCOTT USERS OLAPSYS SYSAUX SI_INFORMTN_SCHEMA SYSAUX OWBSYS SYSAUX USERNAME DEFAULT_TABLESPACE ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ ORDPLUGINS SYSAUX XDB SYSAUX ANONYMOUS SYSAUX CTXSYS SYSAUX ORDDATA SYSAUX OWBSYS_AUDIT SYSAUX APEX_030200 SYSAUX APPQOSSYS SYSAUX WMSYS SYSAUX EXFSYS SYSAUX ORDSYS SYSAUX USERNAME DEFAULT_TABLESPACE ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ MDSYS SYSAUX FLOWS_FILES SYSAUX OUTLN SYSTEM SYSMAN SYSAUX T2 T2_DATA OBETEST OBETEST PLMTEST PLMTEST OBE634 OBE634 PLM634 PLM634 MLSOBE MLSOBE MLSPLM MLSPLM USERNAME DEFAULT_TABLESPACE ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ OBE632M OBE632M PLM632M PLM632M LSHR LSHR_DATA01 NBU USERS SYSTEM SYSTEM SYS SYSTEM MGMT_VIEW SYSTEM DBSNMP SYSAUX EASMID EASMID_DATA ZTB ZTB_D_STANDARD T1 T1_D_STANDARD USERNAME DEFAULT_TABLESPACE ------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ M3 M3_STANDARD }}} === create tablespaces&users V1.0 === {{{ CREATE TABLESPACE T2_DATA DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE OBETEST DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE PLMTEST DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE OBE634 DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE PLM634 DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE MLSOBE DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE MLSPLM DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE OBE632M DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE PLM632M DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE LSHR_DATA01 DATAFILE '+M_DATA' SIZE 10G AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE EASMID_DATA DATAFILE '+M_DATA' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE ZTB_D_STANDARD DATAFILE '+M_DATA' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE T1_D_STANDARD DATAFILE '+M_DATA' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE M3_STANDARD DATAFILE '+M_DATA' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / }}} {{{ create user T2 identified by Systec36 default tablespace T2_DATA quota unlimited on T2_DATA; create user OBETEST identified by Systec36 default tablespace OBETEST quota unlimited on OBETEST; create user PLMTEST identified by Systec36 default tablespace PLMTEST quota unlimited on PLMTEST; create user OBE634 identified by Systec36 default tablespace OBE634 quota unlimited on OBE634; create user PLM634 identified by Systec36 default tablespace PLM634 quota unlimited on PLM634; create user MLSOBE identified by Systec36 default tablespace MLSOBE quota unlimited on MLSOBE; create user MLSPLM identified by Systec36 default tablespace MLSPLM quota unlimited on MLSPLM; create user OBE632M identified by Systec36 default tablespace OBE632M quota unlimited on OBE632M; create user PLM632M identified by Systec36 default tablespace PLM632M quota unlimited on PLM632M; create user LSHR identified by Systec36 default tablespace LSHR_DATA01 quota unlimited on LSHR_DATA01; create user EASMID identified by Systec36 default tablespace EASMID_DATA quota unlimited on EASMID_DATA; create user ZTB identified by Systec36 default tablespace ZTB_D_STANDARD quota unlimited on ZTB_D_STANDARD; create user T1 identified by Systec36 default tablespace T1_D_STANDARD quota unlimited on T1_D_STANDARD; create user M3 identified by Systec36 default tablespace M3_STANDARD quota unlimited on M3_STANDARD; }}} {{{ grant dba to T2; grant dba to OBETEST; grant dba to PLMTEST; grant dba to OBE634; grant dba to PLM634; grant dba to MLSOBE; grant dba to MLSPLM; grant dba to OBE632M; grant dba to PLM632M; grant dba to LSHR; grant dba to EASMID; grant dba to ZTB; grant dba to T1; grant dba to M3; }}} === create tablespaces&users V2.0 === {{{ CREATE TABLESPACE MLSOBE DATAFILE '+M_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE MLSPLM DATAFILE '+M_DATA' SIZE 1G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / }}} {{{ CREATE USER "MLSOBE" PROFILE "DEFAULT" IDENTIFIED BY "MLSOBE" DEFAULT TABLESPACE "MLSOBE" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK / CREATE USER "MLSPLM" PROFILE "DEFAULT" IDENTIFIED BY "MLSPLM" DEFAULT TABLESPACE "MLSPLM" ACCOUNT UNLOCK / }}} {{{ GRANT CREATE ANY CLUSTER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY CONTEXT TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY CUBE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY CUBE BUILD PROCESS TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY CUBE DIMENSION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY DIMENSION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY DIRECTORY TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY EDITION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY EVALUATION CONTEXT TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY INDEX TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY INDEXTYPE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY JOB TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY LIBRARY TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY MATERIALIZED VIEW TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY MEASURE FOLDER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY MINING MODEL TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY OPERATOR TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY OUTLINE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY PROCEDURE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY RULE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY RULE SET TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY SEQUENCE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY SQL PROFILE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY SYNONYM TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY TABLE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY TRIGGER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY TYPE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ANY VIEW TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ASSEMBLY TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE CLUSTER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE CUBE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE CUBE BUILD PROCESS TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE CUBE DIMENSION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE DATABASE LINK TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE DIMENSION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE EVALUATION CONTEXT TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE EXTERNAL JOB TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE INDEXTYPE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE JOB TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE LIBRARY TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE MATERIALIZED VIEW TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE MEASURE FOLDER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE MINING MODEL TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE OPERATOR TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE PROCEDURE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE PROFILE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE PUBLIC DATABASE LINK TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE PUBLIC SYNONYM TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ROLE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE ROLLBACK SEGMENT TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE RULE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE RULE SET TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE SEQUENCE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE SESSION TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE SYNONYM TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE TABLE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE TABLESPACE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE TRIGGER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE TYPE TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE USER TO "MLSOBE" WITH ADMIN OPTION; GRANT CREATE VIEW TO "MLSOBE" WITH ADMIN OPTION; GRANT UNLIMITED TABLESPACE TO "MLSOBE" WITH ADMIN OPTION; GRANT UPDATE ANY TABLE TO "MLSOBE" WITH ADMIN OPTION; GRANT "CONNECT" TO "MLSOBE" WITH ADMIN OPTION; GRANT "DBA" TO "MLSOBE" WITH ADMIN OPTION; GRANT "RESOURCE" TO "MLSOBE" WITH ADMIN OPTION; }}} {{{ GRANT CREATE ANY ASSEMBLY TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY CLUSTER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY CONTEXT TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY CUBE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY CUBE BUILD PROCESS TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY CUBE DIMENSION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY DIMENSION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY DIRECTORY TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY EDITION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY EVALUATION CONTEXT TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY INDEX TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY INDEXTYPE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY JOB TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY LIBRARY TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY MATERIALIZED VIEW TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY MEASURE FOLDER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY MINING MODEL TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY OPERATOR TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY OUTLINE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY PROCEDURE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY RULE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY RULE SET TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY SEQUENCE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY SQL PROFILE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY SYNONYM TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY TABLE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY TRIGGER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY TYPE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ANY VIEW TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ASSEMBLY TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE CLUSTER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE CUBE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE CUBE BUILD PROCESS TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE CUBE DIMENSION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE DATABASE LINK TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE DIMENSION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE EVALUATION CONTEXT TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE EXTERNAL JOB TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE INDEXTYPE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE JOB TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE LIBRARY TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE MATERIALIZED VIEW TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE MEASURE FOLDER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE MINING MODEL TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE OPERATOR TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE PROCEDURE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE PROFILE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE PUBLIC DATABASE LINK TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE PUBLIC SYNONYM TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ROLE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE ROLLBACK SEGMENT TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE RULE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE RULE SET TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE SEQUENCE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE SESSION TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE SYNONYM TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE TABLE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE TABLESPACE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE TRIGGER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE TYPE TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE USER TO "MLSPLM" WITH ADMIN OPTION; GRANT CREATE VIEW TO "MLSPLM" WITH ADMIN OPTION; GRANT UNLIMITED TABLESPACE TO "MLSPLM" WITH ADMIN OPTION; GRANT UPDATE ANY TABLE TO "MLSPLM" WITH ADMIN OPTION; GRANT "CONNECT" TO "MLSPLM" WITH ADMIN OPTION; GRANT "DBA" TO "MLSPLM" WITH ADMIN OPTION; GRANT "RESOURCE" TO "MLSPLM" WITH ADMIN OPTION; }}} == EASDB == === create test tablespaces&users V2.0 === {{{ CREATE TABLESPACE EAS_D_MLS170220_INDEX DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE EAS_D_MLS170220_STANDARD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE EAS_D_MLS170220_TEMP2 DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / CREATE TEMPORARY TABLESPACE EAS_T_MLS170220_STANDARD TEMPFILE '+EAS_DATA' SIZE 1G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL / CREATE TABLESPACE EAS_D_MLS2015DB_INDEX DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO / alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS170220_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; }}} {{{ CREATE USER mls170220 identified by mls170220 default tablespace EAS_D_MLS170220_STANDARD temporary tablespace EAS_T_MLS170220_STANDARD profile default; grant connect,dba to mls170220; impdp mls170220/mls170220 directory=dump_dir dumpfile=expdp_EASDB.dmp logfile=impdp_EASDB.log remap_schema=MLS2015DB:mls170220 remap_tablespace=EAS_D_MLS2015DB_STANDARD:EAS_D_MLS170220_STANDARD,EAS_D_MLS2015DB_TEMP2:EAS_D_MLS170220_TEMP2,EAS_T_MLS2015DB_STANDARD:EAS_T_MLS170220_STANDARD parallel=1 EXCLUDE=STATISTICS }}} === create product tablespaces&users V2.0 === * New! same as Production site !!!! {{{ CREATE TABLESPACE EAS_D_MLS2015DB_INDEX DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE EAS_D_MLS2015DB_STANDARD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE EAS_D_MLS2015DB_TEMP2 DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TEMPORARY TABLESPACE EAS_T_MLS2015DB_STANDARD TEMPFILE '+EAS_DATA' SIZE 1G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL ; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_STANDARD ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_INDEX ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; alter tablespace EAS_D_MLS2015DB_INDEX ADD DATAFILE '+EAS_DATA' SIZE 5G AUTOEXTEND ON NEXT 128M; CREATE USER mls2015db identified by mls2015db default tablespace EAS_D_MLS2015DB_STANDARD temporary tablespace EAS_T_MLS2015DB_STANDARD profile default; grant connect,dba to mls2015db; impdp mls2015db/mls2015db schemas=mls2015db directory=dump_dir dumpfile=mls2015dbexpdp201705010805.dmp logfile=impdp_EASDB.log EXCLUDE=STATISTICS PARALLEL=72 }}} == HRDB == === create tablespaces&users V2.0 === ==== last ==== {{{ CREATE TABLESPACE LSHR_DATA01 DATAFILE '+HR_DATA' SIZE 10G AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; alter tablespace LSHR_DATA01 ADD DATAFILE '+HR_DATA' SIZE 20G AUTOEXTEND ON NEXT 128M; CREATE TABLESPACE LSHR_INDEX01 DATAFILE '+HR_DATA' SIZE 1G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_KQ DATAFILE '+HR_DATA' SIZE 2G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_KQNEW DATAFILE '+HR_DATA' SIZE 2G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_INDEX_KQ DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_INDEX_KQNEW DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_A01 DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_INDEX_A01 DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_JX DATAFILE '+HR_DATA' SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE LSHR_TR DATAFILE '+HR_DATA' SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO; CREATE USER LSHR IDENTIFIED BY "lshr2014" DEFAULT TABLESPACE "LSHR_DATA01" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT QUOTA UNLIMITED ON "LSHR_DATA01"; GRANT "CONNECT" TO "LSHR" WITH ADMIN OPTION; GRANT "DBA" TO "LSHR" WITH ADMIN OPTION; ALTER USER "LSHR" DEFAULT ROLE ALL; impdp lshr/lshr2014 DIRECTORY=dump_dir DUMPFILE=expdp_HRDB_20170505.DMP logfile=expdp_HRDB_20170505.log EXCLUDE=STATISTICS PARALLEL = 72 }}} ==== preview ==== {{{ CREATE TABLESPACE LSHR_DATA01 DATAFILE '+HR_DATA' SIZE 10G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; alter tablespace LSHR_DATA01 ADD DATAFILE '+HR_DATA' SIZE 20G AUTOEXTEND ON NEXT 128M; CREATE TABLESPACE LSHR_INDEX01 DATAFILE '+HR_DATA' SIZE 1G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; CREATE TABLESPACE LSHR_KQ DATAFILE '+HR_DATA' SIZE 2G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_KQNEW DATAFILE '+HR_DATA' SIZE 2G AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_INDEX_KQ DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_INDEX_KQNEW DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_A01 DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_INDEX_A01 DATAFILE '+HR_DATA' SIZE 128M AUTOEXTEND ON NEXT 128M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_JX DATAFILE '+HR_DATA' SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; CREATE TABLESPACE LSHR_TR DATAFILE '+HR_DATA' SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; }}} {{{ CREATE USER LSHR IDENTIFIED BY "lshr2014" DEFAULT TABLESPACE "LSHR_DATA01" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT QUOTA UNLIMITED ON "LSHR_DATA01"; GRANT "CONNECT" TO "LSHR" WITH ADMIN OPTION; GRANT "DBA" TO "LSHR" WITH ADMIN OPTION; ALTER USER "LSHR" DEFAULT ROLE ALL; impdp lshr/lshr2014 DIRECTORY=dump_dir DUMPFILE=expdp_HRDB_20170505.DMP logfile=expdp_HRDB_20170505.log EXCLUDE=STATISTICS PARALLEL = 72 }}} === Drop USER+TABLESPACE === {{{ drop user lshr cascade; drop tablespace LSHR_DATA01 including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_INDEX01 including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_KQ including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_KQNEW including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_INDEX_KQ including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_INDEX_KQNEW including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_A01 including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_INDEX_A01 including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_JX including contents and datafiles CASCADE CONSTRAINTS; drop tablespace LSHR_TR including contents and datafiles CASCADE CONSTRAINTS; }}} = SAN01 = # awk '{ print "alicreate", "\""$1"\",","", "\" \"" }' < x == alicreate == {{{ alicreate "IBM_DS5020_B_F1","20:15:00:80:e5:18:85:00" alicreate "AIX_EAS_FC2","10:00:00:00:c9:9c:19:bb" alicreate "AIX_ORACLE_FC2","10:00:00:00:c9:95:d8:65" alicreate "IBM_DS5020_A_F2","20:24:00:80:e5:18:85:00" alicreate "EMC_5200_A_P3","50:06:01:63:08:60:5c:2d" alicreate "EMC_5200_B_P3","50:06:01:6b:08:60:5c:2d" alicreate "ESXi10_VMHBA2","10:00:00:90:fa:91:5b:16" alicreate "ESXi12_VMHBA2","10:00:00:90:fa:91:56:a8" alicreate "ESXi14_VMHBA2","10:00:00:90:fa:91:62:a4" alicreate "EMC_Unity_A0","50:06:01:62:47:e0:22:43" alicreate "EMC_Unity_B0","50:06:01:6a:47:e0:22:43" alicreate "ESXi16_VMHBA2","21:00:00:24:ff:88:d6:6b" alicreate "RAC01_F1","10:00:00:10:9b:10:51:a2" alicreate "RAC02_F1","10:00:00:10:9b:10:4b:e0" alicreate "RAC02_F1","10:00:00:10:9b:10:4b:e0" # 2017-12-12 added alicreate "ESXi18_VMHBA1","21:00:00:24:ff:19:6d:20" # 2017-12-25 added alicreate "ESXi20_VMHBA1","21:00:00:24:ff:19:6c:aa" # 2018-01-25 added alicreate "ESXi24_VMHBA1","21:00:00:24:ff:19:6d:12" }}} paste `awk '{ print $1, $2 }' < /tmp/x` `awk '{ print $9 }' < /tmp/xx` == zone create == {{{ zonecreate "EMC_Unity_RAC01","EMC_Unity_A0;EMC_Unity_B0;RAC01_F1" zonecreate "EMC_Unity_RAC02","EMC_Unity_A0;EMC_Unity_B0;RAC02_F1" zonecreate "EMC_Unity_ESXi10","EMC_Unity_A0;EMC_Unity_B0;ESXi10_VMHBA2" zonecreate "EMC_5200_ESXi16","EMC_5200_A_P3;EMC_5200_B_P3;ESXi16_VMHBA2" zonecreate "EMC_5200_ESXi14","EMC_5200_A_P3;EMC_5200_B_P3;ESXi14_VMHBA2" zonecreate "EMC_5200_ESXi12","EMC_5200_A_P3;EMC_5200_B_P3;ESXi12_VMHBA2" zonecreate "EMC_5200_ESXi10","EMC_5200_A_P3;EMC_5200_B_P3;ESXi10_VMHBA2" zonecreate "EMC_5200_RAC01","EMC_5200_A_P3;EMC_5200_B_P3;RAC01_F1" zonecreate "EMC_5200_RAC02","EMC_5200_A_P3;EMC_5200_B_P3;RAC02_F1" zonecreate "IBM_DS5020_AIX_ORACLE","IBM_DS5020_A_F2;IBM_DS5020_B_F1;AIX_ORACLE_FC2" zonecreate "IBM_DS5020_AIX_EAS","IBM_DS5020_A_F2;IBM_DS5020_B_F1;AIX_EAS_FC2" # 20170606 added zonecreate "IBM_DS5020_ESXi16","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi16_VMHBA2" zonecreate "IBM_DS5020_ESXi14","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi14_VMHBA2" zonecreate "IBM_DS5020_ESXi12","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi12_VMHBA2" zonecreate "IBM_DS5020_ESXi10","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi10_VMHBA2" # 2017-12-12 added zonecreate "EMC_5200_ESXi18","EMC_5200_A_P3;EMC_5200_B_P3;ESXi18_VMHBA1" zonecreate "IBM_DS5020_ESXi18","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi18_VMHBA1" # 2017-12-25 added zonecreate "EMC_5200_ESXi20","EMC_5200_A_P3;EMC_5200_B_P3;ESXi20_VMHBA1" zonecreate "IBM_DS5020_ESXi20","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi20_VMHBA1" # 2018-01-25 added zonecreate "EMC_5200_ESXi24","EMC_5200_A_P3;EMC_5200_B_P3;ESXi24_VMHBA1" zonecreate "IBM_DS5020_ESXi24","IBM_DS5020_A_F2;IBM_DS5020_B_F1;ESXi24_VMHBA1" zonecreate "EMC_Unity_ESXi10","EMC_Unity_A0;EMC_Unity_B0;ESXi10_VMHBA2" zonecreate "EMC_Unity_ESXi12","EMC_Unity_A0;EMC_Unity_B0;ESXi12_VMHBA2" zonecreate "EMC_Unity_ESXi14","EMC_Unity_A0;EMC_Unity_B0;ESXi14_VMHBA2" zonecreate "EMC_Unity_ESXi16","EMC_Unity_A0;EMC_Unity_B0;ESXi16_VMHBA2" zonecreate "EMC_Unity_ESXi18","EMC_Unity_A0;EMC_Unity_B0;ESXi18_VMHBA1" zonecreate "EMC_Unity_ESXi20","EMC_Unity_A0;EMC_Unity_B0;ESXi20_VMHBA1" zonecreate "EMC_Unity_ESXi24","EMC_Unity_A0;EMC_Unity_B0;ESXi24_VMHBA1" --- }}} == enable zone & config == {{{ cfgcreate "MLS_SAN01","EMC_Unity_RAC01;EMC_Unity_RAC02;EMC_5200_ESXi16;EMC_5200_ESXi14;EMC_5200_ESXi12;EMC_5200_ESXi10;IBM_DS5020_AIX_EAS;IBM_DS5020_AIX_ORACLE" cfgadd "MLS_SAN01","EMC_5200_RAC01;EMC_5200_RAC02" cfgadd "MLS_SAN01","EMC_Unity_ESXi10" # 20170606 added cfgadd "MLS_SAN01","IBM_DS5020_ESXi16;IBM_DS5020_ESXi10;IBM_DS5020_ESXi12;IBM_DS5020_ESXi14" # 2017-12-12 added cfgadd "MLS_SAN01","EMC_5200_ESXi18;IBM_DS5020_ESXi18" # 2017-12-25 added cfgadd "MLS_SAN01","EMC_5200_ESXi20;IBM_DS5020_ESXi20" # 2018-01-25 added cfgadd "MLS_SAN01","EMC_5200_ESXi24;IBM_DS5020_ESXi24" cfgadd "MLS_SAN01","EMC_Unity_ESXi10;EMC_Unity_ESXi12;EMC_Unity_ESXi14;EMC_Unity_ESXi16;EMC_Unity_ESXi18;EMC_Unity_ESXi20" cfgadd "MLS_SAN01","EMC_Unity_ESXi24" cfgenable MLS_SAN01 cfgsave MLS_SAN01 }}} = SAN02 = # awk '{ print "alicreate", "\""$1"\",","", "\" \"" }' < x == alicreate == {{{ # 2017-12-12 added alicreate "ESXi18_VMHBA2","21:00:00:24:ff:19:6d:21" # 2017-12-25 added alicreate "ESXi20_VMHBA2","21:00:00:24:ff:19:6c:ab" # 2018-01-25 added alicreate "ESXi24_VMHBA2","21:00:00:24:ff:19:6d:13" alicreate "IBM_DS5020_A_F1","20:14:00:80:e5:18:85:00" alicreate "AIX_EAS_FC0","10:00:00:00:c9:95:df:3e" alicreate "AIX_ORACLE_FC0","10:00:00:00:c9:95:d5:a3" alicreate "IBM_DS5020_B_F2","20:25:00:80:e5:18:85:00" alicreate "EMC_5200_A_P2","50:06:01:62:08:60:5c:2d" alicreate "EMC_5200_B_P2","50:06:01:6a:08:60:5c:2d" alicreate "ESXi10_VMHBA1","10:00:00:90:fa:91:5b:17" alicreate "ESXi12_VMHBA3","10:00:00:90:fa:91:56:a9" alicreate "OLD_OA_FC","21:00:00:1b:32:80:b8:78" alicreate "ESXi14_VMHBA3","10:00:00:90:fa:91:62:a5" alicreate "EMC_Unity_A1","50:06:01:63:47:e0:22:43" alicreate "EMC_Unity_B1","50:06:01:6b:47:e0:22:43" alicreate "ESXi16_VMHBA4","21:00:00:24:ff:0f:ea:75" alicreate "RAC01_F2","10:00:00:10:9b:10:50:83" alicreate "RAC02_F2","10:00:00:10:9b:10:4d:e8" }}} == zone create == {{{ # 2017-12-12 added zonecreate "EMC_5200_ESXi18","EMC_5200_A_P2;EMC_5200_B_P2;ESXi18_VMHBA2" zonecreate "IBM_DS5020_ESXi18","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi18_VMHBA2" --- # 2017-12-25 added zonecreate "EMC_5200_ESXi20","EMC_5200_A_P2;EMC_5200_B_P2;ESXi20_VMHBA2" zonecreate "IBM_DS5020_ESXi20","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi20_VMHBA2" # 2018-01-25 added zonecreate "EMC_5200_ESXi24","EMC_5200_A_P2;EMC_5200_B_P2;ESXi24_VMHBA2" zonecreate "IBM_DS5020_ESXi24","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi24_VMHBA2" zonecreate "EMC_Unity_ESXi10","EMC_Unity_A1;EMC_Unity_B1;ESXi10_VMHBA1" zonecreate "EMC_Unity_ESXi12","EMC_Unity_A1;EMC_Unity_B1;ESXi12_VMHBA3" zonecreate "EMC_Unity_ESXi14","EMC_Unity_A1;EMC_Unity_B1;ESXi14_VMHBA3" zonecreate "EMC_Unity_ESXi16","EMC_Unity_A1;EMC_Unity_B1;ESXi16_VMHBA4" zonecreate "EMC_Unity_ESXi18","EMC_Unity_A1;EMC_Unity_B1;ESXi18_VMHBA2" zonecreate "EMC_Unity_ESXi20","EMC_Unity_A1;EMC_Unity_B1;ESXi20_VMHBA2" zonecreate "EMC_Unity_ESXi24","EMC_Unity_A1;EMC_Unity_B1;ESXi24_VMHBA2" --- zonecreate "EMC_Unity_RAC01","EMC_Unity_A1;EMC_Unity_B1;RAC01_F2" zonecreate "EMC_Unity_RAC02","EMC_Unity_A1;EMC_Unity_B1;RAC02_F2" zonecreate "EMC_Unity_ESXi10","EMC_Unity_A1;EMC_Unity_B1;ESXi10_VMHBA1" zonecreate "EMC_5200_ESXi16","EMC_5200_A_P2;EMC_5200_B_P2;ESXi16_VMHBA4" zonecreate "EMC_5200_ESXi14","EMC_5200_A_P2;EMC_5200_B_P2;ESXi14_VMHBA3" zonecreate "EMC_5200_ESXi12","EMC_5200_A_P2;EMC_5200_B_P2;ESXi12_VMHBA3" zonecreate "EMC_5200_ESXi10","EMC_5200_A_P2;EMC_5200_B_P2;ESXi10_VMHBA1" zonecreate "EMC_5200_RAC01","EMC_5200_A_P2;EMC_5200_B_P2;RAC01_F2" zonecreate "EMC_5200_RAC02","EMC_5200_A_P2;EMC_5200_B_P2;RAC02_F2" zonecreate "IBM_DS5020_AIX_ORACLE","IBM_DS5020_A_F1;IBM_DS5020_B_F2;AIX_ORACLE_FC0" zonecreate "IBM_DS5020_AIX_EAS","IBM_DS5020_A_F1;IBM_DS5020_B_F2;AIX_EAS_FC0" zonecreate "IBM_DS5020_OLD_OA","IBM_DS5020_A_F1;IBM_DS5020_B_F2;OLD_OA_FC" # 20170606 added zonecreate "IBM_DS5020_ESXi16","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi16_VMHBA4" zonecreate "IBM_DS5020_ESXi14","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi14_VMHBA3" zonecreate "IBM_DS5020_ESXi12","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi12_VMHBA3" zonecreate "IBM_DS5020_ESXi10","IBM_DS5020_A_F1;IBM_DS5020_B_F2;ESXi10_VMHBA1" }}} == enable zone & config == # cat xxx | grep zonecre | awk -F"\"" '{ print $2 }' | sort | fmt | tr '\n' ' ' | tr ' ' ';' >> /tmp/tmp6fzBu_.moin {{{ cfgcreate "MLS_SAN02","EMC_Unity_RAC01;EMC_Unity_RAC02;EMC_5200_ESXi16;EMC_5200_ESXi14;EMC_5200_ESXi12;EMC_5200_ESXi10;IBM_DS5020_AIX_EAS;IBM_DS5020_AIX_ORACLE;IBM_DS5020_OLD_OA" cfgadd "MLS_SAN02","EMC_5200_RAC01;EMC_5200_RAC02" cfgadd "MLS_SAN02","EMC_Unity_ESXi10" # 20170606 added cfgadd "MLS_SAN02","IBM_DS5020_ESXi16;IBM_DS5020_ESXi10;IBM_DS5020_ESXi12;IBM_DS5020_ESXi14" # 2017-12-12 added cfgadd "MLS_SAN02","EMC_5200_ESXi18;IBM_DS5020_ESXi18" # 2017-12-25 added cfgadd "MLS_SAN02","EMC_5200_ESXi20;IBM_DS5020_ESXi20" # 2018-01-25 added cfgadd "MLS_SAN02","EMC_5200_ESXi24;IBM_DS5020_ESXi24" cfgadd "MLS_SAN02","EMC_Unity_ESXi24;" cfgadd "MLS_SAN02","EMC_Unity_ESXi10;EMC_Unity_ESXi12;EMC_Unity_ESXi14;EMC_Unity_ESXi16;EMC_Unity_ESXi18;EMC_Unity_ESXi20;" cfgenable MLS_SAN02 cfgsave MLS_SAN02 }}} = Oracle RAC = == oracleasm == [root@mls-rac01 sysconfig]# cat oracleasm-_dev_oracleasm {{{ # # This is a configuration file for automatic loading of the Oracle # Automatic Storage Management library kernel driver. It is generated # By running /etc/init.d/oracleasm configure. Please use that method # to modify this file # # ORACLEASM_ENABLED: 'true' means to load the driver on boot. ORACLEASM_ENABLED=true # ORACLEASM_UID: Default user owning the /dev/oracleasm mount point. ORACLEASM_UID=grid # ORACLEASM_GID: Default group owning the /dev/oracleasm mount point. ORACLEASM_GID=asmadmin # ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot. ORACLEASM_SCANBOOT=true # ORACLEASM_SCANORDER: Matching patterns to order disk scanning ORACLEASM_SCANORDER="emcpower" # ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan ORACLEASM_SCANEXCLUDE="sd" # ORACLEASM_USE_LOGICAL_BLOCK_SIZE: 'true' means use the logical block size # reported by the underlying disk instead of the physical. The default # is 'false' ORACLEASM_USE_LOGICAL_BLOCK_SIZE=false }}} == Reboot Unity 400F Controller == 當我重啓Unity 400F存儲A控制器之後，在Linux上查看鏈路狀態。 {{{ Pseudo name=emcpowerv Unity ID=CETV3170300043 [Host_5] Logical device ID=600601604120440029BCF9580D7F06B0 [Oracle_CRS01] state=alive; policy=CLAROpt; queued-IOs=0 Owner: default=SP B, current=SP B Array failover mode: 4 ============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats --- ### HW Path I/O Paths Interf. Mode State Q-IOs Errors ============================================================================== 1 lpfc sdaf SP B2 active alive 0 0 2 UNKNOWN unknown SP A3 active dead 0 1 2 lpfc sdcc SP B3 active alive 0 0 1 UNKNOWN unknown SP A2 active dead 0 1 Pseudo name=emcpowerw Unity ID=CETV3170300043 [Host_5] Logical device ID=60060160412044002ABCF9581317ECC8 [Oracle_CRS04] state=alive; policy=CLAROpt; queued-IOs=0 Owner: default=SP A, current=SP B Array failover mode: 4 ============================================================================== --------------- Host --------------- - Stor - -- I/O Path -- -- Stats --- ### HW Path I/O Paths Interf. Mode State Q-IOs Errors ============================================================================== 1 lpfc sdae SP B2 active alive 0 0 2 UNKNOWN unknown SP A3 active dead 0 1 2 lpfc sdcb SP B3 active alive 0 0 1 UNKNOWN unknown SP A2 active dead 0 1 }}} Oracle Instances狀態均正常。 {{{ [grid@mls-rac02 ~]$ crsctl status resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.CRS.dg ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.EAS_DATA.dg ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.HR_DATA.dg ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.LISTENER.lsnr ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.M_DATA.dg ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.REDO.dg ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.asm ONLINE ONLINE mls-rac01 Started ONLINE ONLINE mls-rac02 Started ora.gsd OFFLINE OFFLINE mls-rac01 OFFLINE OFFLINE mls-rac02 ora.net1.network ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.ons ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 ora.registry.acfs ONLINE ONLINE mls-rac01 ONLINE ONLINE mls-rac02 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE mls-rac02 ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE mls-rac01 ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE mls-rac01 ora.cvu 1 ONLINE ONLINE mls-rac01 ora.easdb.db 1 ONLINE ONLINE mls-rac01 Open 2 ONLINE ONLINE mls-rac02 Open ora.hrdb.db 1 ONLINE ONLINE mls-rac01 Open 2 ONLINE ONLINE mls-rac02 Open ora.mdb.db 1 ONLINE ONLINE mls-rac01 Open 2 ONLINE ONLINE mls-rac02 Open ora.mls-rac01.vip 1 ONLINE ONLINE mls-rac01 ora.mls-rac02.vip 1 ONLINE ONLINE mls-rac02 ora.oc4j 1 ONLINE ONLINE mls-rac01 ora.scan1.vip 1 ONLINE ONLINE mls-rac02 ora.scan2.vip 1 ONLINE ONLINE mls-rac01 ora.scan3.vip 1 ONLINE ONLINE mls-rac01 }}} == Delete Unity 400F LUN mapping == 当我在Unity 400F上删除CRS* LUN mapping 之后,可以发现ASM CRS磁盘组空间变少。 === Unmapping before === {{{ [grid@mls-rac01 ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 409530 409243 102399 153422 0 N ARCH/ MOUNTED HIGH N 512 4096 1048576 9207 7943 2046 1965 0 Y CRS/ MOUNTED EXTERN N 512 4096 1048576 819056 511259 0 511259 0 N EAS_DATA/ MOUNTED NORMAL N 512 4096 1048576 614295 609823 102399 253712 0 N HR_DATA/ MOUNTED EXTERN N 512 4096 1048576 2047805 2038519 0 2038519 0 N M_DATA/ MOUNTED NORMAL N 512 4096 1048576 122778 122487 20479 51004 0 N REDO/ }}} === Unmapping after === {{{ [grid@mls-rac01 ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 409530 409243 102399 153422 0 N ARCH/ MOUNTED HIGH N 512 4096 1048576 8184 6922 2046 1625 0 Y CRS/ MOUNTED EXTERN N 512 4096 1048576 819056 511259 0 511259 0 N EAS_DATA/ MOUNTED NORMAL N 512 4096 1048576 614295 609823 102399 253712 0 N HR_DATA/ MOUNTED EXTERN N 512 4096 1048576 2047805 2038519 0 2038519 0 N M_DATA/ MOUNTED NORMAL N 512 4096 1048576 122778 122487 20479 51004 0 N REDO/ }}} ASM log /u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log 显示如下 {{{ Fri May 05 13:27:36 2017 WARNING: Waited 15 secs for write IO to PST disk 3 in group 2. WARNING: Waited 15 secs for write IO to PST disk 3 in group 2. Fri May 05 13:27:50 2017 WARNING: Read Failed. group:2 disk:3 AU:1 offset:4096 size:4096 WARNING: Read Failed. group:2 disk:3 AU:1 offset:0 size:4096 WARNING: Write Failed. group:2 disk:3 AU:1 offset:4096 size:4096 NOTE: group CRS: updated PST location: disk 0000 (PST copy 0) NOTE: group CRS: updated PST location: disk 0001 (PST copy 1) NOTE: group CRS: updated PST location: disk 0002 (PST copy 2) NOTE: group CRS: updated PST location: disk 0005 (PST copy 3) NOTE: group CRS: updated PST location: disk 0006 (PST copy 4) WARNING: Write Failed. group:2 disk:3 AU:1 offset:1044480 size:4096 WARNING: Hbeat write to PST disk 3.3915950009 in group 2 failed. [4] Fri May 05 13:27:50 2017 NOTE: process _b000_+asm1 (24395) initiating offline of disk 3.3915950009 (ORACLECRS02) with mask 0x7e in group 2 NOTE: checking PST: grp = 2 GMON checking disk modes for group 2 at 34 for pid 27, osid 24395 NOTE: checking PST for grp 2 done. NOTE: sending set offline flag message 3808991711 to 1 disk(s) in group 2 WARNING: Disk ORACLECRS02 in mode 0x7f is now being offlined NOTE: initiating PST update: grp = 2, dsk = 3/0xe968a7b9, mask = 0x6a, op = clear GMON updating disk modes for group 2 at 35 for pid 27, osid 24395 NOTE: PST update grp = 2 completed successfully NOTE: initiating PST update: grp = 2, dsk = 3/0xe968a7b9, mask = 0x7e, op = clear GMON updating disk modes for group 2 at 36 for pid 27, osid 24395 NOTE: cache closing disk 3 of grp 2: ORACLECRS02 NOTE: PST update grp = 2 completed successfully Fri May 05 13:27:54 2017 NOTE: Attempting voting file refresh on diskgroup CRS NOTE: Refresh completed on diskgroup CRS . Found 5 voting file(s). NOTE: Voting file relocation is required in diskgroup CRS NOTE: Attempting voting file relocation on diskgroup CRS NOTE: Successful voting file relocation on diskgroup CRS Fri May 05 13:29:26 2017 WARNING: PST-initiated drop of 1 disk(s) in group 2(.2963822433)) SQL> alter diskgroup CRS drop disk ORACLECRS02 force /* ASM SERVER */ NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=2 Fri May 05 13:29:28 2017 GMON updating for reconfiguration, group 2 at 37 for pid 27, osid 24395 NOTE: cache closing disk 3 of grp 2: (not open) ORACLECRS02 NOTE: group 2 PST updated. Fri May 05 13:29:28 2017 NOTE: membership refresh pending for group 2/0xb0a85761 (CRS) GMON querying group 2 at 38 for pid 18, osid 18836 NOTE: cache closing disk 3 of grp 2: (not open) _DROPPED_0003_CRS SUCCESS: refreshed membership for 2/0xb0a85761 (CRS) SUCCESS: alter diskgroup CRS drop disk ORACLECRS02 force /* ASM SERVER */ SUCCESS: PST-initiated drop disk in group 2(2963822433)) NOTE: Attempting voting file refresh on diskgroup CRS NOTE: Refresh completed on diskgroup CRS . Found 5 voting file(s). NOTE: starting rebalance of group 2/0xb0a85761 (CRS) at power 1 Starting background process ARB0 Fri May 05 13:29:33 2017 ARB0 started with pid=34, OS id=27347 NOTE: assigning ARB0 to group 2/0xb0a85761 (CRS) with 1 parallel I/O cellip.ora not found. NOTE: Rebalance has restored redundancy for any existing control file or redo log in disk group CRS NOTE: stopping process ARB0 SUCCESS: rebalance completed for group 2/0xb0a85761 (CRS) Fri May 05 13:29:36 2017 NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=2 Fri May 05 13:29:39 2017 GMON updating for reconfiguration, group 2 at 39 for pid 32, osid 26302 NOTE: cache closing disk 3 of grp 2: (not open) _DROPPED_0003_CRS NOTE: group 2 PST updated. SUCCESS: grp 2 disk _DROPPED_0003_CRS going offline GMON updating for reconfiguration, group 2 at 40 for pid 32, osid 26302 NOTE: cache closing disk 3 of grp 2: (not open) _DROPPED_0003_CRS NOTE: group 2 PST updated. Fri May 05 13:29:39 2017 NOTE: membership refresh pending for group 2/0xb0a85761 (CRS) GMON querying group 2 at 41 for pid 18, osid 18836 GMON querying group 2 at 42 for pid 18, osid 18836 NOTE: Disk _DROPPED_0003_CRS in mode 0x0 marked for de-assignment SUCCESS: refreshed membership for 2/0xb0a85761 (CRS) NOTE: Attempting voting file refresh on diskgroup CRS NOTE: Refresh completed on diskgroup CRS . Found 5 voting file(s). }}} 以上操作之后，数据库运行状态正常。 = add new controlfile location = == HRDB == === STEP 1. Check the current control file status by Connecting to the database from any one for the RAC node. === {{{ SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- +HR_DATA/hrdb/controlfile/current.260.942256709 }}} === STEP 2. Modify control_files parameter by adding the new disk group === {{{ SQL> alter system set control_files='+HR_DATA/hrdb/controlfile/current.260.942256709','+CRS' scope=spfile; System altered. }}} === STEP 3. Shutdown the RAC database and start the database in nomount mode. === {{{ [grid@mls-rac02 ~]$ srvctl stop database -d hrdb [grid@mls-rac02 ~]$ srvctl start database -d hrdb -o nomount }}} === STEP 4. Check the database to see if new diskgroup has been added to the control_files parameter === {{{ SQL> set linesize 500 SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ control_files string +HR_DATA/hrdb/controlfile/curr ent.260.942256709, +CRS }}} === STEP 5. Connect to RMAN and use restore command to create a copy of the control file === {{{ [oracle@mls-rac02 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on 星期三 5月 10 14:53:55 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: HRDB (not mounted) RMAN> restore controlfile from '+HR_DATA/hrdb/controlfile/current.260.942256709'; Starting restore at 10-5月 -2017 14:54:32 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=225 instance=HRDB2 device type=DISK channel ORA_DISK_1: copied control file copy output file name=+HR_DATA/hrdb/controlfile/current.260.942256709 output file name=+CRS/hrdb/controlfile/current.256.943628075 Finished restore at 10-5月 -2017 14:54:34 }}} As you can see above new control file. +CRS/hrdb/controlfile/current.256.943628075 has been generated. === STEP 6. Use ‘alter system..’ command to modify the control_files parameter === {{{ SQL> alter system set control_files='+HR_DATA/hrdb/controlfile/current.260.942256709','+CRS/hrdb/controlfile/current.256.943628075' scope=spfile; }}} === STEP 7. Shutdown the database and start up normal. === {{{ [grid@mls-rac02 ~]$ srvctl stop database -d hrdb [grid@mls-rac02 ~]$ srvctl start database -d hrdb }}} {{{ SQL> show parameter control_files; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string +HR_DATA/hrdb/controlfile/curr ent.260.942256709, +CRS/hrdb/controlfile/current.256.9436280 }}} How To Mirror Controlfile To FRA On ASM [ID 1305674.1] = Veritas Netbackup backup Oracle RAC = == nbumaster == * Login in NBU appliance {{{ nbumaster.Support> Maintenance maintenance's password: maintenance-!> elevate nbumaster:/home/maintenance # # # hosts This file describes a number of hostname-to-address # mappings for the TCP/IP subsystem. It is mostly # used at boot time, when no name servers are running. # On small systems, this file can be used instead of a # "named" name server. # Syntax: # # IP-Address Full-Qualified-Hostname Short-Hostname # 127.0.0.1 localhost # special IPv6 addresses ::1 localhost ipv6-localhost ipv6-loopback # # hosts This file describes a number of hostname-to-address # mappings for the TCP/IP subsystem. It is mostly # used at boot time, when no name servers are running. # On small systems, this file can be used instead of a # "named" name server. # Syntax: # # IP-Address Full-Qualified-Hostname Short-Hostname # 127.0.0.1 localhost # special IPv6 addresses ::1 localhost ipv6-localhost ipv6-loopback fe00::0 ipv6-localnet ff00::0 ipv6-mcastprefix ff02::1 ipv6-allnodes ff02::2 ipv6-allrouters ff02::3 ipv6-allhosts 192.168.17.36 nbumaster nbumaster 192.168.16.101 ufserver11 ufserver11 10.10.10.2 WINDOWS-LFSKV9O WINDOWS-LFSKV9O 192.168.17.31 AntiServer AntiServer 192.168.0.7 mls4 mls4 192.168.0.9 mls mls 192.168.0.20 eset eset 192.168.17.30 isp-654e143a2e3 isp-654e143a2e3 192.168.0.12 co co 192.168.0.14 2012-09121413 2012-09121413 192.168.17.210 nbutestserver nbutestserver 192.168.17.211 testclient testclient 192.168.17.39 WIN-30I007D42SA WIN-30I007D42SA 192.168.16.22 vCenter vCenter # Change from 16.20 to 16.22 192.168.17.22 t1dbserver t1dbserver 192.168.17.10 WINDOWSDB WINDOWSDB 192.168.17.43 testdb testdb 192.168.17.13 oracle oracle 192.168.17.12 eas eas 192.168.17.6 test test 10.10.0.1 XMGUKDQNPVYW7EO XMGUKDQNPVYW7EO 192.168.17.37 opscenter opscenter 192.168.24.73 it003 it003 192.168.17.161 mls-rac01 192.168.17.162 mls-rac02 }}} = Troubleshooting = == cannot start&stop crs == {{{ [root@mls-rac02 ~]# crsctl start crs CRS-4640: Oracle High Availability Services is already active CRS-4000: Command Start failed, or completed with errors. [root@mls-rac02 ~]# crsctl stat res -init -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE mls-rac02 Started ora.cluster_interconnect.haip 1 ONLINE ONLINE mls-rac02 ora.crf 1 ONLINE ONLINE mls-rac02 ora.crsd 1 ONLINE INTERMEDIATE mls-rac02 ora.cssd 1 ONLINE ONLINE mls-rac02 ora.cssdmonitor 1 ONLINE ONLINE mls-rac02 ora.ctssd 1 ONLINE ONLINE mls-rac02 OBSERVER ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 ONLINE ONLINE mls-rac02 ora.evmd 1 ONLINE INTERMEDIATE mls-rac02 ora.gipcd 1 ONLINE ONLINE mls-rac02 ora.gpnpd 1 ONLINE ONLINE mls-rac02 ora.mdnsd 1 ONLINE ONLINE mls-rac02 [root@mls-rac02 ~]# crsctl stop crs CRS-2796: The command may not proceed when Cluster Ready Services is not running CRS-4687: Shutdown command has completed with errors. CRS-4000: Command Stop failed, or completed with errors. [root@mls-rac02 ~]# crsctl stop res -init -all CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.crf' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.crsd' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.asm' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.ctssd' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.evmd' on 'mls-rac02' CRS-2673: Attempting to stop 'ora.mdnsd' on 'mls-rac02' CRS-2677: Stop of 'ora.crf' on 'mls-rac02' succeeded CRS-2677: Stop of 'ora.crsd' on 'mls-rac02' succeeded CRS-2677: Stop of 'ora.evmd' on 'mls-rac02' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'mls-rac02' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'mls-rac02' succeeded CRS-2677: Stop of 'ora.ctssd' on 'mls-rac02' succeeded CRS-5022: Stop of resource "ora.asm" failed: current state is "UNKNOWN" CRS-2675: Stop of 'ora.asm' on 'mls-rac02' failed CRS-2679: Attempting to clean 'ora.asm' on 'mls-rac02' CRS-2677: Stop of 'ora.drivers.acfs' on 'mls-rac02' succeeded CRS-2681: Clean of 'ora.asm' on 'mls-rac02' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'mls-rac02' CRS-2677: Stop of 'ora.cssd' on 'mls-rac02' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'mls-rac02' CRS-2789: Cannot stop resource 'ora.cssdmonitor' as it is not running on server 'mls-rac02' CRS-2677: Stop of 'ora.gipcd' on 'mls-rac02' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'mls-rac02' CRS-2677: Stop of 'ora.gpnpd' on 'mls-rac02' succeeded CRS-4000: Command Stop failed, or completed with errors. [root@mls-rac02 ~]# [root@mls-rac02 ~]# [root@mls-rac02 ~]# [root@mls-rac02 ~]# crsctl stat res -init -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 OFFLINE OFFLINE ora.cluster_interconnect.haip 1 OFFLINE OFFLINE ora.crf 1 OFFLINE OFFLINE ora.crsd 1 OFFLINE OFFLINE ora.cssd 1 OFFLINE OFFLINE ora.cssdmonitor 1 OFFLINE OFFLINE ora.ctssd 1 OFFLINE OFFLINE ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 OFFLINE OFFLINE ora.evmd 1 OFFLINE OFFLINE ora.gipcd 1 OFFLINE OFFLINE ora.gpnpd 1 OFFLINE OFFLINE ora.mdnsd 1 OFFLINE OFFLINE [root@mls-rac02 ~]# crsctl start crs CRS-4640: Oracle High Availability Services is already active CRS-4000: Command Start failed, or completed with errors. [root@mls-rac02 ~]# crsctl start cluster CRS-2672: Attempting to start 'ora.mdnsd' on 'mls-rac02' CRS-2672: Attempting to start 'ora.drivers.acfs' on 'mls-rac02' CRS-2676: Start of 'ora.mdnsd' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'mls-rac02' CRS-2676: Start of 'ora.drivers.acfs' on 'mls-rac02' succeeded CRS-2676: Start of 'ora.gpnpd' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'mls-rac02' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'mls-rac02' CRS-2676: Start of 'ora.cssdmonitor' on 'mls-rac02' succeeded CRS-2676: Start of 'ora.gipcd' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'mls-rac02' CRS-2672: Attempting to start 'ora.diskmon' on 'mls-rac02' CRS-2676: Start of 'ora.diskmon' on 'mls-rac02' succeeded CRS-2676: Start of 'ora.cssd' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'mls-rac02' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'mls-rac02' CRS-2676: Start of 'ora.ctssd' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'mls-rac02' CRS-2676: Start of 'ora.evmd' on 'mls-rac02' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.asm' on 'mls-rac02' CRS-2676: Start of 'ora.asm' on 'mls-rac02' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'mls-rac02' CRS-2676: Start of 'ora.crsd' on 'mls-rac02' succeeded [root@mls-rac02 ~]# crsctl stat res -init -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE mls-rac02 Started ora.cluster_interconnect.haip 1 ONLINE ONLINE mls-rac02 ora.crf 1 OFFLINE OFFLINE ora.crsd 1 ONLINE INTERMEDIATE mls-rac02 ora.cssd 1 ONLINE ONLINE mls-rac02 ora.cssdmonitor 1 ONLINE ONLINE mls-rac02 ora.ctssd 1 ONLINE ONLINE mls-rac02 OBSERVER ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 ONLINE ONLINE mls-rac02 ora.evmd 1 ONLINE ONLINE mls-rac02 ora.gipcd 1 ONLINE ONLINE mls-rac02 ora.gpnpd 1 ONLINE ONLINE mls-rac02 ora.mdnsd 1 ONLINE ONLINE mls-rac02 [root@mls-rac02 ~]# crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [root@mls-rac02 ~]# crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [root@mls-rac02 ~]# }}} == Process 0x0x9887c4208 appears to be hung in Auto SQL Tuning task == licenseshow cedbR9SRydfecSv: Fabric license bdzydd9yzccu0zeI: First Ports on Demand license - additional 8 port upgrade license 7tC9PHfAQH3LZfYCRBWJNL3TQWaWXRWTBAHfQ: Enhanced Group Management license 9YaDMS9mXYFYBmNKLHGFTff9ggaMfBJ3BA7XE: 8 Gig FC license MLS-SAN01:admin> wwn 10:00:00:05:33:44:0f:10 MLS-SAN01:admin> licenseadd Rz9ReQzczSSGESf9 adding license-key [Rz9ReQzczSSGESf9] For license change to take effect, use portdisable/portenable or switchdisable/switchenable commands... MLS-SAN01:admin> licenseshow cedbR9SRydfecSv: Fabric license bdzydd9yzccu0zeI: First Ports on Demand license - additional 8 port upgrade license Rz9ReQzczSSGESf9: Remote Switch license Full Ports on Demand license - additional 16 port upgrade license 7tC9PHfAQH3LZfYCRBWJNL3TQWaWXRWTBAHfQ: Enhanced Group Management license 9YaDMS9mXYFYBmNKLHGFTff9ggaMfBJ3BA7XE: 8 Gig FC license MLS-SAN01:admin> switchshow switchName: MLS-SAN01 switchType: 71.2 switchState: Online switchMode: Native switchRole: Principal switchDomain: 1 switchId: fffc01 switchWwn: 10:00:00:05:33:44:0f:10 zoning: ON (MLS_SAN01) switchBeacon: OFF Index Port Address Media Speed State Proto ============================================== 0 0 010000 id N8 Online FC F-Port 20:15:00:80:e5:18:85:00 1 1 010100 id N4 Online FC F-Port 10:00:00:00:c9:9c:19:bb 2 2 010200 id N4 Online FC F-Port 10:00:00:00:c9:95:d8:65 3 3 010300 id N8 Online FC F-Port 20:24:00:80:e5:18:85:00 4 4 010400 id N8 Online FC F-Port 50:06:01:63:08:60:5c:2d 5 5 010500 id N8 Online FC F-Port 50:06:01:6b:08:60:5c:2d 6 6 010600 id N8 Online FC F-Port 10:00:00:90:fa:91:5b:16 7 7 010700 id N8 Online FC F-Port 10:00:00:90:fa:91:56:a8 8 8 010800 id N8 Online FC F-Port 21:00:00:24:ff:19:6c:aa 9 9 010900 id N8 Online FC F-Port 10:00:00:90:fa:91:62:a4 10 10 010a00 id N8 Online FC F-Port 50:06:01:62:47:e0:22:43 11 11 010b00 id N8 Online FC F-Port 50:06:01:6a:47:e0:22:43 12 12 010c00 id N8 Online FC F-Port 21:00:00:24:ff:88:d6:6b 13 13 010d00 id N8 Online FC F-Port 10:00:00:10:9b:10:51:a2 14 14 010e00 id N8 Online FC F-Port 10:00:00:10:9b:10:4b:e0 15 15 010f00 id N8 Online FC F-Port 21:00:00:24:ff:19:6d:20 16 16 011000 id N8 Online FC F-Port 21:00:00:24:ff:19:6d:12 17 17 011100 id N8 No_Light FC Disabled 18 18 011200 id N8 No_Light FC Disabled 19 19 011300 id N8 No_Light FC Disabled 20 20 011400 id N8 No_Light FC Disabled 21 21 011500 id N8 No_Light FC Disabled 22 22 011600 id N8 No_Light FC Disabled 23 23 011700 id N8 No_Light FC Disabled MLS-SAN01:admin> }}} == mls-san02 == {{{ MLS-SAN02:admin> wwn 10:00:00:05:33:43:75:75 MLS-SAN02:admin> licenseshow bdzzdeyRdcce00e1: Fabric license ScRdzcQcSdTtSe0I: First Ports on Demand license - additional 8 port upgrade license PGtPSBEPH74r4RfGAX97RaZrJaLgTGBNBJWtJ: Enhanced Group Management license HtJ3TQTJLWN7gKgPmm9DtJLFAtMCgLNMB7KDE: 8 Gig FC license MLS-SAN02:admin> licenseadd ScbRcbeScRTtgSdZ adding license-key [ScbRcbeScRTtgSdZ] For license change to take effect, use portdisable/portenable or switchdisable/switchenable commands... MLS-SAN02:admin> licenseshow bdzzdeyRdcce00e1: Fabric license ScRdzcQcSdTtSe0I: First Ports on Demand license - additional 8 port upgrade license ScbRcbeScRTtgSdZ: Remote Fabric license Full Ports on Demand license - additional 16 port upgrade license PGtPSBEPH74r4RfGAX97RaZrJaLgTGBNBJWtJ: Enhanced Group Management license HtJ3TQTJLWN7gKgPmm9DtJLFAtMCgLNMB7KDE: 8 Gig FC license MLS-SAN02:admin> switchshow switchName: MLS-SAN02 switchType: 71.2 switchState: Online switchMode: Native switchRole: Principal switchDomain: 1 switchId: fffc01 switchWwn: 10:00:00:05:33:43:75:75 zoning: ON (MLS_SAN02) switchBeacon: OFF Index Port Address Media Speed State Proto ============================================== 0 0 010000 id N8 Online FC F-Port 20:14:00:80:e5:18:85:00 1 1 010100 id N4 Online FC F-Port 10:00:00:00:c9:95:df:3e 2 2 010200 id N4 Online FC F-Port 10:00:00:00:c9:95:d5:a3 3 3 010300 id N8 Online FC F-Port 20:25:00:80:e5:18:85:00 4 4 010400 id N8 Online FC F-Port 50:06:01:62:08:60:5c:2d 5 5 010500 id N8 Online FC F-Port 50:06:01:6a:08:60:5c:2d 6 6 010600 id N8 Online FC F-Port 10:00:00:90:fa:91:5b:17 7 7 010700 id N8 Online FC F-Port 10:00:00:90:fa:91:56:a9 8 8 010800 id N8 Online FC F-Port 21:00:00:24:ff:19:6c:ab 9 9 010900 id N8 Online FC F-Port 10:00:00:90:fa:91:62:a5 10 10 010a00 id N8 Online FC F-Port 50:06:01:63:47:e0:22:43 11 11 010b00 id N8 Online FC F-Port 50:06:01:6b:47:e0:22:43 12 12 010c00 id N8 Online FC F-Port 21:00:00:24:ff:0f:ea:75 13 13 010d00 id N8 Online FC F-Port 10:00:00:10:9b:10:50:83 14 14 010e00 id N8 Online FC F-Port 10:00:00:10:9b:10:4d:e8 15 15 010f00 id N8 Online FC F-Port 21:00:00:24:ff:19:6d:21 16 16 011000 id N8 Online FC F-Port 21:00:00:24:ff:19:6d:13 17 17 011100 id N8 No_Light FC Disabled 18 18 011200 id N8 No_Light FC Disabled 19 19 011300 id N8 No_Light FC Disabled 20 20 011400 id N8 No_Light FC Disabled 21 21 011500 id N8 No_Light FC Disabled 22 22 011600 id N8 No_Light FC Disabled 23 23 011700 id N8 No_Light FC Disabled }}} == umount datastore == {{{ [root@vSAN-ESXi01-1:~] esxcli storage vmfs extent list Volume Name VMFS UUID Extent Number Device Name Partition ----------------------- ----------------------------------- ------------- -------------------- --------- vSAN-ESXi01-LocalDisk01 5a6763b9-6e159232-1855-90e2baf65204 0 naa.50000398384a6925 1 [root@vSAN-ESXi01-1:~] lsof | grep 5a6763b9-6e159232-1855-90e2baf65204 esxcli storage filesystem unmount -u 5a6763b9-6e159232-1855-90e2baf65204 }}} = References = * http://satya-dba.blogspot.com/2009/05/auditing-in-oracle.html * http://www.toadworld.com/platforms/oracle/w/wiki/1229.enabling-and-disabling-auditing = vCenter EVC = I. 创建一个新的6.5 vCenter with extent PSC. I. 从现有的群集中腾出三台主机，加入vCenter6.5，创建一个新的群集，新的群集启用EVC。 I. 将现有群集的VC6.0的PSC注册至6.5的PSC Server. I. 逐步迁移生产VM虚拟机至新的6.5群集中。 I. 升级现有的ESXi6.0至6.5。 I. 最终结果是有两个群集，一个用于生产，一个用于测试。 注：将创建两个群集 = Appliance 5240 initialization = {{{ > LinkAggregation Create eth0,eth1 active-backup > IPv4 192.168.17.187 255.255.255.0 bond0 > Ping 192.168.17.254 > Gateway Add 192.168.17.254 > Unconfigure bond0 > LinkAggregation Delete bond0 }}} = TEAMVIEWER = {{{ 1323520521 / Jamls@2018 }}} = NOTES = == 20190228 == {{{ VNX5200 firmware upgrade plan, case ID: 13608496 expected date is 3.10 }}}