How to Change Oracle’s NLS (National Language Support)

This article explains how to change the Oracle National Language Support (NLS) settings.

sqlplus " / as sysdba "

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

ALTER DATABASE OPEN;

ALTER SYSTEM CHARACTER SET TR8MSWIN1254;

SHUTDOWN IMMEDIATE;

STARTUP;

sqlplus " / as sysdba "

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

ALTER DATABASE OPEN;

ALTER SYSTEM CHARACTER SET TR8MSWIN1254;

SHUTDOWN IMMEDIATE;

STARTUP;