Oracle手工创建数据库的完整步骤_动视

Oracle手工创建数据库的完整步骤

2020-11-09 12:38:58 责编:小采

点击下载本文 文档为doc格式

Oracle手工创建数据库的完整步骤一建立存放数据库文件的目录和日志相关的文件目录分别在$ORACLE_BASE\oradata 和 $ORACLE_BAS

Oracle手工创建数据库的完整步骤

一建立存放数据库文件的目录和日志相关的文件目录

分别在$ORACLE_BASE\oradata 和 $ORACLE_BASE\admin目录下建立NEWDB目录

使用命令查看目录结构

[oracle@wang NEWDB]$ pwd

/u01/app/admin/NEWDB

[oracle@wang NEWDB]$ pwd

/u01/app/oradata/NEWDB

二确定ORACLE实例名

[oracle@wang NEWDB]$ export ORACLE_SID=NEWDB

--------------------------------------分割线 --------------------------------------

Oracle 11g使用DBCA以非交互(静默)方式创建数据库

Oralce 10g 使用DBCA创建数据库

手动创建数据库的整体流程 Oracle 11g

CentOS 5.2 x86 安装Oracle 11g R2 笔记

在CentOS 6.4下安装Oracle 11gR2(x)

Oracle 11gR2 在VMWare虚拟机中安装步骤

--------------------------------------分割线 --------------------------------------

三创建初始化参数文件

1 创建参数文件

vi $ORACLE_BASE/dbs/initNEWDB.ora

control_files = (/u01/app/oradata/NEWDB/control01.dbf,

/u01/app/oradata/NEWDB/control02.dbf,

/u01/app/oradata/NEWDB/control03.dbf)

db_name = NEWDB

db_domain = NEWDB.oracle.com

log_archive_dest_1 = "LOCATION=/u01/app/admin/NEWDB/arch"

log_archive_dest_state_1 = enable

db_block_size = 8192

pga_aggregate_target = 90M

processes = 100

sessions = 120

open_cursors = 200

undo_management = AUTO

undo_tablespace = undotbs

compatible = 10.2.0

sga_target = 270M

nls_language = AMERICAN

nls_territory = AMERICA

db_recovery_file_dest = /u01/app/admin/NEWDB/flashback

db_recovery_file_dest_size = 1G

audit_dump_dest = /u01/app/admin/NEWDB/adump

core_dump_dest = /u01/app/admin/NEWDB/cdump

background_dump_dest = /u01/app/admin/NEWDB/bdump

2 创建spfile参数文件

[oracle@wang dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 23 14:37:08 2014

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

四创建数据库

1 startup nomount;

2 编写创建数据库脚本

vi temp

CREATE DATABASE NEWDB

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oradata/NEWDB/redo01.log') SIZE 50M,

GROUP 2 ('/u01/app/oradata/NEWDB//redo02.log') SIZE 50M,

GROUP 3 ('/u01/app/oradata/NEWDB/redo03.log') SIZE 50M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/u01/app/oradata/NEWDB/system01.dbf' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oradata/NEWDB//sysaux01.dbf' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oradata/NEWDB/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/u01/app/oradata/NEWDB/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

3执行脚本

SQL> CREATE DATABASE NEWDB