ORACLE11G Manual Hard Steps

#create Oracle Instance parameter
VI initkevin.or
Db_name= ' Kevin '
Memory_target=0
sga_max_size=5g
sga_target=3g
pga_aggregate_target=1g
processes = 150
Audit_file_dest= '/u01/app/oracle/admin/kevin/adump '
Audit_trail = ' db '
db_block_size=8192
Db_domain= "
Db_recovery_file_dest= '/u01/app/oracle/flash_recovery_area '
db_recovery_file_dest_size=2g
Diagnostic_dest= '/u01/app/oracle '
Dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '
open_cursors=300
Remote_login_passwordfile= ' EXCLUSIVE '
Undo_tablespace= ' Undotbs '
Control_files = ('/u01/app/oracle/oradata/kevin/disk1/controflie01.ctl ', '/u01/app/oracle/oradata/kevin/disk2/ Controlfile02.ctl ')
compatible = ' 11.2.0 '


#create audit_file directory, db_recovery directory and Orther directories
Mkdir-p/u01/app/oracle/admin/kevin/adump
Mkdir-p/u01/app/oracle/flash_recovry_area
Mkdir-p/u01/app/oracle/oradata/kevin/disk1
Mkdir-p/u01/app/oracle/oradata/kevin/disk1


#configure Oracle User Environment value
Export Oracle_sid=kevin


#create Oracle Password Pfile
Orapwd File=orapwdkevin password=oracle entries=3 force=y



#start Nomount Oracle Database instance


Startup Nomount Pifle=?/dbs/initkevin.ora


sql> Startup Nomount Pfile=?/dbs/initkevin.ora
ORACLE instance started.


Total System Global area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 2885683584 bytes
Database buffers 2449473536 bytes
Redo buffers 7311360 bytes


#create SPFile from Pfile
Create SPFile from Pfile;


Sql>
Sql> create SPFile from Pfile;


File created.




#create database;


CREATE DATABASE Kevin
USER SYS identified by Oracle
USER SYSTEM identified by Oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kevin/disk1/redo01a.log ', '/u01/app/oracle/oradata/kevin/disk2/ Redo01b.log ') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/kevin/disk1/redo02a.log ', '/u01/app/oracle/oradata/kevin/disk2/redo02b.log ') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/kevin/disk1/redo03a.log ', '/u01/app/oracle/oradata/kevin/disk2/redo03b.log ') SIZE 100M BLOCKSIZE 512
Maxlogfiles 5
Maxlogmembers 5
Maxloghistory 1
Maxdatafiles 100
CHARACTER SET Al32utf8
National CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DataFile '/u01/app/oracle/oradata/kevin/disk1/system01.dbf ' SIZE 325M reuse
Sysaux datafile '/u01/app/oracle/oradata/kevin/disk2/sysaux01.dbf ' SIZE 325M reuse
DEFAULT tablespace Users
DataFile '/u01/app/oracle/oradata/kevin/disk1/users01.dbf '
SIZE 500M Reuse autoextend on MAXSIZE UNLIMITED
DEFAULT Temporary tablespace tempts1
Tempfile '/u01/app/oracle/oradata/kevin/disk2/temp01.dbf '
SIZE 20M Reuse
UNDO tablespace Undotbs
DataFile '/u01/app/oracle/oradata/kevin/disk3/undotbs01.dbf '
SIZE 200M Reuse autoextend on MAXSIZE 1024m;





#create Oracle Dictionary Information


@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql




@?/sqlplus/admin/pupbld.sql




The database was created successfully

ORACLE11G Manual Hard Steps