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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...