Skip to Content
author's profile photo Former Member
Former Member

Oracle 10g Upgrade error

Hi experts

we are upgarding oracle from 9.2.0.6 to 10.2.0.2.

our system configuration :

Oracle : 9.2.0.6

OS - HP-UX 11.23

Hardware : HP Itanium server

We are upgrading oracle 9.2.0.6 to 10.2.0.2.

as a first step ( upgrade guide as on 21/02/2007)

i have upgraded from 9.2.0.6 to 9.2.0.8 and it is successfull.

it showed me 9.2.0.8. and then we dumped the oracle software

of 10.2 of HP-UX itanium (from DVD) to the server and installed the

software and it is succesfull , while installing it showed 10.2.0.1. adn then

i have applied 10.2.0.2 patchset to the software that also successful and the final complaetion is showed as "10.2.0.2 patschset 1 was successfully installed".

and then by dbua command we triggered the upgradation and then also it succesful.

but when we try to query the version from the oracle it showed me 10.2.0.1 and then logged in sqlplus it showed as

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 21 00:15:52 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

so it means until now it is in 10.2.0.1

and the version is

SQL> startup

ORACLE instance started.

Total System Global Area 910163968 bytes

Fixed Size 1994984 bytes

Variable Size 521408280 bytes

Database Buffers 384565248 bytes

Redo Buffers 2195456 bytes

Database mounted.

Database opened.

SQL> select version from v$instance;

VERSION

-


10.2.0.1.0

what to do. I have installed and the 10.2.0.1 software also upgraded and the database is also upgraded by the dbua. then how it shows this version

PLease help

regards

bala

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:29 AM

    what do you get back by this select?

    <b><i>select comp_id, version, status from dba_registry;</i></b>

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      When you apply the 30+ one off patches you should unzip them to a patch directory and then apply then all together with "opatch napply directory_name"

      Applying each patch individually will take a long time and result in several relinks of the Oracle executable. Applying them together (with the napply command) will allow them go much faster, with a single relink.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:24 PM

    Hello,

    From the details provided by you, it doesn't seem that oracle 10.2.0.2 is installed in this particluar ORACLE_HOME. Even SQLPLUS is pointing to oracle 10.2.0.1, that means software not installed in the present oracle_home!

    Reinstalltion of the software and running the script for this upgrade shouldn't create any issue.

    Regards,

    Madhukar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.