Manual Database Creation 11g

Creating Oracle 11G Database manually in Linux Operating system

Step 1: Create Directory structure

#cd $ORACLE_BASE
# cd admin
# mkdir test
#cd test
#mkdir adump  bdump  pfile
#cd fast_recovery_area
# mkdir test

Step 2: Create Parameter file in  $ORACLE_HOME/dbs location

cd $ORACLE_HOME/dbs
vi initTEST.ora

TEST.__db_cache_size=8489271296
TEST.__java_pool_size=33554432
TEST.__large_pool_size=33554432
TEST.__oracle_base='/u03/app/oradba'#ORACLE_BASE set from environment
TEST.__pga_aggregate_target=3388997632
TEST.__sga_target=10166992896
TEST.__shared_io_pool_size=0
TEST.__shared_pool_size=1509949440
TEST.__streams_pool_size=33554432
*.audit_file_dest='/u03/app/oradba/admin/TEST/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u03/app/oradba/oradata/TEST/control01.ctl','/u03/app/oradba/fast_recovery_area/TEST/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='TEST'
*.db_recovery_file_dest='/u03/app/oradba/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/u03/app/oradba'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vtebz1.masscloudspace.local)(PORT=1521)))'
*.open_cursors=300
*.pga_aggregate_target=3380609024
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=10141827072
*.undo_tablespace='undo'


:wq





Step 3: Create the Password file

                        $orapwd file=$ORACLE_HOME/dbs/orapwtestdb
                        Password=sys entries=10

Step 4: Start the database in nomount state

SQL> startup nomount pfile=initTEST.ora




Step 5:Write and execute Database creation script

SQL> create database TEST
  2  logfile '/u03/app/oradba/oradata/TEST/redo01.log' size 50m,
  3             '/u03/app/oradba/oradata/TEST/redo02.log' size 50m
  4  datafile '/u03/app/oradba/oradata/TEST/system01.dbf' size 100m
  5  sysaux datafile '/u03/app/oradba/oradata/TEST/sysaux01.dbf' size 100m
  6  default temporary tablespace temp
  7  tempfile '/u03/app/oradba/oradata/TEST/temp01.dbf' size 100m
  8  undo tablespace undo
  9  datafile '/u03/app/oradba/oradata/TEST/undo01.dbf' size 100m;


Database created.




Step 7: Execute the catalog.sql,catproc.sql and pupbld.sql scripts

a)catalog.sql =>Creates dictionary tables and views
                          
b)catproc.sql =>Creates PL/SQL procedures,functions and packages necessary.

c)pupbld.sql  =>Creates user profiles.


So our database is created. Now just run the catalog.sql,catproc.sql and pupbld.sql scripts.
Location for catalog.sql and catproc.sql in $ORACLE_HOME/rdbms/admin  path and     pupbld.sql in $ORACLE_HOME/sqlplus/admin path.

                   SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql








SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
          conn system/manager


SQL>@$ORACLE_HOME/sqlplus/admin/pupbld.sql


Refer:


Manual Database Creation in Oracle9i (Single Instance and RAC) (Doc ID 137288.1)

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2