Kiwi格網技術開發站

• 環境

FC3
Oracle 10gR2
SRB 331

• Memo

install Oracle 10g R2:

su root
add to /etc/sysctl.conf:
vi /etc/sysctl.conf

kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.sem=250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000

sysctl -p

add oracle user:
groupadd oinstall
groupadd dba
useradd -g dba oracle

install jdk:
rpm -ivh jdk-1_5_0_01-linux-i586.rpm

add to /etc/bashrc and ~oracle/.bashrc:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl

install:
su oracle
cd $ORACLE_SOURCE
./runInstaller

Follow the wizard.

Create a instance \”MCAT\” using DBCA.

Create a table space \”SRBMCAT\” using Enterprise Manager.

Create a user \”SRB\” using Enterprise Manager.

Grant IMP_FULL_DATABASE to SRB

install SRB,MCAT with Oracle 10g:

add srb user:
groupadd srb
useradd -g srb srb

try sqlplus srb@mcat

if there’s any error, consider :
1. $ORACLE_HOME directory and child file permission is 755
2. export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
3. $ORACLE_HOME/lib entry in /etc/ld.so.conf
4. username/password error(try it with other oracle account)

install:
cd $SRB_331_SOURCE
./configure –enable-oraver=10g_32bit –enable-oramcat –enable-orahome=/oracledb/oracle/10g/
–enable-accsctrl –enable-javagui –enable-jdkhome=/usr/java/jdk1.5.0_01
make
cd MCAT
make

configure:
cd $SRB/data
edit hostConfig
edit mcatHost
edit MdasConfig
notice that
we create a user named \”SRB\”, MDASSCHEMENAME is \”srb.\”
DB2INSTANCE is same as MDASDBNAME

sqlplus srb/password@mcat @{file}
catalog.install.ora: this will create difinitions using default table space of \”SRB\”
account
catalog.index.ora: this will create other indexes using \”MCAT_IDX\” table space
catalog.trigger.ora: this will create triggers using default table space of \”SRB\”
account
catalog.quota.ora: unknown usage

modify internal \”srb\” account:
bash
export srbUser=srb
export srbAuth=CANDO
export mdasDomainName=sdsc
ingestToken Domain nchc home
ingestUser srbadmin srbadmin nchc sysadmin ” ” ”

using McatAdmin:
Modify zone
Add User
Create Location
Create Physical Storage
Create Logical Storage
service srball restart

• Test

[kiwi@srb1 kiwi]$ time Sbload 20041203 ./

real 3m43.509s
user 0m0.450s
sys 0m4.310s
[kiwi@srb1 kiwi]$ ./putmeta 20041203
Making metafile…3825
267701 metas, 3825 metafiles
Running metafile…
17 min 45 sec

差太多了吧…這次meta還多很多喔…