Installation of Oracle XE

http://www.davidghedini.com/pg/entry/install_oracle_11g_xe_on

Change MiWIFI back to a normal WIFI LAN CARD

XIAOMI is selling a USB WIFI Adapter in RMB9.9

http://www.xiaomi.com/miniwifi

But it is designed to make your PC to a WIFI router instead of a pure WIFI adapter.

I figured a way to change it back to a normal WIFI Adapter by just installing its driver without using bundled software.

Please download from here.

https://docs.google.com/uc?authuser=0&id=0B8gWj5_Gu6ZudU1FOFp5NzhHdTQ&export=download

Huge Oracle Trace + Alert Log

SQL> show parameter max_dump_file_size

SQL> alter system set max_dump_file_size='1024m' scope=both;

UTF8 issue after upgrading MySQL to 5.5

In MySQL 5.5.X it introduce utf8mb4 and lead to old table might have coding issue.

<my.cnf>

[client]
default_character_set = utf8mb4

[mysql]
default-character-set=utf8mb4
skip-character-set-client-handshake

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
init-connect = 'SET NAMES utf8mb4'
skip-character-set-client-handshake


----------
Convert your table / column collation

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4

ALTER DATABASE  `databasename` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci