Home Forums CA Single Sign-On CA SSO : Unable to set up superuser account

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  Dhilip 5 months, 3 weeks ago.

  • Author
    Posts
  • #991

    Dhilip
    Participant

    Hi Ujwol,

    We are trying to set up Oracle Database as policy store but I am getting the following error message.
    <<
    smreg su command failed.

    Please fix the error and reconfigure the Policy Store.
    >>

    I could see that tables has been created. While trying to execute smreg -tu command, I have noticed the below error message.

    <<
    [][2325][4097406688][08/30/2018][16:13:53][16:13:53.136][][][][Start processing SQL statement.][][][][CSmRecordset::Execute][CDb.cpp:305][][][][insert into smrootconfig5 (rootconfigoid, enableusertracking, dynamicprefs, majorversion, minorversion, smmode) values (‘1c-67b3c2b0-9e28-11d3-95e7-00c04f7468ef’, 0, ‘ ‘, 7, 0, 0)][][][]
    [][2325][4097406688][08/30/2018][16:13:53][16:13:53.173][][][][SQL Error.][][][-1][CSmDbConnectionODBC::CheckForError][CSmDbODBC.cpp:1436][[NS][ODBC Oracle Wire Protocol driver][Oracle]ORA-01950: no privileges on tablespace ‘USERS’][HY000][][][][][]
    ..

    ..

    Failed to create the super user account.
    >>

    It is trying to create the superuser account in “USERS” table space. May I know the reason for the same as we have created dedicated table space and the tables has already been created(by the installer wizard) in the dedicated table space?

    Regards,
    Dhliip

You must be logged in to reply to this topic.