Oracle VirtualBox is unable to list/filter the USB devices attached to my system. As a result, the guest OS is not able to see any USB device either.
<no devices available>
Run this script and reboot your computer
sudo adduser $USER vboxusers
sudo usermod -aG vboxusers $USER
source : https://superuser.com/questions/956622/no-usb-devices-available-in-virtualbox
SQL> select DECODE( TRANSLATE('12345zzz_not_numberee',' 0123456789',' '), NULL, 'number','contains char')
2 from dual
3 / SQL> select DECODE( TRANSLATE('12345',' 0123456789',' '), NULL, 'number','contains char')
2 from dual
3 /
"number"
https://stackoverflow.com/questions/12549029/sql-error-ora-01722-invalid-number
Create multiple initSID.ora
inithsodbc.ora
HS_FDS_CONNECT_INFO = hsodbc
HS_FDS_TRACE_LEVEL = 0
initz.ora
HS_FDS_CONNECT_INFO = z
HS_FDS_TRACE_LEVEL = 0
(SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = hsodbc)
)
(SID_DESC =
(SID_NAME = z)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = hsodbc)
)
HSODBC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = hsodbc))
(HS = OK)
)
z =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = z))
(HS = OK)
)
CREATE DATABASE LINK hsodbc USING 'hsodbc';
CREATE DATABASE LINK z USING 'z';
source : https://knowledgebase.progress.com/articles/Article/6177
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter sga_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 20G
sga_target big integer 20G
unified_audit_sga_queue_size integer 1048576
alter system set sga_max_size=800M scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 2929936 bytes
Variable Size 390073072 bytes
Database Buffers 440401920 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL> alter system set sga_target=800M scope=both;
done
source : https://dbsguru.com/step-by-step-how-to-increase-sga-size-in-oracle/
https://dba.stackexchange.com/questions/121553/increase-sga-max-size-on-oracle-10g-windows
Check the Usage of SGA
select round(used.bytes /1024/1024 ,2) used_mb
, round(free.bytes /1024/1024 ,2) free_mb
, round(tot.bytes /1024/1024 ,2) total_mb
from (select sum(bytes) bytes
from v$sgastat
where name != 'free memory') used
, (select sum(bytes) bytes
from v$sgastat
where name = 'free memory') free
, (select sum(bytes) bytes
from v$sgastat) tot ;
USED_MB FREE_MB TOTAL_MB
---------- ---------- ----------
799.69 736.3 1536
Find the Total Size of SGA
SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga;
TOTAL SGA (MB)
--------------
1535.99715
Check size of different pool in SGA
Select POOL, Round(bytes/1024/1024,0) Free_Memory_In_MB From V$sgastat Where Name Like '%free memory%';
POOL FREE_MEMORY_IN_MB
-------------- -----------------
shared pool 564
large pool 108
java pool 32
streams pool 32
It clearly states that you need to install the virtualbox-dkms packages. You can follow these steps to solve the problem.
Install the virtualbox-dkms
sudo apt-get install virtualbox-dkms
Once you install those packages you also need to do the reconfiguration:
sudo dpkg-reconfigure virtualbox-dkms
sudo dpkg-reconfigure virtualbox
If your problem is still not fixed try installing the headers:
sudo apt-get install linux-headers-generic