Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Orace 11gr2 DB Creation in ASM -Script

vi inittilak.ora
db_name=nijam
COMPATIBLE=11.2.0
diagnostic_dest='/home/oracle/oradata/tilak/dump/'
control_files='+DG1'
sga_max_size=1500M
sga_target=512M
undo_management=AUTO
undo_tablespace=UNDOTBS
db_create_online_log_dest_1='+DG1'
db_create_file_dest='+DG1'


vi create.sql
CREATE DATABASE nijam
DATAFILE '+DG1' SIZE 1000M
SYSAUX DATAFILE '+DG1' SIZE 1000M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '+DG1' SIZE 1000M
UNDO TABLESPACE "UNDOTBS" DATAFILE '+DG1' SIZE 1000M
LOGFILE
GROUP 1 '+DG1' SIZE 10M,
GROUP 2 '+DG1' SIZE 10M;


$ cd $ORACLE_HOME/dbs
vi init+asm.ora

instance_name=+asm
instance_type=asm
asm_diskgroups=DG1, FRA

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

2017 Shortern URL - Other Website Like ADFOC.US

How to Repair Corrupt database postgresql

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?