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 find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Linux ctime,mtime,atime,cmin,amin,mmin

How to Return a Result Set from a PostgreSQL Stored Procedure

7 Steps to configure BDR replication in postgresql

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