I am trying this below way but it gives error
SHUTDOWN IMMEDIATE;
CONNECT system/password AS SYSDBA
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE SET NLS_DUAL_CURRENCY='Kr.';
ALTER DATABASE SET NLS_TIMESTAMP_TZ_FORMAT='DD.MM.RRRR HH24.MI.SSXFF TZR';
ALTER DATABASE SET NLS_TIME_TZ_FORMAT='HH24.MI.SSXFF TZR';
ALTER DATABASE SET NLS_TIMESTAMP_FORMAT='DD.MM.RRRR HH24.MI.SSXFF';
ALTER DATABASE SET NLS_TIME_FORMAT='HH24.MI.SSXFF';
ALTER DATABASE SET NLS_DATE_FORMAT='DD.MM.RRRR';
ALTER DATABASE SET NLS_NUMERIC_CHARACTERS=', ';
ALTER DATABASE SET NLS_ISO_CURRENCY='NORWAY';
ALTER DATABASE SET NLS_CURRENCY='kr';
ALTER DATABASE SET NLS_TERRITORY='NORWAY';
SHUTDOWN IMMEDIATE;
STARTUP;
Getting error
SQL> ALTER DATABASE CHARACTER SET NLS_DUAL_CURRENCY='Kr.';
ALTER DATABASE CHARACTER SET NLS_DUAL_CURRENCY='Kr.'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
and if i tried this below way then only session altered but not set nls_parameter at Database level
SHUTDOWN IMMEDIATE;
CONNECT system/password AS SYSDBA
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER SESSION SET NLS_DUAL_CURRENCY='Kr.';
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='DD.MM.RRRR HH24.MI.SSXFF TZR';
ALTER SESSION SET NLS_TIME_TZ_FORMAT='HH24.MI.SSXFF TZR';
ALTER SESSION SET NLS_TIMESTAMP_FORMAT='DD.MM.RRRR HH24.MI.SSXFF';
ALTER SESSION SET NLS_TIME_FORMAT='HH24.MI.SSXFF';
ALTER SESSION SET NLS_DATE_FORMAT='DD.MM.RRRR';
ALTER SESSION SET NLS_NUMERIC_CHARACTERS=', ';
ALTER SESSION SET NLS_ISO_CURRENCY='NORWAY';
ALTER SESSION SET NLS_CURRENCY='kr';
ALTER SESSION SET NLS_TERRITORY='NORWAY';
SHUTDOWN IMMEDIATE;
STARTUP;
Could you please help me to fix this issue as i need to set these parameters on Database level