Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Oracle 11g Manual Database Creation.

  1. #1
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92

    Oracle 11g Manual Database Creation.

    Create necessary directories.

    $ mkdir -p /u01/app/oracle/admin/pub/adump/
    $ mkdir -p /u01/app/oracle/oradata/pub/
    $ mkdir -p /u01/app/oracle/flash_recovery_area/pub/


    Startup the database to nomount stage with sample parameter file.

    --Sample Parameter File
    ----------------------------------------------------------------------------
    pub.__db_cache_size=213909504
    pub.__java_pool_size=4194304
    pub.__large_pool_size=4194304
    pub.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
    pub.__pga_aggregate_target=251658240
    pub.__sga_target=369098752
    pub.__shared_io_pool_size=0
    pub.__shared_pool_size=138412032
    pub.__streams_pool_size=0
    *.audit_file_dest='/u01/app/oracle/admin/pub/adump'
    *.audit_trail='db'
    *.compatible='11.2.0.0.0'
    *.control_files='/u01/app/oracle/oradata/pub/control01.ctl',
    '/u01/app/oracle/flash_recovery_area/pub/control02.ctl'
    *.db_block_size=8192
    *.db_domain=''
    *.db_name='pub'
    *.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=pubXDB)'
    *.memory_target=620756992
    *.open_cursors=300
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.undo_tablespace='UNDOTBS1'
    ----------------------------------------------------------------------------


    $ export ORACLE_SID=pub
    $ sqlplus / as sysdba

    SQL> startup nomount pfile='/u01/initpub.ora';

    --Execute the Database Creation Script.


    CREATE DATABASE pub
    USER SYS IDENTIFIED BY sys
    USER SYSTEM IDENTIFIED BY sys
    LOGFILE GROUP 1 ('/u01/app/oracle/oradata/pub/redo01.log') SIZE 100M,
    GROUP 2 ('/u01/app/oracle/oradata/pub/redo02.log') SIZE 100M,
    GROUP 3 ('/u01/app/oracle/oradata/pub/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/pub/system01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE '/u01/app/oracle/oradata/pub/sysaux01.dbf' SIZE 325M REUSE
    DEFAULT TEMPORARY TABLESPACE temp1
    TEMPFILE '/u01/app/oracle/oradata/pub/temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE UNDOTBS1
    DATAFILE '/u01/app/oracle/oradata/pub/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/initpub.ora';

    File created.

    SQL> shutdown immediate
    SQL> startup

    Create password files.

    $ export ORACLE_SID=pub
    $ orapwd file=${ORACLE_HOME}/dbs/orapw${ORACLE_SID} password=sys entries=10

  2. #2
    This is a very simple and useful information. This is very useful information for the beginners.

+ Reply to Thread

Similar Threads

  1. Oracle RAC 11gR2 Policy Managed Database Creation using DBCA Part 2.
    By ajaychandi in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 02-26-2013, 07:14 PM
  2. Oracle RAC 11gR2 Policy Managed Database Creation using DBCA Part 1.
    By ajaychandi in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 02-26-2013, 07:11 PM
  3. Oracle Clusterware manual control command lines
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-24-2012, 04:15 PM
  4. Learn to do manual installation of the database in just 6 steps
    By shoaibansari in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 1
    Last Post: 02-14-2012, 04:50 PM
  5. Oracle Database Manual Backup and Recovery.
    By ajaychandi in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 01-24-2012, 06:51 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics