Oracle Error ORA-00038: Cannot create session: server group belongs to another user

Oracle Error Message

ORA-00038: Cannot create session: server group belongs to another user

Reason for the Error

A non-migrable session was attempted to be created in a server group that belongs to a separate user.

Solution

The first user to log into a server in the server group in non-migrable mode is the owner of the server group.

The user who controls the server group must log in every time you want to use non-migrable mode going forward.

The ownership of the server group must be altered in non-migrable mode in order to allow for a different user login.

This can be accomplished by terminating all active sessions, disconnecting from all currently running servers in the server group, and then logging in the new user to take over as owner.