Oracle – Criando BD

Pessoal, vamos criar um banco via script ???

Atenção hein … lembrando que o binário tem que estar previamente instalado, ok?

CRIAR OS DIRETORIOS
———————————————–

mkdir -p /u01/app/admin/GENERIC/adump
mkdir -p /u01/app/admin/GENERIC/bdump
mkdir -p /u01/app/admin/GENERIC/cdump
mkdir -p /u01/app/admin/GENERIC/dpdump
mkdir -p /u01/app/admin/GENERIC/pfile
mkdir -p /u01/app/admin/GENERIC/udump

CRIA O INIT ou PFILE (utilizando o VI)
————————————————–
vi /u01/app/oracle/product/10.2.0/db_1/dbs/initGENERIC.ora
————————————
GENERIC.__db_cache_size=1644167168
GENERIC.__java_pool_size=33554432
GENERIC.__large_pool_size=16777216
GENERIC.__shared_pool_size=436207616
GENERIC.__streams_pool_size=0
*.audit_file_dest=’/u01/app/admin/GENERIC/adump’
*.background_dump_dest=’/u01/app/admin/GENERIC/bdump’
*.compatible=’10.2.0.1.0′
*.control_files=’/oracle/GENERIC/control01.ctl’,’/oracle/GENERIC/control02.ctl’,’/oracle/GENERIC/control03.ctl’
*.core_dump_dest=’/u01/app/admin/GENERIC/cdump’
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_name=’GENERIC’
*.db_recovery_file_dest=’/oracle/GENERIC/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=GENERICXDB)’
*.job_queue_processes=10
*.open_cursors=900
*.pga_aggregate_target=1692401664
*.processes=300
*.remote_login_passwordfile=’EXCLUSIVE’
*.sessions=335
*.sga_target=2124756480
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′
*.user_dump_dest=’/u01/app/admin/GENERIC/udump’

 

export ORACLE_SID=GENERIC
echo $ORACLE_SID
sqlplus /nolog
conn / as sysdba
startup nomount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initGENERIC.ora
CREATE DATABASE GENERIC
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 50
DATAFILE ‘/oracle/GENERIC/system01.dbf’ SIZE 50M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/oracle/GENERIC/sysaux01.dbf’ SIZE 20M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE ‘/oracle/GENERIC/temp01.dbf’ SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE “UNDOTBS1” DATAFILE ‘/oracle/GENERIC/undotbs01.dbf’ SIZE 20M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 (‘/oracle/GENERIC/redo01.log’) SIZE 51200K,
GROUP 2 (‘/oracle/GENERIC/redo02.log’) SIZE 51200K,
GROUP 3 (‘/oracle/GENERIC/redo03.log’) SIZE 51200K;
@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql
CREATE TABLESPACE DAT_GENERIC DATAFILE ‘/oracle/GENERIC/DAT_GENERIC.dbf’ SIZE 128M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE INX_GENERIC DATAFILE ‘/oracle/GENERIC/INX_GENERIC.dbf’ SIZE 128M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
 
 
— proximo passo
1 – criar e subir o listener
2 – criar demais tablespaces
3 – criar usuarios
4 – aplicar os grants

Valeu galera !!!

Deixe um comentário

Nenhum comentário ainda.

Comments RSS TrackBack Identifier URI