Oracle 10g Application Server Release (10.1.2 & 9.0.4.0)

tukwilagleefulInternet and Web Development

Oct 31, 2013 (3 years and 9 months ago)

113 views

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



1


Oracle Consulting


Public Authority of
Agriculture & Fish
Resources, Kuwait

Oracle 10g Application
Server Release (10.1.2 &
9.0.4.0)


I
NSTALLATION
R
EPORT



Author:

Oracle Consulting

Date Created:

June 14, 2005

Last Updated:

October 31, 2013

Version:

1.1









tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



2


Oracle Consulting

Document Control


Change Record









Date

Author

Version

Change Reference





14
-
June
-
2005

Oracle Consulting

Draft1A

No previous document

15
-
June
-
2005

Oracle Consulting

1.0

PAAFR_10gAS_Setup_Draft1A.doc, final
changes incorporated

15
-
June
-
2005

Oracle Consulting

1.1

PAAFR_10gAS_Setup_V1.0, IP and Hostnames
have been corrected.




Reviewers


Name

Company



Suresh Iyer

PAAFR, Kuwait

Saumen Gangopadhyay

PAAFR, Kuwait











Distribution


Copy
No.

Name

Location




1




2








tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



3


Oracle Consulting

Contents

Document Control

................................
................................
................................
..............................

2

Reviewers

................................
................................
................................
................................
.......

2

Introduction

................................
................................
................................
................................
..........

4

Purpose

................................
................................
................................
................................
............

4

Background

................................
................................
................................
................................
....

4

Overview of the 10g AS 10.1.2 and 9.0.4 Installation & Deployment
Architecture

................................
................................
................................
................................
..........

5

Architecture Details
................................
................................
................................
..................

5

Other Setup Detail
s

................................
................................
................................
..................

7

Access Details

................................
................................
................................
................................
.....

9

Portal Access

................................
................................
................................
...............................

9

Identity Management Access

................................
................................
.............................

9

BI Applications Access
................................
................................
................................
............

9

Enterprise Manager Access for Application Server

................................
................

9

Enterprise Manager Access for Database
................................
................................
..

10

Miscellaneous

................................
................................
................................
................................
.....

11

Starting / Stopping services

................................
................................
.............................

11

Log file Monitoring

................................
................................
................................
...................

15

Reference Documents

................................
................................
................................
...........

15

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



4


Oracle Consulting

Introduction


Purpose

The document is the result of Setup and Installatio
n of Oracle 10g Application
Server 10.1.2 and Business Intelligence 9.0.4.0 done at the Public Authority
of Agriculture & Fish Resources, Kuwait.


Background

PAAFR is the government of Kuwait having various activities related to
agriculture, fish, animal r
esources and maintenance of gardens under it.
Systems developed in Oracle 9iDS (Forms 9i, Reports 9i and JDeveloper 9i)
are expected to be deployed on Oracle Application Server 10g on Red Hat
Linux Advanced Servers.


PAAFR is planning to implement the Orac
le Application Server 10g on Red Hat
Linux Enterprise Linux AS 3.0. It will be used for the PAAFR portal, to deploy
Oracle 9i Forms and Reports, Oracle 9i Discoverer and JSP applications.


tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



5


Oracle Consulting

Overview of the 10g AS 10.1.2 and 9.0.4 Installation &
Deployment A
rchitecture


The Oracle Application Server installation has been performed on a 3 Box architechture. On the
BI Server, we’ve installed BI 10.1.2 and BI 9.0.4 in separate Oracle Homes. The setup has been
depicted as given below:






Architecture Details




Middle Tier (10g AS Server)


Hardware Specifications



System Model: HP Proliant DL 380



Processor Type: Intel ® Xeon ™



Number of Processors: 2 (Working as 4)



Processor Clock Speed: 3.2 GHz



Memory Size (Physical): 4 GB



Hard Disk: 6 x 72.8 GB


tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



6


Oracle Consulting


Network Specif
ications



Host Name: portal.paaf.gov.kw (www.paaf.gov.kw)



IP Address: 192.168.0.248


