How to Migrate Data from 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate Data from 9i to 12c via DB Link
How to Resolve ORA-12899: value too large for column
ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. Let's… Read More »How to Resolve ORA-12899: value too large for column
How to Resolve "Connected to an idle instance"
Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you enter… Read More »How to Resolve "Connected to an idle instance"
What Makes Instance Shutdown Itself
What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »What Makes Instance Shutdown Itself
How to Resolve ORA-00059: maximum number of DB_FILES exceeded
ORA-00059 Found ORA-00059 when creating a new tablespace, it told us that the maximum number of data files (DB_FILES) had been reached and was likely… Read More »How to Resolve ORA-00059: maximum number of DB_FILES exceeded
What Can We See in a Normal Data File
You might think that the content of a normal data file should be unrecognized binary text and we cannot really see it except using special… Read More »What Can We See in a Normal Data File
How to Open Port on Windows Server
After our Oracle database 12.2 has been created on Windows server, we should open port 1521 on firewall for incoming connections. For Linux, you can… Read More »How to Open Port on Windows Server
How to Install Oracle Database 12.2 on Windows Server
The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »How to Install Oracle Database 12.2 on Windows Server
How to Fix Garbled Filename and Text
There're several ways to display your garbled filename correctly. LANG Environment Variable PuTTY Character Set Rename Badly Encoded Filename A. LANG Environment Variable Tried to… Read More »How to Fix Garbled Filename and Text
How to Cat a File Content by iNode
Symptoms At times, we may see some garbled filenames or even worse, empty or white-spaced names like this: [root@test ~]# ls -lai total 48 402653349… Read More »How to Cat a File Content by iNode