oracle 10g手动建库,10G oracle 手动建库

1.首先创建一个参数文件pfile.ora ：

可添加参数文件：

CLUSTER_DATABASE

COMPATIBLE

CONTROL_FILES

DB_BLOCK_SIZE

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_DEST_n

DB_DOMAIN

DB_NAME

DB_RECOVERY_FILE_DEST

DB_RECOVERY_FILE_DEST_SIZE

DB_UNIQUE_NAME

INSTANCE_NUMBER

JOB_QUEUE_PROCESSES

LOG_ARCHIVE_DEST_n

LOG_ARCHIVE_DEST_STATE_n

NLS_LANGUAGE

NLS_TERRITORY

OPEN_CURSORS

PGA_AGGREGATE_TARGET

PROCESSES

REMOTE_LISTENER

REMOTE_LOGIN_PASSWORDFILE

ROLLBACK_SEGMENTS

SESSIONS

SGA_TARGET

SHARED_SERVERS

STAR_TRANSFORMATION_ENABLED

UNDO_MANAGEMENT

UNDO_TABLESPACE

我的ora：

CONTROL_FILES='/u01/app/oracle/disk1/control01.ctl'

DB_BLOCK_SIZE=8192

DB_NAME=PROD

JOB_QUEUE_PROCESSES=10

LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/disk1/arch'

PGA_AGGREGATE_TARGET=1024m

PROCESSES=200

REMOTE_LOGIN_PASSWORDFILE=SHARED

SGA_TARGET=500m

UNDO_MANAGEMENT=auto

UNDO_TABLESPACE=undotbs1

2.然后修改ORACLE_SID，启动到nomount

3.执行创建数据库

CREATE DATABASE PROD

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oracle/disk1/redo01.log') SIZE 60M,

GROUP 2 ('/u01/app/oracle/disk1/redo02.log') SIZE 60M,

GROUP 3 ('/u01/app/oracle/disk1/redo03.log') SIZE 60M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/u01/app/oracle/disk1/system01.dbf' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oracle/disk1/sysaux01.dbf' SIZE 100M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oracle/disk1/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs1

DATAFILE '/u01/app/oracle/disk1/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

4.执行脚本

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28889722/viewspace-1424442/，如需转载，请注明出处，否则将追究法律责任。