mxmc-install.cmd do not work (windows 2003/oracle)

[Former Member]

Hi!

I'm trying to install the IC (oracle) as per Installation guide.

I have just installed a Nw 7.1 CE EHP1 with Oracle and so, I have a DB on my server (sid = IM1)

When I run the script mxmc-install.cmd, after i have put some pswd I receive som error.

• install.log begin *******

Session altered.

********************************************************************************

• Creating database

********************************************************************************

create user MXMC_OPER identified by remote01

*

ERROR at line 1:

ORA-00959: tablespace 'USERS' does not exist

create trigger to MXMC_OPER

*

ERROR at line 9:

ORA-01917: user or role 'MXMC_OPER' does not exist

• Creating users

create user MXMC_ADMIN identified by remote01

*

ERROR at line 1:

ORA-00959: tablespace 'USERS' does not exist

grant create session,create synonym to MXMC_ADMIN

*

ERROR at line 1:

ORA-01917: user or role 'MXMC_ADMIN' does not exist

create user MXMC_RT identified by remote01

*

ERROR at line 1:

ORA-00959: tablespace 'USERS' does not exist

grant create session,create synonym to MXMC_RT

*

ERROR at line 1:

ORA-01917: user or role 'MXMC_RT' does not ex

.....

• log finish *****

Seems that tablespace USERS do not exist... this is correct but who have to create this ?

I have leave the default prefix MXMC. Is this correct ??

regards

PiCo

[Former Member]

Hi PiCo

You need to configure your database server first, the error below requires you to create the tablespace ( also create temporary table space) for the oracle user which you would be using to setup the IdM database.

Check the include file to verify which user is being used to setup the database.

>

> ORA-00959: tablespace 'USERS' does not exist
> PiCo

PS: You may take help of database guy...

Let me know if you still face any issues.

Cheers !!

Zaheer

[Former Member]

Hi folks,

When we execute script mxmc-install from IDM 7.1 SP2 or SP3 on Oracle, we are facing compilation issue on the creation of the some oracle procedures :

mxp_init_ids_lang
Warning: Procedure created with compilation errors.
[...]
mxp_init_ids
Warning: Procedure created with compilation errors.
[...]
mc_reset_ids
Warning: Procedure created with compilation errors.
[...]
mxp_init_all_ids
Warning: Procedure created with compilation errors.
[...]
mxp_Xcreate_ids
Warning: Procedure created with compilation errors.
[...]
mxp_create_ids
Warning: Procedure created with compilation errors.

So then, initial data load facing errors :

BEGIN mxp_init_all_ids(:vStatus,:vStatusText); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object IP3_OPER.MXP_INIT_ALL_IDS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


BEGIN mxp_create_ids(:IsId,:Status,:StatusText); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object IP3_OPER.MXP_CREATE_IDS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Does anyone has tips for this issue ?

Thanks,

Benjamin

[Former Member]

Hi Benjamin,

Check the initial configuration/prerequisites for running the install script.

By the way, a frank suggestion, better start a new thread, its not a good idea to hijack someone's thread, other referring to it for some solution may go astray... i hope you understand what i trying to convey.

Cheers !!

Zaheer

[Former Member]

HI!

I read the installation guide and the configuration file. But is not clear.

Ihave just a DB installed and the documento do not explain if you need to create another new DB for IC or, if you have to use the DB used for NW 7.1.

Very hard to have help on this... seems nobody have experience on this product....

thx

[Former Member]

From my experience with this issue (I am not an oracle expert) it is an Oracle configuration issue. Please check with your DBA.

Or better yet, use MSSQL which installs much easier.

Matt

[Former Member]

PiCo,

As I recall there is a configuration file that needs to be configured. Not sure if you checked it or not.

I've seen the USERS table issue before. I'm not a DBA, so hopefully your DBA will know know what to do with this:

Check the table space configuration. I belive there's an issue with the tablespace you are installing to. Have the DBA examine the script and they will see it immediately. They can then either make the needed changes to the database specified by the script or alter the script to work with another database.

Hope this helps!

Matt