使用 oraToolKit 在 RHEL4.8 安裝 Oracle 10gR2

參考:
Installing Oracle 10g Release 2 Enterprise Edition on Red Hat Enterprise Linux 4.8 (x86_64) within 60 minutes
https://www.oratoolkit.ch/knowledge/howto/installation/eeSrv-10g-R2-on-RHEL-4.8-x86_64.php

筆記:
oraToolKit 安裝 Oracle Software 預設路徑為 /opt/oracle, 以下安裝將路徑改為 /oracle.

# uname -a
Linux FEE.goldenchang.com.cn 2.6.9-89.0.0.0.1.ELsmp #1 SMP Tue May 19 05:31:20 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

# top
top - 09:29:15 up 11:51,  2 users,  load average: 0.05, 0.06, 0.02
Tasks: 109 total,   1 running, 108 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.0% us,  0.6% sy,  0.0% ni, 99.4% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:   4009944k total,   376896k used,  3633048k free,    31524k buffers
Swap: 16779852k total,        0k used, 16779852k free,   197772k cached


# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda5              63G  4.2G   56G   7% /
/dev/sda1             494M   22M  447M   5% /boot
none                  2.0G     0  2.0G   0% /dev/shm
/dev/sda8              16G   77M   15G   1% /home
/dev/sda10            9.9G   55M  9.3G   1% /oracle
/dev/sda11            7.9G  105M  7.4G   2% /tmp
/dev/sda3             252G   92M  240G   1% /u1
/dev/sda2             252G   92M  240G   1% /u2
/dev/sda6              20G  2.3G   17G  13% /usr
/dev/sda7              16G  161M   15G   2% /var

安裝oraToolKit:
將oratoolkit-1.0.2.1.4-1.noarch.rpm copy到 /var/tmp/oracle
# su - root
# cd /var/tmp/oracle
# ls -1 oratool*
oratoolkit-1.0.2.1.4-1.noarch.rpm
[root@FEE oracle]# rpm -ivh oratoolkit-1.0.2.1.4-1.noarch.rpm
warning: oratoolkit-1.0.2.1.4-1.noarch.rpm: V3 RSA/MD5 signature: NOKEY, key ID 66f452c8
Preparing...                ########################################### [100%]
   1:oratoolkit             ########################################### [100%]
   
設置oracle用戶密碼:
# passwd oracle
Changing password for user oracle.
New UNIX password: oracle
Retype new UNIX password: oracle
passwd: all authentication tokens updated successfully.

檢查package需求
# cd /opt/oracle/otk/current/bin/
# cp installManager installManager.20100918
# vi installManager
# sdiff -s installManager installManager.20100918
ORACLE_BASE=${ORACLE_BASE:-"/oracle"}                         | ORACLE_BASE=${ORACLE_BASE:-"/opt/oracle"}

# cd /opt/oracle/otk/current/conf/installManager
# vi osSetup10gR2.cfg
# sdiff -s osSetup10gR2.cfg sample/osSetup10gR2.cfg
OS_USER_COMMENT="Oracle software owner"                       | OS_USER_COMMENT="Oracle and oraToolKit software owner"
OSDBA_DIRECTORIES="/u1 /u2"                                   | OSDBA_DIRECTORIES="/data01 /data02 /backup01"
INVENTORY_GROUP_DIRECTORIES="/oracle /var/opt/oracle /var/opt | INVENTORY_GROUP_DIRECTORIES="/opt/oracle /var/opt/oracle /var
INVENTORY_LOC="/oracle/oraInventory"                          | INVENTORY_LOC="/opt/oracle/oraInventory"

# /opt/oracle/otk/current/bin/installManager swReqCheck osSetup10gR2.cfg
20100916_095427: Warning: Optional package unixODBC not found, installation of 32-bit version 2.2.9-1 or later recommended. Package is usually installed with default installation
----------------------------------------------------------------------------------------------------
20100916_094315: Info: Executing libmiscellaneous.getFooter function
20100916_094315: Info: Terminating installManager execution
20100916_094315: Info: Summary log file:  /var/opt/oracle/otk/1.0/log-old/installManager/../installManager.log
20100916_094315: Info: Detailed log file: /var/opt/oracle/otk/1.0/log-old/installManager/swreqcheck-20100916_094257.log
20100916_094315: Info: Action swReqCheck of installManager ended with one WARNING
----------------------------------------------------------------------------------------------------

