oracle12-nlssettings

Connect:

dba@solasoa:~$ export ORACLE_SID=orcl
dba@solasoa:~$ export SID=orcl
dba@solasoa:~$ export ORACLE_HOME=/oracle/dba/app/dba/product/12.1.0/dbhome_1
dba@solasoa:~$ cd $ORACLE_HOME 
dba@solasoa:~/app/dba/product/12.1.0/dbhome_1$ ./bin/sqlplus sys as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu May 31 16:36:02 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

SQL>

Check:

SQL> column VALUE format a10
SQL> column PARAMETER format a30
SQL> select * from v$nls_parameters;

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
NLS_LANGUAGE               AMERICAN        0
NLS_TERRITORY               AMERICA           0
NLS_CURRENCY               $           0
NLS_ISO_CURRENCY           AMERICA           0
NLS_NUMERIC_CHARACTERS           .,           0
NLS_CALENDAR               GREGORIAN       0
NLS_DATE_FORMAT            DD-MON-RR       0
NLS_DATE_LANGUAGE           AMERICAN        0
NLS_CHARACTERSET           AL32UTF8        0
NLS_SORT               BINARY           0
NLS_TIME_FORMAT            HH.MI.SSXF       0

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
                   F AM

NLS_TIMESTAMP_FORMAT           DD-MON-RR       0
                   HH.MI.SSXF
                   F AM

NLS_TIME_TZ_FORMAT           HH.MI.SSXF       0
                   F AM TZR

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR       0
                   HH.MI.SSXF

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
                   F AM TZR

NLS_DUAL_CURRENCY           $           0
NLS_NCHAR_CHARACTERSET           AL16UTF16       0
NLS_COMP               BINARY           0
NLS_LENGTH_SEMANTICS           BYTE           0
NLS_NCHAR_CONV_EXCP           FALSE           0SQL> column VALUE format a10
SQL> column PARAMETER format a30
SQL> select * from v$nls_parameters;

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
NLS_LANGUAGE               AMERICAN        0
NLS_TERRITORY               AMERICA           0
NLS_CURRENCY               $           0
NLS_ISO_CURRENCY           AMERICA           0
NLS_NUMERIC_CHARACTERS           .,           0
NLS_CALENDAR               GREGORIAN       0
NLS_DATE_FORMAT            DD-MON-RR       0
NLS_DATE_LANGUAGE           AMERICAN        0
NLS_CHARACTERSET           AL32UTF8        0
NLS_SORT               BINARY           0
NLS_TIME_FORMAT            HH.MI.SSXF       0

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
                   F AM

NLS_TIMESTAMP_FORMAT           DD-MON-RR       0
                   HH.MI.SSXF
                   F AM

NLS_TIME_TZ_FORMAT           HH.MI.SSXF       0
                   F AM TZR

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR       0
                   HH.MI.SSXF

PARAMETER               VALUE          CON_ID
------------------------------ ---------- ----------
                   F AM TZR

NLS_DUAL_CURRENCY           $           0
NLS_NCHAR_CHARACTERSET           AL16UTF16       0
NLS_COMP               BINARY           0
NLS_LENGTH_SEMANTICS           BYTE           0
NLS_NCHAR_CONV_EXCP           FALSE           0

19 rows selected.

SQL> 

19 rows selected.

SQL>

Bajamos y subimos:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1627389952 bytes
Fixed Size            3004232 bytes
Variable Size          520095928 bytes
Database Buffers     1090519040 bytes
Redo Buffers           13770752 bytes
Database mounted.
SQL>

Ajustamos los settings:

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> update sys.props$ set value$='AL32UTF8' where name='NLS_CHARACTERSET';

1 row updated.

SQL> commit;

Commit complete.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Startup and apply:

SQL> startup mount
ORACLE instance started.

Total System Global Area 1627389952 bytes
Fixed Size            3004232 bytes
Variable Size          520095928 bytes
Database Buffers     1090519040 bytes
Redo Buffers           13770752 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set AL32UTF8;

Database altered.

SQL> alter system set job_queue_processes=1000;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>

Restart and check:

SQL> startup mount
ORACLE instance started.

Total System Global Area 1627389952 bytes
Fixed Size            3004232 bytes
Variable Size          520095928 bytes
Database Buffers     1090519040 bytes
Redo Buffers           13770752 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set AL32UTF8;

Database altered.

SQL> alter system set job_queue_processes=1000;

System altered.

SQL>