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

Oracle手工创建数据库的完整步骤一建立存放数据库文件的目录和日志相关的文件目录分别在$ORACLE_BASEoradata 和 $ORACLE_BASEadmin目录下建立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以非交互（静默）方式创建数据库 http://www.linuxidc.com/Linux/2014-04/99840.htmOralce 10g 使用DBCA创建数据库 http://www.linuxidc.com/Linux/2013-08/88791.htm手动创建数据库的整体流程 Oracle 11g http://www.linuxidc.com/Linux/2013-04/83260.htmCentOS 5.2 x86 安装Oracle 11g R2 笔记 http://www.linuxidc.com/Linux/2014-04/99931.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm--------------------------------------分割线 --------------------------------------三创建初始化参数文件1 创建参数文件vi $ORACLE_BASE/dbs/initNEWDB.oracontrol_files = （/u01/app/oradata/NEWDB/control01.dbf,/u01/app/oradata/NEWDB/control02.dbf,/u01/app/oradata/NEWDB/control03.dbf）db_name = NEWDBdb_domain = NEWDB.oracle.comlog_archive_dest_1 = "LOCATION=/u01/app/admin/NEWDB/arch"log_archive_dest_state_1 = enabledb_block_size = 8192pga_aggregate_target = 90Mprocesses = 100sessions = 120open_cursors = 200undo_management = AUTOundo_tablespace = undotbscompatible = 10.2.0sga_target = 270Mnls_language = AMERICANnls_territory = AMERICAdb_recovery_file_dest = /u01/app/admin/NEWDB/flashbackdb_recovery_file_dest_size = 1Gaudit_dump_dest = /u01/app/admin/NEWDB/adumpcore_dump_dest = /u01/app/admin/NEWDB/cdumpbackground_dump_dest = /u01/app/admin/NEWDB/bdump2 创建spfile参数文件[oracle@wang dbs]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 23 14:37:08 2014Copyright （c） 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> create spfile from pfile;File created.四创建数据库1 startup nomount;2 编写创建数据库脚本vi tempCREATE DATABASE NEWDBUSER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY oracleLOGFILE 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 50MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16DATAFILE "/u01/app/oradata/NEWDB/system01.dbf" SIZE 325M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE "/u01/app/oradata/NEWDB//sysaux01.dbf" SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE "/u01/app/oradata/NEWDB/temp01.dbf"SIZE 20M REUSEUNDO TABLESPACE undotbsDATAFILE "/u01/app/oradata/NEWDB/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;3执行脚本SQL> CREATE DATABASE NEWDBUSER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY oracleLOGFILE 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 50MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16DATAFILE "/u01/app/oradata/NEWDB/system01.dbf" SIZE 325M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE "/u01/app/oradata/NEWDB//sysaux01.dbf" SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE "/u01/app/oradata/NEWDB/temp01.dbf"SIZE 20M REUSEUNDO TABLESPACE undotbsDATAFILE "/u01/app/oradata/NEWDB/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22Database created.更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-05/101286p2.htm

Oracle Connect By 使用实例Oracle备份脚本执行失败解决实例相关资讯 Oracle创建数据库 Oracle手工创建数据库

Oracle创建数据库和用户（07/23/2015 11:15:57）
通过命令创建Oracle 11g数据库（10/15/2014 11:20:09）
Linux下手动创建Oracle数据库过程（07/26/2013 10:16:25）

手工创建Oracle数据库详解（05/19/2015 08:41:49）
Oracle 10g创建数据库并配置远程访（08/13/2013 10:14:08）
手工创建Oracle数据库（05/26/2013 14:15:20）

本文评论查看全部评论（0）