本文描述了在Ubuntu环境中使用Cloudfoundry集成Oracle时，通过Ruby查询数据库遇到ORA-00029错误的情况。分析表明尝试杀死的会话可能为后台进程，而非用户会话，并提供了在操作系统级别终止此类后台会话的方法。
1、问题描述
ubuntu环境下，cloudfoundry集成oracle，使用ruby查询数据库时，出现如上错误
2、原因分析
You are trying to kill a session with the alter system command and you did specify a correct sid and serial number.
The session however is not a user session, but probably will be a background session:
3、解决办法
If you really have a need to kill a background session – which is strongly discouraged – you need to kill the process on operating system level.
原帖链接 http://www.dbmotive.com/ora-00029-session-is-not-a-user-session/
扫一扫
1179
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
