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

$ vi initpripadchev.artem.p3415.ora
"initpripadchev.artem.p3415.ora" 16 lines, 412 characters
db_name='wetfish'
memory_target=1G
sga_target=600M
processes=150
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
audit_trail='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files=(ora_control1,ora_control2)

mkdir /u01/uhy57
chown oracle:oinstall /u01/uhy57
mkdir /u01/uhy57/logs
mkdir /u01/uhy57/wetfish
mkdir /u01/uhy57/wetfish/node01
mkdir /u01/uhy57/wetfish/node02
mkdir /u01/uhy57/wetfish/node03

cd $ORACLE_HOME/network/admin
cp samples/listener.ora listener.ora
cp samples/sqlnet.ora sqlnet.ora
cp samples/tnsnames.ora tnsnames.ora

vi listener.ora
  LISTENER =
  (DESCRIPTION_LIST=
    (DESCRIPTION=
      (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
      )
    )
  )


vi sqlnet.ora
names.directory_path=(tnsnames)

vi tnsnames.ora
pripadchev.artem.p3415=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
    ) 
    (CONNECT_DATA=
      (SERVICE_NAME=pripadchev.artem.p3415)
    )
  )

lsnrctl start


sqlplus /nolog
connect / as sysdba
create SPFILE from PFILE
startup nomount

cd $HOME/uhy57
mkdir sqlfiles

cr.sql
CREATE DATABASE wetfish
   USER SYS IDENTIFIED BY admin
   USER SYSTEM IDENTIFIED BY admin
   LOGFILE GROUP 1 ('/u01/uhy57/logs/redo01a.log') SIZE 10M,
           GROUP 2 ('/u01/uhy57/logs/redo02a.log') SIZE 10M,
           GROUP 3 ('/u01/uhy57/logs/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;


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;

	@?/rdbms/admin/catalog.sql
	@?/rdbms/admin/catproc.sql
	grant sysdba to sys;

cr3.sql
CREATE USER ARTEM IDENTIFIED BY MANAGER DEFAULT TABLESPACE FAT_BROWN_SONG QUOTA UNLIMITED ON FAT_BROWN_SONG
/
GRANT CREATE SESSION TO ARTEM
/
GRANT CREATE TABLE TO ARTEM
/
GRANT CREATE PROCEDURE TO ARTEM
/
GRANT CREATE TRIGGER TO ARTEM
/
GRANT CREATE VIEW TO ARTEM
/
GRANT CREATE SEQUENCE TO ARTEM
/
GRANT CREATE VIEW TO ARTEM
/

GRANT DELETE ANY TABLE TO ARTEM
/
GRANT DROP ANY TABLE TO ARTEM
/
GRANT DROP ANY PROCEDURE TO ARTEM
/
GRANT DROP ANY TRIGGER TO ARTEM
/
GRANT DROP ANY VIEW TO ARTEM
/

GRANT ALTER ANY TABLE TO ARTEM
/
GRANT ALTER ANY TABLE TO ARTEM
/
GRANT ALTER ANY PROCEDURE TO ARTEM
/
GRANT ALTER ANY TRIGGER TO ARTEM
/
commit
/


ALTER USER ARTEM QUOTA UNLIMITED ON TALL_RED_FOOD;

connect ARTEM