Oracle --- Create instance



pbrun - root
su - oracle

1. Create all required directories as below.

mkdir -p /u20/oracle/admin/PROJECT/adump
mkdir -p /u20/oracle/admin/PROJECT/dpdump
mkdir -p /u20/oracle/admin/PROJECT/pfile
mkdir -p /u20/oradata/PROJECT/ARCHLOG
mkdir -p /u20/oradata/PROJECT/CONTROLFILE1
mkdir -p /u20/oradata/PROJECT/CONTROLFILE2
mkdir -p /u20/oradata/PROJECT/CONTROLFILE3
mkdir -p /u20/oradata/PROJECT/DATAFILES
mkdir -p /u20/oradata/PROJECT/REDOLOG/

chown -R oracle u20

2:create initPROJECT.ora as below

PROJECT.__db_cache_size=192937984
PROJECT.__java_pool_size=67108864
PROJECT.__large_pool_size=4194304
PROJECT.__oracle_base='/optware/oracle'#ORACLE_BASE set from environment
PROJECT.__pga_aggregate_target=364904448
PROJECT.__sga_target=683671552
PROJECT.__shared_io_pool_size=0
PROJECT.__shared_pool_size=406847488
PROJECT.__streams_pool_size=0
*.audit_file_dest='/u20/oracle/admin/PROJECT/adump'
*.audit_sys_operations=FALSE
*.audit_trail='NONE'
*.compatible='11.2.0.0.0'
*.control_files='//u20/oradata/PROJECT/CONTROLFILE1/control01.ctl','/u20/oradata/PROJECT/CONTROLFILE2/control02.ctl'
*.db_block_size=8192