Solved

Database sessions ORA-00026 missing or invalid session id

  • 21 April 2021
  • 1 reply
  • 4641 views
R
Rank
Userlevel 7
Badge +18

In Database Sessions we have a long running session related to Business Reporter scheduled report that we wish to kill.

The session id in Database Sessions is 642:

 

 

However, on RMB > Kill Session we receive the following error:

 

I cannot see the session in Monitor Sessions in SQL Developer but can see the session when doing select from v$session :

 

select * from v$session where sid = '642'  ;

Using the SID and SERIAL#  I tried to kill the session:

ALTER SYSTEM KILL SESSION '642,12109'

I receive the following error:


Error report -
ORA-00026: missing or invalid session ID
00026. 00000 -  "missing or invalid session ID"
*Cause:    Missing or invalid session ID string for the current operation.
*Action:   Retry with a valid session ID.

Obviously, can see the session in FND_SESSION_RUNTIME

 

How can I kill this session when it isn’t reported in Monitor Sessions and any attempt to kill the session report in the missing or invalid session id?
 

icon

Best answer by RutJWhalen 21 April 2021, 12:51

View original
This topic has been closed for comments

1 reply

R
Rank
Userlevel 7
Badge +18

Logged onto the Database server and through SQLPLUS ran the same command and it worked:

 

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> conn / as sysdba;
Connected.
SQL> alter system kill session '642,12109'

 

Once PMON kicked in the session was removed from v$session.

Terms & ConditionsCookie settings