Create Directory
-----------------
mkdir -p /apps/oracle/test
Crate a pfile with Min requirements
-----------------------------------
vi $ORACLE_HOME/dbs/initada.ora
db_name = ada
diagnostic_dest='/apps/oracle/test/'
control_files='/apps/oracle/test/ctrl1','/apps/oracle/test/ctrl2'
db_create_file_dest='/apps/oracle/test/'
db_create_online_log_dest_1='/apps/oracle/test/'
db_recovery_file_dest='/apps/oracle/test/'
db_recovery_file_dest_size=10G
diagnostic_dest='/apps/oracle/test/'
Create DB now
-------------------------------------
export ORACLE_SID=ada
sqlplus /nolog
STARTUP NOMOUNT
CREATE DATABASE ada
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/apps/oracle/test/redo01.log') SIZE 10M,
GROUP 2 ('/apps/oracle/test/redo02.log') SIZE 10M,
GROUP 3 ('/apps/oracle/test/redo03.log') SIZE 10M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/apps/oracle/test/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/apps/oracle/test/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/apps/oracle/test/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/apps/oracle/test/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/apps/oracle/test/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
/
create spfile
------------------------
create spfile from pfile;
Create Dictonary Objects
-------------------------
cd $ORACLE_HOME/rdbms/admin
SQL> @catalog.sql
SQL> @catproc.sql
SQL> @pupbld.sql
Change Mode
--------------------------
Change Database Mode from NO-ARCHIVELOG to ARCHIVELOG.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 150667264 bytes
Fixed Size 1331740 bytes
Variable Size 92278244 bytes
Database Buffers 50331648 bytes
Redo Buffers 6725632 bytes
Database mounted.
SQL> alter database ARCHIVELOG;
Database altered.
SQL> alter database OPEN;
Database altered.
Craete password File
--------------------
orapwd file=$ORACLE_HOME/dbs/orapwada entries=30
Thanks
Adarsh Kumar
AK Technosoft Corp.
www.aktechnosoft.com
