Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g

系统环境：操作系统： RedHat EL6Oracle： Oracle 10g and Oracle 11g 手工建库相对来说很容易实现，本案例是从10g和11g，通过手工建库的方式做一个简单的对比，可以看出11g和10g之间的一个简单的差异！VMware+Linux+Oracle 10G RAC全程详细图解 http://www.linuxidc.com/Linux/2011-02/31976.htm案例二：在Oracle 11g 环境下手工建库DB_NAME="test1"INSTANCE_NAME="test1"1、建立Instance的初始化参数文件和口令文件[oracle@rh6 dbs]$cat inittest1.oradb_name="test1"memory_target=400m //Oracle 11g增加了内存自动管理processes = 150audit_file_dest="$ORACLE_BASE/admin/test1/adump"audit_trail ="db"db_block_size=8192db_domain=""open_cursors=300remote_login_passwordfile="EXCLUSIVE"undo_tablespace="UNDOTBS1"# You may want to ensure that control files are created on separate physical# devicescontrol_files = /u01/app/oracle/oradata/test1/control01.ctlcompatible ="11.2.0" [oracle@rh6 dbs]$ orapwd file=orapwtest1 password=oracle entries=3 2、建立数据库相关的目录Oracle 11g增加了diagnostic directory，默认的为$ORACLE_BASE[oracle@rh6 dbs]$ mkdir -p $ORACLE_BASE/admin/test1/adump[oracle@rh6 dbs]$ mkdir -p /u01/app/oracle/oradata/test1 3、建立建库脚本[oracle@rh6 ~]$ cat cr_db.sqlCREATE DATABASE test1USER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY oracleLOGFILEGROUP 1 （"/u01/app/oracle/oradata/test1/redo01a.log"） SIZE 50M ,GROUP 2 （"/u01/app/oracle/oradata/test1/redo02a.log"） SIZE 50MMAXLOGFILES 10MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 200CHARACTER SET zhs16gbkDATAFILE "/u01/app/oracle/oradata/test1/system01.dbf" SIZE 325M REUSESYSAUX DATAFILE "/u01/app/oracle/oradata/test1/sysaux01.dbf" SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE "/u01/app/oracle/oradata/test1/temp01.dbf"SIZE 100M REUSEUNDO TABLESPACE undotbs1DATAFILE "/u01/app/oracle/oradata/test1/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 4、启动Instance并建立数据库[oracle@rh6 ~]$ export ORACLE_SID=test1[oracle@rh6 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.1.0 Production on Wed May 21 10:59:58 2014Copyright （c） 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.10:59:59 SYS@ test1>startup nomount;ORACLE instance started.Total System Global Area 417546240 bytesFixed Size 2213936 bytesVariable Size 268437456 bytesDatabase Buffers 142606336 bytesRedo Buffers 4288512 bytes11:00:12 SYS@ test1>@/home/oracle/cr_dbDatabase created.Elapsed: 00:01:23.4411:01:51 SYS@ test1> 建库告警日志：CREATE TABLESPACE sysaux DATAFILE "/u01/app/oracle/oradata/test1/sysaux01.dbf" SIZE 325M REUSEEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINEWed May 21 11:01:08 2014Completed: CREATE TABLESPACE sysaux DATAFILE "/u01/app/oracle/oradata/test1/sysaux01.dbf" SIZE 325M REUSEEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINEprocessing ？/rdbms/admin/dplsql.bsqprocessing ？/rdbms/admin/dtxnspc.bsqCREATE UNDO TABLESPACE UNDOTBS1 DATAFILE "/u01/app/oracle/oradata/test1/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDWed May 21 11:01:23 2014Successfully onlined Undo Tablespace 2.Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE "/u01/app/oracle/oradata/test1/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDCREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE "/u01/app/oracle/oradata/test1/temp01.dbf"SIZE 100M REUSECompleted: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE "/u01/app/oracle/oradata/test1/temp01.dbf"SIZE 100M REUSEALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1ALTER DATABASE DEFAULT TABLESPACE SYSTEM Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM processing ？/rdbms/admin/dfmap.bsqprocessing ？/rdbms/admin/denv.bsqprocessing ？/rdbms/admin/drac.bsqprocessing ？/rdbms/admin/dsec.bsqprocessing ？/rdbms/admin/doptim.bsqprocessing ？/rdbms/admin/dobj.bsqprocessing ？/rdbms/admin/djava.bsqprocessing ？/rdbms/admin/dpart.bsqWed May 21 11:01:34 2014processing ？/rdbms/admin/drep.bsqprocessing ？/rdbms/admin/daw.bsqprocessing ？/rdbms/admin/dsummgt.bsqprocessing ？/rdbms/admin/dtools.bsqprocessing ？/rdbms/admin/dexttab.bsqprocessing ？/rdbms/admin/ddm.bsqprocessing ？/rdbms/admin/dlmnr.bsqprocessing ？/rdbms/admin/ddst.bsqWed May 21 11:01:43 2014SMON: enabling tx recoveryStarting background process SMCOWed May 21 11:01:44 2014SMCO started with pid=17, OS id=2816 Wed May 21 11:01:50 2014replication_dependency_tracking turned off （no async multimaster replication found）Starting background process QMNCWed May 21 11:01:50 2014QMNC started with pid=20, OS id=2826 Completed: CREATE DATABASE test1USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILEGROUP 1 （"/u01/app/oracle/oradata/test1/redo01a.log"） SIZE 50M ,GROUP 2 （"/u01/app/oracle/oradata/test1/redo02a.log"） SIZE 50MMAXLOGFILES 10MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 200CHARACTER SET zhs16gbkDATAFILE "/u01/app/oracle/oradata/test1/system01.dbf" SIZE 325M REUSESYSAUX DATAFILE "/u01/app/oracle/oradata/test1/sysaux01.dbf" SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE "/u01/app/oracle/oradata/test1/temp01.dbf"SIZE 100M REUSEUNDO TABLESPACE undotbs1DATAFILE "/u01/app/oracle/oradata/test1/undotbs01.dbf"SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED 更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-05/102086p2.htm10gRAC-10.2.0.4-dbca建库时配置OEM遇到BUG-p8350262 http://www.linuxidc.com/Linux/2014-02/97111.htmOracle 11g R2 手动建库（create database manually） http://www.linuxidc.com/Linux/2013-11/92829.htmOracle 11g + ASM DBCA 建库问题解决心得 http://www.linuxidc.com/Linux/2013-10/90974.htmLinux下Oracle 10g手工建库全过程 http://www.linuxidc.com/Linux/2013-02/78887.htmOracle 9i数据库手工建库过程简记 http://www.linuxidc.com/Linux/2013-01/78630.htm静默安装Oracle 11gR2软件并且手动建库 http://www.linuxidc.com/Linux/2012-07/64651.htm

Oracle查看SQL执行计划的方式Oracle 10g AND Oracle 11g手工建库案例之--Oracle 10g相关资讯 Oracle 10g手工建库 Oracle 11g手工建库 Oracle 11g建库

Oracle 10g 快速手工建库步骤（01/11/2015 07:48:57）
Linux下Oracle 10g手工建库全过程（02/02/2013 07:38:32）

Oracle 10g AND Oracle 11g手工建（05/22/2014 11:01:52）

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