Documentum Server Installation Error Database Session is shutting down due to

Mark Stone · 2023-04-29T02:00:06+00:00

There was an error rendering this rich post.

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)"

Find more posts tagged with

Documentum

Content Server

Installation

Comments

Mark Stone

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

Mahmud Hoque

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

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

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

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