Home » Archive

Articles tagged with: error

Oracle Error Codes »

[13 Jul 2009 | No Comment | 110 views]

ORACLE ERROR CODE ORA-00042
ERROR
Unknown Service name string
CAUSE
An attempt was made to use an invalid application service
ACTION
Use a valid service name from SERVICE$ or add a new service using the DBMS_SERVICE package

Oracle Error Codes »

[13 Jul 2009 | No Comment | 102 views]

ORACLE ERROR CODE ORA-00041
ERROR
active time limit exceeded – session terminated
CAUSE
The Resource Manager SWITCH_TIME limit was exceeded
ACTION
Reduce the complexity of the update or query, or contact your database administrator for more information

Oracle Error Codes »

[13 Jul 2009 | No Comment | 69 views]

ORACLE ERROR CODE ORA-00040
ERROR
active time limit exceeded – call aborted
CAUSE
The Resource Manager SWITCH_TIME limit was exceeded
ACTION
Reduce the complexity of the update or query, or contact your database administrator for more information

Oracle Error Codes »

[4 May 2009 | No Comment | 259 views]

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 »

[4 May 2009 | No Comment | 296 views]

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 »

[4 May 2009 | No Comment | 432 views]

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 »

[4 May 2009 | No Comment | 288 views]

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 »

[4 May 2009 | No Comment | 226 views]

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 »

[4 May 2009 | No Comment | 236 views]

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 »

[4 May 2009 | No Comment | 275 views]

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)