Manual Database Creation In 11g

Manual Database Creation:

Set the bash profile

[oracle@cissoadevdb02 bin]$vi ORAUAT

ORACLE_SID="orauat" ; export ORACLE_SID

DB_NAME="orauat" ; export DB_NAME

ORACLE_BASE=/orauat/product/oracle ; export ORACLE_BASE

ORACLE_HOME=/orauat/product/oracle/11.2.0 ; export ORACLE_HOME

TNS_ADMIN=$ORACLE_HOME/network/admin ; export TNS_ADMIN

PATH=$ORACLE_HOME/bin:$PATH:. ; export PATH

. ~/bin/login.env

Now source the envfile . .bash_profile

Create the pfile in dbs location vi initorauat.ora

*.archive_lag_target=3600

*.audit_file_dest='/orauat/product/oracle/audit/orauat/adump'

*.compatible='11.2.0'

*.control_file_record_keep_time=45

*.control_files='/orauat/oradata/orauat/control01.ctl','/orauat/oradata/orauat/control02.ctl'

*.db_block_size=8192

*.db_cache_size=128m

*.db_file_multiblock_read_count=16

*.db_name='orauat'

*.diagnostic_dest='/orauat/product/oracle'

*.java_pool_size=16m

*.job_queue_processes=4

*.large_pool_size=16m

*.log_archive_dest='/orauat/oradata/archives/orauat'

*.open_cursors=500

*.parallel_max_servers=16

*.pga_aggregate_target=500M

*.processes=600

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=4g

*.shared_pool_size=128m

*.undo_tablespace='UNDOTBS1'

:wq!

Create Directories for datafiles,Controlfiles,archives and Audit files

$cd /orauat/product/oracle/audit/

$ mkdir -p /orauat/adump

$cd /orauat/oradata/

$mkdir orauat

$cd /orauat/oradata/archives/

$mkdir orauat

 Now check the inventory location

[orauat@ltkoraorauatdb02 etc]$cat oraInst.loc (Global Inventory Location cd /etc)

inventory_loc=/orauat/product_11.2.0.4/oraInventory

inst_group=oinstall

Set tns and listener files

Cd $ORACLE_HOME/network/admin

vi listener.ora

 (SID_DESC =

      (ORACLE_HOME= /orauat/product/oracle/11.2.0)

      (SID_NAME = orauat)

   )

:wq!

vi tnsnames.ora

orauat =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ltkoraorauatdb02.com )(PORT = 1545))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID = orauat)

    )

  )

wq!

Now prepare the database creation script

vi orauat.sql

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "orauat" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 16

    MAXLOGMEMBERS 4

    MAXDATAFILES 100

    MAXINSTANCES 8

    MAXLOGHISTORY 292

LOGFILE

  GROUP 1 '/orauat/oradata/orauat/redo01.log'  SIZE 128m BLOCKSIZE 512,

  GROUP 2 '/orauat/oradata/orauat/redo02.log'  SIZE 128m BLOCKSIZE 512,

  GROUP 3 '/orauat/oradata/orauat/redo03.log'  SIZE 128m BLOCKSIZE 512

DATAFILE

  '/orauat/oradata/orauat/system.dbf',

  '/orauat/oradata/orauat/sysaux.dbf',

  '/orauat/oradata/orauat/afpodata.dbf',

  '/orauat/oradata/orauat/undotbs1.dbf'

CHARACTER SET AL32UTF8;

ALTER DATABASE OPEN RESETLOGS;

ALTER TABLESPACE TEMP ADD TEMPFILE '/orauat/oradata/orauat/temp.dbf'

     SIZE 30408704  REUSE AUTOEXTEND ON NEXT 134217728  MAXSIZE 8192M;

:wq!

Connect sqlplus ‘/ as sysdba’

Run the database creation script

Connect sqlplus ‘/ as sysdba’

Run the database creation script

$cd $ORACLE_HOME/rdbms/admin
run the bleow scrits after creation of database

$sqlplus '/ as sysdba';

SQL>@?/rdbms/admin/catalog.sql

SQL>@?/rdbms/admin/catproc.sql

SQL>@?/javavm/install/initjvm.sql