日本免费全黄少妇一区二区三区-高清无码一区二区三区四区-欧美中文字幕日韩在线观看-国产福利诱惑在线网站-国产中文字幕一区在线-亚洲欧美精品日韩一区-久久国产精品国产精品国产-国产精久久久久久一区二区三区-欧美亚洲国产精品久久久久

  1. 首頁 > 云知道 > >

在Solaris 10 ZFS上安裝Oracle 9i

云知道

ZFS是SUN Solaris 10的下一代文件存儲(chǔ)解決方案 ， ZFS即Zettabyte File System ， 也叫動(dòng)態(tài)文件系統(tǒng)Dynamic File System, 是第一個(gè)128位文件系統(tǒng) ， 無限容量、自優(yōu)化、數(shù)據(jù)永遠(yuǎn)保持一致,并且管理簡(jiǎn)單.
ZFS不僅支持基于文件系統(tǒng)方式的訪問,也支持基于卷(裸設(shè)備)方式的訪問,加上ZFS的不斷完善和成熟,基本上可以取代傳統(tǒng)的磁盤管理軟件,如Solairs Volume Manager和Veritas Volume Manager.本文將介紹如何在Solaris 10 ZFS上安裝Oracle 9i.
基本需求:
- 將Oracle程序文件安裝在zfs文件系統(tǒng)上.
- 將數(shù)據(jù)庫data file安裝在zfs裸卷上.
step1. 創(chuàng)建pool和zfs文件系統(tǒng)及祼卷.
# zpool create ora_pool c0t4d0
# zfs create -V 210mora_pool/controlfile01_200m
# zfs create -V 210mora_pool/controlfile02_200m
# zfs create -V 210mora_pool/controlfile03_200m
# zfs create -V 4010m　ora_pool/index01_4000m
# zfs create -V 410mora_pool/redo1_01_400m
# zfs create -V 410mora_pool/redo2_01_400m
# zfs create -V 410mora_pool/redo3_01_400m
# zfs create -V 810mora_pool/system_800m
# zfs create -V 1010m　ora_pool/tools_1000m
# zfs create -V 4010m　ora_pool/undotbs1_01_4000m
# zfs create -V 4010m　ora_pool/users01_4000m
ZFS卷提供了類似于VxVM卷的路徑名供引用：
/dev/zvol/[r]dsk//
# zfs create ora_pool/oracle
# zfs set mountpoint=/opt/oracle ora_pool/oracle
step2. 創(chuàng)建oracle用戶及dba組 ， 設(shè)置基本的環(huán)境變量.
# groupadd dba
# useradd -d /opt/oracle -g dba -s /bin/sh -m oracle
# passwd oracle
# ORACLE_BASE=/opt/oracle; export ORACLE_BASE
# ORACLE_HOME=$ORACLE_BASE/product/9.2; export ORACLE_HOME
# ORACLE_SID=ora9; export ORACLE_SID
# chown oracle:dba /dev/zvol/rdsk/ora_pool/*
# chmod 600 /dev/zvol/rdsk/ora_pool/*
step3. 基于項(xiàng)目管理方式 ， 為oracle分配系統(tǒng)資源如最大共享內(nèi)存、信號(hào)燈等.
# projadd -U oracle -p 1233 -c "oracle parameters setting" user.oracle
# projmod -a -K "project.max-shm-memory=(priv,17179869184,deny)" user.oracle (為物理內(nèi)存的1/2 ， 單位為字節(jié)）
# projmod -a -K "project.max-sem-ids=(priv,2000,deny)" user.oracle
# projmod -a -K "process.max-sem-nsems=(priv,2048,deny)" user.oracle
# projmod -a -K "project.max-shm-ids=(priv,256,deny)" user.oracle
step4. 安裝Oracle程序（過程略）.
step5. 利用腳本方式創(chuàng)建新數(shù)據(jù)庫.
oracle> cat $ORACLE_BASE/admin/ora9/scripts/ora9.sh
#!/bin/sh
mkdir /opt/oracle/admin/ora9/bdump
mkdir /opt/oracle/admin/ora9/cdump
mkdir /opt/oracle/admin/ora9/create
mkdir /opt/oracle/admin/ora9/pfile
mkdir /opt/oracle/admin/ora9/udump
mkdir /opt/oracle/oradata/ora9
mkdir /opt/oracle/product/9.2/dbs
export ORACLE_SID ora9
【在Solaris 10 ZFS上安裝Oracle 9i】export PATH=$PATH:/opt/oracle/product/9.2/bin/
echo Add this entry in the oratab: ora9:/opt/oracle/product/9.2:Y
orapwd file=/opt/oracle/product/9.2/dbs/orapwora9　passWord=change_on_install
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDB.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBFiles.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBCatalog.sql
sqlplus /nolog @/opt/oracle/admin/ora9/scripts/postDBCreation.sql
oracle> cat $ORACLE_BASE/admin/ora9/scripts/CreateDB.sql
connect SYS/change_on_install as SYSDBA
set echo on
spool /opt/oracle/product/9.2/assistants/dbca/logs/CreateDB.log
startup nomount pfile="/opt/oracle/admin/ora9/scripts/init.ora";
CREATE DATABASE ora9
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/dev/zvol/rdsk/ora_pool/system_800m' SIZE 800M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/zvol/rdsk/ora_pool/temp01_4000m' SIZE 4000M REUSE

推薦閱讀