Sql plus doesn't show English

oracle oracle11g sqlplus ora-12560
palAlaa picture palAlaa · Nov 16, 2011 · Viewed 7k times · Source

SQL plus doesn't show English as shown here

sql plus

and it also returns error for system user name and password, even the user name and password are correct! The error is ORA-12560:TNS:protocol adapter error, what should I dخ??

Answer

drnk picture drnk · Nov 24, 2011

This problem occurs when console codepage mismatch Oracle client NLS_LANG parameter.

NLS_LANG parameter you can set changing Windows-registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG or defines environment variable NLS_LANG.

Example of setting parameter for console session:

set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Codepage of console you can set execute this:

chcp 850

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More
PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More