Re: PROBLEM NATIONAL CHARACTER

Posted by Arsalan on Aug 23, 2017; 5:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PROBLEM-NATIONAL-CHARACTER-tp3260p3323.html


Thanks Arsalan,

I am very thankful that you always supported and guide me when ever i have some query or problem.

so i followed the below script which  solved database character problem.


 SHUTDOWN IMMEDIATE;

 STARTUP MOUNT;

 ALTER SYSTEM ENABLE RESTRICTED SESSION;

 ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

 ALTER SYSTEM SET AQ_TM_PROCESSES=0;

ALTER DATABASE OPEN;

ALTER DATABASE CHARACTER SET INTERNAL_USE  AL32UTF8;

SHUTDOWN IMMEDIATE;

STARTUP;