//
archives

Archive for

Oracle PL/SQL Examples

Advertisements

Database Upgrade from Oracle 9i R2 (9.2.0.7) HP-UX to 11g R2 (11.2.0.4) OEL cross platform – section4

In section 3, the database has been upgraded from Oracle 9i to Oracle 10g. Now we can use the Oracle Data Pump to tranfer the database from 10g R2 to 11g R2 Data Pump configuration on source database (10g R2) Export DDL for creating tablespaces Run get_ddl to get the create tablespace statement In this … Continue reading

Database Upgrade from Oracle 9i R2 (9.2.0.7) HP-UX to 11g R2 (11.2.0.4) OEL cross platform – section3

In section 2, I upgraded the Oracle Database software from Oracle 9i R2 (9.2.0.7) to 10g R2 (10.2.0.5) Now, it is the time to upgrade the database Create pfile from current spfile of Oracle 9i database and copy that parameter file to the new 10g ORACLE HOME Some Oracle 9i Initialization Parameters has been deprecated … Continue reading

Database Upgrade from Oracle 9i R2 (9.2.0.7) HP-UX to 11g R2 (11.2.0.4) OEL cross platform – section2

There are two approaches we can upgrade the database from Oracle 9i R2 (HP UX) to 11g R2 (Oracle Enterprise Linux) The first approach, use the database import (imp) and export (emp). This approach is the simplest way to upgrade the database, but also the most time consuming approach. If your main business application is … Continue reading

Database Upgrade from Oracle 9i R2 (9.2.0.7) HP-UX to 11g R2 (11.2.0.4) OEL cross platform – section1

Why we need to upgrade the database? If your application to use the new version of the database; If the database is running heavily loaded, and by adjusting the software and hardware can not have a fundamental improvement; If you want to replace the operating system platform; If you want to enhance the security of … Continue reading