今天进行了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 ]
