Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00030: User session ID does not exist

420827Oct 14 2008 — edited Oct 14 2008
Hi all,

I runned import in my local database server and after few minutes of runing i want to stop this import, to do that i killed the process running the command and after killed the session on oracle database.
But when i check my database usage, the import session is still active till now, i check in v$session view sid and serial and allinofs for this session are still present. But when i'm trying to kill the session it gives error ORA-00030: User session ID does not exist.
Does anybody can help me how to kill this session or how to remove this session in my session list and active session.
Here bellow the thing i did:

SYS @ abdb1>select serial#||' * '||program from v$session where sid=365;

SERIAL#||'*'||PROGRAM
-------------------------------------------------------------------------------------------
21462 * imp@ab-db1 (TNS V1-V3)

SYS @ abdb1>alter system kill session '365,21462' immediate;
alter system kill session '365,21462'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.

Thanks
Raitsarevo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2008
Added on Oct 14 2008
6 comments
9,032 views