Follow Us on Twitter

Upgrading to Oracle 11.1.0.7.0 on Windows

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

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

Most developers that want to use 11g on Windows are limited to the 11.1.0.6.0 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 11.1.0.7.0. And that version is only available for download for Microsoft Windows Server 2008.

The only way to get a 11.1.0.7.0 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
SQL> CONNECT SYS AS SYSDBA

Enter password: SYS_password

4. Enter the following SQL*Plus commands:

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

5. Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

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 11.1.0.7.0 patchset.

Upgrading to Oracle 11.1.0.7.0 on Windows, 3.8 out of 5 based on 4 ratings
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.

Reply

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.

Reply

Venkat December 4, 2010 at 5:33 am

Hi Michel,

Thanks for you post. I have to upgrade our 11.1.0.6. database to 11.1.0.7. 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 11.1.0.7 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.

Reply

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 11.1.0.6.0 to 11.1.0.7.0. i think we receive the error ORA-12514 error not ORA-12154

Reply

Leave a Comment

 

Previous post:

Next post:

About Whitehorses
Company profile
Services
Technology

Whitehorses website

Home page
Whitebooks
Jobs

Follow us
Blog post RSS
Comment RSS
Twitter