# rpm -ivh glibc-kernheaders-2.4-9.1.103.EL.x86_64.rpm \
> glibc-headers-2.3.4-2.43.x86_64.rpm \
> glibc-devel-2.3.4-2.43.x86_64.rpm \
> libstdc++-devel-3.4.6-11.0.1.x86_64.rpm \
> gcc-3.4.6-11.0.1.x86_64.rpm \
> gcc-c++-3.4.6-11.0.1.x86_64.rpm \
> libaio-0.3.105-2.x86_64.rpm \
> sysstat-5.0.5-25.el4.x86_64.rpm \
> libtermcap-devel-2.0.8-39.x86_64.rpm \
> readline-devel-4.3-13.x86_64.rpm \
> unixODBC-devel-2.2.11-1.0.1.RHEL4.1.x86_64.rpm \
> glibc-devel-2.3.4-2.43.i386.rpm \
> libaio-devel-0.3.105-2.x86_64.rpm \
> unixODBC-devel-2.2.11-1.0.1.RHEL4.1.i386.rpm

加強 sql*plus
# cd /opt/oracle/otk/current/tools/rlwrap/
# ./configure
# make
# make install
# /usr/local/bin/rlwrap -v   

执行installManager的osSetup动作
# cd /opt/oracle/otk/current/conf/installManager/
# vi osSetup10gR2.cfg
# sdiff -s osSetup10gR2.cfg sample/osSetup10gR2.cfg
OS_USER_COMMENT="Oracle software owner"                       | OS_USER_COMMENT="Oracle and oraToolKit software owner"
OSDBA_DIRECTORIES="/u1 /u2"                                   | OSDBA_DIRECTORIES="/data01 /data02 /backup01"
INVENTORY_GROUP_DIRECTORIES="/oracle /var/opt/oracle /var/opt | INVENTORY_GROUP_DIRECTORIES="/opt/oracle /var/opt/oracle /var
INVENTORY_LOC="/oracle/oraInventory"                          | INVENTORY_LOC="/opt/oracle/oraInventory"

# /opt/oracle/otk/current/bin/installManager osSetup osSetup10gR2.cfg
----------------------------------------------------------------------------------------------------
20100916_110155: Info: Executing libmiscellaneous.getFooter function
20100916_110155: Info: Terminating installManager execution
20100916_110155: Info: Summary log file:  /var/opt/oracle/otk/1.0/log-old/installManager/../installManager.log
20100916_110155: Info: Detailed log file: /var/opt/oracle/otk/1.0/log-old/installManager/ossetup-20100916_110120.log
20100916_110155: Info: Action osSetup of installManager ended with one WARNING
----------------------------------------------------------------------------------------------------

移动下载的Oracle软件到 /var/opt/oracle
# cd /soft
# chown oracle:oinstall *
# cp 10201_database_linux_x86_64.cpio.gz p6810189_10204_Linux-x86-64.zip /var/opt/oracle/repository/
# cd /var/opt/oracle/repository
# chown oracle:oinstall *

以oracle用户登录定制PS1变量
# su - oracle
 
 ------------------------------------------------------
 oraToolKit environment variables
 ------------------------------------------------------
 Installation directory :   /opt/oracle/otk
 Release                :   1.0.2.1.4
 $RUN directory         :   /opt/oracle/otk/1.0/bin
 $LOG_BASE directory    :   /var/opt/oracle/otk/1.0/log
 ------------------------------------------------------

$ grep ^SITE .profile.custom.interactive
SITE="<SITE|COMPANY>"
$ vi .profile.custom.interactive
t$ grep ^SITE .profile.custom.interactive
SITE="FEEDB"
$ exit
# su - oracle

