IDM db installation issue

[Former Member]

Hi,

I am installing  Identity Center database on Oracle by using the sps09 patch files, this is a fresh installation.

while installing it is asking for below inputs.

In the installation guide, we cannot find any help for below values..

Enter value for dbtypename:

Enter value for dbtypenum:

Enter value for longclob:

Enter value for modcol:

Enter value for defval:

Enter value for clobclob:

Enter value for dropnotnull:

Enter value for setdayatype:

Any one face this issue while installing the DB using  sps09 patch, i am able to install the db if i use the sps04 patch files.

I am not sure why it is asking for above inputs if is use sps09  (IC_DESIGNTIME_72_9 )

[former_member2987 · Accepted solution]

Prashanth,

The only thing I can think of is to check what user you are logged in as in your OS/Oracle.

I believe there are some requirements for this per the Oracle Install document.

Thanks,

Matt

[Former Member · Accepted solution]

hi Matt,

I logged in with orasid user.

we have installed the sap netweaver 7.4 which is required for of IDM UI components,

on the same database we are executing the IDM database scripts.

Actually with this user i was able to install the IDM db using sps 04 patch files.

Also i tried with sps 08 patch files and noticed the same issue.

[former_member2987 · Accepted solution]

Prashanth,

Please check the contents of the include.sql file.  Perhaps something has not been updated?

Matt

[Former Member · Accepted solution]

Matt,

You are right, thanks for the input.

It was a miss from my end, i was using the old include.sql file instead of editing the new .include.sql file

[former_member2987 · Accepted solution]

Prashanth,

Glad to be of help!

Matt

[Former Member]

Hi Prashanth,

Are you using Oracle Database Installer tool?

BR,

Simona

[Former Member]

Hello Simona,

we are usiing the exiting database, on which we have  already installed the sap Netweaver 7.4.