Hi. i got here:
win 7 ultimate 64 bits (english); chcp 850; java 7 32 bits (english); oracle 11g r201.
My chcp is 850 by default but i set chcp to 1252 on prompt when i start sqlplus!!
Installed, using administrator account unblocked on win 7, oracle 11g.
Set on enviroment variables this:
NLS_LANG = PORTUGUESE_BRAZIL.WE8MSWIN1252
Path = D:\app\Jamn\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\NVIDIA corporation\PhysX\Common;%SystemRoot%\ system32;%SystemRoot%;%SystemRoot%\ System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
ORACLE_HOME = D:\app\Jamn\product\11.2.0\dbhome_1
ORACLE_SID=ORCL
Besides that, i got this on regedit:
NLS_LANG (same) ; ORACLE_HOME (same); ORACLE_SID (same); and ORACLE_BASE = d:\app\administrator and bunch others that come with register.
My data is correct. If i issue -- select * from tb_cidades -- All the data is Ok.
if i go SELECT * FROM NLS_DATABASE_PARAMETERS; i got
PARAMETER VALUE
------------------------------ ----------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.1.0
but i override this with
SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
------------------------------ --------------------------
NLS_LANGUAGE PORTUGUESE
NLS_TERRITORY BRAZIL
NLS_CURRENCY R$
NLS_ISO_CURRENCY BRAZIL
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE PORTUGUESE
NLS_SORT WEST_EUROPEAN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY Cr$
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
the problem is when i issue some command and got syntax error like
ALTER SYSTEM SET;
alter system set
*
ERROR at line 1:
ORA-00922: opþÒo invßlida ou ausente
SQL>
Notice: first line in english, but after in portuguese and not correct, without accentuation.
I ve tried setting oracle_sid; oracle_home, path env. variables (beside registry and env. variables) by issuing on the prompt b4 sqlplus, but no joy.
can some1, pls, pls help??
TY advance