Oracle 10g 静默安装-升级

环境:aix 5.3
oracle版本:
10.2.0.1 -> 10.2.0.4

1.修改/etc/hosts 主机名和ip地址映射

2.检查开发包:

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \

binutils \

compat-libstdc++-33 \

compat-libstdc++-33 \

elfutils-libelf \

elfutils-libelf-devel \

expat \

gcc- \

gcc-c++ \

glibc \

glibc \

glibc-common \

glibc-devel \

glibc-headers \

libaio \

libaio \

libaio-devel \

libaio-devel \

libgcc \

libgcc \

libstdc++ \

libstdc++ \

libstdc++ \

make \

pdksh \

sysstat \

unixODBC \

unixODBC \

unixODBC \

unixODBC-devel \

3.创建组和用户

[root@redpay-data01 ~]# groupadd -g 501 dba

[root@redpay-data01 ~]# useradd -u 500 -g dba oracle

[root@redpay-data01 ~]# passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: it is based on a dictionary word

BAD PASSWORD: is too simple

Retype new password:

passwd: all authentication tokens updated successfully.

[root@redpay-data01 ~]#

4.创建目录并赋权

[root@redpay-data01 ~]#  mkdir -p /oracle/app/oracle/product/10.2/db_1

[root@redpay-data01 ~]# chmod -R 755 /oracle

[root@redpay-data01 ~]# chown -R oracle:dba /oracle

[root@redpay-data01 ~]#

5.修改系统参数

vi /etc/sysctl.conf

  

        fs.aio-max-nr = 1048576

        fs.file-max = 6815744

        kernel.shmall = 2097152

        kernel.shmmax = 536870912

        kernel.shmmni = 4096

        kernel.sem = 250 32000 100 128

        net.ipv4.ip_local_port_range = 9000 65500

        net.core.rmem_default = 262144

        net.core.rmem_max = 4194304

        net.core.wmem_default = 262144

        net.core.wmem_max = 1048576

    修改完后执行:sysctl -p

    b.vi /etc/security/limits.conf

        oracle soft nproc 2047

        oracle hard nproc 16384

        oracle soft nofile 1024

        oracle hard nofile 65536

6.添加环境变量

 export ORACLE_BASE=/oracle/app/oracle

        export ORACLE_HOME=/oracle/app/oracle/product/10.2/db_1

        export PATH=$ORACLE_HOME/bin:$PATH

7.静默安装

cpio -idcmv  < 10201_database_linux_x86_64.cpio

编辑:vi enterprise.rsp 文件

UNIX_GROUP_NAME="dba"

FROM_LOCATION="/home/oracle/database/stage/products.xml"

ORACLE_HOME="/oracle/app/oracle/product/10.2/db_1"

ORACLE_HOME_NAME="OraDbHome1"

s_nameForDBAGrp="dba"

n_configurationOption=3 ---只安装数据库软件

 

./runInstaller -silent -responseFile /home/oracle/database/response/enterprise.rsp

安装后执行两个root脚本。

8.静默升级

vi /home/oracle/Disk1/response/patchset.rsp

UNIX_GROUP_NAME="dba"

FROM_LOCATION="/home/oracle/Disk1/stage/products.xml"

ORACLE_HOME="/oracle/app/oracle/product/10.2/db_1"

ORACLE_HOME_NAME="OraDbHome1" --/oracle/app/oracle/oraInventory/ContentsXML/inventory.xml 在这个文件下查看

RESTART_SYSTEM=false

 ./runInstaller -silent -responseFile /home/oracle/Disk1/response/patchset.rsp

 

执行root脚本

安装PatchSet后新增的文件或目录是限制访问的, 其它用户或第三方工具要访问这些文件时会提示错误,

所以要修改权限:

# su - oracle

$ cd $ORACLE_HOME/install

$ ./changePerm.sh

...

Do you wish to continue (y/n) [n]: y

...

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30024909/viewspace-1368032/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30024909/viewspace-1368032/