خطـــوات سهلـــة لإنشــاء مشـــروع جديـــد Oracle Developer Project Tasks: Configure Forms 10g On Oracle 11g

Configure Forms 10g On Oracle 11g

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

Despite the new Oracle technologies, i noticed that Oracle forms 10G still the favorite version for a large sector of companies around the Arabic and far east World. Besides the CS students are still looking forward to install and learn as a training.

Oracle forms 10G is NOT compatible with Microsoft Windows 8.1 Operating System. So we had made some workarounds. Once it is successfully installed then, it is time to configure. The next step you should look forward is configuring Oracle Forms…

Why do we need to configure Oracle Forms 10G ?

The answer is simple; we configure it to run it successfully on the browser.

Task Definition:

Configure Oracle forms 10G

The significant importance of configuring Oracle Forms guarantees a successful running on browser.

Let's try to run Oracle forms without configuration you will face the following forms errors…

Open Oracle form builder and press run button

Oracle Forms asks you the following question

Press yes and input your connection strings

You will step into a sequenced error messages you have to solve as follow:

Task Problem no.1

The first configuration problem is the connection between Oracle database and Oracle forms is missing so Oracle forms generates the following error message
Ora-12154 tns could not resolve service name.

Task Solution no.1:

between If this is your first time you are trying to establish a database connection forms then you have two possible solutionsOracle Data base 11G and Oracle

1.copy the content of the tnsnames.ora file located on the Oracle home <oracle_home>/network/admin/tnsnames.ora

into the tnsnames.ora file located on Oracle Developer Suite path

DevSuiteHome_1 /network/admin/tnsnames.ora

2. you can do it manually create a new entry in the following path

C:\DevSuiteHome_1/NETWORK/ADMIN/ tnsnames.ora file.


ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = AMATU_ALLAH)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ORCL)

    )

  )

If this is NOT your first time you are trying to establish a database connection
between Oracle database 11G and Oracle forms then you have to start the service
over and over until it is successfully started.

Press the Run button once again you will get the following error

Task Problem no.2

Task Solution no.2

Create a new canvas with any data block or even a simple text or button for testing purposes.

Press the Run button once again you will get the following error

Task Problem no.3

Task Solution no.3

Set in Edit-->preferences-runtime - reset default browser

http://Amatu-Allah:8889/forms/frmservlet

The port number must match that found in your portlist.ini file as follow.

You have to specify the browser location where Oracle form display its contents.

Once again try press Oracle Forms Run button, you will face the next error message:

Task Problem no.4

Task Solution no.4:

You must run the OC4J (Oracle Containers for Java/ J2EE) provides an execution environment for J2EE applications.

Windows users have to use the scripts located in the DevSuiteHome\j2ee\DevSuite directory:

o startinst.bat

o stopinst.bat

All our concern in this point is to learn how to start and stop Oracle Developer Suite OC4J instances for Oracle Forms for testing purpose and to create a desktop short-cut for its frequent need as long as you need to run Oracle forms builder.
Please follow the steps:

· Create a Start Oc4j Short Cut file on desk top.

The Oc4j start up file is located at the following path:

C:\DevSuiteHome_1\j2ee\DevSuite\startinst.bat