Oracle 11g hand-built library

Create a password file

CD $ORACLE _home/dbs

Orapwd file=orapwogg02 password=oracle entries=5

Mkdir-p $ORACLE _base/flash_recovery_area

Mkdir-p $ORACLE _base/admin/$ORACLE _sid/adump

Mkdir-p $ORACLE _base/admin/$ORACLE _sid/dpdump

Mkdir-p $ORACLE _base/admin/$ORACLE _sid/pfile

Mkdir-p $ORACLE _base/admin/$ORACLE _sid/scripts

CD $ORACLE _home

CD DBS

Cat init.ora|grep-v ^$|grep-v ^# > Initicsdb.ora

Vim Edit icsdb.sh file

Db_name= ' Icsdb ' #此处设置为SID

memory_target=450m #SGA Size

processes = #连接数

Audit_file_dest= '/oracle/admin/icsdb/adump '

Audit_trail = ' db '

db_block_size=8192 #块大小

Db_domain= "

db_recovery_file_dest= '/oracle/flash_recovery_area ' #指定快速恢复区路径

db_recovery_file_dest_size=2g

diagnostic_dest= '/oracle ' #oracle Software installation directory

Dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '

open_cursors=300

Remote_login_passwordfile= ' EXCLUSIVE '

Undo_tablespace= ' Undotbs ' #指定control file path

Control_files = (/ora_data/icsdb/control01.ctl,/ora_data/icsdb/control02.ctl)

compatible = ' 11.2.0 '

Launch instance to Nomount state

Sqlplus/as SYSDBA

sql> startup Nomount pfile= ' $ORACLE _home/dbs/initicsdb.ora '

Sql> create SPFile from Pfile;

Run the following script:

CREATE DATABASE Icsdb

USER SYS identified by Sys_password

USER SYSTEM identified by System_password

LOGFILE GROUP 1 ('/ora_data/icsdb/redo01a.log ', '/ora_data/icsdb/redo01b.log ') SIZE 100M BLOCKSIZE 512,

GROUP 2 ('/ora_data/icsdb/redo02a.log ', '/ora_data/icsdb/redo02b.log ') SIZE 100M BLOCKSIZE 512,

GROUP 3 ('/ora_data/icsdb/redo03a.log ', '/ora_data/icsdb/redo03b.log ') SIZE 100M BLOCKSIZE 512

Maxlogfiles 5

Maxlogmembers 5

Maxloghistory 1

Maxdatafiles 100

CHARACTER SET Us7ascii

National CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DataFile '/ora_data/icsdb/system01.dbf ' SIZE 325M reuse

Sysaux datafile '/ora_data/icsdb/sysaux01.dbf ' SIZE 325M reuse

DEFAULT tablespace Users

DataFile '/ora_data/icsdb/users01.dbf '

SIZE 500M Reuse autoextend on MAXSIZE UNLIMITED

DEFAULT Temporary tablespace tempts1

Tempfile '/ora_data/icsdb/temp01.dbf '

SIZE 50M Reuse

UNDO tablespace Undotbs

DataFile '/ora_data/icsdb/undotbs01.dbf '

SIZE 200M Reuse autoextend on MAXSIZE UNLIMITED;

#create Oracle Dictionary Information

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

Conn/as system

@?/sqlplus/admin/pupbld.sql

The database was created successfully

This article is from the "record a bit of learning life" blog, please make sure to keep this source http://ureysky.blog.51cto.com/2893832/1918307

Oracle 11g hand-built library