export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=pripadchev.artem.p3415 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/dbs orapwd file=orapwpripadchev.artem.p3415 entries=10 mv init.ora initpripadchev.artem.p3415.ora vi initpripadchev.artem.p3415.ora cat initpripadchev.artem.p3415.ora db_name='wetfish' memory_target=300M sga_target=90M db_block_size=8192 #Configuration for replica log_archive_dest_1='LOCATION=/u01/uhy57/log/' log_archive_dest_state_1=ENABLE log_archive_format=%t_%s_%r.arc mkdir /u01/uhy57 chown oracle:oinstall /u01/uhy57 mkdir /u01/uhy57/log mkdir /u01/uhy57/wetfish mkdir /u01/uhy57/wetfish/node01 mkdir /u01/uhy57/wetfish/node02 mkdir /u01/uhy57/wetfish/node03 mkdir /u01/uhy57/wetfish/node03 lsnrctl start sqlplus /nolog connect / as sysdba create SPFILE from PFILE; startup nomount cd /u01/uhy57/ mkdir sqlfiles vi cr.sql CREATE DATABASE wetfish USER SYS IDENTIFIED BY admin USER SYSTEM IDENTIFIED BY admin LOGFILE GROUP 1 ('/u01/uhy57/log/redo01a.log') SIZE 10M, GROUP 2 ('/u01/uhy57/log/redo02a.log') SIZE 10M, GROUP 3 ('/u01/uhy57/log/redo03a.log') SIZE 10M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 10 MAXDATAFILES 50 CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/uhy57/wetfish/node01/acume76.dbf' SIZE 100M REUSE AUTOEXTEND ON, '/u01/uhy57/wetfish/node03/utebe94.dbf' SIZE 100M REUSE AUTOEXTEND ON SYSAUX DATAFILE '/u01/uhy57/wetfish/node03/wiz57.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TABLESPACE users DATAFILE '/u01/uhy57/wetfish/node04/agawaqo738.dbf' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/uhy57/wetfish/temp01.dbf' SIZE 100M REUSE UNDO TABLESPACE undotbs1 DATAFILE '/u01/uhy57/wetfish/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; vi cr2.sql CREATE TABLESPACE FAT_BROWN_SONG DATAFILE '/u01/uhy57/wetfish/node01/fatbrownsong01.dbf' SIZE 10M, '/u01/uhy57/wetfish/node02/fatbrownsong02.dbf' SIZE 10M, '/u01/uhy57/wetfish/node02/fatbrownsong03.dbf' SIZE 10M; CREATE TABLESPACE TALL_RED_FOOD DATAFILE '/u01/uhy57/wetfish/node03/tallredfood01.dbf' SIZE 10M, '/u01/uhy57/wetfish/node03/tallredfood02.dbf' SIZE 10M, '/u01/uhy57/wetfish/node03/tallredfood03.dbf' SIZE 10M, '/u01/uhy57/wetfish/node03/tallredfood04.dbf' SIZE 10M, '/u01/uhy57/wetfish/node03/tallredfood05.dbf' SIZE 10M; sqlplus / as sysdba @cr.sql @cr2.sql @?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql grant sysdba to sys; fill.sql CREATE TABLE fbs (pktest NUMBER(5) PRIMARY KEY, vctest VARCHAR2(15) NOT NULL) TABLESPACE FAT_BROWN_SONG STORAGE (INITIAL 50K); INSERT INTO fbs VALUES (1, 'FBS_1'); CREATE TABLE trf (pktest NUMBER(5) PRIMARY KEY, vctest VARCHAR2(15) NOT NULL) TABLESPACE TALL_RED_FOOD STORAGE (INITIAL 50K); INSERT INTO trf VALUES (1, 'TRF_1'); sqlplus / as sysdba show user startup select name from v$database; WETFISH select tablespace_name from dba_tablespaces; TABLESPACE_NAME ------------------------------ SYSTEM SYSAUX UNDOTBS1 TEMP USERS FAT_BROWN_SONG TALL_RED_FOOD select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/uhy57/wetfish/node01/acume76.dbf /u01/uhy57/wetfish/node03/utebe94.dbf /u01/uhy57/wetfish/node03/wiz57.dbf /u01/uhy57/wetfish/undotbs01.dbf /u01/uhy57/wetfish/node04/agawaqo738.dbf /u01/uhy57/wetfish/node01/fatbrownsong01.dbf /u01/uhy57/wetfish/node02/fatbrownsong02.dbf /u01/uhy57/wetfish/node02/fatbrownsong03.dbf /u01/uhy57/wetfish/node03/tallredfood01.dbf /u01/uhy57/wetfish/node03/tallredfood02.dbf /u01/uhy57/wetfish/node03/tallredfood03.dbf NAME -------------------------------------------------------------------------------- /u01/uhy57/wetfish/node03/tallredfood04.dbf /u01/uhy57/wetfish/node03/tallredfood05.dbf 13 rows selected. select name from v$controlfile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/product/11.2.0/dbhome_1/dbs/cntrlpripadchev.artem.p3415.dbf select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/uhy57/log/redo01a.log /u01/uhy57/log/redo02a.log /u01/uhy57/log/redo03a.log cd /u01/app/oracle/product/11.2.0/dbhome_1/ cd $ORACLE_HOME/dbs export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=+ASM 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 vi init+ASM.ora cat init+ASM.ora instance_type=asm ASM_POWER_LIMIT=9 mkdir /u01/crazybear mkdir /u01/crazyhamster mkdir /u01/carelessbear mkdir /u01/angrydeer chown oracle:dba ./crazybear dd if=/dev/zero of=./crazybear/crazybear1 bs=1k count=50000 dd if=/dev/zero of=./crazybear/crazybear2 bs=1k count=50000 dd if=/dev/zero of=./crazybear/crazybear3 bs=1k count=50000 dd if=/dev/zero of=./crazybear/crazybear4 bs=1k count=50000 su root /usr/sbin/lofiadm -a /u01/crazybear/crazybear1 /usr/sbin/lofiadm -a /u01/crazybear/crazybear2 /usr/sbin/lofiadm -a /u01/crazybear/crazybear3 /usr/sbin/lofiadm -a /u01/crazybear/crazybear4 cat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/init+ASM.ora instance_type=asm ASM_POWER_LIMIT=9 ASM_DISKSTRING='/u01/crazybear/*' $ ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid; export ORACLE_HOME $ ./runInstaller GRID_HOME=/u01/app/oracle/product/11.2.0/grid; export GRID_HOME # /u01/app/11.2.0/grid/root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /var/opt/oracle/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user: /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl To configure Grid Infrastructure for a Cluster perform the following steps: 1. Provide values for Grid Infrastructure configuration parameters in the file - /u01/app/11.2.0/grid/crs/install/crsconfig_params. For details on how to do this, see the installation guide. 2. Run the following command as the root user: /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl To update inventory properties for Grid Infrastructure, perform the following steps. If a pre-11.2 home is already configured, execute the following: 11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=false ORACLE_HOME=pre-11.2_Home Always execute the following to register the current home: 11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=true ORACLE_HOME=11.2_Home. If either home is shared, provide the additional argument -cfs. # /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl 2015-12-01 04:53:26: Checking for super user privileges 2015-12-01 04:53:26: User has super user privileges 2015-12-01 04:53:26: Parsing the host name Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Creating trace directory LOCAL ADD MODE Creating OCR keys for user 'oracle', privgrp 'oinstall'.. Operation successful. CRS-4664: Node unknown successfully pinned. Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting unknown 2015/12/01 04:53:55 /u01/app/11.2.0/grid/cdata/unknown/backup_20151201_045355.olr Successfully configured Oracle Grid Infrastructure for a Standalone Server # ./crsctl start resource ora.cssd orapwd file=init+ASM entries=10 ./srvctl add asm -p /u01/app/oracle/product/11.2.0/dbhome_1/dbs/init+ASM.ora ./srvctl status asm ./srvctl start asm bash-3.2$ ./srvctl status asm ASM is running on unknown bash-3.2$ export ORACLE_HOME=/u01/app/11.2.0/grid bash-3.2$ cd $ORACLE_HOME bash-3.2$ cd bash-3.2$ export ORACLE_SID=+ASM bash-3.2$ export PATH=$PATH:$ORACLE_HOME/bin bash-3.2$ sqlplus /nolog pwd /u01/app/11.2.0/grid/dbs bash-3.2$ ls ab_+ASM.dat hc_+ASM.dat init+ASM init+ASM.ora init.ora bash-3.2$ cat init+ASM.ora instance_type=asm ASM_POWER_LIMIT=9 ASM_DISKSTRING='/u01/crazybear/*' remote_login_passwordfile=exclusive large_pool_size=12M sqlplus / as sysasm startup; select path,mount_status from v$asm_disk; create diskgroup crazybear normal redundancy disk '/u01/crazybear/crazybear1', '/u01/crazybear/crazybear2', '/u01/crazybear/crazybear3', '/u01/crazybear/crazybear4'; select group_number, name, total_mb, free_mb, state, type from v$asm_diskgroup; chown oracle:dba ./angrydeer dd if=/dev/zero of=./angrydeer/angrydeer1 bs=1k count=50000 dd if=/dev/zero of=./angrydeer/angrydeer2 bs=1k count=50000 dd if=/dev/zero of=./angrydeer/angrydeer3 bs=1k count=50000 dd if=/dev/zero of=./angrydeer/angrydeer4 bs=1k count=50000 su root /usr/sbin/lofiadm -a /u01/angrydeer/angrydeer1 /usr/sbin/lofiadm -a /u01/angrydeer/angrydeer2 /usr/sbin/lofiadm -a /u01/angrydeer/angrydeer3 /usr/sbin/lofiadm -a /u01/angrydeer/angrydeer4 chown oracle:dba angrydeer/* create diskgroup angrydeer normal redundancy disk '/u01/angrydeer/angrydeer1', '/u01/angrydeer/angrydeer2', '/u01/angrydeer/angrydeer3', '/u01/angrydeer/angrydeer4'; shutdown CREATE SPFILE from PFILE; startup; Добавить новую дисковую группу "luckywolf[6]"; размер AU - 8 МБ. create diskgroup luckywolf normal redundancy disk '/u01/luckywolf/luckywolf1', '/u01/luckywolf/luckywolf2', '/u01/luckywolf/luckywolf3', '/u01/luckywolf/luckywolf4', '/u01/luckywolf/luckywolf5', '/u01/luckywolf/luckywolf6' ATTRIBUTE 'AU_SIZE'='8M'; Удалить дисковую группу "carelessbear". DROP DISKGROUP carelessbear INCLUDING CONTENTS; Добавить новую дисковую группу "youngkitten[3]"; размер AU - 16 МБ. create diskgroup youngkitten normal redundancy disk '/u01/youngkitten/youngkitten1','/u01/youngkitten/youngkitten2','/u01/youngkitten/youngkitten3' ATTRIBUTE 'AU_SIZE'='16M'; Добавить новую дисковую группу "sadseal[5]"; размер AU - 8 МБ. create diskgroup sadseal normal redundancy disk '/u01/sadseal/sadseal1', '/u01/sadseal/sadseal2', '/u01/sadseal/sadseal3', '/u01/sadseal/sadseal4', '/u01/sadseal/sadseal5' ATTRIBUTE 'AU_SIZE'='8M'; Добавить новую дисковую группу "youngwolf[4]"; размер AU - 2 МБ. create diskgroup youngwolf normal redundancy disk '/u01/youngwolf/youngwolf1', '/u01/youngwolf/youngwolf2', '/u01/youngwolf/youngwolf3', '/u01/youngwolf/youngwolf4' ATTRIBUTE 'AU_SIZE'='2M'; Добавить новую дисковую группу "luckyoctopus[5]"; размер AU - 32 МБ. create diskgroup luckyoctopus normal redundancy disk '/u01/luckyoctopus/luckyoctopus1', '/u01/luckyoctopus/luckyoctopus2', '/u01/luckyoctopus/luckyoctopus3', '/u01/luckyoctopus/luckyoctopus4', '/u01/luckyoctopus/luckyoctopus5' ATTRIBUTE 'AU_SIZE'='32M'; Добавить новый диск в группу sadseal. alter diskgroup sadseal add disk '/u01/sadseal/sadseal6'; create diskgroup angrydeer normal redundancy disk '/u01/angrydeer/angrydeer1', '/u01/angrydeer/angrydeer2', '/u01/angrydeer/angrydeer3', '/u01/angrydeer/angrydeer4' ATTRIBUTE 'AU_SIZE'='8M'; cat init+ASM.ora instance_type=asm ASM_POWER_LIMIT=9 ASM_DISKSTRING='/u01/crazybear/*','/u01/angrydeer/*' remote_login_passwordfile=exclusive large_pool_size=12M _ASM_ALLOW_ONLY_RAW_DISKS=FALSE create tablespace test datafile '+ANGRYDEER' 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 '+ANGRYDEER' size 10M autoextend on next 100M; select file_name from dba_data_files where tablespace_name='TEST'; 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 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=pripadchev.artem.p3415 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