How to create database manually

How to create Database manually

creation of manual oracle database

• Choose a database name

orcl

• Create appropriate directories

mkdir -p /u01/app/oracle/oradata/orcl/ctl

mkdir -p /u01/app/oracle/oradata/orcl/log

mkdir -p /u01/app/oracle/oradata/orcl/data

mkdir -p /u01/app/oracle/oradata/orcl/temp

mkdir -p /u01/app/oracle/oradata/orcl/undo

mkdir -p /u01/app/oracle/oradata/orcl/ctl

• Create a parameter file

cd /u01/app/oracle/product/12.1.0/db_1/dbs/

vi initorcl.ora

db_name=orcl

control_files='/u01/app/oracle/oradata/orcl/ctl/control01.ctl'

sga_target=2G

pga_aggregate_target=1G

• Create a Windows service in case of Windows.

• Start the instance

SQL> SQL> SQL> startup nomount

ORACLE instance started.

Total System Global Area 2147481656 bytes

Fixed Size                  8898616 bytes

Variable Size             486539264 bytes

Database Buffers         1644167168 bytes

Redo Buffers                7876608 bytes

• Run the 'create database'

create database orcl

user sys identified by oracle

user system identified by oracle

logfile

 group 1 ('/u01/app/oracle/oradata/orcl/log/log1a.olf') size 50m,

 group 2 ('/u01/app/oracle/oradata/orcl/log/log2a.olf') size 50m

datafile

 '/u01/app/oracle/oradata/orcl/data/system01.dbf' size 1g

sysaux datafile

 '/u01/app/oracle/oradata/orcl/data/sysaux01.dbf' size 1g

default temporary tablespace temp

tempfile

 '/u01/app/oracle/oradata/orcl/temp/temp01.dbf' size 1g

undo tablespace undotb

datafile

 '/u01/app/oracle/oradata/orcl/undo/undo01.dbf' size 1g;

• Run the script to create dictionary views

@?/rdbms/admin/catalog.sql

• Run the script to create default pl/sql packages

@?/rdbms/admin/catproc.sql

• Run the script to create the sqlplus public user profile tables

@?/sqlplus/admin/pupbld.sql