Nothing Special   »   [go: up one dir, main page]

As10g Installation Steps

Download as txt, pdf, or txt
Download as txt, pdf, or txt
You are on page 1of 5

############ installing oracle application server 10g 32 bit on windows2008

64bit########

Note Before installing Do change System Name e.g(appsvr) and give a Static IP to
it. e.g. 192.168.5.10

1. set virtual memory size 2 times for drive on which application server is to be
installed e.g. D:

Right Click on My Computer -> Properties -> advance system settings ->
advanced tab ->Performance Settings ->
Virtual Memory Change
Uncheck Automatically manage paging file for all drives
Select required drive e.g D:
Select Custom Size option
Set Initial size = 1024
Maximum Size = 4096

Press OK -> OK -> OK.

2. Unzip as_windows_x86_forms_reports_101202.zip
3. Unzip p5983622_10123_WINNT.zip
4. Set file compatibility mode
a) go to as_windows_x86_forms_reports_101202\install\setup.exe
Right Click on setup.exe -> Select properties -> select compatibility ->
Select Run this program in compatibility mode for
Select Windows XP service pack 3
b) go to p5983622_10123_WINNT\install\setup.exe
Right Click on setup.exe -> Select properties -> select compatibility ->
Select Run this program in compatibility mode for
Select Windows XP service pack 3

5. Create foler in D: drive named "oracle"


6. Right click and run as administrator
as_windows_x86_forms_reports_101202\install\setup.exe
7. On Welcome Screen Click Next
8. On Specify File Lations page
Leave source as default
In Destination change leave Name unchanged
In path enter "D:\oracle\FRHome_1"
Click Next
9. Ignore warning if displays. Click OK
10. On language selection page click Next
11. On Specify Port Configuration Option select Automatic and Click Next
12. On Specify Instance Name and ias_admin Password
Instance Name = <of your choice> e.g. suntexapps
ias_admin Password = <of your choice>
confirm Password = <of your choice>
Click Next
13. On Summary page Click Install
14. On Configuration Assistants Page
if Application Server Control Configuration server gives error Click Ok and
Retry to run this.
15. On End of Installation
Save information a text file.
Click exit and Yes.

16. Inatall patch


Right click and run as administrator p5983622_10123_WINNT\install\setup.exe
On Welcom Screen Click next.

17. On Specify File Locations page


Select Name as FRHome_1
It will automatically select Path , leave it unchanged. Click Next
18. On select a product to install page
Select Oracle Application Server Developer Suite and Click Next
19. On Application Server Instance Password Page
Provide ias_admin password which was given while installing application server
in step 12.
20. On summary page click Install
21. On End of instllation Page Click Exit and Yes.

############## After Installation Configuration ####################


1. Define DB connection
TNSNAMES.ORA database connection
i) go to D:\oracle\FRHome_1\NETWORK\ADMIN and open tnsnames.ora in text
editor as administrator.
ii) add
SUNTEX=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.5.5)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=SUNTEX)
)
)

IMAGE=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.5.6)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=STPRODDB)
)
)

iii) Save file.


2. connect / as sysdba on database server
sql> alter system set sec_case_sensitive_logon=false scope=both;
sql> alter profile DEFAULT limit password_life_time UNLIMITED;
######### Forms configuration Starts #################
1. a) copy webutilbase.htm,webutiljini,webutiljpi,webutil.cfg to
D:\oracle\FRHome_1\forms\server
b) copy webutil.olb,webutil.pll,webutil.plx to D:\oracle\FRHome_1\forms\
c) copy webutil folder to D:\oracle\FRHome_1\forms\
d) copy myicons.jar to D:\oracle\FRHome_1\forms\java\
e) copy frmwebutil.jar to D:\oracle\FRHome_1\forms\java\
f) copy jre-6u45-windows-i586.exe to D:\oracle\FRHome_1\forms\java\
g) copy common folder to D:\data
2. Open d:\oracle\FRHome_1\forms\server\default.env
a) FORMS_PATH should look like
before
FORMS_PATH=D:\oracle\FRHome_1\forms
after

