我的编程空间,编程开发者的网络收藏夹
学习永远不晚

ora-00030:User session ID does not exists

短信预约 -IT技能 免费直播动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

ora-00030:User session ID does not exists


RAC双节点,其中一个节点突然出现log file sync等待,且就是固定的几个回话,回话一直存在不结束,于是手动删掉:

select 'alter system kill session ''' || sid|| ',' || serial# || ''' immediate;' from gv$session where  event = 'log file sync';

 但是有部分回话提示:ora-00030:User session ID does not exists;  确认会话都在第一个节点上:

ora-00030:User session ID does not exists



而且使用emcc 也是报这个错误:
ora-00030:User session ID does not exists


ora-00030:User session ID does not exists


ora-00030:User session ID does not exists


ora-00030:User session ID does not exists


于是从操作系统层面杀掉回话:

select spid, osuser, s.program
from v$session s, v$process p
where s.paddr = p.addr
and s.sid =2350;


登录超出系统:

kill -9 spid


免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

ora-00030:User session ID does not exists

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

ORA-00030: User session ID does not exist. ORACLE 报错 故障修复 远程处理

文档解释ORA-00030: User session ID does not exist.Cause: The user session ID no longer exists, probably because the session
ORA-00030: User session ID does not exist. ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_

文档解释ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE
ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_
2023-11-05

ORA-00029: session is not a user session ORACLE 报错 故障修复 远程处理

文档解释ORA-00029: session is not a user sessionCause: The session ID specified in an ALTER SYSTEM KILL SESSION command was
ORA-00029: session is not a user session ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-00152: current session does not match requested session ORACLE 报错 故障修复 远程处理

文档解释ORA-00152: current session does not match requested sessionCause: The current session is not the same as the
ORA-00152: current session does not match requested session ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-13754: “SQL Tuning Set” “string” does not exist for user “string&#

文档解释ORA-13754: SQL Tuning Set string does not exist for user string.Cause: The user attempted to access a SQL
ORA-13754: “SQL Tuning Set” “string” does not exist for user “string&#
2023-11-05

ORA-23398: user name “string” at database link “string” does not match local

文档解释ORA-23398: user name string at database link string does not match local user name stringCause: the user name
ORA-23398: user name “string” at database link “string” does not match local
2023-11-05

ORA-41009: Session with session number string, serial number string does not exist ORACLE 报错 故障修复 远程

文档解释ORA-41009: Session with session number string, serial number string does not existCause: An attempt to migrate was
ORA-41009: Session with session number string, serial number string does not exist ORACLE 报错 故障修复 远程
2023-11-05

ORA-00086: user call does not exist ORACLE 报错 故障修复 远程处理

文档解释ORA-00086: user call does not existCause: An invalid attempt was made to dump the user call heap.Action: Wait until
ORA-00086: user call does not exist ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-49412: Package ID does not match existing ID [string] [string] ORACLE 报错 故障修复 远程处理

文档解释ORA-49412: Package ID does not match existing ID [string] [string]Cause: The package ID in package file did not
ORA-49412: Package ID does not match existing ID [string] [string] ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-41006: session id not specified ORACLE 报错 故障修复 远程处理

文档解释ORA-41006: session id not specifiedCause: An attempt to get migration status was made, which failed because the
ORA-41006: session id not specified ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-29303: user does not login as SYS ORACLE 报错 故障修复 远程处理

文档解释ORA-29303: user does not login as SYSCause: The user did not log in as SYS to perform tablespace point-in-time
ORA-29303: user does not login as SYS ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-23653: LogMiner session does not exist ORACLE 报错 故障修复 远程处理

文档解释ORA-23653: LogMiner session does not existCause: LogMiner session did not exist.Action: Make sure the Capture
ORA-23653: LogMiner session does not exist ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-41030: Session id not specified ORACLE 报错 故障修复 远程处理

文档解释ORA-41030: Session id not specifiedCause: An attempt to migrate was made, which failed during migration because the
ORA-41030: Session id not specified ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-29343: user string (mapped from user string) does not exist in the database ORACLE 报错 故障修复 远程处理

文档解释ORA-29343: user string (mapped from user string) does not exist in the databaseCause: The referred user is one of
ORA-29343: user string (mapped from user string) does not exist in the database ORACLE 报错 故障修复 远程处理
2023-11-04

ORA-46061: Session ID not specified ORACLE 报错 故障修复 远程处理

文档解释ORA-46061: Session ID not specifiedCause: Extensible security Session ID was not specified.Action: Execute the
ORA-46061: Session ID not specified ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-41028: Session id not specified ORACLE 报错 故障修复 远程处理

文档解释ORA-41028: Session id not specifiedCause: An attempt to migrate was made, which failed during migration because the
ORA-41028: Session id not specified ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-29393: user string does not exist or is not logged on ORACLE 报错 故障修复 远程处理

文档解释ORA-29393: user string does not exist or is not logged onCause: An invalid user name was specified as argument to
ORA-29393: user string does not exist or is not logged on ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-26930: User “string” does not have privileges to perform this operation ORACLE 报错 故障

文档解释ORA-26930: User string does not have privileges to perform this operationCause: An attempt was made to create,
ORA-26930: User “string” does not have privileges to perform this operation ORACLE 报错 故障
2023-11-05

编程热搜

目录