How to Resolve ORA-12899: value too large for column

Posted on
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 see how I found ORA-12899 when I migrated some tables from one database (UTF8) to another (AL32UTF8). SQL> INSERT INTO “ERPAPP”.”FIN_NORTH_HIST”@ORA12C SELECT * FROM “ERPAPP”.”FIN_NORTH_HIST”; INSERT INTO “ERPAPP”.”FIN_NORTH_HIST”@ORA12C SELECT * […]
Startup and Shutdown

How to Resolve “Connected to an idle instance” on Windows

Posted on
Connected to an idle instance Let’s check oracle database services on Windows server. It appeared that all oracle services are running on this Windows server. Let’s try to connect to the database locally: C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release Production on Wed Oct 30 00:55:22 2019 Copyright (c) 1982, 2016, Oracle.  All rights reserved. […]

What Makes Instance Shutdown Itself

Posted on
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. What factors to make instance decide to run away from current situation? Was it trying to protect itself from further damage? In my cases, those causes seem to point to […]

How to Open Port on Windows Server

Posted on
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 refer to : How to Open Ports and Survives from Reboots Use ⊞ Win + F to search for “Windows Firewall with Advanced Security”, then click it. In “Inbound Rules”, […]

How to Fix Garbled Filename and Text

Posted on
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 list a file which name is made by a multi-byte language like this. [root@test ~]# ll total 8 -rw-r–r–  1 root root  217 Oct 17 00:39 ▒?▒▒?▒▒?▒.txt … This is […]
Shell Script

How to Cat a File Content by iNode

Posted on
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 -rw-r–r–   1 root root  174 Oct 17 17:31 402653313 dr-xr-x—.  3 root root 4096 Oct 17 17:36 .       128 dr-xr-xr-x. 18 root root 4096 Oct 17 17:27 […]