【安裝配置】oracle 10g 手工建庫

慢慢把一些安裝配置的記錄放上來，為了試驗將使用檔案系統的資料庫遷移到asm下，特意建一個實驗庫，正好實驗一下手動建庫的過程，這也是ocm的必經之路。記錄如下：

oracle 10g 手工建庫

設定環境變數
export ORACLE_HOME=/tpdata/ora/oracle/product/10.2.0/db_1
export ORACLE_SID=TEST_HAND
export ORACLE_BASE=/tpdata/ora/oracle

引數檔案
vi $ORACLE_HOME/dbs/init$ORACLE_SID.ora
control_files = (/tpdata/ora/oracle/oradata/TEST_HAND/control01.ctl,
/tpdata/ora/oracle/oradata/TEST_HAND/control02.ctl,
/tpdata/ora/oracle/oradata/TEST_HAND/control03.ctl)
undo_management = AUTO
undo_tablespace = UNDOTBS01
db_name = test
db_unique_name = TEST_HAND
db_block_size = 8192
sga_max_size = 320M
sga_target = 320M

密碼檔案
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys force=y

建立目錄
mkdir -p /tpdata/ora/oracle/oradata/$ORACLE_SID
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/ddump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile

sqlplus / as sysdba
create spfile from pfile;
startup nomount;

create database test controlfile reuse
MAXINSTANCES 8 MAXDATAFILES 100 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 5
character set ZHS16GBK national character set AL16UTF16
logfile group 1 ('/tpdata/ora/oracle/oradata/TEST_HAND/redo01.log') size 50M reuse,group 2 ('/tpdata/ora/oracle/oradata/TEST_HAND/redo02.log') size 50M reuse,group 3 ('/tpdata/ora/oracle/oradata/TEST_HAND/redo03.log') size 50M reuse
datafile '/tpdata/ora/oracle/oradata/TEST_HAND/system.dbf' size 500M reuse autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/tpdata/ora/oracle/oradata/TEST_HAND/sysaux.dbf' size 100M reuse autoextend on next 10M maxsize unlimited
default temporary tablespace temp tempfile '/tpdata/ora/oracle/oradata/TEST_HAND/temp01.dbf' size 100M reuse autoextend on next 10M maxsize unlimited
undo tablespace undotbs01 datafile '/tpdata/ora/oracle/oradata/TEST_HAND/undotbs01.dbf' size 200M reuse autoextend on next 10M maxsize unlimited
USER SYS IDENTIFIED BY "SYS" USER SYSTEM IDENTIFIED BY "SYS"

資料庫open後，執行一些sql
spool /tpdata/ora/oracle/oradata/TEST_HAND/create.log
@ ?/rdbms/admin/catalog.sql
@ ?/rdbms/admin/catproc.sql
@ ?/rdbms/admin/catblock.sql
@ ?/rdbms/admin/catoctk.sql
@ ?/rdbms/admin/owminst.plb
@ ?/sqlplus/admin/pupbld.sql
@ ?/rdbms/admin/help/hlpbld.sql helpus.sql

建立users表空間，並設定為預設表空間
create tablespace users logging datafile '/tpdata/ora/oracle/oradata/TEST_HAND/users01.dbf' size 100M reuse autoextend on next 10M
MAXSIZE unlimited extent management local segment space management auto;
alter database default tablespace users;

編譯失效過程：
execute utl_recomp.recomp_serial();

em配置：（待續）

SQL> select instance_name,status from v$instance a;

INSTANCE_NAME    STATUS
---------------- ------------
TEST_HAND        OPEN

1 row selected.

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      test
SQL>

 

 

 

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16179598/viewspace-671956/，如需轉載，請註明出處，否則將追究法律責任。