Scribd
Upload
28 views1 page

Skill Matrix

The document outlines the prerequisites and configurations needed to set up an Oracle application server with a database schema named 'emp'. It includes steps for installing necessary software, running scripts, and modifying configuration files for the application to function correctly. Specific instructions are provided for setting up the working directory, environment variables, and database connection strings.

Uploaded by

miand.mamdouh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
28 views1 page

Skill Matrix

The document outlines the prerequisites and configurations needed to set up an Oracle application server with a database schema named 'emp'. It includes steps for installing necessary software, running scripts, and modifying configuration files for the application to function correctly. Specific instructions are provided for setting up the working directory, environment variables, and database connection strings.

Uploaded by

miand.mamdouh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Prerequisites

1- Install oracle application server 10g (Forms, Reports, service only)


2- Install oracle database and create a new schema named emp
3- Run the scripts of the tables and views
4- Create folder in the D:\skillmatrix

Configurations
1- Add the following code into “Oracle_Home\forms\server\formsweb.cfg”

[skillmatrix]

workingDirectory=D:\ skillmatrix

envFile=default.env

form = D:\ skillmatrix\main_form.fmx

colorScheme=blaf

#userid=emp/[email protected]:1521/xe

2- In the file “Oracle_home\forms\server\default.env”

Change the value of the FORMS_PATH

FORMS_PATH= D:\ skillmatrix

3- Add the connection string for the created database In the file “Oracle_Home\NETWORK\ADMIN\ tnsnames”

For example

empex =

(DESCRIPTION =

(ADDRESS_LIST =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = xe) ) )

You might also like