Upgrade DB2 ESE from 9.7 to 10.5

# v10.5fp7_aix64_server_t.tar 10.5.0.7 media # as user db2inst1, make sure no invalid objects exist db2 connect to shinpbdb db2 connect to shibordb db2 connect to shinetdb db2 “SELECT SUBSTR(OBJECTSCHEMA,1,10) OBJECTSCHEMA, SUBSTR(OBJECTNAME,1,30) OBJECTNAME, SUBSTR(ROUTINENAME, 1,30) ROUTINENAME, OBJECTTYPE, INVALIDATE_TIME, LAST_REGEN_TIME FROM SYSCAT.INVALIDOBJECTS” db2 “CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(NULL, NULL, NULL)” # as user root cd /install tar -xvf v10.5fp7_aix64_server_t.tar cd… Continue reading Upgrade DB2 ESE from 9.7 to 10.5

Out-of-place Upgrading single instance DB from 11.2.0.3 to 11.2.0.4.160719

OS: AIX 7.1 # install 11.2.0.4 on new oracle home # as user oracle on both hosts mkdir -p /oraapp/11.2.0.4/oracle/product/dbhome_1 # upgrade an existing database # Cancel Netca # modify .profile cp .profile .profile.`date +%Y%m%d` vi .profile # modify ORACLE_BASE and ORACLE_HOME # compile invalid objects, purge recyclebin and gather dictionary stats @?/rdbms/admin/utlrp set lines… Continue reading Out-of-place Upgrading single instance DB from 11.2.0.3 to 11.2.0.4.160719

Out-of-place Upgrading GI and DB from 11.2.0.3 to 11.2.0.4.160719

OS: AIX 7.1 # prerequisites 1 make sure GUI is available for installation 2 make sure /oraapp has at least 50G free space 3 media list p13390677_112040_AIX64-5L_[1-4]of7.zip # AIX 11.2.0.4 p23274134_112040_AIX64-5L.zip # 11.2.0.4.160719 GI + DB PSU (or 23615403 combo patch) p21354456_112040_AIX64-5L.zip # 21354456 one-off patch p6880880_112000_AIX64-5L.zip # opatch 11.2.0.3.10 # as root on both… Continue reading Out-of-place Upgrading GI and DB from 11.2.0.3 to 11.2.0.4.160719

ORA-918 raised after migrating from 10g to 11g

After migration from Oracle 10g to 11g, we found an invalid object, which was valid in 10g database: SQL> alter procedure FXDM.SP_STAT_MAKER_P compile; Warning: Procedure altered with compilation errors. SQL> show errors Errors for PROCEDURE FXDM.SP_STAT_MAKER_P: LINE/COL ERROR ——– —————————————————————– 479/4 PL/SQL: SQL Statement ignored 481/118 PL/SQL: ORA-00918: column ambiguously defined According to Query Fails… Continue reading ORA-918 raised after migrating from 10g to 11g