数据库的升级
步骤
3)打开数据库,重新编译数据库对象. SQL> STARTUP SQL> @/u01/oracle/product/10.2/db_1/rdbms/admin/utlrp.sql 4)正常关闭数据库,并以正常方式启动数据库. SQL> SHUTDOWN IMMEDIATE SQL> STARTUP 5)检查当前的数据库版本 .
nc效率优化
lastsql: SELECT ichead.fallocflag, icbody.cinvbasid, icbody.cfirstbillhid cfirstid, icbody.cfirstbillbid cfirstbid, icbody.cfirsttype cfirsttypecode, icbody.vfirstbillcode vfirstcode, icbody.vfirstrowno, ichead.cbilltypecode csourcetypecode, ichead.vbillcode vsourcecode, ichead.cgeneralhid csourceid, ichead.boutretflag, icbody.crowno vsourcerowno, icbody.cgeneralbid csourcebid, ichead.ts sourceheadts, icbody.ts sourcebodyts, icbody.dbizdate, icbody.vbatchcode, icbody.vfree1, icbody.vfree2, icbody.vfree3, icbody.vfree4, icbody.vfree5, icbody.castunitid, nvl( icbb3.nsettlenum1, 0.0 ) nioaccountnum, nvl( icbb3.ntoaccountnum, 0.0 ) nooaccountnum, nvl( icbb3.nsettlenum1, 0.0 ) noutiosettlenum, nvl( icbb3.ntoaccountnum, 0.0 ) noutoosettlenum, icbody.csourcebillhid cinsrcid, icbody.csourcebillbid cinsrcbid, icbody.csourcetype cinsrctypecode, ichead.freplenishflag borderretflag, icbody.cquoteunitid, icbody.nquoteunitnum, icbody.nquoteunitrate, icbody.ninnum, icbody.noutnum, CASE WHEN ichead.cbilltypecode = '4Y' THEN icbody.noutnum ELSE icbody.ninnum END nshldnumber, CASE WHEN ichead.cbilltypecode = '4Y' THEN icbody.noutnum ELSE icbody.ninnum END nnumber, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.pk_corp ELSE ichead.cothercorpid END ctakeoutcorpid, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.pk_calbody ELSE ichead.cothercalbodyid END ctakeoutcbid, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.cwarehouseid ELSE ichead.cotherwhid END ctakeoutwhid, ichead.coutcorpid, ichead.coutcalbodyid coutcbid, ichead.cbiztype cbiztypeid, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.cothercorpid ELSE ichead.pk_corp END cincorpid, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.cothercalbodyid ELSE ichead.pk_calbody END cincbid, CASE WHEN ichead.cbilltypecode = '4Y' THEN ichead.cotherwhid ELSE ichead.cwarehouseid END cinwhid, nvl( bd_stordoc.isgathersettle, 'N' ) isgathersettle, nvl( bd_stordoc.iscapitalstor, 'N' ) iscapitalstor, icbody.btoinzgflag, icbody.btoouttoiaflag, gprice1, gmny1, ichead.csettlepathid, icbody.ntranoutnum naccuminnum, icbody.naccumwastnum, icbody.flargess, icbb3.naccumoutbacknum, icbb3.bfchsflag, nvl( icbb3.bzgarapflag, 'N' ) bzgarapflag, icbb3.fzgarrule, icbody.pk_defdoc4, icbody.vuserdef4 vbdef4 FROM ic_general_h ichead INNER JOIN ic_general_b icbody ON ichead.cgeneralhid = icbody.cgeneralhid INNER JOIN ic_general_bb3 icbb3 ON icbody.cgeneralbid = icbb3.cgeneralbid INNER JOIN bd_stordoc ON ichead.cwarehouseid = bd_stordoc.pk_stordoc INNER JOIN T_TO_TRANSFER_ORDER_BID trans ON icbody.cfirstbillbid = trans.cfirstbid and icbody.cfirstbillhid = trans.cfirstid WHERE ( icbody.cfirsttype IN ( '5C', '5D' ) ) AND ( ichead.fbillflag = 3 OR ichead.fbillflag = 4 ) AND ( ichead.dr = 0 ) AND ( icbody.dr = 0 ) AND ( ichead.cbilltypecode IN ( '4E', '4Y' ) ) AND nvl( ichead.boutretflag, 'N' ) = 'N' AND icbb3.bendsettle1 = 'N' and ( icbody.dbizdate >= '2011-01-01' ) and ( icbody.dbizdate <= '2011-01-31' ) and ( ( ( ichead.cwarehouseid = '1040A110000000000QFJ' ) and ichead.cbilltypecode = '4Y' ) or cbilltypecode = '4E' ) and ( ichead.pk_corp = '1040' or ichead.cothercorpid = '1040' or ichead.coutcorpid = '1040' ) and icbody.dbizdate <= '2011-01-31' 数据库连接ID:731655068 数据源:nc 执行状态:执行完毕 执行耗时:66164ms 读取记录数:0
1
中间件软件 数据库软件 存储 磁带库
IBM WAS6.1 oracle DS**** TS3200
1 1 1 1
客户环境
硬件部署图：
Was 集群安装
详细步骤参阅《AIX垂直集群实施过程》
数据库的升级
步骤
1、当前的数据库版本做升级,升级目标:ORACLE 10G 10.2.0.4.0. 2、下载并解压对应补丁包: P6810189_10204_aix.zip是下载的补丁安装包,Disk1是解压后的一个目录. 注:检查该目录的权限应该为ORACLE用户所有. 确定当前数据库的版本: Select * from v$version; 3、关闭所有的ORACLE服务: $shutdown immediate lsnrctl stop emctl stop dbconsole ps –ef |grep oracle 4、备份数据库: Rman备份、逻辑备份
类别 数据库服务器 设备型号 IBM Power 550 描述 4颗4核3.5/4.2/5.00GH POWER6 16 GB memory 2 x 73.4GB SAS硬盘 4Gb 光纤通道 个数 1
应用服务器
IBM Power 520
4颗4核 3.5/4.2/5.00GH POWER6 16 GB memory 2 x 73.4GB SAS硬盘 4Gb 光纤通道 WEBSPERE中间件软件 数据库软件 4*4Gbps光纤通道/4G缓存/至少10块硬盘做raid5或raid10 IBM TS3200 1*LTO-3 driver，1盘清洗带，40盘数据带（带条形码）