SAP NW IDM Identity Center - Initial Configuration

[Former Member]

Hi experts

- Initial config IDM Identity Center -

I have a problem to connect from the IDM Mgmt Console to the Oarcle DB (dedicated) over ODBC.

The test-connection works fine. But with the next step I get the Error:

Method: Identity Center database connection wizard

Error: 80040E37h

Description: ORA-00942: table or view does not exist

My TNSNAMES.ora:

XXX = (DESCRIPTION =

(ADDRESS =

(COMMUNITY = XXX.WORLD)

(PROTOCOL = tcp)

(HOST = xxx.xxx.xxx.xxx)

(PORT = 1527)

)

(CONNECT_DATA =

(SID = XXX)

(SERVICE_NAME = XXX)

(GLOBAL_NAME = XXX.WORLD)

)

)

I install the IDM DB (the Schema) in an existing Oracle DB.

I think, I have a problem with the rights in the Oracle DB.

Where can I debug this Problem?

Any recommendations?

Thanks

M.W.

[Former Member]

Marco,

I had the same issue (on oracle db). But I figured out I wasnu2019t using the correct userid during the configuration. Make sure you use the user ids that are described in the SAP NW IdM Initial configuration guide. i.e

1. For Identity Center connection string - mxmc_admin

2. For windows runtime engine- mxmc_rt

3. For JDBC URL for the java runtime- mxmc_db

Regards,

Anurag

[Former Member]

rollback and install in a new separate database that will be the path of least effort and ease of install.

[Former Member]

Did mxmc-install.cmd run smooth?

Also what use you use to connect to the DB?

[Former Member]

Hello Christian

Yes, the MXMC-install was smooth.

I create for the IDM a seperate tablespace in the DB. And set this tablespace for the installation in the include.sql:

DEFINE DATA_TS = IDMTABLESPACE

DEFINE INDEX_TS = IDMTABLESPACE

The mxmc-test.sh closed with *** Done -> The MXMC_OPER user appear.

The Oracle DB version is the 10.2.0.4.0

and I use the Oracle Provider for OLE DB in the client.

[Former Member]

Login to SQLPlus with mxmc_oper.

Select * form MXI_VALUES;

Do you get result?

What use you use in the MMC?

[Former Member]

SQL> connect mxmc_oper/<PW>@XXX

SQL> select * from MXI_VALUES;

no rows selected

I had installed the oracle instantclient 11.1 (32bit). This client I have uninstall and now I install the Oracle DB 10g Client Release 2 (10.2.0.1.0). But now in the IC database connection wizard the provider "Oracle OLE DB Provider" is missing.

[Former Member]

Marco,

try downloading the oracle instantclient Version 10.2.0.4, it worked in our setup.