Virtual Memory



Paging Space: 5119 MB

Software Specifications



Operating System:

Linux version 2.4.21
-
27.Elsmp



Oracle 10g Application Server 10.1.2



Oracle Home = /oracle/10
gAS/Portal




Identity Management (Infrastructure) Server


Hardware Specifications



System Model: HP Proliant DL 380



Processor Type: Intel ® Xeon




Number of Processors: 2 (Working as 4)



Processor Clock Speed: 3.2 GHz



Memory Size (Physical): 4 GB



Hard Disk: 6 x 72.8 GB



Network Specifications



Host Name: infra.paaf.gov.kw (login.paaf.gov.kw)



IP Address: 192.168.0.244


Virtual Memory



Paging Space:
5119 MB

Software Specifications



Operating System:

Linux version 2.4.21
-
27.Elsmp



Oracle 10g Application Server 10.1.2



Oracle Home = /oracle/10gAS/Infra




BI Server


Hardware Specifications



System Model: HP Proliant DL 380



Processor Type: Intel ® Xeon ™



Numb
er of Processors: 2 (Working as 4)



Processor Clock Speed: 3.2 GHz



Memory Size (Physical): 4 GB



Hard Disk: 6 x 72.8 GB



Network Specifications



Host Name: forms.paaf.gov.kw (www.paaf.gov.kw)



IP Address: 192.168.0.243


Virtual Memory



Paging Space: 5119 MB

Software Specifications



Operating System:

Linux version 2.4.21
-
27.Elsmp



Oracle 10g Application Server 10.1.2.0 and 9.0.4.0



Oracle Homes



Discoverer 10.1.2 = /oracle/10gAS/BI



Forms & Reports 9.0.4 = /oracle/10gAS/BI_904


tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



7


Oracle Consulting


Other Setup Details

Webcache Servic
es have been shutdown disabled on the BI Server for both
the Installations using Enterprise Manager.

New additions have been done in the Webcache Server of the Middle Tier
server to access the BI Servers as shown below:

New sites have been created to Acces
s BI components like Discoverer,
Forms & Reports.


The new sites have been mapped to their respective Origin servers as shown
below:

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



8


Oracle Consulting



Host file entries (/etc/hosts)

Current the hosts files have the following entries on all the servers. Once
the developm
ent environment is shifted to the new environment, the DNS
servers can be updated with the new server (IPs) entries.

127.0.0.1

localhost.localdomain

localhost

192.168.0.248

www.paaf.gov.kw

portal.paaf.gov.kw

portal

1
92.168.0.244

login.paaf.gov.kw

infra.paaf.gov.kw

infra

192.168.0.243

forms.paaf.gov.kw

forms





tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



9


Oracle Consulting

Access Details


Portal Access

URL =
http://www.paaf.gov.kw/pls/portal

Username = portal

Password = welcome1


Identity Management Access

URL =
http://login.paaf.gov.kw/oiddas

(Directory Access Management)

URL =
http://login.paaf.gov.kw/pls/orasso

(Single Sign On
Server)

Username = orcladmin

Password = welcome1


BI Applications Access

Discoverer 10.1.2

URL =
http://www.paaf.gov.kw:7777/discoverer/plus

URL =
http://www.paaf.gov.kw:7777/discoverer/viewer

Forms & Reports 9.0.4

URL =
http://www.paaf.gov.kw:7779/forms90/f90servlet

(Forms)

URL =
http://www.paaf.gov.kw:7779/repdemo/index.html

(Reports)


Enterprise Manager Access for Application Server

URL =
http://www.paaf.gov.kw:1810

(Middle Tier Server)

URL =
http://login.paaf.gov.kw:1810

(Infrastructure Server)

URL =
http://forms.paaf.gov.kw:1810

(BI 10.1.2 Server)

URL =
http://forms.paaf.go
v.kw:1811

(BI 9.0.4 Server)

Username = ias_admin

Password = welcome1

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



10


Oracle Consulting


Enterprise Manager Access for Database

URL =
http://login.paaf.gov.kw:5500/em

