Contents
- VSAN poweron
- VSAN poweroff
- Embedded to External Platform Services Controller Instance
- Orace parameters
- Huawei S5700S 配制
-
RAC operations
- REDO log
- impdp errors
-
RMAN DUPLICATE
- 1 stop another instance
- db parameters
- Enable status registration for HRDB1 to run LISTENER
- 4- Ceate a password file for auxiliary instance HRDB1 on prd-db-01:
- 5- Test connectivity to auxiliary and target instances from BOTH hosts using TNS:
- 6- On the auxiliary host, start RMAN and run the DUPLICATE command:
- MDB(PLM)
- RAC01
- MDB (PLM)
- EASDB
- HRDB
- SAN01
- SAN02
- Oracle RAC
-
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.
- STEP 2. Modify control_files parameter by adding the new disk group
- STEP 3. Shutdown the RAC database and start the database in nomount mode.
- STEP 4. Check the database to see if new diskgroup has been added to the control_files parameter
- STEP 5. Connect to RMAN and use restore command to create a copy of the control file
- STEP 6. Use ‘alter system..’ command to modify the control_files parameter
- STEP 7. Shutdown the database and start up normal.
-
HRDB
- Veritas Netbackup backup Oracle RAC
- Troubleshooting
- References
- vCenter EVC
- Appliance 5240 initialization
- TEAMVIEWER
- NOTES
VSAN poweron
- poweron ESXi host
- exit ESXi maintenanceMode: esxcli system maintenanceMode set -e false
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=<value> 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.9436280How To Mirror Controlfile To FRA On ASM [ID 1305674.1]
Veritas Netbackup backup Oracle RAC
nbumaster
- Login in NBU appliance
nbumaster.Support> Maintenance <!-- Maintenance Mode --!> 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
<msg time='2017-06-01T23:10:51.654+08:00'
Doc ID 1344499.1
ORA-00600: 内部错误代码, 参数: [kole_t2u], [34], [], [], [], [], [], [], [], [], [], []
Doc ID 734474.1
mls-san01
MLS-SAN01:admin> 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
- 创建一个新的6.5 vCenter with extent PSC.
- 从现有的群集中腾出三台主机，加入vCenter6.5，创建一个新的群集，新的群集启用EVC。
- 将现有群集的VC6.0的PSC注册至6.5的PSC Server.
- 逐步迁移生产VM虚拟机至新的6.5群集中。
- 升级现有的ESXi6.0至6.5。
- 最终结果是有两个群集，一个用于生产，一个用于测试。
注：将创建两个群集
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