Scribd
Upload
4 views1 page

Oracle Application Server Setup Guide

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
4 views1 page

Oracle Application Server Setup Guide

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\[Link]”

[skillmatrix]

workingDirectory=D:\ skillmatrix

envFile=[Link]

form = D:\ skillmatrix\main_form.fmx

colorScheme=blaf

#userid=emp/emp@[Link]:1521/xe

2- In the file “Oracle_home\forms\server\[Link]”

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 = [Link])(PORT = 1521)) )

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = xe) ) )

You might also like