1. Global Data Services Concepts and Administration
  2. ORA-01045: user GSMADMIN\_INTERNAL lacks CREATE SESSION privilege; logon denied

ORA-01045: user GSMADMIN_INTERNAL lacks CREATE SESSION privilege; logon denied

Do not unlock or grant privileges to GSMADMIN_INTERNAL. Instead, trace failed logons to misconfigured GDS credentials or scripts.

No direct modifications should be made on the Global Data Services schema objects unless directed by Oracle Technical Support.

Why does this error occur? The user GSMADMIN_INTERNAL is an internal-only user for controlled operations. It should never be unlocked or used for any database login. It is intentionally restricted (including lacking CREATE SESSION), so it cannot be used as a general login.

Seeing ORA-01045 typically means a component is attempting a direct DB login using GSMADMIN_INTERNAL, which usually indicates:

  • Misconfiguration (wrong username stored somewhere).
  • Someone attempted to connect manually with that username.
  • A script or tool mistakenly references it.
  • There are credentials, wallet or connection string issues that cause fallback to an unintended user.

Parent topic: User and Password Management Issues