How to upgrade from an Oracle 10g to Database on MS Vista

Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database ( to on Microsoft Windows Vista?  If you have the patch numbers that one needs to download from Oracle's Metalink and the order that they need to be applied.  Several users have pointed out that you cannot apply patches to a database until it is upgraded to and that interim patches require the Opatch utility.  Any details would be appreciated!


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Cannot access metalink right now:

404 Not Found
Resource /CSP/ui/signin_de.html not found on this server


Might be a locale problem.

Will see.

Here you go
The patch No. is 6810189
Step 1). download the pacth from metalink. the file name for solaris is
Step 2). Extract the file using unzip utilities
Step 3). Stop all services
         i) shutdown database (using: connect / as sysdba and shutdown immediate )
         ii) Shutdown listener (using lsnrctl stop)
        iii) emctl stop dbconsole  (if dbconsole is configured and running).
       iv). isqlplusctl stop (if isqlplus is configured and running)
Step 4). Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe
select the proper Oracle home and click next ..... next ... next
On the Summary screen, click Install. When the installation is complete, the End of Installation screen appears. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

Step 5). startup the listener.  (lsnrctl start )
Step 6). Start the Oracle Database Upgrade Assistant:
From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.

On the Summary screen, check the summary, then click Finish.

On the End of Upgrade screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.

Step 7). Restart the database:


Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql


When the patch set is applied to an Oracle Database 10g Standard Edition database, there may be 54 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:



Run the following command to check the status of all the components after the upgrade:


In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rockwiseAuthor Commented:
Thanks for the suggestion.  This patch should do it.  It comes with its own Universal Installer making it easier to deploy than the earlier interim patches.  Also it can be applied to all 10g Release 2 Databases (10.2.0.x) as well as most 32-bit operating systems - MS Windows Server 2003, Server 2003 R2, Windows XP Professional, Windows Vista SP1, and even Windows 2000 SP2 or later.

Thanks again,

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.