Open cmd as administrator.
And the following command.
# sqlplus / as sysdba
Like in below screen it’s now connected.

Follow the below steps.
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP RESTRICT
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SQL>ALTER DATABASE CHARACTER SET AL32UTF8;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ;
Now , its set on UTF8
Click to rate this post!
[Total: 0 Average: 0]