And now for the RDBMS upgrade
Principally it should be the other way around...... but as the 10.2.0.4 is also certified for the 12.1 E-business version...
then there is no _real_ reason why this should be done..... Apart from the challenge to do so...
Furthermore it should be noted that the present version of the RDBMS 11G is 11.0.7 and such not 11GR2...
but that will be remedied in the near future....

1. Two ways togo... using the “dbua” from the R12 RDBMS directory..or the manual way.....
“dbua” do have embedded problems in that it references some directory structure from the creation time at Oracle... and the “dbua” script should as such be tailored to “our” structure.... There a number of entries on Metalink(Sorry.... godawful Oracle
Support!!!).. but the “easy” part is just to adapt the script....
The alternative is to use the manual upgrade as described in the 837570.1 Note on Oracle Support....
Step 1: check for invalid objects....
Step 2: check for duplicate objects(actually there was one out the ordinary 4 packages.... and that was WPG_DOCLOAD
which existed both in the SYS and SYSTEM schema’s... dropped that SYSTEM part, as this was _not_ referenced by the
public synonym!
Step 3: Corrected all the init.ora parametsr for the 10.2.0.4 RDBMS to correspond to the R12.1 Apps installation...
Step 4: Follow Support Note: 761570.1 for upgrading the RDBMS to the 11.0.7 .... although this is not needed... we are
already on a certified level... this will be done as an exercise....
Step 5: Run the 11G “dbua” from the 10.2.0.4 environment....
Start: 11:45 end: several days later......
Ran into a “ORA-01498 such column list already indexed” using “dbua” ... See Oracle Support Note:
Ora-01408 Error Upgrading from 9i to 11g using Dbua [ID 737400.1]... which has the solution:
Do:
drop index system.REPCAT$_AUDIT_COLUMN_IDX1;
and
create index system.repcat$_audit_column_f2_idx
on system.repcat$_audit_column
(base_sname,base_oname,base_conflict_type_id, base_reference_name);
and continue.....
fails on a minor issue at the end... Grid Control, configuration.... has still the “nfs/bld” structure......
Not to worry right now as grid Control is not used.....

Mærker: oracle e-business R12 R12.1 upgrade