Thursday, December 13, 2018

CHANGING THE CHARACTER SET TO AL32UTF8

Open cmd as administrator.

And the following command.

# sqlplus / as sysdba

Like in below screen it's now connected.

clip_image001

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

clip_image002

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

Now , its set on UTF8

No comments:

Post a Comment

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...