Oracle9208升级过程

今天进行了oracle9206升级oracle9208，大致如下：

1：安装oracle software（40分钟）

x-manger
runInstaller.sh

vi .rhosts
/oracle/app/oracle/product/9.2.0.6/oui/lib/aix> mv liboraInstaller.so liboraInstaller.so.old
/oracle/app/oracle/product/9.2.0.6/lib32> mv libclntsh.a libclntsh.a.old
/oracle/app/oracle/product/9.2.0.6/bin> mv sqlplus sqlplus.old
/oracle/app/oracle/product/9.2.0.6/lib> mv libjox9.a libjox9.a.old

/oracle/app/oracle/product/9.2.0.6 root.sh
qdzw2:/oracle/app/oracle/product/9.2.0.6> root.sh
Running Oracle9 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/app/oracle/product/9.2.0.6

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 ...

Adding entry to /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.

2：upgrade database （30分钟）

--用srvctl启动数据库
qdzw1:/oracle> srvctl start database -d account1
PRKR-1007 : getting of cluster database account1 configuration failed, PRKR-1001 : cluster database account1 does not exist
PRKO-2005 : Application error: Failure in getting Cluster Database Configuration for: account1

cat /var/opt/oracle/srvConfig.loc
cat /etc/srvConfig.loc

qdzw1:/oracle> srvconfig -init -f
qdzw1:/oracle> srvctl add db -d account1 -o /oracle/app/oracle/product/9.2.0.6
qdzw1:/oracle> srvctl add instance -d account1 -i acct1 -n qdzw1
qdzw1:/oracle> srvctl add instance -d account1 -i acct2 -n qdzw2

--遇到的问题
ORA-00600: internal error code, arguments: [504], [0x70000000008CEC0], [160], [7], [shared pool], [2], [0], [0x70000000008CDD0]
$ORACLE_HOME/install/changePerm.sh

3：opatch apply patch （20分钟）

--patch
opatch lsinventory

  Installed Patch List:
  =====================
  1) Patch 4741381 applied on Sat Apr 19 09:55:53 GMT+08:00 2008
      [ Base Bug(s): 4741381  ]
  2) Patch 5065930 applied on Sat Apr 19 09:55:02 GMT+08:00 2008
      [ Base Bug(s): 5065930  ]
  3) Patch 4605569 applied on Sat Apr 19 09:52:40 GMT+08:00 2008
      [ Base Bug(s): 4605569  ]
  4) Patch 5496862 applied on Sat Apr 19 09:51:00 GMT+08:00 2008
      [ Base Bug(s): 5496862  ]
  5) Patch 5659663 applied on Sat Apr 19 09:46:37 GMT+08:00 2008
      [ Base Bug(s): 5659663  ]

 

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

转载于:http://blog.itpub.net/13132547/viewspace-244121/