Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2009 at 01:29 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2009 at 01:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 03:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.