Username = sys

Password = welcome1

Select “SYSDBA” from
Drop Down list.


WebCache Manager Access


URL =
http://www.paaf.gov.kw:4000/webcacheadmin

Username = administrator

Password = welcome1

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



11


Oracle Consulting

Miscellaneous


Starting / Stopping services

Always start only
those services, which are required, and shutdown the services,
which are not required. Check all the oc4j you have created along with the default
ones like DEMOS and HOME and stop if you are not using them.

This will help in speeding up the necessary proce
sses. Startup and Shutdown scripts
are as given below. Please shutdown all Middle Tier Services before shutting down the
Infrastructure and Infrastructure should be started first before starting up of any of
the Middle Tier services.

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

#!/bin/bash

#

# Filename : startinfra.sh

#

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


rm
-
f /tmp/startinfra.log

echo "Executing startinfra.sh Start time = `date` " > /tmp/startinfr
a.log

chmod 777 /tmp/startinfra.log


#################### Setting up the Environment ###############


export ORACLE_SID=imdb

export ORACLE_HOME=/oracle/10gAS/Infra

export TMP=/tmp

export TMPDIR=/tmp

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE
_HOME/opmn/bin:$PATH

export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib


#################### Starting IMDB Database ###############


echo "Starting IMDB Database ......`date`" >>

/tmp/startinfra.log

echo "Starting IMDB Database ......`date`"

sqlplus "/ as sysdba" <<eof

startup;

exit;

eof

echo "Started IMDB Database ......`date`" >> /tmp/startinfra.log

echo "Started IMDB Database ......`date`"


#################### Starting IMDB Li
stener ###############


echo "Starting IMDB Listener ......`date`" >> /tmp/startinfra.log

echo "Starting IMDB Listener ......`date`"

lsnrctl start

echo "Started IMDB Listener ......`date`" >> /tmp/startinfra.log

echo "Started IMDB Listener ......`date`"



##################### Starting All EM Services ###############


echo "Starting All services....`date`" >> /tmp/startinfra.log

opmnctl start

opmnctl startall

opmnctl status

emctl start iasconsole

emctl start dbconsole

echo "Started All EM services....`date`
" >> /tmp/startinfra.log

echo "Started All EM services...."

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



12


Oracle Consulting

echo "Ending startinfra script End time = `date`" >> /tmp/startinfra.log


exit 0


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

#!/bin/bash

#

# Filename : startportal.sh

#
PLEASE RUN THIS SCRIPT AS ORACLE USER!!!!!

#

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


rm
-
f /tmp/startportal.log

echo "Executing startportal.sh Start time = `date` " > /tmp/startportal.log

chmod 777 /tmp/startportal.log


#####
############### Setting up the Environment ###############


export ORACLE_HOME=/oracle/10gAS/Portal

export TMP=/tmp

export TMPDIR=/tmp

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$PATH


##################### Starting Portal Serv
ices ###############


echo "Starting Portal & Wireless Services.....`date`" >> /tmp/startportal.log

echo "Starting Portal & Wireless Services.....`date`"

opmnctl start

opmnctl startall

opmnctl status

emctl start iasconsole

echo "Started Portal & Wireless S
ervices.....`date`" >> /tmp/startportal.log

echo "Started Portal & Wireless Services.....`date`"


echo "Ending startportal script End time = `date`" >> /tmp/startportal.log


exit 0



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

#!/b
in/bash

#

# Filename : startbi.sh

# PLEASE RUN THIS SCRIPT AS ORACLE USER!!!!!

#

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


rm
-
f /tmp/startbi.log

echo "Executing startbi.sh Start time = `date` " > /tmp/startbi.log

chmod 777 /tm
p/startbi.log


##################### Setting Environment for BI 10.1.2 ###############


export ORACLE_HOME=/oracle/10gAS/BI

export TMP=/tmp

export TMPDIR=/tmp

export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$OR
ACLE_HOME/imeeting/bin:$PATH


##################### Starting BI 10.1.2 Services ###############


