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

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

PGA monitoring views in oracle

datapump inctype explanation in oracle

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

Postgres Streaming Replication Configuration