oracle小版本升级9206到9208（静默方式）

341243

操作系统：solaris10 sparc

        1.   Oracle 升级9206—>9208 ：

        1)   静默安装oracle9208 patch

        修改response静默安装文件，主要修改以下三条：

        UNIX_GROUP_NAME="dba"

        ORACLE_HOME="/orahome/oracle/product/9.2.0"

         ORACLE_HOME_NAME=" ora9ibims "

        ORACLE_HOME_NAME可以从../oraInventory/ContentsXML/inventory.xml文件中 HOME NAME获取。

        bash-3.00$ grep ORACLE_HOME bims.rsp      //bims.rsp为修改后的response文件
#Name       : ORACLE_HOME
#Example: ORACLE_HOME = "C:\OHOME1"
ORACLE_HOME="/orahome/oracle/product/9.2.0"
#Name       : ORACLE_HOME_NAME
#Example: ORACLE_HOME_NAME = "OHOME1"
ORACLE_HOME_NAME="ora9ibims"
bash-3.00$ grep UNIX_GROUP_NAME bims.rsp
#Name       : UNIX_GROUP_NAME
#Example: UNIX_GROUP_NAME = "install"
UNIX_GROUP_NAME="dba"

       

        #-------------------------------------------------------------------------------

        #Name       : FROM_LOCATION

        #Datatype   : String

        #Description: Complete path to the products.xml.

        #Example: FROM_LOCATION = "../stage/products.xml"

        #-------------------------------------------------------------------------------

        FROM_LOCATION="/orahome/software/Disk1/stage/products.xml"

       

        执行静默安装：

        bash-3.00$ cd /orahome/software/Disk1

        bash-3.00$ ./runInstaller -silent -responseFile /orahome/software/Disk1/response/bims.rsp

       

       

        安装完成后用root用户执行roo.sh文件完成安装：

        root@ts-db1 # /orahome/oracle/product/9.2.0/root.sh

        Running Oracle9 root.sh script...

       

        The following environment variables are set as:

            ORACLE_OWNER= oracle

            ORACLE_HOME=  /orahome/oracle/product/9.2.0

       

        Enter the full pathname of the local bin directory: [/usr/local/bin]:

        Creating /usr/local/bin directory...

           Copying dbhome to /usr/local/bin ...

           Copying oraenv to /usr/local/bin ...

           Copying coraenv to /usr/local/bin ...

       

       

        Creating /var/opt/oracle/oratab file...

        Adding entry to /var/opt/oracle/oratab file...

        Entries will be added to the /var/opt/oracle/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.

        rm: /orahome/oracle/product/9.2.0/rdbms/filemap is a directory

        root@ts-db1 #

       

        2)   更新数据字典,编译失效对象

        $ sqlplus /nolog
SQL> CONNECT /AS SYSDBA
SQL> STARTUP

        SQL> SHOW PARAMETER SHARED_POOL_SIZE

        SQL> SHOW PARAMETER JAVA_POOL_SIZE

        SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
SQL> shutdown immediate
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
SQL> SPOOL OFF
SQL> shutdown immediate
SQL> STARTUP
SQL> select comp_id,status,version from dba_registry;

        检查是否有无效的对象。
Sql>select object_name,status from dba_objects where object_Name in ('SYS','SYSTEM') and status = 'INVALID';
如果有invalid对象则运行以下的脚本。
SQL> @?/rdbms/admin/utlrp.sql

        3)   检查完成
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='64M' SCOPE=spfile; （还原设置）
SQL> select comp_id,status,version from dba_registry;
查一下表，查一下alert日志
启动监听：lsnrctl start
检查监听：lsnrctl status

        安装过程中遇到的问题：

        bash-3.00$ more /tmp/OraInstall2014-07-22_02-33-50PM/installActions2014-07-22_02-33-50PM.log

        Using paramFile: /orahome/oracle/product/9.2.0/oui/oraparam.ini

       

       

        Checking installer requirements...

       

        Checking operating system version: must be 5.8 or 5.9. Actual 5.10

        Failed <<<<

       

        Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2014-07-22_02-33-50PM/installActions2014-07-

        22_02-33-50PM.log

       

        解决办法：

        修改/orahome/oracle/product/9.2.0/oui/oraparam.ini文件

       

        [Certified Versions]

        #You can customise error message shown for failure through CERTIFIED_VERSION_FAILURE_MESSAGE

        Solaris=5.8,5.9,5.10 添加5.10