Tecnomatix Ora-00942: table or view does not exist on initDB.bat

2023-07-13T10:52:56Z
eM-Server

Summary


Details

Error shown after running initDB.bat right after this line:

GRAN SELECT ON v_$session to EMP_ADMIN

"Ora-00942: table or view does not exist"

Setup:

Windows Server: 2019

Oracle DB: Oracle Database Enterprise Edition 19.0.0.0 - Production Version 19.3.0.0

Tecnomatix: 2206

Platforms
  • na windows-1064
Release Versions
  • Tecnomatix V2206
Solution

It failed due to permissions, run the command instead with this user:

Enter user-name: sys as sysdba

Enter password: Note: Just running the failed command is enough:

GRANT SELECT ON V_$SESSION to EMP_ADMIN;

Notes

KB Article ID# PL8720945

Contents

SummaryDetails

Associated Components

eMS Setup