上海涛德顾问学院

查看: 5110|回复: 0

[OCP] ORACLE错误代码超级大全下载

[复制链接]

88

主题

0

好友

451

积分

管理员

Rank: 9Rank: 9Rank: 9

发表于 2014-4-29 12:00:22 |显示全部楼层
内容预览:
ORA-00000: normal, successful completion
原因: Normal exit.
解决: None.
ORA-00001: unique constraint(string.string) violated
原因: An UPDATEor INSERT statement attempted to insert a duplicate key. For Trusted Oracleconfigured in DBMS MAC mode, you may see this message if a duplicate entryexists at a different level.
解决: Eitherremove the unique restriction or do not insert the key.
ORA-00017: session requested to set traceevent
原因: Thecurrent session was requested to set a trace event by another session.
解决: This isused internally; no action is required.
ORA-00018: maximum number of sessionsexceeded
原因: Allsession state objects are in use.
解决: Increasethe value of the SESSIONS initialization parameter.
ORA-00019: maximum number of sessionlicenses exceeded
原因: Alllicenses are in use.
解决: Increasethe value of the LICENSE MAX SESSIONS initialization parameter.
ORA-00020: maximum number of processes(string) exceeded
原因: Allprocess state objects are in use.
解决: Increasethe value of the PROCESSES initialization parameter.
ORA-00021: session attached to some otherprocess; cannot switch session
原因: The usersession is currently used by others.
解决: Do notswitch to a session attached to some other process.
ORA-00022: invalid session ID; accessdenied
原因: Either thesession specified does not exist or the caller does not have the privilege toaccess it.
解决: Specify avalid session ID that you have privilege to access, that is either you own itor you have the CHANGE_USER privilege.
ORA-00023: session references processprivate memory; cannot detach session
原因: An attemptwas made to detach the current session when it contains references to processprivate memory.
解决: A sessionmay contain references to process memory (PGA) if it has an open networkconnection, a very large context area, or operating system privileges. To allowthe detach, it may be necessary to close the session"s database linksand/or cursors. Detaching a session with operating system privileges is alwaysdisallowed.
ORA-00024: logins from more than oneprocess not allowed in single-process mode
原因: Trying tologin more than once from different processes for ORACLE started insingle-process mode.
解决: Logofffrom the other process.
ORA-00025: failed to allocate string
原因: Out ofmemory.
解决: Restartwith larger sga heap.
ORA-00026: missing or invalid session ID
原因: Missing orinvalid session ID string for ALTER SYSTEM KILL SESSION.
解决: Retry witha valid session ID.
ORA-00027: cannot kill current session
原因: Attemptedto use ALTER SYSTEM KILL SESSION to kill the current session.
解决: None.
ORA-00028: your session has been killed
原因: Aprivileged user has killed your session and you are no longer logged on to thedatabase.
解决: Loginagain if you wish to continue working.
ORA-00029: session is not a user session
原因: Thesession ID specified in an ALTER SYSTEM KILL SESSION command was not a usersession (for example, recursive, etc.).
解决: Retry witha user session ID.
ORA-00030: User session ID does not exist.
原因: The usersession ID no longer exists, probably because the session was logged out.
解决: Use avalid session ID.
ORA-00031: session marked for kill
原因: Thesession specified in an ALTER SYSTEM KILL SESSION command cannot be killedimmediately (because it is rolling back or blocked on a network operation), butit has been marked for kill. This means it will be killed as soon as possibleafter its current uninterruptable operation is done.
解决: No actionis required for the session to be killed, but further executions of the ALTERSYSTEM KILL SESSION command on this session may cause the session to be killedsooner.
ORA-00032: invalid session migrationpassword
原因: Thesession migration password specified in a session creation call was invalid(probably too long).
解决: Retry witha valid password (less than 30 chars).
ORA-00033: current session has emptymigration password
原因: An attemptwas made to detach or clone the current session and it has an empty migrationpassword. This is not allowed.
解决: Create thesession with a non-empty migration password.
ORA-00034: cannot string in current PL/SQLsession
原因: An attemptwas made to issue a commit or rollback from a PL/SQL object (procedure,function, package) in a session that has this disabled (by "alter sessiondisable commit in procedure")
解决: Enablecommits from PL/SQL in this session, or do not attempt to use commit orrollback in PL/SQL when they are disabled in the current session.
ORA-00036: maximum number of recursive SQLlevels (string) exceeded
原因: An attemptwas made to go more than the specified number of recursive SQL levels.
解决: Remove therecursive SQL, possibly a recursive trigger.
ORA-00037: cannot switch to a sessionbelonging to a different server group
原因: An attemptwas made to switch to a session in a different server group. This is notallowed.
解决: Make surethe server switches to a session that belongs to its server group.
ORA-00038: Cannot create session: servergroup belongs to another user
原因: An attemptwas made to create a non-migratable session in a server group that is owned bya different user.
解决: A servergroup is owned by the first user who logs into a server in the server group innon-migratable mode. All subsequent non-migratable mode logins must be made bythe user who owns the server group. To have a different user login innon-migratable mode, the ownership of the server group will have to be changed.This can be done by logging off all current sessions and detaching from allexisting servers in the server group and then having the new user login tobecome the new owner.
ORA-00040: active time limit exceeded - callaborted
原因: TheResource Manager SWITCH_TIME limit was exceeded.
解决: Reduce thecomplexity of the update or query, or contact your database administrator formore information.

......


oracle错误代码超级大全ORA-00000_to_ORA-40322.rar

767.32 KB, 下载次数: 5237

oracle错误代码超级大全ORA-00000_to_ORA-40322

涛德顾问学院
Oracle OCM 11g认证培训Oracle 12c OCP 全国独家推出
大数据,BI商业智能,数据库,ADF,中间件,EBS,ODI,ETL全产业链培训服务提供商
回复

使用道具 举报

上海涛德顾问学院 ( 沪ICP备14006824号 )  

GMT+8, 2018-12-15 01:48 , Processed in 0.219592 second(s), 28 queries , Gzip On.

Top Data World

回顶部