echo "Starting BI 10.1.2 Services.....`date`" >> /tmp/startbi.log

echo "Starting BI 10.1.2 Services.....`date`"

opmnctl start

opmnctl startall

opmnctl status

e
mctl start iasconsole

echo "Started BI 10.1.2 Services.....`date`" >> /tmp/startbi.log

echo "Started BI 10.1.2 Services.....`date`"

unset ORACLE_HOME


tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



13


Oracle Consulting

##################### Setting Environment for BI 9.0.4 ###############


export ORACLE_HOME=/oracle/10gAS/
BI_904

export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$OR
ACLE_HOME/imeeting/bin:$PATH


##################### Starting BI 9.0.4 Services ###############


echo "Starting BI 9.0.4 Services.....`date`" >> /tmp/sta
rtbi.log

echo "Starting BI 9.0.4 Services.....`date`"

opmnctl start

opmnctl startall

opmnctl status

emctl start iasconsole

echo "Started BI 9.0.4 Services.....`date`" >> /tmp/startbi.log

echo "Started BI 9.0.4 Services.....`date`"


echo "Ending startbi scr
ipt End time = `date`" >> /tmp/startbi.log


exit 0


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

#!/bin/bash

#

# Filename : stopbi.sh

# PLEASE RUN THIS SCRIPT AS ORACLE USER!!!

#

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


rm
-
f /tmp/stopbi.log

echo "Executing stopbi.sh Start time = `date` " > /tmp/stopbi.log

chmod 777 /tmp/stopbi.log


##################### Stopping BI 10.1.2 Services ###############


export ORACLE_HOME=/oracle/10gAS/BI

export TMP=/tmp

exp
ort TMPDIR=/tmp

export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$PA
TH


##################### Stopping BI 10.1.2 Services ###############


echo "Stopping BI 10.1.2 Services.....`date`" >> /tmp/stopbi.log

echo "S
topping BI 10.1.2 Services.....`date`"

opmnctl shutdown

emctl stop iasconsole

echo "Stopped BI 10.1.2 Services.....`date`" >> /tmp/stopbi.log

echo "Stopped BI 10.1.2 Services.....`date`"

unset ORACLE_HOME


##################### Stopping BI 9.0.4 Services
###############


export ORACLE_HOME=/oracle/10gAS/BI_904

export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$PA
TH


##################### Stopping BI 9.0.4 Services ###############


echo "Stopping BI 9.0.4 Services
.....`date`" >> /tmp/stopbi.log

echo "Stopping BI 9.0.4 Services.....`date`"

opmnctl shutdown

emctl stop iasconsole

echo "Stopped BI 9.0.4 Services.....`date`" >> /tmp/stopbi.log

echo "Stopped BI 9.0.4 Services.....`date`"


echo "Ending stopbi script End
time = `date`" >> /tmp/stopbi.log


exit 0

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



14


Oracle Consulting


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

#!/bin/bash

#

# Filename : stopportal.sh

# PLEASE RUN THIS SCRIPT AS ORACLE USER!!!

#

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


rm
-
f /tmp/stopportal.log

echo "Executing stopportal.sh Start time = `date` " > /tmp/stopportal.log

chmod 777 /tmp/stopportal.log


#################### Setting up the Environment ###############


export ORACLE_HOME=/oracle/10gAS/Portal

export

TMP=/tmp

export TMPDIR=/tmp

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$PATH


##################### Stopping Portal Services ###############


echo "Stopping Portal & Wireless Services.....`date`" >> /tmp/stopportal.log

echo "S
topping Portal & Wireless Services.....`date`"

opmnctl shutdown

emctl stop iasconsole

echo "Stopped Portal & Wireless Services.....`date`" >> /tmp/stopportal.log

echo "Stopped Portal & Wireless Services.....`date`"


echo "Ending stopportal script End time

= `date`" >> /tmp/stopportal.log


exit 0


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

#!/bin/bash

#

# Filename : stopinfra.sh

# PLEASE RUN THIS SCRIPT AS ROOT USER ONLY!!!

#

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


rm
-
f /tmp/stopinfra.log

