ORACLE 11G MANUAL DB CREATION

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