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
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
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
Post a Comment