Follow Us on Twitter

Upgrading to Oracle on Windows

by Michel van Zoest on January 27, 2010 · 4 comments

The latest release of the Oracle database is, but this release is for Linux and Solaris only.

Most developers that want to use 11g on Windows are limited to the release. This is a problem when trying to install Oracle SOA Suite 11g or some other Middleware 11g products (like Forms 11g). These products require the installation of the Repository Creation Utility, which is only supported for And that version is only available for download for Microsoft Windows Server 2008.

The only way to get a installation on computers with other versions of Microsoft Windows is to use the available patchset. This patchset is available as patch #6890831 on Oracle Support (Metalink).

After downloading the patchset you can start the installation by clicking setup.exe. After this follow the steps to enter information for your current ORACLE_HOME and other parameters. The installer then proceeds with upgrading the database software.

When this is completed, you’re not done yet! The software is now updated, but you still have to upgrade the database itself. When you would try to login to your database instance, you would receive an ORA-12154 error.

To solve this you can use the Database Upgrade Assistent, or you can do it manually:

1. Log in with administrator privileges.

2. Start the listener as follows:

C:\> lsnrctl start [listener_name]

3. Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

C:\> sqlplus /NOLOG

Enter password: SYS_password

4. Enter the following SQL*Plus commands:

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

5. Restart the database:


6. 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

You’re database is now ready to be used again. For advanced features and instructions, you can read the README.html that is shipped with the patchset.

Upgrading to Oracle on Windows, 3.8 out of 5 based on 4 ratings
VN:D [1.9.22_1171]
Rating: 3.8/5 (4 votes cast)

{ 4 comments… read them below or add one }

R. J. July 28, 2010 at 6:39 pm

Thank you _SO_ much! I have had a TERRIBLE time trying to locate even just the patch from within Metalink and Oracle’s site. They have gotten just too big.

Opinions aside, this post has been most helpful in getting us our database server back up and running.


Michel van Zoest July 28, 2010 at 9:15 pm

You’re welcome, and thank you for your reaction. It’s nice to know that this post helped someone else as well 🙂
That’s one of the reasons that we blog; to help other people find the answers to questions we’ve struggled with ourselves.


Venkat December 4, 2010 at 5:33 am

Hi Michel,

Thanks for you post. I have to upgrade our database to I plan to stop the oracle services on windows before the upgrade. One the oracle binaries are updated with the new patch set how should have bring the db up for startup upgrade.

If I start the service, the db fill be up and running. If I don’t start the servie then the db will not come up.

Once the ORACLE_HOME is upgraded to can i just start the service without bringing up database in order to do “STARTUP UPGRADE” . I know its a basic question but I am a unix guy just moving onto windows.

Thanks in advance.


sandhya July 20, 2012 at 8:11 am

Thanks a lot. It is very useful to us while installing the RCU.
we have upgraded oracle to i think we receive the error ORA-12514 error not ORA-12154


Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS