oracle11g 建库步骤,oracle11g 手工建库步骤

#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

原文：http://www.cnblogs.com/jhcelue/p/6901992.html