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 CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...