Share |

ORA-00026: missing or invalid session ID

You are trying to kill a user session with the alter system command, but the given session id and/or serial number is incorrect: 
SQL> alter system kill session '0, 0';
alter system kill session '0, 0'
*
ERROR at line 1:
ORA-00026: missing or invalid session ID
Query the v$session view to get an idea of all sessions in the database instance: 
SQL> select sid, serial#, process,  type from v$session;

       SID    SERIAL# PROCESS                  TYPE
---------- ---------- ------------------------ ----------
         1          1 1308                     BACKGROUND
         2          1 4660                     BACKGROUND
         3          1 5344                     BACKGROUND
         4          1 2976                     BACKGROUND
         5          1 5724                     BACKGROUND
         6          1 3568                     BACKGROUND
         7          1 4532                     BACKGROUND
         8          1 4992                     BACKGROUND
        10          1 3480                     BACKGROUND
        13          2 2432                     BACKGROUND
        15          2 4604                     BACKGROUND
       126          1 656                      BACKGROUND
       127          1 5444                     BACKGROUND
       128          1 4292                     BACKGROUND
       129          1 1436                     BACKGROUND
       130          1 4248                     BACKGROUND
       131          1 3056                     BACKGROUND
       132          1 5372                     BACKGROUND
       135         18 3584                     BACKGROUND
       136         73 3920                     BACKGROUND
       137        220 6124:3196                USER
       138          1 5756                     BACKGROUND
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-00026 Add your own message



At the moment there are no forum messages. You can add your own question.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: ap82whexm4pnvakjg


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.