安裝Oracle Software
$ bash
$ cd $INSTALL_CONF
$ cp sample/swInstEeSrv10gR2-Step[123]-linux-x86_64.cfg .
$ cp response/10_2_0_1_EE.rsp response/10_2_0_1_EE.rsp.20100918
$ vi response/10_2_0_1_EE.rsp
$ sdiff -s response/10_2_0_1_EE.rsp response/10_2_0_1_EE.rsp.20100918
ORACLE_HOME="/oracle/eesrv/10.2.0/db1"                        | ORACLE_HOME="/opt/oracle/eesrv/10.2.0/db1"
s_dlgRBORecoveryLocation="/oracle/eesrv/10.2.0/db1/flash_reco | s_dlgRBORecoveryLocation="/opt/oracle/eesrv/10.2.0/db1/flash_
s_mountPoint="/oracle/eesrv/10.2.0/db1/oradata/"              | s_mountPoint="/opt/oracle/eesrv/10.2.0/db1/oradata/"

$ installManager swInst swInstEeSrv10gR2-Step1-linux-x86_64.cfg
----------------------------------------------------------------------------------------------------
20100918_093127: Info: Executing libmiscellaneous.getFooter function
20100918_093127: Info: Terminating installManager execution
20100918_093127: Info: Summary log file:  /var/opt/oracle/otk/1.0/log-old/installManager/../installManager.log
20100918_093127: Info: Detailed log file: /var/opt/oracle/otk/1.0/log-old/installManager/swinst-20100918_092739.log
20100918_093127: Info: Action swInst of installManager ended successfully
----------------------------------------------------------------------------------------------------

$ su -
# /oracle/eesrv/10.2.0/db1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/eesrv/10.2.0/db1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

$ cp response/10_2_0_4_EE.rsp response/10_2_0_4_EE.rsp.20100918
$ vi response/10_2_0_4_EE.rsp
$ sdiff -s response/10_2_0_1_EE.rsp response/10_2_0_1_EE.rsp.20100918
ORACLE_HOME="/oracle/eesrv/10.2.0/db1"                        | ORACLE_HOME="/opt/oracle/eesrv/10.2.0/db1"
s_dlgRBORecoveryLocation="/oracle/eesrv/10.2.0/db1/flash_reco | s_dlgRBORecoveryLocation="/opt/oracle/eesrv/10.2.0/db1/flash_
s_mountPoint="/oracle/eesrv/10.2.0/db1/oradata/"              | s_mountPoint="/opt/oracle/eesrv/10.2.0/db1/oradata/"
GCMS:SSH:oracle@FEE:test$ sdiff -s response/10_2_0_4_EE.rsp response/10_2_0_4_EE.rsp.20100918
ORACLE_HOME="/oracle/eesrv/10.2.0/db1"                        | ORACLE_HOME="/opt/oracle/eesrv/10.2.0/db1"

$ installManager swInst swInstEeSrv10gR2-Step3-linux-x86_64.cfg
$ su -
# /oracle/eesrv/10.2.0/db1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/eesrv/10.2.0/db1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

創建TEST資料庫
$ cd $INSTALL_CONF
$ ls -1 dbSetup*.cfg
dbSetup-dev.cfg
dbSetup-prod.cfg
dbSetup-test.cfg
$ vi dbSetup-test.cfg
$ sdiff -s dbSetup-test.cfg sample/dbSetup-test.cfg
NLS_LANG=".AL32UTF8"                                          | NLS_LANG=".UTF8"
DATA01="/u1/rdbms/${DB_NAME}"                                 | DATA01="/data01/rdbms/${DB_NAME}"
DATA02="/u1/rdbms/${DB_NAME}"                                 | DATA02="/data01/rdbms/${DB_NAME}"
PWFILE="/u1/rdbms/${DB_NAME}/pfile"                           | PWFILE="/data01/rdbms/${DB_NAME}/pfile"
BACKUP_BASE="/u2"                                             | BACKUP_BASE="/backup01"
UTL="/u1/utl/$DB_NAME"                                        | UTL="/data01/utl/$DB_NAME"
PASSWORD_OTK="practice"                                       | PASSWORD_OTK="otk"

