Manual construction of oracle 11g 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 Editing icsdb.sh Fil

Db_name='icsdb' # set to SID here

Memory_target=450M # SGA size

Processes = 150 # connections

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

Audit_trail = 'db'

Db_block_size=8192 # block size

Db_domain=''

Db_recovery_file_dest='/oracle/flash_recovery_area' # specify the path to the quick 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' # specify the control file path

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

Compatible = '11.2.0'

Start the instance to nomount status

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 ZHS16GBK

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 system/password pay attention to execution, otherwise using ordinary user connection will report "error accessing PRODUCT_USER_PROFILE" later.

@? / sqlplus/admin/pupbld.sql

The database was created successfully