Oracle Upgrade -- Error after installing software of Oracle 11.2g

[joo_migueldimas]

I´ve been trying to do an Oracle Database Upgrade from 10.2.0.4 to 11.2.0.1. I finished the installation of Oracle 11.2g

software, but now I´m stuck in importing of Generic Patches:

G:oraclePRD112OPatch>opatch napply generic
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY

Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
UTIL session
Oracle Home       : G:oraclePRD102
Central Inventory : C:Program FilesOracleInventory
   from           : n/a
OPatch version    : 11.2.0.1.1
OUI version       : 10.2.0.4.0
OUI location      : G:oraclePRD102oui
Log file location : G:oraclePRD102cfgtoollogsopatchopatch2010-08-08_02-11-45AM.log
Patch history file: G:oraclePRD102cfgtoollogsopatchopatch_history.txt
Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
UtilSession failed: Patch 8830174 requires component(s) that are not installed in OracleHome. These not-installed compon
ents are oracle.sysman.console.db:11.2.0.1.0,

OPatch failed with error code = 73

Edited by: Julius Bussche on Aug 9, 2010 7:46 AM

Subject title changed as requested.

[stefan_koehler]

Hello João,

there seems to be something wrong wiht your environment (ORACLE_HOME) or central oracle inventory.

You are running OPatch for 11g R2 (from the correct directory "G:oraclePRD112"), but the oracle inventory still gets your old oracle version with the old path " G:oraclePRD102" .. so the error message is correct in that case.

Oracle Home       : G:oraclePRD102
Log file location : G:oraclePRD102cfgtoollogsopatchopatch2010-08-08_02-11-45AM.log
Patch history file: G:oraclePRD102cfgtoollogsopatchopatch_history.txt
UtilSession failed: Patch 8830174 requires component(s) that are not installed in OracleHome. 
These not-installed components are oracle.sysman.console.db:11.2.0.1.0,

Please check your environment on that windows server.

Regards

Stefan

[joo_migueldimas]

Hello Stefan,

That was just what I assumed after installation... I asked myself whether I would not have to set other environment variables, this is, update the environment variables to the new ones of ORACLE_HOME 11.2g, it seemed weird in that point but I continued as is mentioned in the Upgrade guide!! In the manual is not mentioned this important point which is necessary to change the environment variable ORACLE_HOME ... I assumed this would be done at a later point of upgrade process... but I was wrong, I think it should be mentioned on the upgrade guide but unfortunately is not!!

The current ORACLE_HOME & PATH are:

ORACLE_HOME = G:oraclePRD102

PATH = G:oraclePRD112 in;G:oraclePRD102 in;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;C:WINDOWSsystem32WindowsPowerShellv1.0;C:j2sdkx64 in

So as I understood with your words, you told me to change the value of Oracle_Home to the new oracle version G:oraclePRD112 ? But as I said above, this procedure is not covered in the manual !! 😐

Best regards,

João Dimas - Portugal

[stefan_koehler]

Hey João,

So as I understood with your words, you told me to change the value of Oracle_Home to the new oracle version G:oraclePRD112 ?

Right ... of course it is mentioned in the "Oracle 11gR2 Upgrade guide", but a few steps later (check Point "5.1Changing Environment Variables" on page 31).

However just do it )

Regards

Stefan

[joo_migueldimas]

OK! I just passed that point...

Yes you´re right Stefan, but even so, as you said it mentioned in point "5.1Changing Environment Variables" on page 31" and this is necessary to do before, for instance in that point where I found the problem, how you import the Generic Patches and other patchs into new database without change the value of environment variable ORACLE_HOME to the new path G:oraclePRD102?

Don´t you think this procedure of changing the ORACLE_HOME value should be mentioned on a previous point in upgrade guide... just after the point "4.1.1 Installing the Oracle 11g Server Software"?

Thank you,

João Dimas - Portugal

[joo_migueldimas]

Hi again Stefan..

At the finish of upgrade procedure in point "5.6 Updating the SAP Executables and the BR*Tools" in the lastest phrases on page 37 say:

4.Execute the following SQL commands:sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>DB

But when I do this it give me an error as you can see below:

C:>sqlplus /nolog @sapdba_role SR3
SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 9 19:07:35 2010
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
SP2-0310: unable to open file "sapdba_role.sql"

Can you tell me what´s happen? How can I solve this...?

Kind regards,

João Dimas - Portugal

[former_member204746]

come on...

read the messsge:

SP2-0310: unable to open file "sapdba_role.sql"

can you find that file? it is probably not in the current directory, eh?

[Former Member]

Hi,

As mentioned above make sure sapdba_role.sql exist in same directory or alternatively you can give full path to this file.

Regards,

Gagan

[joo_migueldimas]

Ah I forgot...

Another thing... after the error that I mentioned above, when I tried to fix that, I stopped all sap / database services (through services.msc), I did a reboot to the server but after all this when I tried to put the database up through cmd command (SQL Plus - startup) it show me the following error:

C:>sqlplus /nolog
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

This serious problem... now I not able to startup the current database!! Can you tell me why?... how correct this...?!

Please, help me!

Kind regards

João Dimas - Portugal