$ installManager dbSetup dbSetup-test.cfg

20100918_103228: Info: sqlplus -s /nolog @/oracle/admin/test/create/postInstall.sql successfully executed
----------------------------------------------------------------------------------------------------
20100918_103228: Info: Executing libinstallManager.setTimeStampFile function
20100918_103228: Info: Creating creation timestamp file /oracle/admin/test/create/timestamp.log
----------------------------------------------------------------------------------------------------
20100918_103228: Info: Executing libmiscellaneous.getFooter function
20100918_103228: Info: Terminating installManager execution
20100918_103228: Info: Summary log file:  /var/opt/oracle/otk/1.0/log-old/installManager/../installManager.log
20100918_103228: Info: Detailed log file: /var/opt/oracle/otk/1.0/log-old/installManager/dbsetup-20100918_102147.log
20100918_103228: Info: Action dbSetup of installManager ended successfully
--------------------------------------------------------------------------------

修改環境設置
$ cd /opt/oracle/otk
$ cp  envsetup envsetup.20100918
$ vi envsetup
$ sdiff -s envsetup envsetup.20100918
  # echo " "                                                  |   echo " "
  # echo " -------------------------------------------------- |   echo " ----------------------------------------------------
  # echo " oraToolKit environment variables"                  |   echo " oraToolKit environment variables"
  # echo " -------------------------------------------------- |   echo " ----------------------------------------------------
  # echo " Installation directory :   $BASEDIR"               |   echo " Installation directory :   $BASEDIR"
  # echo " Release                :   $OTK_RELEASE"           |   echo " Release                :   $OTK_RELEASE"
  # echo " \$RUN directory         :   $RUN"                  |   echo " \$RUN directory         :   $RUN"
  # echo " \$LOG_BASE directory    :   $LOG_BASE"             |   echo " \$LOG_BASE directory    :   $LOG_BASE"
  # echo " -------------------------------------------------- |   echo " ----------------------------------------------------
  # echo " "                                                  |   echo " "

$ cd ~
$ cp .profile.default .profile.default.20100918
$ vi .profile.default
$ sdiff -s .profile.default .profile.default.20100918
if [ -f "/oracle/admin/$USER/setenv.ora" ]; then              | if [ -f "/opt/oracle/admin/$USER/setenv.ora" ]; then
   . "/oracle/admin/$USER/setenv.ora"                         |    . "/opt/oracle/admin/$USER/setenv.ora"
  if [ -f "/oracle/admin/$SID/setenv.ora" ]; then             |   if [ -f "/opt/oracle/admin/$SID/setenv.ora" ]; then
    . "/oracle/admin/$SID/setenv.ora"                         |     . "/opt/oracle/admin/$SID/setenv.ora"
    if [ -f "/oracle/setenv817.sh" ]; then                    |     if [ -f "/opt/oracle/setenv817.sh" ]; then
      . "/oracle/setenv817.sh"                                |       . "/opt/oracle/setenv817.sh"

$ cp .setenv.ora .setenv.ora.20100918
$ vi .setenv.ora
$ sdiff -s .setenv.ora .setenv.ora.20100918
  ORACLE_BASE=${ORACLE_BASE:-"/oracle"}                       |   ORACLE_BASE=${ORACLE_BASE:-"/opt/oracle"}

$ cp .alias .alias.20100918
$ vi .alias
$ sdiff -s .alias .alias.20100918
if [ -d /oracle/admin -a "$1" = "SET" ]; then                 | if [ -d /opt/oracle/admin -a "$1" = "SET" ]; then
  cd /oracle/admin                                            |   cd /opt/oracle/admin
        alias source${gDIR:0:1}${gDir:1}env=". /oracle/admin/ |         alias source${gDIR:0:1}${gDir:1}env=". /opt/oracle/ad
        alias source${gDIR:0:1}${gDir:1}Env=". /oracle/admin/ |         alias source${gDIR:0:1}${gDir:1}Env=". /opt/oracle/ad

