Creating database manually step by step by Pushpjeet Cholkar
Download the text file from her Download
1)Create required directories at OS level as oracle user
/u01/app/oracle/oradata/info
/u01/app/oracle/oradata/info/log
/u01/app/oracle/oradata/info/data
/u01/app/oracle/oradata/info/control
2)
Compose a parameter file with name initinfo.ora at database default location $ORACLE_HOME/dbs
db_name=info
instance_name=info
db_block_size=8192
control_files=(/u01/app/oracle/oradata/info/control/control1.ctl,/u01/app/oracle/oradata/info/control/control2.ctl)
sga_max_size=400m
shared_pool_size=300m
undo_management=auto
undo_tablespace=undotbs1
remote_login_passwordfile=exclusive
compatible=11.2.0
3)
Create a database script file with name db.txt at database default location -- Create sql script file or normal text file anywhere at os level or even just write the below command to create database.
create database info
logfile group 1 '/u01/app/oracle/oradata/info/log/redo1a.log' size 50m,
group 2 '/u01/app/oracle/oradata/info/log/redo2a.log' size 50m,
group 3 '/u01/app/oracle/oradata/info/log/redo3a.log' size 50m,
group 4 '/u01/app/oracle/oradata/info/log/redo4a.log' size 50m
datafile '/u01/app/oracle/oradata/info/data/system01.dbf' size 200m autoextend on maxsize unlimited
sysaux datafile '/u01/app/oracle/oradata/info/data/sysaux01.dbf' size 200m autoextend on maxsize unlimited
default temporary tablespace info_temp tempfile '/u01/app/oracle/oradata/info/data/temp1.dbf' size 200m autoextend on maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/info/data/undo1.dbf' size 200m autoextend on maxsize unlimited;
4)
Create password file by the following command
orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwinfo password=admin entries=10
5)
Make entry in /etc/oratab file
info:/u01/app/oracle/product/11.2.0/dbhome_1:N
6)
Set the enviornment to start the instance
[oracle@oracle ~]$ . oraenv
ORACLE_SID = [orcl] ? info
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@oracle ~]$
Check it is set or not
[oracle@oracle ~]$ env | grep ORACLE
ORACLE_UNQNAME=info
ORACLE_SID=info
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=oracle.localdomain
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@oracle ~]$
7)
Startup database in nomount state to run the 3 important script to create data dictionary view,procedure,function,package and other object automatically.
[oracle@oracle ~]$ sqlplus / as sysdba
SQL> startup nomount
SQL> @'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/db.txt'
SQL> create spfile from pfile;
SQL> @'/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catalog.sql'
SQL> @'/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catproc.sql'
* For the 3rd script pupbld.sql login as system the default password will be manager
SQL> conn system/manager
SQL> '/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/pupbld.sql'
*Again login as sys
SQL> connect sys/admin as sysdba
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 418484224 bytes
Fixed Size 1336932 bytes
Variable Size 360712604 bytes
Database Buffers 50331648 bytes
Redo Buffers 6103040 bytes
Database mounted.
Database opened.
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
INFO READ WRITE
Congratulation your database is created and now in open mode!!!!!!
Thanks Pushpjeet Cholkar.
