I open a PL / SQL Developer database with a query and do you see cracks in the text fields? How to win? Podugu and found that the encoding should be RUSSIAN_AMERICA.CL8MSWIN1251 . Installed it in client environment variables.

But now when in progress in PL / Sql Developer writes the following:

Database charter set (AL32UTF8) and Client character set (CL8MSWIN1251) are different.

Still poduggl and understood that probably it is necessary to change CHARACTER in parameters. But I am not an admin and honestly do not know how to do it. I also tried to google from the user system:

 ALTER SYSTEM ENABLE RESTRICTED SESSION;

and

 ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE CL8MSWIN1251; ORA-12718: operation requires connection as SYS

I tried to give rights to:

 grant update on sys.nls_database_parameters to system; ORA-01031: insufficient privileges

Tell pzhl:

  1. Am I on the right path?
  2. How to change the construction and that is necessary if you can step by step?
  3. but. SQLplus is also not configured by me if you need it. b. If you need sysdba his password, I also do not know, apparently it should be standard?

0