Powered By Blogger

Tuesday, March 22, 2011

Changing between ALOM and ILOM

ALOM -> ILOM
sc> userclimode admin default
sc> logout

ILOM -> ALOM
-> set /SP/users/admin cli_mode=alom
-> exit

Wednesday, March 2, 2011

Killing session in oracle

Finding session:

SQL> select SID,serial# from v$session where username='TESTER'

and Killing it


SQL> ALTER SYSTEM KILL SESSION '2090,4043'IMMEDIATE;
Welcome to the UNIX world