How to Check 32-bit or 64-bit Oracle Client
32-bit or 64-bit In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool… Read More »How to Check 32-bit or 64-bit Oracle Client
sqlplus
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 entered… Read More »How to Resolve "Connected to an idle instance"
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154 means that your connection tools including sqlplus cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns in… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
How to Resolve ORA-12705: invalid or unknown NLS parameter value specified
ORA-12705 tells you that your NLS settings are not correct, you have to fix them first before doing something to the database. There're 2 error… Read More »How to Resolve ORA-12705: invalid or unknown NLS parameter value specified
ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法
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:… Read More »ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法
Difference between Oracle Client and Oracle Instant Client
Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features… Read More »Difference between Oracle Client and Oracle Instant Client
How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As a… Read More »How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
How to Use Bind Variable in Oracle
Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when executions. That… Read More »How to Use Bind Variable in Oracle
sqlplus, tnsping or lsnrctl Hangs
sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases that can share with you. Those hanging… Read More »sqlplus, tnsping or lsnrctl Hangs
How to Move Tables by SQL Script
I usually move some tables for data reorganization, and I found the procedure is pretty routine:Moving the table.Rebuilding indexes related to this table.Analyzing all segments… Read More »How to Move Tables by SQL Script