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

系统环境：操作系统： RedHat EL6Oracle： Oracle 10g and Oracle 11g手工建库相对来说很容易实现，本案例是从10g和11g，通过手工建库的方式做一个简单的对比，可以看出11g和10g之间的一个简单的差异！10gRAC-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 10g 环境下手工建库DB_NAME="cuug"INSTANCE_NAME="cuug"1、建立Instance的初始化参数文件和口令文件： [oracle@oracle dbs]$ cat initcuug.oradb_name = cuugdb_block_size = 8192pga_aggregate_target = 30M db_cache_size = 80M shared_pool_size = 60M parallel_threads_per_cpu = 4 optimizer_mode = choosestar_transformation_enabled = truedb_file_multiblock_read_count = 16query_rewrite_enabled = truequery_rewrite_integrity = trustedbackground_dump_dest = $ORACLE_BASE/admin/cuug/bdumpuser_dump_dest = $ORACLE_BASE/admin/cuug/udumpcore_dump_dest = $ORACLE_BASE/admin/cuug/cdumpcontrol_files = $ORACLE_BASE/oradata/cuug/control01.ctlundo_management = autoundo_tablespace = rtbs[oracle@oracle dbs]$orapwd file=orapwcuug password=oracle entries=3
2、建立数据库相关目录 [oracle@oracle dbs]$ mkdir -p $ORACLE_BASE/admin/cuug/bdump[oracle@oracle dbs]$ mkdir -p $ORACLE_BASE/admin/cuug/cdump[oracle@oracle dbs]$ mkdir -p $ORACLE_BASE/admin/cuug/udump[oracle@oracle dbs]$ mkdir -p $ORACLE_BASE/oradata/cuug
3、建立建库脚本（参考Oracle 11g Online）[oracle@oracle dbs]$cat cr_db.sql create database cuug user sys identified by oracle user system identified by oracledatafile "$ORACLE_BASE/oradata/cuug/system01.dbf" size 300msysaux datafile "$ORACLE_BASE/oradata/cuug/sysaux01.dbf" size 100mdefault temporary tablespace temp tempfile "$ORACLE_BASE/oradata/cuug/temp01.dbf" size 100mundo tablespace rtbs datafile "$ORACLE_BASE/oradata/cuug/rtbs01.dbf" size 100mlogfile group 1 "$ORACLE_BASE/oradata/cuug/redo01a.log" size 10m, group 2 "$ORACLE_BASE/oradata/cuug/redo02a.log" size 10mcharacter set zhs16gbk;
4、启动Instance建立数据库[oracle@oracle dbs]$export ORACLE_SID=cuug[oracle@oracle dbs]$sqlplus "/as sysdba"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_db.sqlDatabase created.
查看告警日志信息（alert_cuug.log）;[oracle@oracle dbs]tail -f /u01/app/oracle/admin/cuug/bdump/alert_cuug.logcreate tablespace SYSTEM datafile "$ORACLE_BASE/oradata/test/system01.dbf" size 400m default storage （initial 10K next 10K） onlineSat Aug 20 00:26:34 2011Completed: create tablespace SYSTEM datafile "$ORACLE_BASE/oradata/test/system01.dbf" size 400m default storage （initial 10K next 10K） EXTENT MANAGEMENT DICTIONARY onlineSat Aug 20 00:26:34 2011create rollback segment SYSTEM tablespace SYSTEM storage （initial 50K next 50K）Completed: create rollback segment SYSTEM tablespace SYSTEM storage （initial 50K next 50K）Sat Aug 20 00:26:49 2011Thread 1 advanced to log sequence 2 Current log# 2 seq# 2 mem# 0: /u01/app/oracle/oradata/test/redo02a.logSat Aug 20 00:26:50 2011CREATE UNDO TABLESPACE RTBS DATAFILE "$ORACLE_BASE/oradata/test/rtbs01.dbf" size 100mSat Aug 20 00:26:51 2011Successfully onlined Undo Tablespace 1.Completed: CREATE UNDO TABLESPACE RTBS DATAFILE "$ORACLE_BASE/oradata/test/rtbs01.dbf" size 100mSat Aug 20 00:26:51 2011create tablespace SYSAUX datafile "$ORACLE_BASE/oradata/test/sysaux01.dbf" size 100m EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO onlineCompleted: create tablespace SYSAUX datafile "$ORACLE_BASE/oradata/test/sysaux01.dbf" size 100m EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO onlineSat Aug 20 00:26:54 2011CREATE TEMPORARY TABLESPACE TEMP TEMPFILE "$ORACLE_BASE/oradata/test/temp01.dbf" size 100mCompleted: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE "$ORACLE_BASE/oradata/test/temp01.dbf" size 100mSat Aug 20 00:26:55 2011ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPCompleted: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPSat Aug 20 00:26:55 2011ALTER DATABASE DEFAULT TABLESPACE SYSTEMCompleted: ALTER DATABASE DEFAULT TABLESPACE SYSTEMSat Aug 20 00:27:01 2011SMON: enabling tx recoverySat Aug 20 00:27:02 2011Threshold validation cannot be done before catproc is loaded.replication_dependency_tracking turned off （no async multimaster replication found）Starting background process QMNCQMNC started with pid=13, OS id=6485Sat Aug 20 00:27:03 2011Completed: create database test user sys identified by **user system identified by *datafile "$ORACLE_BASE/oradata/test/system01.dbf" size 400msysaux datafile "$ORACLE_BASE/oradata/test/sysaux01.dbf" size 100mundo tablespace rtbs datafile "$ORACLE_BASE/oradata/test/rtbs01.dbf" size 100mdefault temporary tablespace temp tempfile "$ORACLE_BASE/oradata/test/temp01.dbf" size 100mlogfile group 1 "$ORACLE_BASE/oradata/test/redo01a.log" size 10m, group 2 "$ORACLE_BASE/oradata/test/redo02a.log" size 10m, group 3 "$ORACLE_BASE/oradata/test/redo03a.log" size 10mcharacter set zhs16gbk 更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-05/102087p2.htm

Oracle 10g AND Oracle 11g手工建库案例--Oracle 11gOracle ROWID详解相关资讯 Oracle手工建库 Oracle 10g手工建库

Oracle 10g 快速手工建库步骤（01/11/2015 07:48:57）
Oracle 10g AND Oracle 11g手工建（05/22/2014 10:54:41）
Oracle 9i数据库手工建库过程简记（01/26/2013 19:43:39）

静默方式安装Oracle 10g数据库软件（08/30/2014 06:38:18）
Linux下Oracle 10g手工建库全过程（02/02/2013 07:38:32）

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