FORMS_PATH=D:\oracle\FRHome_1\forms;D:\data\common;D:\data\forms;D:\data\reports;D:
\data\employees;D:\data\cv;D:\data\style_specs

b)at the end of CLASSPATH


add
;D:\oracle\FRHome_1\forms\java\frmall.jar;D:\oracle\FRHome_1\jdk\jre\lib\rt.jar;

3. Open d:\oracle\FRHome_1\forms\server\formsweb.cfg
a) add after [default]

WebUtilArchive=/forms/java/frmwebutil.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384

b) change
from baseHTML=base.htm
to baseHTML=webutilbase.htm

c)change
from baseHTMLjinitiator=basejpi.htm
to baseHTMLjinitiator=webutiljpi.htm

note this is for webutil

d)change from
baseHTMLjpi=basejpi.htm
to baseHTMLjpi=webutiljpi.htm

e) change
from form=test.fmx
to form=navigator.fmx

f) change
from userid=
to userid=sun/sun01@suntex

g) change page title as


pageTitle=Suntex Enterprise Resource Planning

h)change
from imageBase=DocumentBase
to imageBase=CodeBase

i) change width and height


width=100%
height=100%

j) set
separateFrame=true
splashScreen=NO
background=NO
colorScheme=blaf
logo=NO
archive=frmall.jar,myicons.jar,frmwebutil.jar
networkRetries=10
#add#
separate_jvm=true

#set#
jpi_download_page=http://192.168.5.10:80/forms/java/jre-6u45-windows-i586.exe
jpi_classid=clsid:CAFEEFAC-0016-0000-0045-ABCDEFFEDCBA
jpi_codebase=http://192.168.5.10:80/forms/java/jre-6u45-windows-i586.exe
jpi_mimetype=application/x-java-applet

4. For Display of LOV Button


a)Open D:\oracle\FRHome_1\forms\java\oracle\forms\registry\Registry.dat
b) change
from
app.ui.lovButtons=false
to
app.ui.lovButtons=ture
c) Save and close file
5. For LOV key change to F9
a) Open D:\oracle\FRHome_2\forms\frmweb.res
b)comment and add new line
comment
#76 : 2 : "Ctrl+L" : 29 : "List of Values"
add
120 : 0 : "F9" : 29 : "List of Values"

c) save and close file


if required change Esc key mapping

comment
#115 : 0 : "F4" : 32 : "Exit"
add
27 : 0 : "Esc" : 32 : "Exit"

Visit for futher info:


https://hasanjawaid.blogspot.com/2017/04/key-mapping-in-oracle-forms.html

########## Froms Configuration Ends ##################

########## Reports Configuration Starts ##################

1. Open specific report_server configuration file in


D:\oracle\FRHome_1\reports\conf
e.g. rep_appsvr2_frhome2

ADD in <engine id="rwEng" ...> new property as

<property name="sourceDir"
value="D:\data\common;D:\data\reports;D:\data\employees;D:\data\cv;D:\data\style_sp
ecs"/>

2. Add a key in for report links


a) Open D:\oracle\FRHome_1\reports\conf\cgicmd.dat

add
st_rep: destype=cache desformat=pdf server=rep_appsvr_FRHome1
userid=username/password@suntex %*

3. -- barcode setting for reports


1. Open D:\oracle\FRHome_1\tools\common\uifont.ali

ADD in [ Global ] section

"3 of 9 Barcode" =times

2. ADD in [ PDF:Subset ] section


times="3of9Barcode.ttf"

3. copy "3of9Barcode.ttf" font file in d:\data\common

4. add at then end of REPORTS_PATH registry key as

;D:\data\common;D:\data\reports;D:\data\employees;D:\data\cv;D:\data\style_sp
ecs;

all required common locations

You might also like