Project: Cross Platform Migration by using RMAN
(From Windows-32 bit to Solaris x86) Source System Details: Platform: Windows – 32 bit DB Version: 10.2.0.2 DB NAME: INDIAN DB Location: D: /INDIAN/ Target…
Category: Upgrade/Migrate
Moving From the Standard Edition to the Enterprise Edition and via-verse
If you are using a Standard Edition database (Release prior to 11gR1), then you can change it to an Enterprise Edition database. Step 1Standard Edition…
Converting 32-bit Oracle Databases to 64-bit Oracle Database
If you are using 32-bit oracle database on any 32-bit / 64-bit plateform then you can convert or migrate 32-bit database to 64-bit database. Now…
Role of the Database Administrator during the Upgrade
The database administrator (DBA) is the most important person for upgrade process. He involve in each steps, except application testing. The DBA handle following task…
Why upgrade oracle database to higher version
Oracle release 10g version about a year ago and recently release 11g. Many companies are still using the 8i (8.1.x), 8 (8.0.x) and 7.x database…
Project: Migration of Database across OS Platform through Export and Import
In this section, we will discuss how to migrate an existing database from one OS platform to another (i.e.: Windows to Solaris). We can migrate…
Project: Migration Oracle Databases across Platforms by using Transporting Tablespace
Prior to Oracle 10g, one of the only supported ways to move an Oracle database across platforms was to export the data from the existing…
How to create Shared Disk “between” two Solaris Machine on VMWare
Step 1 Create first Machine Create the windows folders to house the first virtual machines and the shared storage. D:>mkdir SUNOS-1 F:>mkdir SHARED-STORAGE Install Solaris…
Upgrade from 9.2.0.1.0 or 9.2.0.8.0 to 10g release 2 (10.2.0.1.0)
Note: If you want to upgrade 9.2.0.1.0, you must apply patch set 7 R2 (9.2.0.8) (Down load from Metal ink) or you can upgrade directly…
Upgrade Database from 8.1.7.0.0 to 9i release 2 (9.2.0.8.0)
Upgrade from 8.1.7.0.0 to 9i release 2 (9.2.0.8.0) We can use three methods to upgrade our oracle database. Export / Import Database Upgrade Assistant Manually…