Problem in connection oracle lower version client with oracle database

Tags:
Oracle
Oracle Database
Problem in connection oracle lower version client with oracle database.

Software/Hardware used:
Oracle
ASKED: August 21, 2009  3:31 AM
UPDATED: April 15, 2010  5:57 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JohnPGI
    Hi, I did all steps, but when I tried to connect the forms closed.
    10 pointsBadges:
    report
  • carlosdl
    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.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following