A collection of tutorials, code and tools to help you get better using Oracle
18 July 2014
To create a database manually under ASM, it is actually a little easier than with a non asm database - mainly because you don't need to worry about paths to datafiles etc.
control_files = (+DATADG, +FRADG) undo_management = auto db_name = CLEAN01 db_block_size = 8192 DB_CREATE_FILE_DEST = +DATADG DB_RECOVERY_FILE_DEST = +FRADG DB_RECOVERY_FILE_DEST_SIZE = 10G
Set the Oracle SID:
sqlplus / as sysdba create spfile from pfile; startup nomount
create database clean01 logfile group 1 ('+DATADG') size 100M, group 2 ('+DATADG') size 100M, group 3 ('+DATADG') size 100M character set utf8 national character set utf8;
create temporary tablespace temp tempfile '+DATADG' size 500M;
CREATE TABLESPACE users DATAFILE '+DATADG' SIZE 50M autoextend on maxsize 10G EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
create pfile from spfile; create spfile='+DATADG/CLEAN01/spfileCLEAN01.ora' from pfile; shutdown immediate;
Now create a file called initAPEX01.ora in the ORACLE_HOME/dbs directory, and put the following contents in it:
Remember to remove the SPFile from the dbs directory or it will not use the ASM spfile!