Thursday, May 14, 2015

Forms And Reports 6i Crash When Connection with 11g XE Database !!!

As salamualikum (islamic greetings), brothers and sisters. :)

 Hope you are fine.. 

Not very useful for everybody but it's a solution if you need.

If you try to connect Oracle form & Reports 6i with Oracle Database 11g XE (Express Edition), every time, it will crash and you will not able to connect. 

But it will not happen with 11gR2 Enterprise or any other Edition.

>>?? Why this happen ?

Because, Database 11g XE use,

SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET%';

PARAMETER                                                        VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                             
---------------------------------------------------------------- ----------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                  
NLS_CHARACTERSET                                                 AL32UTF8                                                                                                                                                                                                                                                                                                                                                                                                                                          
NLS_NCHAR_CHARACTERSET                                           AL16UTF16                                                                                                                                                                                                                                                                                                                                                                                                                                         
 

you  need to set the database character set as UTF8.

To do so you need to follow the bellow steps..

1. connect as sysdba using SYSTEM not SYS.

Run the following command sequencially.

SQL>CONN SYSTEM/MANAGER AS SYSDBA

2. Shutdown the database if running:
SQL>SHUTDOWN IMMEDIATE

3. Start the database in restrict mode:
SQL>STARTUP RESTRICT

4. Change the databse charcter set to UTF8 as follows:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

5. Shutdown the database:
SQL>SHUTDOWN IMMEDIATE

6. At last, start the database in normal mode:
SQL>STARTUP

After successfull of these steps, you can connect to the Oracle XE database through Forms 6i or Oracle Reports 6i


 Comments to share your thoughts..


End for the day....


Praise to Almighty Allah(swt).  :)


Fi amanillah

3 comments:

  1. Very useful... Thank you for share your knowledge

    ReplyDelete
  2. My thought is : How do i buy you a beer my good man ?

    ReplyDelete
  3. Dude! Thank you so much!

    ReplyDelete