Oracle Update from 10.2.0.4 to 11.2.0.1 - Post activities for patches

[Former Member]

For my NW 7.0 system I have updated Oracle from 10.2.0.4 to 11.2.0.1 on Win2003 according to the Upgrade Guide together with all the notes mentioned in it. In the beginning of the upgrade there has to be installed the Oracle 11.2.0.1 software, the generic patches and the patch collection (bundle patch 8). Then the migration of the database is done and the post activities.

But I'm missing the post activities, which have to be done for the Oracle generic patches and the patch collection.

That means the execution of the scripts:

@?/rdbms\admin\prvsash.plb

@?/rdbms\admin\prvtash.plb

@?/rdbms\admin\prvtdput.plb

@?/rdbms\admin\catost.sql

@?/rdbms\admin\cdcore.sql

@?/Bundle\Patch8\catcpu.sql

Have they been forgotten in the upgrade guide?

Or are they included in the migration of the database?

On my test database I executed the above statements and found in the log for catcpu.sql the following error:

....

SQL> @?/rdbms/admin/bug9758569.sql

SQL>

SQL> begin

2 initjvmaux.exec('revoke execute on "oracle/aurora/vm/HotLoader" from public');

3 exception when others then if sqlcode not in (-1927) then

4 raise;end if;

5 end;

6 /

initjvmaux.exec('revoke execute on "oracle/aurora/vm/HotLoader" from public');

*

ERROR at line 2:

ORA-06550: line 2, column 2:

PLS-00201: identifier 'INITJVMAUX.EXEC' must be declared

ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

....

But I did not find any hints in SAPNEt for this error. So what should I do now?

How has the installation of the patches to be handled in the Oracle upgrade?

In advance thanks a lot for your help!

Marlene

[Former Member]

I have opened a SAP message and got as answer,

1. that all the scipts have to be executed after the migration.

2. the error with "initjvmaux.exec" can be ignored as JVM is not used.