Problem in connection oracle lower version client with oracle database
Problem in connection oracle lower version client with oracle database.
Software/Hardware used:
Oracle
Software/Hardware used:
Oracle
ASKED:
August 21, 2009 3:31 AM
UPDATED:
April 15, 2010 5:57 PM
Answer Wiki:
Connecting Oracle Forms 6i to Oracle XE 10G
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 database character 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.
To see all answers submitted to the Answer Wiki: View Answer History.
Hi, I did all steps, but when I tried to connect the forms closed.
Hi JohnPGI.
Are you trying to connect this exact combination of products (Oracle 10g XE and Forms 6i) ?
If not, I would recommend creating a new question, and provide enough details about your versions and the problems you are having, including complete error messages, and the troubleshootings steps you have taken so far.