Identity IQ External DB Upgrade (Oracle)

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4

Share all details about your problem, including any error messages you may have received.

We have SailPoint IdentityIQ version 8.4 with an external Oracle database.
We want to upgrade the Oracle database itself without upgrading the application.

Are there any actions that need to be performed before or after the database upgrade?

2

@AlaaKhaled Could you please elaborate what do you mean by External DB? Does it mean you are using Oracle as your IIQ Database?

3

Hello @neel193 Yes exactly and it is installed on external server

4

@AlaaKhaled You might want to follow this thread: SailPoint Database version upgrade from SQL server 2019 to 2022 - #11 by neel193

We are discussing the same where SQL server being upgraded (without upgrading IIQ). To summarize:

  • Please check all supporting jars if they need upgrade.
  • any db jobs you have written you need to update.
  • if there are changes to db url you need to update them as well.

Please validate the support matrix to make sure your IIQ version is compatible with the new Oracle DB version.

5

Thanks @neel193 for you reply
I got itm but kindly clarify what do you mean by : any db jobs you have written you need to update.

6

@AlaaKhaled Some clients write few DB jobs like we have written for below cases:

  • To periodically archive spt_audit_event for audits older than 2 years.
  • Another job to read few tables and send it to Kibana.
  • another job to read details from Oracle to update a custom table in MSSQL.

So something similar if you have written, you need to review that as well.