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

Creating Domain Failed while Configuring Oracle Forms Instance 11gR2

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

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

You are planning to install Oracle Forms 11gR2 ( 11.1.2.2.0). :)

And you done all pre-requition task  before installing Oracle Forms 11gR2

Installation going on all the way fine but stuck at the point of configuration like bellow image

and said Domain creation failed.

??? What's the wrong I've done ? Don't worry, go to the log file indicated by the image arrow location and open it.
Go to the end and scrolling up.

If you see something like

XXX: adding task: oracle.as.install.classic.ca.standard.DomainProvisioningTask
  AdminServer port is 7001
  trying to connect to WIN-EJ826NJ1OBP 7001
  Creating Weblogic Domain.
oracle.as.provisioning.exception.ASProvWorkflowException
    at oracle.as.provisioning.weblogic.ASDomain._createDomain(ASDomain.java:2633)


WIN-EJ826NJ1OBP indicate Operating System Name

THEN it's the certainly issue of 
Oracle WebLogic NodeManager  service is started and you NEED to stop them to continue your setup.

Ok. Open Services (Windows)
Search for the named services and stop it.

Now Click on the Check box of First image and click RETRY

Wow... Configuration going on and Completed. Now start the NodeManager.

All the praises to Almighty Allah (swt)

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

How cat Learn to Hunting Rat ?

Just a little Fun.
With my Cat's Family. "Tiger" & "Fighter" (little one)

Hope get some fun.

Off topic :)