After installing and configuring a new Oracle Mart, the below error is received when attempting to initialize the Oracle database.
"StatementCallback; SQL [DROP SEQUENCE m9Session_sequence ]; IO Error: An existing connection was forcibly closed by the remote host; nested exception is java.sql.SQLRecoverableException: IO Error: An existing connection was forcibly closed by the remote host.
The cause of this error is due to missing one or some of the required Oracle privileges needed by the Installer Role.
In one specific case, we found that missing the "grant select on dba_data_files to MMINSTALL;" caused this error but this can also be caused from missing one of the other grants as well.
This information can be found in the "Install and Configure an Oracle Mart" section of the Mart Server Release notes:
The installer needs the following Oracle privileges:
grant create sequence to MMINSTALL;
grant create table to MMINSTALL;
grant create view to MMINSTALL;
grant drop public synonym to MMINSTALL;
grant create public synonym to MMINSTALL;
grant create procedure to MMINSTALL;
grant select on dba_data_files to MMINSTALL;
grant create session to MMINSTALL;
***These grants can be found in the above section of the Mart release notes. (Create the Mart Database and Perform the Additional Tasks). Please refer to this section of the release notes for your appropriate version of erwin Mart.
Here is a link to this section for the 2020 R1 version: