Articles Archive for May 2009
Oracle Error Codes »
ORACLE ERROR CODE ORA-00038
ERROR
Cannot create session: server group belongs to another user
CAUSE
An attempt was made to create a non-migratable session in a server group that is owned by a different user
ACTION
A server group is owned by the first user who logs into a server in the server group in non-migratable mode. All subsequent non-migratable mode logins must be made by the user who owns the server group. To have a different user login in non-migratable mode, the ownership of the server group will have to be changed. This can be …
Oracle Error Codes »
ORACLE ERROR CODE ORA-00037
ERROR
cannot switch to a session belonging to a different server group
CAUSE
An attempt was made to switch to a session in a different server group. This is not allowed
ACTION
Make sure the server switches to a session that belongs to its server group
Oracle Error Codes »
ORACLE ERROR CODE ORA-00036
ERROR
maximum number of recursive SQL levels (string) exceeded
CAUSE
An attempt was made to go more than the specified number of recursive SQL levels
ACTION
Remove the recursive SQL, possibly a recursive trigger
Oracle Error Codes »
ORACLE ERROR CODE ORA-00035
ERROR
LICENSE_MAX_USERS cannot be less than current number of users
CAUSE
Specified values for LICENSE_MAX_USERS is less than the current number of users
ACTION
Check the license limit and drop extra users or purchase more licenses
Oracle Error Codes »
ORACLE ERROR CODE ORA-00034
ERROR
cannot string in current PL/SQL session
CAUSE
An attempt was made to issue a commit or rollback from a PL/SQL object (procedure, function, package) in a session that has this disabled (by ‘alter session disable commit in procedure’)
ACTION
Enable commits from PL/SQL in this session, or do not attempt to use commit or rollback in PL/SQL when they are disabled in the current session
Oracle Error Codes »
ORACLE ERROR CODE ORA-00033
ERROR
current session has empty migration password
CAUSE
An attempt was made to detach or clone the current session and it has an empty migration password. This is not allowed
ACTION
Create the session with a non-empty migration password
Oracle Error Codes »
ORACLE ERROR CODE ORA-00032
ERROR
invalid session migration password
CAUSE
The session migration password specified in a session creation call was invalid (probably too long)
ACTION
Retry with a valid password (less than 30 chars)
Oracle Error Codes »
ORACLE ERROR CODE ORA-00031
ERROR
session marked for kill
CAUSE
The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterruptable operation is done
ACTION
No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner
Oracle Error Codes »
ORACLE ERROR CODE ORA-00030
ERROR
User session ID does not exist
CAUSE
The user session ID no longer exists, probably because the session was logged out
ACTION
Use a valid session ID
Oracle Error Codes »
ORACLE ERROR CODE ORA-00029
ERROR
session is not a user session
CAUSE
The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user session (for example, recursive, etc.)
ACTION
Retry with a user session ID
