How to change NLS_CHARACTERSET to AL32UTF8

Below are steps:

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP RESTRICT;
ORACLE instance started.

Total System Global Area 6.0663E+10 bytes
Fixed Size                  2268032 bytes
Variable Size            5637145728 bytes
Database Buffers         5.4895E+10 bytes
Redo Buffers              128344064 bytes
Database mounted.
Database opened.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

Database altered.

ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ERP_DB/spfileerp.ora_1522172043297' ORA-17503: ksfdopn:10 Failed to open file +ERP_DB/spfileerp.ora_1522172043297 ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux-x86_64 Error: 13: Permission denied Additional information: 6761 Additional information: 60391427

Issue Type:

SQL> startup mount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ERP_DB/spfileerp.ora_1522172043297'
ORA-17503: ksfdopn:10 Failed to open file +ERP_DB/spfileerp.ora_1522172043297
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6761
Additional information: 60391427

Solution:
***********


To place your database in archivelog mode, perform the following steps:

  1. Check listener status.
  2. Check oracle utility permission for both users grid & oracle.
  3. Change permission of oracle utility for both users grid & oracle.
  4. Startup your database.

[grid@myserver]$ cd $GRID_HOME/bin
[grid@myserver]$ chmod 6751 oracle

[oracle@myserver]$ cd $ORACLE_HOME/bin
[oracle@myserver]$ chmod 6751 oracle