How to Used Bangla (Unicode) In Oracle Database.

1. go to run then open cmd window

2. sqlplus /nolog

3. SQL> conn /as sysdba ( for connecting system user)
  Connected.

4. SQL> SHUTDOWN IMMEDIATE;
 Database closed.
 Database dismounted.
 ORACLE instance shut down.

5. SQL> STARTUP RESTRICT;
     ORACLE instance started.

 Total System Global Area  778387456 bytes
 Fixed Size                  1374808 bytes
 Variable Size             402654632 bytes
 Database Buffers          369098752 bytes
 Redo Buffers                5259264 bytes
 Database mounted.
 Database opened.

6. SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

 System altered.

7. SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

 System altered.

8. SQL> ALTER DATABASE CHARACTER SET AL32UTF8;(or ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;)


Database altered.

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

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             402654632 bytes
Database Buffers          369098752 bytes
Redo Buffers                5259264 bytes
Database mounted.
Database opened.

Now Check Using Bangla Using Toad 10.5 and  Avro Bangla keyboard.