Oracle 11g Manual Database Creation.
Create necessary directories.
$ mkdir -p /u01/app/oracle/admin/nashim/adump/
$ mkdir -p /u01/app/oracle/oradata/nashim/
$ mkdir -p /u01/app/oracle/flash_recovery_area/nashim/
Startup the database to nomount stage with sample parameter file.
--Sample Parameter File
----------------------------------------------------------------------------
nashim.__db_cache_size=213909504
nashim.__java_pool_size=4194304
nashim.__large_pool_size=4194304
nashim.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
nashim.__pga_aggregate_target=251658240
nashim.__sga_target=369098752
nashim.__shared_io_pool_size=0
nashim.__shared_pool_size=138412032
nashim.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/nashim/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/nashim/control01.ctl',
'/u01/app/oracle/flash_recovery_area/nashim/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='nashim'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=nashimXDB)'
*.memory_target=620756992
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
----------------------------------------------------------------------------
$ export ORACLE_SID=nashim
$ sqlplus / as sysdba
SQL> startup nomount pfile='/u01/initnashim.ora';
--Execute the Database Creation Script.
CREATE DATABASE nashim
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY sys
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/nashim/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/nashim/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/nashim/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/nashim/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/nashim/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE temp1
TEMPFILE '/u01/app/oracle/oradata/nashim/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE '/u01/app/oracle/oradata/nashim/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Run additional scripts
SQL>@?/rdbms/admin/catalog.sql
SQL>@?/rdbms/admin/catproc.sql
Create Spfile for the database.
SQL> create spfile from pfile='/u01/initnashim.ora';
File created.
SQL> shutdown immediate
SQL> startup
Create password files.
$ export ORACLE_SID=nashim
$ orapwd file=${ORACLE_HOME}/dbs/orapw${ORACLE_SID} password=sys entries=10
