Oracle 10g r2 application server configuration in linux

0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

* First make a user like oracle and create a group

(ex: groupadd dba, useradd –G dba oracle;)

* Then create a directory

(ex: mkdir /hisapps)

* Make sure that this directory have the those group permission

(ex: chown –R oracle:dba /hisapps/; chmod ………..)

*Edit .bash_profile of oracle directory

ex:

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/OraHome_1

JAVA_HOME=$ORACLE_HOME/jdk

ORACLE_SID=ORCL

LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$PATH:$ORACLE_HOME/bin

ORACLE_TERM=vt220

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH ORACLE_TERM JAVA_HOME

TMPDIR=/usr/tmp

TEMP=/usr/tmp

REPORTS_PATH=$REPORTS_PATH:$ORACLE_HOME/guicommon/tk/admin/TTF

export REPORTS_PATH

#DISPLAY=192.168.10.7:0.0

#export DISPLAY

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

export TMPDIR TEMP

####################################

echo "profile upadted

####################"

* Also check /etc/sysctl.conf and add parameter as required

Ex:

*run a script from /etc/init.d/ias

#! /bin/sh

#

# Author : Arun Singh, Novell Inc.

#

# 1. Add root to dba and oinstall group to function this script properly

#

# 2. Create this file in /etc/init.d directory (ias) and use "chkconfig ias on"

# You can put these and other commands in a single file (startup or shutdown)

# and use as single command. This example is to make instruction clear.

# $ORACLE_HOME/dcm/bin/dcmctl startup

# $ORACLE_HOME/opmn/bin/opmnctl start

# $ORACLE_HOME/bin/emctl start iasconsole

#

### BEGIN INIT INFO

# Provides: ias

# Required-Start: $network $syslog $remote_fs raw

# Required-Stop:

# Default-Start: 3 5

# Default-Stop: 0 1 2 6

# Description: Start the Oracle iAS

### END INIT INFO

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/OraHome_1

ORA_OWNER=oracle

case "$1" in

start)

echo -n "Satring Oracle iAS"

su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl start" &

su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl startall" &

su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl start iasconsole" &

;;

stop)

echo -n "Stopping Oracle iAS"

su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl shutdown" &

su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl stopall" &

su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl stop iasconsole" &

;;

status)

echo -n "Checking for Oracle iAS"

su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl status iasconsole" &

;;

*)

echo "Usage: $0 {start|stop|status}"

exit 1

esac

* now install the application server. If this file is .cpio ext

then we execute the following command

cpio – idmv

* and need to change some basic change like

vi /etc/oratab

Y

Vi /etc/rc.local

Sh /etc/init.d/ias start

* After installation we need to configure the application server

/forms/server/formweb.cfg

Change rerquied as like attached file

[Apps]

form=/hisapps/LOGON.fmx usesdi=yes

userid=username/password@SID

width=100%

height=100%

colorscheme=teal

pageTitle=APPS:: DEVELOPED BY shumon khan

imagebase=codebase

archive=frmall.jar

WebUtilArchive=frmwebutil.jar,jacob.jar

baseHTMLJInitiator=webutiljpi.htm

lookAndFeel=Oracle

splashscreen=ati_splash.gif

logo=asd.jpg

separateFrame=true

*And copy here the following three file webutiljini.htm webutiljpi.htm webutilbase.htm s

*then change orahome_1/forms/java here add all jar which we are use.

*And hisapps\orahome_1\forms\java\oracle\forms\registry then open the registry.dat file and change the following

Ex: app.ui.lovButtons=true

• Add the following file in orahome_1/forms/

Namely are webutil.cfg, webutil.plx,

• make a folder form those directory and deploy all those form the folder.
• Finally configure tns using netca

Then network admin e tnsname.ora write

Apps =

(description =

(address_list =

(address = (protocol = tcp)

(host = 192.168.xx.xx) (Port = 1521)

(connect_data = )

(service_name = orcl)

)

)

Finally run the application from the below URL from any browser:

http://192.168.xx.xx:7778/froms/frmservlet?config=apps