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
How Big a Table Can Be
Maximum Size Limit of a Table According to Oracle Logical Database Limits, tables can have at most 1000 columns and no limit on rows and… Read More »How Big a Table Can Be
How Big a Database Can Be
Maximum Size Limit of a Database After knowing how big a data file can be and how big a tablespace can be in previous posts,… Read More »How Big a Database Can Be
How Big a Tablespace Can Be
Maximum Size Limit of a Tablespace Basically, at least one data file should be specified in the tablespace creation, thereafter we can add more data… Read More »How Big a Tablespace Can Be