Home > IT Answers > Oracle > Connect Oracle 10g Express with Oracle Forms 6i
12000
5 pts.
 Connect Oracle 10g Express with Oracle Forms 6i
Oracle 10g, Oracle 10g connectivity, Oracle 10g Express, Oracle Forms, Oracle Forms 6i
How to make connection with oracle 10g EX with Oracle froms 6i?

Software/Hardware used:
ASKED: February 5, 2011  8:29 AM
UPDATED: May 5, 2011  11:31 AM
RELATED QUESTIONS
Answer Wiki:
Just define a connection entry to your database in your Forms' installation tnsnames.ora file.
Last Wiki Answer Submitted:  February 7, 2011  2:23 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Connect with sys user of xe database.

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

Entry in tnsnames.ora of orant directory.

Webtechsolutions
 55 pts.