Locale

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 […]
Globalization

NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table

Posted on
How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Territory Only
NLS_TERRITORY to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_TERRITORY to their respective NLS_DATE_FORMAT. In some situations, you may need this mapping table to solve globalization problems. For instances, ORA-01861 and ORA-12705. Please note that, NLS_DATE_FORMAT is not derived from NLS_LANGUAGE, in fact, it’s derived from NLS_TERRITORY. Therefore, any conflicts between […]
Globalization

NLS_LANGUAGE to NLS_TERRITORY Mapping Table

Posted on
NLS_LANGUAGE to NLS_TERRITORY Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this mapping table to solve globalization problems. In order to change NLS_TERRITORY, you can change NLS_LANGUAGE by setting the environment variable NLS_LANG at OS-level, database sessions will use the value to […]
Globalization

NLS_LANG, How and Why

Posted on
What is NLS_LANG? What is NLS_LANG? NLS_LANG is an environment variable in the client’s environment, it’s also a notation that can notify database what NLS (National Language Support) parameters should be used for current session. The format of NLS_LANG is such: <LANGUAGE>_<TERRITORY>.<CHARACTERSET> There’re 3 components in the environment variable NLS_LANG: LANGUAGE: It is equivalent to […]
Globalization

ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法

Posted on
ORA-12705では、NLS設定が正しくないことを示しています。データベースに対して何かを実行する前に、まずそれらを修正する必要があります。 この投稿にはORA-12705の2つのエラーパターンがあります。 接続前のORA-12705 接続後のORA-12705 接続前のORA-12705 データベースに接続する前に故意に偽のNLS_LANGを設定しましょう。これは、Oracleが使用するために選択する環境変数です。NLS_LANGの形式については、NLS_LANG方法と理由を確認できます。 [oracle@test ~]$ export NLS_LANG=JAPAN_JAPAN.UTF8 [oracle@test ~]$ echo $NLS_LANG JAPAN_JAPAN.UTF8 データベースに接続しようとしました。 [oracle@test ~]$ sqlplus /nolog … SQL> conn hr/hr ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified SQL> conn / as sysdba ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified SQL> exit エラーORA-12705は、両方の接続がデータベースによって拒否されたことを示しています。 どうして? […]
Patching

How to Apply Patch in Oracle Database

Posted on
Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement, especially for production environments. Although I’ll talk about the steps that we apply patch, you should read readme.txt in patch files before taking any actions. Pre-Patching 1. Get the Latest OPatch Before any patching, you […]