export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=s174358 PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN 2) Задать метод аутентификации администратора cd $ORACLE_HOME/dbs orapwd file=orapws174358 3)Создать конфигурационные файлы, необходимые для инициализации и запуска экземпляра Oracle cd $ORACLE_BASE; mkdir p admin/orcl/adump mkdir flash_recovery_area mkdir /u01/jkr17 mkdir $ORACLE_HOME/dbs/inits1743358.ora inits1743358.ora db_name='longuser' memory_target=300M sga_target=90M db_block_size=8192 #Configuration for replica log_archive_dest_1='LOCATION=/u01/jkr17/logs/' log_archive_dest_state_1=ENABLE log_archive_format=%t_%s_%r.arc chown oracle:oinstall /u01/jkr17 chmod 775 /u01/jkr17 cd /u01/jkr17 mkdir logs; mkdir longuser cd longuser mkdir node01 node02 node03 node04 4) Запустить экземпляр Oracle. lsnrctl start sqlplus /nolog SQL> connect / as sysdba SQL> create SPFILE from PFILE='$ORACLE_HOME/dbs/inits174358.ora'; SQL> startup nomount; 5) Создать новую базу данных CREATE DATABASE longuser USER SYS IDENTIFIED BY admin USER SYSTEM IDENTIFIED BY admin LOGFILE GROUP 1 ('/u01/jkr17/logs/redo01a.log') SIZE 10M, GROUP 2 ('/u01/jkr17/logs/redo02a.log') SIZE 10M, GROUP 3 ('/u01/jkr17/logs/redo03a.log') SIZE 10M, GROUP 4 ('/u01/jkr17/logs/redo04a.log') SIZE 10M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 10 MAXDATAFILES 50 CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/jkr17/longuser/node03/uripo74.dbf' SIZE 100M REUSE AUTOEXTEND ON, '/u01/jkr17/longuser/node04/idubi57.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED SYSAUX DATAFILE '/u01/jkr17/longuser/node02/wus98.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TABLESPACE users DATAFILE '/u01/jkr17/longuser/node02/ixaqoda794.dbf' SIZE 50M REUSE AUTOEXTEND ON, '/u01/jkr17/longuser/node02/apuruye842.dbf' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/jkr17/longuser/temp01.dbf' SIZE 100M REUSE UNDO TABLESPACE undotbs1 DATAFILE '/u01/jkr17/longuser/undotbs1.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 6) Создать дополнительные табличные пространства CREATE TABLESPACE WET_BLUE_ROAD DATAFILE '/u01/jkr17/longuser/node04/wetblueroad01.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/busygoldbird02.dbf' SIZE 10M, '/u01/jkr17/longuser/node02/wetblueroad02.dbf' SIZE 10M, '/u01/jkr17/longuser/node02/wetblueroad03.dbf' SIZE 10M; CREATE TABLESPACE OLD_GOLD_SOUP DATAFILE '/u01/jkr17/longuser/node03/oldgoldsoup01.dbf' SIZE 10M, '/u01/jkr17/longuser/node03/oldgoldsoup02.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/oldgoldsoup03.dbf' SIZE 10M, '/u01/jkr17/longuser/node01/oldgoldsoup04.dbf' SIZE 10M; CREATE TABLESPACE BIG_WHITE_FOOD DATAFILE '/u01/jkr17/longuser/node02/bigwhitefood01.dbf' SIZE 10M, '/u01/jkr17/longuser/node01/bigwhitefood02.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/bigwhitefood03.dbf' SIZE 10M; 7) Сформировать представления словаря данных. cd $ORACLE_HOME/rdbms/admin; sqlplus /nolog SQL> connect / as sysdba SQL> @catalog.sql SQL> @catproc.sql @?/rdbms/admin/catalog.sql; @?/rdbms/admin/catproc.sql; grant sysdba to sys; ASM export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/11.2.0/grid export ORACLE_SID=+ASM export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN cd $ORACLE_HOME cat init+ASM.ora iinstance_type=asm ASM_POWER_LIMIT=4 ASM_DISKSTRING='/u01/clevergiraffe/*','/u01/excitingcrocodile/*','/u01/angrydog/*','/u01/famouscheetah/*' remote_login_passwordfile=exclusive large_pool_size=12M _ASM_ALLOW_ONLY_RAW_DISKS=FALSE mkdir /u01/famouscheetah mkdir /u01/clevergiraffe mkdir /u01/excitingcrocodile mkdir /u01/angrydog chown oracle:dba /u01/famouscheetah/* chown oracle:dba /u01/clevergiraffe/* chown oracle:dba /u01/angrydog/* chown oracle:dba /u01/excitingcrocodile* "famouscheetah[3]", "clevergiraffe[6]", "angrydog[7]", "excitingcrocodile[5]". 1) dd if=/dev/zero of=/u01/famouscheetah/famouscheetah0 bs=1k count=200000 dd if=/dev/zero of=/u01/famouscheetah/famouscheetah1 bs=1k count=200000 dd if=/dev/zero of=/u01/famouscheetah/famouscheetah2 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/famouscheetah/famouscheetah0 /usr/sbin/lofiadm -a /u01/famouscheetah/famouscheetah1 /usr/sbin/lofiadm -a /u01/famouscheetah/famouscheetah2 2) dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe0 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe1 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe2 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe3 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe4 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe5 bs=1k count=200000 dd if=/dev/zero of=/u01/clevergiraffe/clevergiraffe5 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe0 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe1 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe2 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe3 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe4 /usr/sbin/lofiadm -a /u01/clevergiraffe/clevergiraffe5 3) dd if=/dev/zero of=/u01/angrydog/angrydog0 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog1 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog2 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog3 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog4 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog5 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog6 bs=1k count=100000 dd if=/dev/zero of=/u01/angrydog/angrydog7 bs=1k count=100000 /usr/sbin/lofiadm -a /u01/angrydog/angrydog0 /usr/sbin/lofiadm -a /u01/angrydog/angrydog1 /usr/sbin/lofiadm -a /u01/angrydog/angrydog2 /usr/sbin/lofiadm -a /u01/angrydog/angrydog3 /usr/sbin/lofiadm -a /u01/angrydog/angrydog4 /usr/sbin/lofiadm -a /u01/angrydog/angrydog5 /usr/sbin/lofiadm -a /u01/angrydog/angrydog6 4) dd if=/dev/zero of=/u01/excitingcrocodile/excitingcrocodile0 bs=1k count=200000 dd if=/dev/zero of=/u01/excitingcrocodile/excitingcrocodile1 bs=1k count=200000 dd if=/dev/zero of=/u01/excitingcrocodile/excitingcrocodile2 bs=1k count=200000 dd if=/dev/zero of=/u01/excitingcrocodile/excitingcrocodile3 bs=1k count=200000 dd if=/dev/zero of=/u01/excitingcrocodile/excitingcrocodile4 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/excitingcrocodile/excitingcrocodile0 /usr/sbin/lofiadm -a /u01/excitingcrocodile/excitingcrocodile1 /usr/sbin/lofiadm -a /u01/excitingcrocodile/excitingcrocodile2 /usr/sbin/lofiadm -a /u01/excitingcrocodile/excitingcrocodile3 /usr/sbin/lofiadm -a /u01/excitingcrocodile/excitingcrocodile4 sqlplus / as sysasm startup pfile='/u01/app/11.2.0/grid/init+ASM.ora' alter diskgroup ALL MOUNT; select path,mount_status from v$asm_disk; select group_number, name, total_mb, free_mb, state, type from v$asm_diskgroup; select * from v$asm_disk; "famouscheetah[3]", "clevergiraffe[6]", "angrydog[7]", "excitingcrocodile[5]". DROP DISKGROUP famouscheetah INCLUDING CONTENTS; 1) create diskgroup famouscheetah normal redundancy disk '/u01/famouscheetah/famouscheetah0', '/u01/famouscheetah/famouscheetah1', '/u01/famouscheetah/famouscheetah2'; 2) create diskgroup clevergiraffe normal redundancy disk '/u01/clevergiraffe/clevergiraffe0', '/u01/clevergiraffe/clevergiraffe1', '/u01/clevergiraffe/clevergiraffe2', '/u01/clevergiraffe/clevergiraffe3', '/u01/clevergiraffe/clevergiraffe4', '/u01/clevergiraffe/clevergiraffe5'; 3) create diskgroup excitingcrocodile normal redundancy disk '/u01/excitingcrocodile/excitingcrocodile0', '/u01/excitingcrocodile/excitingcrocodile1', '/u01/excitingcrocodile/excitingcrocodile2', '/u01/excitingcrocodile/excitingcrocodile3', '/u01/excitingcrocodile/excitingcrocodile4'; 4) create diskgroup angrydog normal redundancy disk '/u01/angrydog/angrydog0', '/u01/angrydog/angrydog1', '/u01/angrydog/angrydog2', '/u01/angrydog/angrydog3', '/u01/angrydog/angrydog4', '/u01/angrydog/angrydog5', '/u01/angrydog/angrydog6'; 4) create diskgroup angrydog normal redundancy disk '/u01/angrydog/angrydog0', '/u01/angrydog/angrydog1', '/u01/angrydog/angrydog2', '/u01/angrydog/angrydog3', '/u01/excitingcrocodile/angrydog4', '/u01/excitingcrocodile/angrydog5', '/u01/excitingcrocodile/angrydog6'; FAMOUSCHEETAH create tablespace test datafile 'FAMOUSCHEETAH' size 10m autoextend on next 100m extent management local segment space management auto; select tablespace_name from dba_data_files; alter tablespace test add datafile 'clevergiraffe' size 10M autoextend on next 100M; alter tablespace test add datafile 'angrydog' size 10M autoextend on next 100M; alter tablespace test add datafile 'excitingcrocodile' size 10M autoextend on next 100M; export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/11.2.0/grid export ORACLE_SID=+ASM export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN 2) этап (ALTER DISKGROUP famouscheetah MOUNT;) 1)Удалить дисковую группу "excitingcrocodile". DROP DISKGROUP excitingcrocodile INCLUDING CONTENTS; 2)Удалить дисковую группу "famouscheetah". DROP DISKGROUP famouscheetah INCLUDING CONTENTS; 3)Пересоздать группу "angrydog", сконфигурировав в ней избыточность следующим образом: Размер группы - 12 элементов. Тип избыточности - "HIGH"; количество failure-групп - 4. Равномерно распределить диски по failure-группам. dd if=/dev/zero of=/u01/angrydog/angrydog7 bs=1k count=200000 dd if=/dev/zero of=/u01/angrydog/angrydog8 bs=1k count=200000 dd if=/dev/zero of=/u01/angrydog/angrydog9 bs=1k count=200000 dd if=/dev/zero of=/u01/angrydog/angrydog10 bs=1k count=200000 dd if=/dev/zero of=/u01/angrydog/angrydog11 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/angrydog/angrydog7 /usr/sbin/lofiadm -a /u01/angrydog/angrydog8 /usr/sbin/lofiadm -a /u01/angrydog/angrydog9 /usr/sbin/lofiadm -a /u01/angrydog/angrydog10 /usr/sbin/lofiadm -a /u01/angrydog/angrydog11 chown oracle:dba /u01/angrydog/ alter diskgroup angrydog normal redundancy disk '/u01/angrydog/angrydog0', '/u01/angrydog/angrydog1', '/u01/angrydog/angrydog2', '/u01/angrydog/angrydog3', '/u01/angrydog/angrydog4', '/u01/angrydog/angrydog5', '/u01/angrydog/angrydog6', '/u01/angrydog/angrydog7', '/u01/angrydog/angrydog8', '/u01/angrydog/angrydog9', '/u01/angrydog/angrydog10', '/u01/angrydog/angrydog11'; DROP DISKGROUP angrydog INCLUDING CONTENTS; CREATE DISKGROUP angrydog HIGH REDUNDANCY FAILGROUP failure_group_1 DISK '/u01/angrydog/angrydog0' NAME angrydog0, '/u01/angrydog/angrydog1' NAME angrydog1, '/u01/angrydog/angrydog2' NAME angrydog2 FAILGROUP failure_group_2 DISK '/u01/angrydog/angrydog3' NAME angrydog3, '/u01/angrydog/angrydog4' NAME angrydog4, '/u01/angrydog/angrydog5' NAME angrydog5 FAILGROUP failure_group_3 DISK '/u01/angrydog/angrydog6' NAME angrydog6, '/u01/angrydog/angrydog7' NAME angrydog7, '/u01/angrydog/angrydog8' NAME angrydog8 FAILGROUP failure_group_4 DISK '/u01/angrydog/angrydog9' NAME angrydog9, '/u01/angrydog/angrydog10' NAME angrydog10, '/u01/angrydog/angrydog11' NAME angrydog11; 4) Добавить новый диск в группу angrydog. dd if=/dev/zero of=/u01/angrydog/angrydog12 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/angrydog/angrydog12 chown oracle:dba /u01/angrydog/angrydog12 ALTER DISKGROUP angrydog ADD FAILGROUP failure_group_1 DISK '/u01/angrydog/angrydog12' NAME angrydog12 NOFORCE; 5) Добавить новую дисковую группу "happyturtle[6]"; размер AU - 4 МБ. mkdir /u01/happyturtle/ dd if=/dev/zero of=/u01/happyturtle/happyturtle0 bs=1k count=200000 dd if=/dev/zero of=/u01/happyturtle/happyturtle1 bs=1k count=200000 dd if=/dev/zero of=/u01/happyturtle/happyturtle2 bs=1k count=200000 dd if=/dev/zero of=/u01/happyturtle/happyturtle3 bs=1k count=200000 dd if=/dev/zero of=/u01/happyturtle/happyturtle4 bs=1k count=200000 dd if=/dev/zero of=/u01/happyturtle/happyturtle5 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle0 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle1 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle2 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle3 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle4 /usr/sbin/lofiadm -a /u01/happyturtle/happyturtle5 chown oracle:dba /u01/happyturtle create diskgroup happyturtle normal redundancy disk '/u01/happyturtle/happyturtle0','/u01/happyturtle/happyturtle1','/u01/happyturtle/happyturtle2','/u01/happyturtle/happyturtle3','/u01/happyturtle/happyturtle4','/u01/happyturtle/happyturtle5'ATTRIBUTE 'AU_SIZE'='4M'; 6)Удалить дисковую группу "happyturtle". DROP DISKGROUP happyturtle INCLUDING CONTENTS; 7)Yдалить дисковую группу "angrydog" и добавить новую дисковую группу "friendlypig[4]"; размер AU - 16 МБ. mkdir /u01/friendlypig dd if=/dev/zero of=/u01/friendlypig/friendlypig0 bs=1k count=200000 dd if=/dev/zero of=/u01/friendlypig/friendlypig1 bs=1k count=200000 dd if=/dev/zero of=/u01/friendlypig/friendlypig2 bs=1k count=200000 dd if=/dev/zero of=/u01/friendlypig/friendlypig3 bs=1k count=200000 /usr/sbin/lofiadm -a /u01/friendlypig/friendlypig0 /usr/sbin/lofiadm -a /u01/friendlypig/friendlypig1 /usr/sbin/lofiadm -a /u01/friendlypig/friendlypig2 /usr/sbin/lofiadm -a /u01/friendlypig/friendlypig3 chown oracle:dba /u01/friendlypig DROP DISKGROUP angrydog INCLUDING CONTENTS; create diskgroup happyturtle normal redundancy disk '/u01/friendlypig/friendlypig0','/u01/friendlypig/friendlypig1','/u01/friendlypig/friendlypig2','/u01/friendlypig/friendlypig3' ATTRIBUTE 'AU_SIZE'='16M'; 8)Удалить диск #3 из группы "friendlypig". alter diskgroup friendlypig drop disk '/u01/friendlypig/friendlypig3';