You are here:>>>Upgrade OID from to

Upgrade OID from to

Video Tutorial

Upgrade Steps

In this post I will be covering the steps required to upgrade Oracle Internet Directory from to

OID upgrade is not a patch but it’s a full installer. You can use the same installer to install a new OID environment.


  • You already have a working OID environment running on version (If you want to know how to build an OID environment from scratch, please have a look at my post here)

My Current Environment

  • Oracle Linux 6.7 64Bit
  • OID
  • Weblogic Server 10.3.6
  • JDK 1.8
  • Middleware Home: /u01/app/oracle/product/fmw/ (MW_HOME)
  • Weblogic Home: /u01/app/oracle/product/fmw/wlserver_10.3/ (WL_HOME)
  • IDM Oracle Home: /u01/app/oracle/product/fmw/Oracle_IDM1 (ORACLE_HOME)
  • IDM Domain Home: /u01/app/oracle/product/fmw/user_projects/domains/IDMDomain (DOMAIN_HOME)
  • OID Instance Home: /u01/app/oracle/product/fmw/instances/oid_inst1 (INSTANCE_HOME)
  • OID Port: 3060
  • OID SSL Port: 3161

Current Environment Backup

It is very important to take a complete backup of your existing environment especially if you have lot of existing users, groups, policies etc.,

Recommended Backups:

  • File system backup of IDM Home
tar -cvf OracleIDM1_bkp.tar Oracle_IDM1
  • File system backup of Instance Home
cd /u01/app/oracle/product/fmw/instances
tar -cvf oid_inst1_bkp.tar oid_inst1
  • Complete backup / snapshot of database
  • LDIF back up all your base domain using LDIFWRITE. It will be useful to import back the base domain using script
ldifwrite -connect connect_string  -b base_domain -f backup.ldif

Software Required

  • p20995629_111190_Linux-x86-64_1of2.zi
  • (This is required patch for SOA and needed only if you have integrated OID with OIM/OAM)

Prepare for Upgrade

  • Stop ODS managed server from Weblogic Admin Console
  • Stop Weblogic Admin Server
  • Stop OID using OPMN process
./opmnctl stopall

Install OID Patch

1. Extract software zip files and navigate to Disk1 and execute the installer


2. Click “Next” on Welcome screen



3. Select “Skip Software Updates” and click “Next”


4. Select “Install Software – Do Not Configure” and click “Next”

  • As we are upgrading, we just need to install the binaries.


5. Make sure that prerequisite checks are successful and click “Next”


6. Verify Middleware Home & IDM Home and click “Next”

  • These should be the existing middleware home and IDM home.


7. Click “Yes” on upgrade confirmation screen


8. Uncheck security updates and click “Next”


9. Click “Yes” on security updates confirmation screen


10. Click “Install” on Summary screen


11. Installation Progress screen


12. Click “Next” when you see “Execution of post install scripts completed” message


13. Execute below script as root and click OK



14. Click “Finish” on Installation Complete screen

Apply SOA Patch 16468944 (Only if OID is integrated with OIM/OAM)

1. Extract and navigate to extracted directory

2. Set SOA Oracle Home


3. Add SOA Opatch to PATH

export PATH=$ORACLE_HOME/OPatch/

4. Execute opatch apply from extracted patch directory

opatch apply

5. Verify patch by executing lsinventory

opatch lsinventory

Upgrade Database Schema Using Patch Set Assistant (PSA)

1. Navigate to IDM home bin and execute patch set assistant


2. Click “Next” on the Welcome screen


3. Select “Oracle Internet Directory” and click “Next”


4. Select both checkboxes and click “Next”


5. Provide ODS schema details and click “Next”

  • Connect String: localhost:1521/orcl
  • DBA Username: sys as sysdba
  • DBA Password: SYS password
  • Schema User Name: ODS


6. Make sure the examine phase is successful and click “Next”


7. Click “Upgrade” on the Summary screen


8. Make sure the upgrade is successful and click “close”


9. If you have additional schema on (If integrated with OIM/OAM), execute PSA for each schema separately in the following order:

  • Metadata Service – MDS
  • SOA Infrastructure – SOAINFRA
  • Oracle Platform Security Services – OPSS
  • Audit Service – IAU
  • User Messaging Service – ORASDPM

10. Verify schema version using below SQL query

select comp_name,owner,version from schema_version_registry where owner = 'ODS';


11. Check if there are any invalid opjects or packages in database using below query

select owner,object_name from all_objects where status='INVALID';

12. If you get any invalid objects, re-compile them using below query.

execute dbms_utility.compile_schema('schema_name');

13. Start Admin Server, ODS Managed Server, OPMN.


THATS IT !! Now you have upgraded OID from to If you have any questions, let me know in the comments below.


About the Author:

I am a Senior Cloud Professional specialized in AWS Cloud with 11 years of IT experience. I am enthusiastic about Serverless Architecture. I am an expert in Oracle Fusion Middleware.


  1. Deejay September 25, 2016 at 7:33 AM - Reply

    very useful thank you!

  2. Jonathan October 1, 2016 at 1:38 AM - Reply

    Great information. Quick question, do I have to upgrade OID to after the oracle RDBMS binaries and the database have been upgraded to 12c?

    Thanks in advance

  3. Rosa January 11, 2017 at 4:52 PM - Reply

    Thanks very much for this information. I am going to do a similar upgrade from OIAM to OIAM During this process I have to upgrade OID to OID And SOA to, as Oracle support has indicated me OID is not longer support with OIAM
    In this case I need the patch 16468944 ?
    Thanks in advance.

Leave A Comment