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

ORA-28001: the password has expired or ORA-28002 the password will expire within 7 days (Oracle Database Password Expired)

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

Hope you are well with the grace of Almighty Allah (swt).

Today we talk on issue of Oracle Database password Expired issues show version 11g and on words.

What will you see ? 

Solution:: 

1. Connect to Database with SYS DBA.

For Example

C:\oraclexe\app\oracle\product\11.2.0\server\bin>SQLPLUS/NOLOG

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 23 19:53:42 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> CONN SYS/SYSTEM11g AS SYSDBA

2. Execute the following query
3. Sql > select * from dba_profiles;

You will see something like bellow… (Shortened)

1.  PROFILE              RESOURCE_NAME             RESOURCE LIMIT

2.  -------------------- ------------------------- -------- ---------------

3.  DEFAULT              FAILED_LOGIN_ATTEMPTS     PASSWORD 10

4.  MONITORING_PROFILE   PASSWORD_LIFE_TIME        PASSWORD DEFAULT

5.  DEFAULT              PASSWORD_LIFE_TIME        PASSWORD 180

6.   

7.  PROFILE              RESOURCE_NAME             RESOURCE LIMIT

8.  -------------------- ------------------------- -------- ---------------

9.  MONITORING_PROFILE   PASSWORD_REUSE_TIME       PASSWORD DEFAULT

10.DEFAULT              PASSWORD_REUSE_TIME       PASSWORD UNLIMITED

11. 

12.32 rows selected.

4. Here PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.

5.  Execute following command to disable this feature:
6. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 

7. Now crosscheck for disabling of this feature.
8. Sql > select * from dba_profiles;

9. The value in PASSWORD_LIFE_TIME has changed to unlimited. Now password will never expire.

 You are almost DONE

 Now reset the password of locked user. 
Here are two options to reset password. 
Either you can keep same password or you can give a new password.

One is..

 

 You are Done :)

Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.