Documentum Server Installation Error Database Session is shutting down due to

Mark Stone
Mark Stone Member
edited April 29, 2023 in Documentum #1

Brand new install for DS 22.4, Oracle 19c db, Windows 2019 server. JDK and Oracle Client installed. Confirmed DB via TNSPING and SQL Plus connection on the box. Ran the Documentum Server software installer with no issues. Ran the Server Configuration Program to configure a docbroker no issue. When installing the Reportistory an issue was encountered. No database objects were created prior to the error being thrown

Docbase log:

Database Session is shutting down due to ()

[DM_SERVER_I_START_ID]info: "Docbase dctmsbd was not successfully opened. Docbase id: (230428)"

Tagged:

Comments

  • Mark Stone
    Mark Stone Member
    #2

    Resolved: Database permissions issue. Granted addition roles to the user, one at a time, to identify which roles were needed and missing.

  • Mahmud Hoque
    Mahmud Hoque Member
    #3

    Hi Mark,

    Great job on resolving the issue. Could you please let us know which permissions on the DB finally resolved the issue? We are facing the same problem while upgrading from 16.4 to 22.2.

  • Naveen Rajendiran
    Naveen Rajendiran
    #4

    We are facing the same problem while upgrading from 16.7.1 to 22.4.Could you please let us know which permissions on the DB finally resolved the issue?

  • Mark Stone
    Mark Stone Member
    #5

    These are all of the Oracle roles assigned to the database user:

    CREATE TYPE
    CREATE MATERIALIZED VIEW
    CREATE TABLE
    CREATE SEQUENCE
    CREATE SYNONYM
    CREATE INDEXTYPE
    CREATE PROCEDURE
    CREATE ANY INDEX
    CREATE VIEW
    CREATE TRIGGER

  • Mahmud Hoque
    Mahmud Hoque Member
    #6

    Thanks for the information, although we gave Full Admin Role to the DB user to mitigate the issue and proceed with the installation.

Categories