#Guide to oracle 10g code
# Database Creation Code #ĭatafile '/u01/oracle/product/10.2.0/devdb/data/system01.dbf' size 500M users.dbf (for DEFAULT PERMANENT tablespace) temp_tbs.dbf file (for TEMPORARY tablespace) system.dbf and sysaux.dbf (files for SYSTEM tablespace)
As a result, below files will be created:
To create a new database, use the CREATE DATABASE statement. $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwd.ora password=oracle entries=5Ĥ. Now our instance started, SGA allocated and background processes started Sql\> CREATE SPFILE FROM PFILE=’/home/oracle/oracle/product/10.2.0/init.ora’ Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode. Create parameter file and modify it by setting minimum required parameters: Mkdir -p /u01/oracle/product/10.2.0/flash_recovery_areaĢ. Mkdir -p /u01/oracle/product/10.2.0/admin/devdb/cdump Mkdir -p /u01/oracle/product/10.2.0/admin/devdb/udump Mkdir -p /u01/oracle/product/10.2.0/admin/devdb/oradata Create desired folder apropiriet directory