$ cd /opt/oracle/otk/1.0/bin/
$ cp test_lsnrenv test_lsnrenv.20100918
$ cp test_sidenv test_sidenv.20100918
$ vi test_lsnrenv
$ sdiff -s test_lsnrenv test_lsnrenv.20100918
. /oracle/admin/test/setenv.ora >/dev/null                    | . /opt/oracle/admin/test/setenv.ora >/dev/null

$ vi test_sidenv
$ sdiff -s test_lsnrenv test_lsnrenv.20100918
. /oracle/admin/test/setenv.ora >/dev/null                    | . /opt/oracle/admin/test/setenv.ora >/dev/null
GCMS:SSH:oracle@FEE:test$ sdiff -s test_sidenv test_sidenv.20100918
. /oracle/admin/test/setenv.ora >/dev/null                    | . /opt/oracle/admin/test/setenv.ora >/dev/null

連線資料庫
$ bash
$ sourceTestEnv
$ sqlplus otk/otk@TEST

使用appctl管理Oracle
$ ctl status all
$ ctl stop all
$ ctl start all

 

網路設置
將 host 設為 IP.
1516T=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.151.6)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TEST)(SERVER=DEDICATED)))
$ cd $TNS_ADMIN
$ cp listener.ora listener.ora.20100920
$ cp tnsnames.ora tnsnames.ora.20100920
$ vi listener.ora
$ vi tnsnames.ora
$ sdiff -s listener.ora listener.ora.20100920
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.151.6)(POR |         (ADDRESS = (PROTOCOL = TCP)(HOST = FEE.goldenchang.co
$ sdiff -s tnsnames.ora tnsnames.ora.20100920
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.151.6)(PORT =  |     (ADDRESS = (PROTOCOL = TCP)(HOST = FEE.goldenchang.com.cn
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.151.6)(PORT  |       (ADDRESS = (PROTOCOL = TCP)(HOST = FEE.goldenchang.com.

---------------------------------------------------------------------------
修改參數:
$ sqlplus /nolog
SQL> connect /as sysdba
SQL> show parameter sga;
SQL> alter system set sga_max_size=1024m scope=spfile;
$ ctl restart test_sid
SQL> alter system set sga_target=1024M;
SQL> alter system set PGA_AGGREGATE_TARGET=200M
SQL> alter system set open_links=20 scope=spfile;
SQL> alter system set remote_dependencies_mode=SIGNATURE scope=spfile;
$ ctl restart test_sid

 

=======================================================================================================================
RMAN 備份

$ cd $BACKUP_CONF
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Sat May 7 09:56:54 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> connect /as sysdba
Connected.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /data01/rdbms/utf8/archivelog
Oldest online log sequence     238
Next log sequence to archive   240
Current log sequence           240
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

$ cp prod.cfg utf8.cfg
$ vi utf8.cfg
$ sdiff -s utf8.cfg prod.cfg
DB_NAME="utf8"                                                | DB_NAME="prod"
DISK_DEVICE_MOUNT_POINT="/6037rman"                           | DISK_DEVICE_MOUNT_POINT="/backup01"
BACKUP_DIR="$DISK_DEVICE_MOUNT_POINT/rdbms/physical/$DB_NAME" | BACKUP_DIR="$BACKUP_AREA"

修改環境變數設置: 改日誌檔格式為只包含年月日內容而不包含時分秒內容.
vi /opt/oracle/otk/1.0/lib/libbackupManager.ksh
$ sdiff -s libbackupManager.ksh libbackupManager.ksh.old
  setEnvVar START_TS          `date '+%Y%m%d'`  |   setEnvVar START_TS          `getTimeStamp`

$ backupManager full utf8.cfg
完成動作:
    *配置資料庫庫備份設置
    *交叉檢查備份資料庫和archivelogs
    *創建資料庫備份
    *刪除過時的備份
    *備份pfile文件到當前的SPFILE
    *配置歸檔日誌備份設置
    *備份 archivelogs
   
查看日誌:
$ cd $BACKUP_LOG
$ ls -l backupManager.log


排程:
$ crontab -e
0 2 * * * [ -d $HOME/../current ] && (ksh -c '. ./.profile >/dev/null; backupManager full utf8.cfg >/dev/null')