Connecting Oracle Forms 6i to Oracle XE 10G

June 23rd, 2007 by Rajender Singh · 16 Comments

Today I faced the problem of Oracle Forms 6i failing to connect to Oracle XE 10g on my colleague’s laptop.

I faced this problem before also but never thought of jotting it down.

Now I though it will be good idea and helpful to many of my colleagues and friends in Oracle community, if I do so!

Here is what I did to connect Oracle Forms 6i to Oracle XE 10g.

To make Oracle Forms 6i able to connect to Oracle XE 10g I set the database character set to UTF8.

Steps to do are as follows:

First I shutdown the database:

SQLPLUS>shutdown immediate

Then I start the database in restrict mode:

SQLPLUS>startup restrict

Then I change the databse charcter set as follows:

SQLPLUS>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

Then I shutdown the database:
SQLPLUS>shutdown immediate

Then I start the database in normal mode:
SQLPLUS>startup

After this my colleague was able to connect to the Oracle XE database through Forms 6i.

Hide

Tags: Oracle Database · Oracle Forms · Oracle Installation

16 responses so far ↓

1 Dusan Skenderovic // Dec 31, 2007 at 4:22 am

Great,
You save me a lot of time ))
Thanks, it works.
2 Muhammad Faizan // Mar 21, 2008 at 5:31 am

this post is ever helpful when ever i installed forms 6i with oracle DB XE!
thnx for info
i have also a blog dedicated to oracle product
navigate http://techfresh.info
3 Lenin Rivera // Apr 28, 2008 at 7:19 pm

Excelente, muchas gracias por la explicaciÃ³n. Tenia ya un tiempo tratando conectarme sin lograr nada. Muchas pero muchas personas te deben una.
4 naveen wason // Jul 3, 2008 at 12:00 pm

It’s a very usefull information for me. because one day i have tried to connect database 10g xe with forms 6i but it was not connected. then i thought it will not connect to form 6i or its not supported by oracle. but with this information i have also connect my database 10g xe with form 6i.

Thanks
5 naveen wason // Jul 3, 2008 at 12:05 pm

WHY WE CHANGE
CHARACTER SET INTERNAL_USE UTF8;

WHAT IS USE OF CHARACTER SET
6 panagiotis zarafidis // Aug 1, 2008 at 10:02 pm

Thanks, quick and clean solution. You saved me a lot of time.
7 Rami // Aug 2, 2008 at 7:50 pm

what a good idea. thanks very much for your experience.
8 naesse // Aug 6, 2008 at 1:23 am

Thanx for this tip.. Saved me a lot of time
9 Rajender Singh // Aug 8, 2008 at 9:25 am

Thanks Guys for all your appreciations and comments!
10 Osciel // Aug 21, 2008 at 9:08 am

It works!.

Thank you very much Rajender.

It was really helpfull.
11 Sivakumar // Sep 22, 2008 at 10:23 pm

very useful info….i searched for this info on various sites…atlast arrived at your site…keep sharing the knowledge.
12 vamsi // Sep 23, 2008 at 1:26 am

hi
i’ve tried to do so but it says insufficient privileges, i’ve tried to login as admin it says the same thing.
please help me.

u can contact me with my mail id
13 Rajender Singh // Sep 23, 2008 at 11:14 am

Hi Vamsi,

Check out the connect privileges of your users.

Thanks
14 thanks a lot,but I cannot run my reports it just hangs (Reports 6i) .... any suggestions // Sep 25, 2008 at 6:19 pm

How to run reports 6i in oracle 10g XE
15 william ng // Sep 29, 2008 at 1:40 pm

I encounter this connection problem also when i port my application database to XE, the encrypted password stored in the database was wrongly decrypted after the database imported to the new system. after i use the alter ALTER DATABASE CHARACTER SET INTERNAL USE WE8ISO8859P1; then it works!

However, i face another problem of after upgrade from 6.0.5 to 6i release 2 (with patchset 18 p4888294), the properties inside the detail blocks was unable to update when the details information was generated from the header block , caused the form trigger FRM-40222 validation error.

Any suggestion?
16 Piotrek // Oct 22, 2008 at 5:32 am

Great job, thank you Rajender. It helped me very much.