SAP IDM 7.2 with ORACLE DB and Linux

[Former Member]

Hi, Experts

I installed SAP IDM 7.2  with oracle Database "11", on linux OS

The problem is when i open the Identity center to create a new indetity,

So i give the correct information for the ORACLE OLDEB connector

The databaseName / USER / PASSWORD etc....,

But there a message error :

ORA-12154: TNS: could not resolve the connect identifier specified

i also installed the ORACLE ODAC for ORACLE DB 11, JV, when i check my DB i fount the mxmc_oper  !

It seems also my tnsnames.ora file's good! i made sur the correct information in the file

any advice or help will be appreciated !

Regards,

Elmehdi

[Former Member · Accepted solution]

Hi, Experts,

I solved the problem. that was a missing information in my tnsanames.

Thanks to all.

Now we try to make the transport fonctionality from an idenitity center to another one. so we did and when we open the the TASK exported from the other indentity it gives ORA-00942 table or view does not exist. it's only when we try to accede to the task. otherwise we can check the job and all the fonctionnalities. ? any idea about this ?

Regards

[Ckumar · Accepted solution]

Hello Elmedi,

Please close the thread (by marking/sharing the correct answer) If your issue is resolved.

For more details abut using SAP IDM SCN please check the Matt's post A few reminders

Regards,

C Kumar

[former_member2987 · Accepted solution]

Hi Elmehdi,

What did you need to update in your tnsnames.ora file?

Thanks,

Matt

[Former Member · Accepted solution]

Hi Matt,

for the tnsnames problem must provide next points :

1- Make sur that you have aleardy a listnner on your Database
2- You must have the tnsnames in the correct directory

3-You should verifiy the tnsnames configuration as follow

<addressname> =

(DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))

  )

(CONNECT_DATA =

  (SERVICE_NAME = <service_name>)

)

)

4- Check also your Path and your environment variable

BR, El-Mehdi

[former_member2987]

Hi Elmehdi,

Have you specified a driver and properly created the connection strings?

I'd recommend reviewing Installing the Identity Center Database on Oracle - SAP NetWeaver Identity Management Installation G...

Matt

[Former Member]

Hi Matt

Yes, I installed ODAC for the connection between the identity center and my database oracle!

I saw the documentation aleardy and i did the same steps. !

I checked also my tnsnames.ora file to be sure "Data-Connection"

As required i'v opened the include.sql and i changed the name as our requires. !

but something wasn't good with create-user.ql i couldn't found the correct information ! is that can cause problem ?

I'm on IDM 7.2 SP08

regards

[former_member2987]

Hi there,

Does the dispatcher start? Have you created the classpath in IDM?

[Former Member]

Hi,

We'r just in the creation of the identity center we haven't creat the dispatcher yet !

" sorry if i'm not clear enough i'm just beginner "

Regards !

[jaisuryan]

Hi Elmehdi,

Have you added the directory of tnsnames.ora file in 'PATH' environment variable?

Have you also added TNSNames in NAMES.DIRECTORY_PATH in the file 'sqlnet.ora' under ‘Admin’ folder in Oracle home.

Kind regards,

Jai

[Former Member]

Hi Jai,

I just did this and still the same problem !!!

Regards

[former_member2987]

Elmehdi,

I'd suggest reviewing all documentation.  You've probably missed a step or two.

Please confirm that you have done all installation steps correctly for an Oracle installation. If you have, can you please check the settings with your DBA team?

Matt