echo "Executing stopinfra.sh Start time = `date` " > /tmp/stopinfra.log

chmod 777 /tmp/stopinfra.log


#################### Setting up the Environment ###############


export ORACLE_SID=imdb

export ORACLE_HOME=/oracl
e/10gAS/Infra

export TMP=/tmp

export TMPDIR=/tmp

export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$PA
TH

export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_P
ATH=$ORACLE_HOME/lib


##################### Stopping All Services ###############


echo "Stopping All EM services....`date`" >> /tmp/stopinfra.log

opmnctl shutdown

emctl stop iasconsole

emctl stop dbconsole

echo "Stopped All EM services....`date`" >> /tmp/
stopinfra.log

echo "Stopped All EM services...."


##################### Stopping IMDB & Listener #####################


echo "Stopping IMDB Listener ......`date`" >> /tmp/stopinfra.log

echo "Stopping IMDB Listener ......`date`"

lsnrctl stop

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



15


Oracle Consulting

echo "Stopped I
MDB Listener ......`date`" >> /tmp/stopinfra.log

echo "Stopped IMDB Listener ......"

echo "Stopping IMDB Database ......`date`" >> /tmp/stopinfra.log

echo "Stopping IMDB Database ......`date`"

sqlplus "/ as sysdba" <<eof

shutdown immediate;

exit;

eof

echo
"Stopped IMDB Database ......`date`" >> /tmp/stopinfra.log

echo "Stopped IMDB Database ......`date`"


echo "Ending stopinfra script End time = `date`" >> /tmp/stopinfra.log


exit 0





Log file Monitoring


Component

Log files

HTTP Server (OHS)

$ORACLE_HOM
E/Apache/Apache/logs

OPMN

$ORACLE_HOME/opmn/logs/*

OC4J

$ORACLE_HOME/j2ee/home/log/log.xml

$ORACLE_HOME/j2ee/<OC4J_instance>/log/*/*

OEM

$ORACLE_HOME/sysman/log/*

WebCache

$ORACLE_HOME/webcache/logs/*

DCM

$ORACLE_HOME/dcm/logs/*




The Error Log is be
en setup to record “Critical” Errors Only



The HTTP Access log has been disabled



Webcache logs can be used for performance monitoring etc. Please use Webcache
Administration to view the logs.


Reference Documents

J2EE Best practices:


http://www.oracle.com/technology/products/ias/pdf/Oracle9iAS
-
J2EE
-
BP.pdf


http://www.theserverside.
com/articles/content/TMCBestPractices/J2EE_BP.zip


Forms & Reports Development:

Forms Architecture
http://www.oracle.com/technology/products/forms/pdf/forms9iarchi
tecture.pdf

Oracle Forms and J2EE: A Business Case for Application Development
http://www.oracle.com/technology/products/forms/pdf/formsj2ee_business.pdf

tukwilagleeful_6d864e77
-
e564
-
4223
-
87f9
-
4592521ce68b.doc

_________________________________________________________________________________________________________

___________________________________________________________________________________________________________
___________



16


Oracle Consulting

Best Prac
tices
http://www.oracle.com/technology/products/forms/pdf/bestpractices9i.pdf

http://www.odtug.com/2000
_handouts_developer.htm

Integration Oracle9iAS Reports Services in Oracle9iAS Forms Services
http://www.oracle.com/technology/products/forms/pdf/frm9isrw9i.pdf

Implementin
g Single Sign
-
On for Forms
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_
id=NOT&p_id=199072.1


You can f
ind more information at the following
http://www.oracle.com/technology/products/forms/techlisting9i.html

Reports and Single
-
Sign
-
On
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=222332.1

Online Help and Howto’s for Oracle Reports
http://otn.oracle.com/reports/help/

Discovere
r best pratices:



http://www.oracle.com/technology/products/discoverer/pdf/DiscoBestPractices_10g_9
04.pdf


http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=266818.1


http://www.rittman.net/archives/000709.html

More information on Discoverer can be fou
nd here
http://www.oracle.com/technology/products/discoverer/index.html