ORA-00029: session is not a user session

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/