Oracle11g manual steps, oracle11g steps

Oracle11g manual steps, oracle11g 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 = 'clusive'
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 100 m blocksize 512,
GROUP 2 ('/u01/app/oracle/oradata/kevin/disk1/redo02a. log', '/u01/app/oracle/oradata/kevin/disk2/redo02b. log') SIZE 100 m blocksize 512,
GROUP 3 ('/u01/app/oracle/oradata/kevin/disk1/redo03a. log', '/u01/app/oracle/oradata/kevin/disk2/redo03b. log ') SIZE 100 m 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 325 M REUSE
Sysaux datafile '/u01/app/oracle/oradata/kevin/disk2/sysaux01.dbf' SIZE 325 M REUSE
Default tablespace users
DATAFILE '/u01/app/oracle/oradata/kevin/disk1/users01.dbf'
SIZE 500 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Default temporary tablespace tempts1
TEMPFILE '/u01/app/oracle/oradata/kevin/disk2/temp01.dbf'
SIZE 20 M REUSE
Undo tablespace undotbs
DATAFILE '/u01/app/oracle/oradata/kevin/disk3/undotbs01.dbf'
SIZE 200 m reuse autoextend on maxsize 1024 m;




 
# Create oracle dictionary information


@? /Rdbms/admin/catalog. SQL
@? /Rdbms/admin/catproc. SQL




@? /Sqlplus/admin/pupbld. SQL




The database was created successfully