Get Information About Your BIOS without reboot or opening chassis

# dmidecode --type  9 (Change number as per your requirement)

Use above command to get all details.

Full details pls follow this link

DMIDECODE

libvirtError: internal error Cannot find suitable emulator

Virtualization Technology option not available in BIOS for vt-x CPU  IBM x346

"There is the possibility that even if the BIOS is fully updated, the option may not appear even if the CPU supports VT. I ran into that problem with IBM x346 servers. The processors supported VT, but IBM, in their infinite wisdom, never released a BIOS update that would allow you to enable it."

Link to follow for full details

db_link not working proplery. global_name Problem.

SELECT * FROM GLOBAL_NAME:

To db_link work properly add same global name in two databases.

Query to update.

SQL>alter database rename global_name to "TESTDB";


 

Killing Oracle Sessions

Refer below mentioned link.

Killing oracle sessions

SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';

ALTER SYSTEM KILL SESSION 'sid,serial#';

kill -9 spid

ps -ef | grep ora