Version – 2.5
By
Sikandar Hayat Awan Rizwan Ahmad Cheema
Pakistan Pakistan
www.erpstuff.com
Keep visiting www.erpstuff.com to download the latest version of this document.
Oracle Applications 11i – Administration www.erpstuff.com
Send Us Your Comments
The document is prepared by using Oracle 11.5.10.2 on Linux Red hat 4 while installation on
Windows is also covered. We have tried our best in preparing this document but still if there is any
observation then please let us know so we can correct in the next release of the document.
Please also suggest if you think any major feature is missing and you think that should also be
part of this document.
You can submit your feedback directly on the web site www.erpstuff.com or email to
admin@erpstuff.com. If both options are not working due to any reason then please email directly
to sikandar_h@hotmail.com.
Your comments and feedback will be really appreciated.
Thanks
Last updated: Jun - 2007
All Rights Reserved 2006-07 2/173
Oracle Applications 11i – Administration www.erpstuff.com
Preface
This document is for those who are interested to learn Oracle Applications Administration
(Database or System). Although the document will cover most of the features but this is not the
whole story of patching. So please consider it as a basic or reference document. We will also
recommend reading the Oracle Documentation provided by Oracle and use metalink
www.oracle.metalink.com.
Important
The authors will not be responsible if there will be any issue during or after practicing any feature
described in this document as this is just a basic document. It is also strongly recommended that
take backup before starting any critical feature and to practice on TEST servers and only perform
on production when you have personally tested all steps and feeling comfortable.
All Rights Reserved 2006-07 3/173
Oracle Applications 11i – Administration www.erpstuff.com
Contents
Contents ..........................................................................................................................4
1 - Key Files Locations ....................................................................................................6
1. Database Tier ....................................................................................................................................... 6
2. Application Tier..................................................................................................................................... 7
2 - Installation (OS & APPS) ........................................................................................ 10
1. Hardware & Software Requirements .............................................................................................. 10
2. Operating System Installation.......................................................................................................... 10
3. OS User and Group Creation............................................................................................................ 30
4. Setting up Stage................................................................................................................................. 30
5. Oracle Applications Installation (Linux).......................................................................................... 32
6. Oracle Applications Installation (Windows) ................................................................................... 41
3 - Start & Stop Services ............................................................................................. 48
1. Start ..................................................................................................................................................... 48
2. Stop...................................................................................................................................................... 48
4 - Patching ................................................................................................................. 49
1. Set Environment Variables ............................................................................................................... 49
2. Stop Apps Services (on all nodes)................................................................................................... 49
3. Enable Maintenance Mode................................................................................................................ 51
4. Apply Patch using adpatch ............................................................................................................... 55
5. Disabling Maintenance Mode............................................................................................................ 59
6. Start Apps Services............................................................................................................................ 60
5 - Backup ................................................................................................................... 62
1. Enabling Archivelog Mode................................................................................................................. 62
2. RMAN Settings.................................................................................................................................... 63
6 - Recovery ................................................................................................................ 65
1. Complete Recovery............................................................................................................................ 65
7 - Cloning ................................................................................................................... 68
1. Prepare Source System - dbTier...................................................................................................... 68
2. Preparing Source System - appsTier............................................................................................... 68
3. Copy the Source System to the Target System ............................................................................ 69
4. Configuring the Target System........................................................................................................ 70
8 - Statistics Gathering................................................................................................ 78
1. Gather Schema Statistics .................................................................................................................. 78
9 - Concurrent Manager .............................................................................................. 82
1. Purging Request of Concurrent Manager ....................................................................................... 82
10 - VNC Configuration................................................................................................ 85
1. Server Side Configuration ................................................................................................................. 85
2. Client Side Configuration .................................................................................................................. 88
11 - NFS Configuration ................................................................................................ 92
1. NFS Installation (Both Nodes) ......................................................................................................... 92
2. Server Side Configuration (Host)..................................................................................................... 93
3. Configuring NFS on the Client (Guest) ........................................................................................... 94
4. Deleting, Moving Or Modifying A Share ......................................................................................... 96
12 - Display Settings ................................................................................................... 97
1. Display Settings.................................................................................................................................. 97
All Rights Reserved 2006-07 4/173
Oracle Applications 11i – Administration www.erpstuff.com
13 - OS Auto login ..................................................................................................... 100
1. Setting Auto Login on Linux ........................................................................................................... 100
14 - ADI Setup ........................................................................................................... 102
1. ADI Setup for Oracle Apps 10.2 .................................................................................................... 102
15 - Reports Integration ........................................................................................... 105
1. Sample report Development .......................................................................................................... 105
2. Integration in Applications.............................................................................................................. 106
3. Reports output in Excel................................................................................................................... 111
16 - Browser Settings ................................................................................................ 116
1. Security Zones .................................................................................................................................. 116
2. JInitiator ............................................................................................................................................ 118
3. Page Refresh..................................................................................................................................... 118
4. Shared Desktop Security................................................................................................................. 118
5. Auto complete in Internet Explorer............................................................................................... 119
6. HTTP 1.1/Keep Alive Settings ........................................................................................................ 120
17 - Forms Personalization ........................................................................................ 122
1. Personalize fields properties........................................................................................................... 122
18 - Change Color Scheme ........................................................................................ 126
1. Changing color scheme................................................................................................................... 126
19 - Printer Configturation ........................................................................................ 129
1. Configuring Windows Shared Printer on Linux............................................................................ 129
2. Defining Printer in Oracle Applications ......................................................................................... 136
3. Reports Printing using above Defined Printer ............................................................................. 138
20 - Printer Page Customization ............................................................................... 142
1. Page Size Customization ................................................................................................................. 142
21 - Menu, Responsibility & User .............................................................................. 150
1. Customized Menu Definition........................................................................................................... 150
2. Responsibility Creation to Assign Menu........................................................................................ 151
3. Responsibility Assignment to User ................................................................................................ 152
22 - Descriptive Flexfields (DFF) ............................................................................... 154
1. Locating Descriptive Flexfield (DFF) on the Form....................................................................... 154
2. Defining Descriptive Flexfield (DFF).............................................................................................. 157
3. Entry in Defining Descriptive Flexfield (DFF)............................................................................... 165
23 - FNDCPASS .......................................................................................................... 168
1. Using FNDCPASS to change APPS password ............................................................................... 168
2. Changing Application User (sysadmin) Password ....................................................................... 170
3. Change Single Oracle User Password ........................................................................................... 170
4. Change All Oracle Users Passwords.............................................................................................. 171
All Rights Reserved 2006-07 5/173
Oracle Applications 11i – Administration www.erpstuff.com
1 - Key Files Locations
1. Database Tier
1.1. Set Environment Variables
$ cd /u01/oracle/visdb/9.2.0
$. ./VIS_vision.env
$ echo $ORACLE_HOME
/u01/oracle/visdb/9.2.0
1.2. Files in ORACLE_HOME
1.2.1. My SID = VIS and HOST is Vision
To view SID
$ echo $ORACLE_SID
VIS
To view Host
$ hostname -s
vision
File Path
SID_HOST.env $ORACLE_HOME/
init.ora $ORACLE_HOME/dbs/
initSID.ora $ORACLE_HOME/dbs/
SID_HOST_ifile.ora $ORACLE_HOME/
addbctl.sh $ORACLE_HOME/appsutil/scripts/SID_HOST/
addlnctl.sh $ORACLE_HOME/appsutil/scripts/SID_HOST/
adautocfg $ORACLE_HOME/appsutil/scripts/SID_HOST/
adautocfg.sh $ORACLE_HOME/appsutil/scripts/SID_HOST/
adchknls.pl $ORACLE_HOME/appsutil/scripts/SID_HOST/
adexecsql.pl $ORACLE_HOME/appsutil/scripts/SID_HOST/
adlsnodes.sh $ORACLE_HOME/appsutil/scripts/SID_HOST/
adpreclone.pl $ORACLE_HOME/appsutil/scripts/SID_HOST/
adstopdb.sql $ORACLE_HOME/appsutil/scripts/SID_HOST/
adstrtdb.sql $ORACLE_HOME/appsutil/scripts/SID_HOST/
All Rights Reserved 2006-07 6/173
Oracle Applications 11i – Administration www.erpstuff.com
1.3. Files in TNS_ADMIN
1.3.1. To view the TNS_ADMIN,
$ echo $TNS_ADMIN
/u01/oracle/visdb/9.2.0/network/admin/VIS_vision
File Path
listener.ora $TNS_ADMIN/
sqlnet_ifile.ora $TNS_ADMIN/
sqlnet.ora $TNS_ADMIN/
tnsnames.ora $TNS_ADMIN/
listener_ifile.ora $TNS_ADMIN/
2. Application Tier
2.1. Set Environment Variables
$ cd /u01/oracle/visappl
$. ./ APPSORA.env
$ echo $ORACLE_HOME
/u01/oracle/visora/8.0.6
2.2. Files in ORACLE_HOME
File Path
SID_HOST.env $ORACLE_HOME/
forms60_server $ORACLE_HOME/
CGIcmd.dat $ORACLE_HOME/reports60/server/
REP60_SID.ora $ORACLE_HOME/reports60/server/
runform.htm $ORACLE_HOME/tools/web60/html/
runrep.htm $ORACLE_HOME/tools/web60/html/
2.3. Files in TNS_ADMIN
2.3.1. To view the TNS_ADMIN,
$ echo $TNS_ADMIN
/u01/oracle/visdb/9.2.0/network/admin/VIS_vision
All Rights Reserved 2006-07 7/173
Oracle Applications 11i – Administration www.erpstuff.com
2.4. Files in APPL_TOP
2.4.1. To view the APPL_TOP,
$ echo $APPL_TOP
/u01/oracle/visappl
File Path
APPSORA.env $APPL_TOP/
APPSSID_HOST.env $APPL_TOP/
SID.env $APPL_TOP/
SID_HOST.env $APPL_TOP/
adconfig.txt $APPL_TOP/admin/
adovars.env $APPL_TOP/admin/
2.5. Files in FND_TOP
2.5.1. To view the FND_TOP,
$ echo $FND_TOP
/u01/oracle/visappl/fnd/11.5.0
File Path
HOST_SID.dbc $FND_TOP/secure/
appsweb.cfg $FND_TOP/resource/
2.6. Files in COMN_TOP
2.6.1. To view the COMN_TOP,
$ echo $COMN_TOP
/u01/oracle/viscomn
File Path
adalnctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adapcctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adaprstctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adautocfg.sh $COMN_TOP/admin/scripts/SID_HOST/
adcmctl.sh $COMN_TOP/admin/scripts/SID_HOST/
addisctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adexecsql.pl $COMN_TOP/admin/scripts/SID_HOST/
adfmcctl.sh $COMN_TOP/admin/scripts/SID_HOST/
All Rights Reserved 2006-07 8/173
Oracle Applications 11i – Administration www.erpstuff.com
adfmsctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adfrmctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adpreclone.pl $COMN_TOP/admin/scripts/SID_HOST/
adrepctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adstpall.sh $COMN_TOP/admin/scripts/SID_HOST/
adstrtal.sh $COMN_TOP/admin/scripts/SID_HOST/
adtcfctl.sh $COMN_TOP/admin/scripts/SID_HOST/
gsmstart.sh $COMN_TOP/admin/scripts/SID_HOST/
jtffmctl.sh $COMN_TOP/admin/scripts/SID_HOST/
adgendbc.sh $COMN_TOP/admin/install/SID_HOST/
aplogon.html $COMN_TOP/admin/portal/SID_HOST/
applist.html $COMN_TOP/admin/portal/SID_HOST/
2.7. Files in OA_HTML
2.7.1. To view the OA_HTML,
$ echo $ OA_HTML
/u01/oracle/viscomn/html
File Path
appsweb_SID_HOST.cfg $OA_HTML/bin/
ICXINDEX.htm $OA_HTML/US/
All Rights Reserved 2006-07 9/173
Oracle Applications 11i – Administration www.erpstuff.com
2 - Installation (OS & APPS)
1. Hardware & Software Requirements
1.1. Hardware (minimum)
o Server machine P4
o DVD
o RAM Minimum 1GB
o Hard Disk Space
Operating System 4.7GB
Stage 27GB (recommended 30GB)
Installation 96GB (Vision)
85GB (Production)
Note: To get the spaces command $ du –h /Stage11i is used.
o A Note book and a writing pen
o UPS (to avoid a power failure during installation).
1.2. Software
o Oracle Application 11.5.10.2
o Linux Redhat AS 4 32bit.
o Metalink Access
o Oracle Metalink Reference document # 287453.1
2. Operating System Installation
2.1. Insert the first bootable CD and reboot the machine.
All Rights Reserved 2006-07 10/173
Oracle Applications 11i – Administration www.erpstuff.com
2.2. Press ENTER key from the keyboard.
All Rights Reserved 2006-07 11/173
Oracle Applications 11i – Administration www.erpstuff.com
2.3. If you are not sure about your media then better to select OK and the media verification
will be started which will ask you to enter all CD’s one by one. If media is tested then
TAB to Skip and press ENTER.
2.4. No action required on this screen.
All Rights Reserved 2006-07 12/173
Oracle Applications 11i – Administration www.erpstuff.com
2.5. Click on Next (button).
All Rights Reserved 2006-07 13/173
Oracle Applications 11i – Administration www.erpstuff.com
2.6. Click on Next (button).
All Rights Reserved 2006-07 14/173
Oracle Applications 11i – Administration www.erpstuff.com
2.7. Click on Next (button).
All Rights Reserved 2006-07 15/173
Oracle Applications 11i – Administration www.erpstuff.com
2.8. Select Manually partition with Disk Druid and click on Next (button).
All Rights Reserved 2006-07 16/173
Oracle Applications 11i – Administration www.erpstuff.com
2.9. As I have used VMWARE to get these installation screens so there is an NTFS hard disk
which in your case will not appear. Select Free and click on Next (button).
All Rights Reserved 2006-07 17/173
Oracle Applications 11i – Administration www.erpstuff.com
2.10. Select /boot as Mount Point and enter 500 MB as size, ext3 as File System Type while
keeping Fixed size and click on OK (button).
2.11. Select swap in the File System Type and 2000 MB in Size and Fixed size then click on OK
(button).
All Rights Reserved 2006-07 18/173
Oracle Applications 11i – Administration www.erpstuff.com
2.12. Select / in Mount Point, ext3 as File System Type and click on Fill to maximum allowable
size and click on OK (button).
2.13. Verify the sized and after verification click on Next (button).
All Rights Reserved 2006-07 19/173
Oracle Applications 11i – Administration www.erpstuff.com
2.14. Click on Next (button).
2.15. Click on Edit (button).
All Rights Reserved 2006-07 20/173
Oracle Applications 11i – Administration www.erpstuff.com
2.16. Uncheck Configure using DHCP.
2.17. Keep check Activate on boot and enter IP Address and Netmask. If your machine is not
on network then enter as above otherwise ask your network administrator to provided
you IP address so you can enter here.
2.18. Click on OK (button).
2.19. Click manually under Hostname and enter the host and domain name.
2.20. If your machine is on network then ask your Network Administrator to provide you
Gateway and Primary DNS information.
All Rights Reserved 2006-07 21/173
Oracle Applications 11i – Administration www.erpstuff.com
2.21. Click on Next (button).
2.22. Select No firewall and click on Next (button).
2.23. Click on Proceed (button).
All Rights Reserved 2006-07 22/173
Oracle Applications 11i – Administration www.erpstuff.com
2.24. Click on Next (button).
2.25. Select your time zone and click on Next (button).
All Rights Reserved 2006-07 23/173
Oracle Applications 11i – Administration www.erpstuff.com
2.26. Enter root password but don’t forget, better to note it and click on Next (button).
2.27. Select Customize software packages to be installed and click on Proceed (button).
All Rights Reserved 2006-07 24/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: It is recommended to install All packages so we have selected Customize software
packages to be installed in the above step. If there is any space limitation then you may go
with Install default software packages but later you will have to install required packages
manually.
Select the following packages to install manually as by default these would not be installed. If
you will select complete installation then these packages would be installed automatically.
o Legacy Software Development package
o X Software Development package
2.28. Scroll down to the bottom.
All Rights Reserved 2006-07 25/173
Oracle Applications 11i – Administration www.erpstuff.com
2.29. Select Everything for full installation.
2.30. Click on Next (button).
All Rights Reserved 2006-07 26/173
Oracle Applications 11i – Administration www.erpstuff.com
2.31. Click on Continue (button) and the installation will be started.
2.32. Insert CD’s as prompted and click on OK (button).
All Rights Reserved 2006-07 27/173
Oracle Applications 11i – Administration www.erpstuff.com
2.33. Installation is complete so remove any CD from the drive and click on Reboot (button).
Note: If you installed with default packages instead of everything then you will have to install
few required packages manually. So insert the CD/DVD and during installation please make
sure that you have
Select these packages from the Package Group Selection screen. If the operating system is
already installed, use System Settings > Add/Remove Applications to install these two
packages.
The following required components must be installed manually:
o openmotif21-2.1.30-11.RHEL4.4
o libaio-0.3.102-1
o libaio-devel-0.3.102-1
The libaio components are available on Disk 3 of the RHEL4.0 media. For information on
downloading the openmotif component, see the instructions at the following URL:
https://rhn.redhat.com/errata/RHSA-2005-412.html
2.34. After installing these patches, run ldconfig -v.
2.35. Verify minimum Kernel Requirements with uname and rpm command,
[root@vision ~]# uname -r
All Rights Reserved 2006-07 28/173
Oracle Applications 11i – Administration www.erpstuff.com
2.6.9-5.ELsmp
[root@vision ~]# rpm -q glibc
glibc-2.3.4-2
Note: The above displayed information is as per recommendations.
2.36. Domain Name System (DNS) Resolver Parameters
Edit the following file /etc/resolv.conf and set the following parameters as below,
options attempts:5
options timeout:15
2.37. The format of hosts /etc/hosts file must be formatted as follows :
127.0.0.1 localhost.localdomain
.
2.38. Verify that the /etc/sysconfig/network file is formatted as follows :
HOSTNAME=.
2.39. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
Note: If you changed any files in the previous steps, reboot the system.
2.40. Modify number of open descriptors: in file /etc/security/limits.conf add the
following lines:
* hard nofile 65535
* soft nofile 4096
Note: The following warning will appear in the alert log file if these above settings will not
be effective. Make sure that each line must have “*” .
WARNING:Oracle instance running on a system with low open file descriptor
limit. Tune your system to increase this limit to avoid
severe performance degradation.
2.41. Change port range value : /etc/sysctl.config add the following line,
net.ipv4.ip_local_port_range = 1024 65000
2.42. Set LD_ASSUME_KERNEL in file /etc/profile
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL
2.43. Apply one of these OS library patches: 4198954 (for Red Hat 4.0), you can download it
from metalink.
2.44. Java 2 Standard Edition (J2SE), Rapid Install installs the Java 2 Standard Edition
1.4.2 automatically.
All Rights Reserved 2006-07 29/173
Oracle Applications 11i – Administration www.erpstuff.com
3. OS User and Group Creation
3.1. Create a user named oracle and two groups named dba and oinstall.The steps are
demonstrated in the following slide.
$ groupadd dba
$ groupadd oinstall
$ useradd -G dba -g oinstall oracle
$ passwd oracle
$ id oracle
uid=500(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)
$ chown -R oracle:oinstall /x01 /Stage
$ ll
Total 194
drwxr-xr-x 2 root root 4096 Jul 8 12:49 bin
drwxr-xr-x 4 root root 1024 Jul 8 12:49 boot
drwxr-xr-x 7 root root 5880 Aug 27 09:19 dev
drwxr-xr-x 105 root root 12288 Sep 2 09:00 etc
drwxr-xr-x 4 root root 4096 Sep 2 08:51 home
drwxr-xr-x 2 root root 4096 Aug 12 2004 initrd
drwxr-xr-x 11 root root 4096 Jul 9 15:04 lib
drwx------ 2 root root 16384 Jul 7 17:05 lost+found
drwxr-xr-x 6 root root 4096 Aug 27 09:19 media
drwxr-xr-x 2 root root 4096 Dec 2 2005 misc
drwxr-xr-x 2 root root 4096 Aug 12 2004 mnt
drwxr-xr-x 2 root root 4096 Aug 12 2004 opt
dr-xr-xr-x 425 root root 0 Aug 27 14:18 proc
drwxr-x--- 14 root root 4096 Sep 1 15:59 root
drwxr-xr-x 2 root root 12288 Jul 9 11:36 sbin
drwxr-xr-x 2 root root 4096 Jul 7 12:06 selinux
drwxr-xr-x 2 root root 4096 Aug 12 2004 srv
drwxr-xr-x 2 oracle oinstall 4096 Sep 2 09:02 Stage11i
drwxr-xr-x 9 root root 0 Aug 27 14:18 sys
drwxr-xr-x 3 root root 4096 Jul 9 11:36 tftpboot
drwxrwxrwt 15 root root 4096 Sep 2 04:02 tmp
drwxr-xr-x 14 root root 4096 Jul 7 12:41 usr
drwxr-xr-x 25 root root 4096 Jul 9 11:35 var
drwxr-xr-x 2 oracle oinstall 4096 Sep 2 09:02 u01
4. Setting up Stage
4.1. Staging is to copy all the contents of DVD’s on the hard disk as the following directory
structure. Don’t worry in earlier releases it was manual but now all is automated. Just
you need to run a perl script and rest will be managed by the script.
All Rights Reserved 2006-07 30/173
Oracle Applications 11i – Administration www.erpstuff.com
The DVD’s are labeled as below,
o Start Here - Disk 1
o APPL_TOP - Disk n
o RDBMS - Disk n
o Tools - Disk n
o Databases - Disk n
4.2. Now we will use adautostg.pl to create stage and please resolve any issue if the script
prompts for any.
4.3. Login as OS user with privileges to mount, unmount and eject the DVD. The must also
have write privileges to the stage area.
4.4. Insert the first DVD named Start Here in DVD-ROM drive and mount the DVD if not auto
mounted.
4.5. To verify perl version and to confirm if it is in the PATH,
perl –v
The version should be 5.0053 or higher else download from perl.com and install it.
4.6. Run adautostg.pl script from the mounted DVD,
$ perl /mnt/cdrom/Disk1/rapidwiz/adautostg.pl
4.7. Provide the top-level directory on the prompt like /u01 and the script will create a
directory Stage11i in the directory automatically and will create all other folders in this
directory as the structure shown in the above figure. So the directory will look like
/u01/Stage11i.
4.8. Select the components you want to be staged, sufficient help is available on the screen
to decide what to copy as the dependencies will be automatically verified.
4.9. Insert the DVD as the script will prompt for one by one.
Note: Good thing is that script will maintain a log so if copying is aborted due to any
reason so next time you can resume from the same stage.
All Rights Reserved 2006-07 31/173
Oracle Applications 11i – Administration www.erpstuff.com
5. Oracle Applications Installation (Linux)
5.1. Login as oracle user we created in the above steps.
5.2. Start Oracle Applications installation and follow as the following screens. I will
demonstrate vision installation on a single node.
5.3. Change directory to /u01/Stage11i/startCD/Disk1/rapidwiz/ with the cd command.
5.4. Execute $./rapidwiz
5.5. In the displayed Select Wizard Operation screen we have selected Install Oracle
Applications E-Business 11i. After selecting the desired option press Next.
5.6. If you already have a configuration created with rapidwiz then you can provide it on the
Load Configuration screen by select Yes, load configuration file and click open to find
the configuration file. By providing the file the next steps will be skipped and the system
status check step will be performed on the basis of parameters provided in the
configuration file. To know how this file is created and saved just see next screen Save
All Rights Reserved 2006-07 32/173
Oracle Applications 11i – Administration www.erpstuff.com
Instance – specific Configuration, which displayed after we provide all the information.
The default name is config.txt.
I have selected No as I don’t have configuration.
5.7. Press the next button on the above screen.
5.8. As I already mentioned above that I will demonstrate single node installation so here on
the Install Type screen I will select, Single – node (All services on a single node).
All Rights Reserved 2006-07 33/173
Oracle Applications 11i – Administration www.erpstuff.com
5.9. Press Next and the next screen will be to define database type.
5.10. I will install Vision Demo Database instead of Fresh Database as the Fresh would be
blank while Vision is preconfigured Database. So on the Define Database Type screen I
have selected Vision Demo Database and also entered my database name VIS.
All Rights Reserved 2006-07 34/173
Oracle Applications 11i – Administration www.erpstuff.com
5.11. After providing these two information press Next on the above screen.
5.12. By default the Oracle OS User is the user with which I logged in and started the
installation so I can’t change it here. The second is to enter the group so provide the
name of group which was created in few steps above. The third entry on the Database
Install Information – Vision screen is to provide the Base Install Directory where the
application will be installed.
All Rights Reserved 2006-07 35/173
Oracle Applications 11i – Administration www.erpstuff.com
5.13. If you need to change any other path on the above screen the click on Advanced Edit
else proceed by clicking Next.
5.14. In the previous step we provided information for Database while on this Configuration
Information for Node – Vision screen we will provide information for Application side.
The information is just like same as on the database screen. You can set different paths
of database and applications installation if any space limitation on one disk.
All Rights Reserved 2006-07 36/173
Oracle Applications 11i – Administration www.erpstuff.com
5.15. Enter your domain name in the Domain Name field on Global System Settings screen.
Like for demonstration I have entered erpstuff.com.
5.16. Save the configuration file on the following Save Instance – specific Configuration screen
for future use. Name the file which is convenient for you as kept the default one that is
config.txt.
All Rights Reserved 2006-07 37/173
Oracle Applications 11i – Administration www.erpstuff.com
5.17. Press Next to proceed.
5.18. All the input tasks of DBA are completed now the checks will be performed on the basis
of information provided in
the previous steps.
5.19. The next screen which will
appear is the System Check
Status screen.
5.20. The next immediate screen
will show the results of
checks performed in the last
step.
5.21. View if any cross found and
resolve the error mentioned.
I am sure if all steps above
were performed carefully
there should be no issue at
this place. If any error
displayed on the Validate
System Configuration screen
then press Back else press
Next.
All Rights Reserved 2006-07 38/173
Oracle Applications 11i – Administration www.erpstuff.com
5.22. The next screen is Component Installation Review which displays the components to be
installed.
5.23. Pressing Next will bring the Load Balancing screen.
All Rights Reserved 2006-07 39/173
Oracle Applications 11i – Administration www.erpstuff.com
5.24. I have used default values for Concurrent Manager, Forms Server on the Load Balancing
Node Specification screen.
5.25. As we are installing single node so Node name is same for all Services while Linux is
selected as Operating System on Node Information screen.
All Rights Reserved 2006-07 40/173
Oracle Applications 11i – Administration www.erpstuff.com
5.26. After pressing the Next on the above screen will bring the following Installing Oracle
Applications screen which shows two progress bars.
5.27. During this the DBA can perform the following tasks,
o In case of multi node installation start OS installation on the other node.
o If it is lunch time then have a nice lunch as the installation will take time to complete
depending on the hardware.
o If you have music system then listening good music would also be a good time passing.
o Mean while keep watching the progress bars as any error may be prompted due to
certain reason like if any step(s) was/were missed.
6. Oracle Applications Installation (Windows)
Now we will try to capture the steps for the Installation of Oracle eBusiness suite on Microsoft
Windows.
All Rights Reserved 2006-07 41/173
Oracle Applications 11i – Administration www.erpstuff.com
6.1. Windows OS Setup
6.1.1. Fist of all download the latest version of JDK from http://java.sun.com and install it
while keeping in mind that there should be no space in the folder(s) name.
6.1.2. During Windows installation please make sure that the machine should be at least 8
characters and if during installation it is less than 8 then change it.
6.1.3. First of all you need to create a new user on Windows server with name “oracle” and
add the user in administrators group to give administrative privileges.
6.1.4. Logoff and login into as “oracle” and install the following tools before installation of
11i.
6.1.5. The sequence of installation of these softwares should be as the sequence in the
following steps.
6.1.6. Install the printer on the server before proceeding with the installation.
Note: There should be no space in the folder names of the following softwares. Do not install
in the “Program Files” folder because there is a space character in the folder name.
6.2. JDK
6.2.1. Fist of all download the latest version of JDK from http://java.sun.com and install it
while keeping in mind that there should be no space in the folder(s) name.
6.3. MS Outlook
6.3.1. For few versions of eBusiness suite you need to install Microsoft Outlook so install
the Microsoft Outlook.
6.4. Microsoft Visual C++
6.4.1. The next is to install Microsoft Visual C++.
6.4.2. Start the setup.
6.4.3. Select “Product” on the following screen.
All Rights Reserved 2006-07 42/173
Oracle Applications 11i – Administration www.erpstuff.com
6.4.4. Click on Next (B).
6.4.5. Select Visual C++ 6.0 Enterprise Edition and click on Next (B).
All Rights Reserved 2006-07 43/173
Oracle Applications 11i – Administration www.erpstuff.com
6.4.6. Select Register Environment Variables and click on OK (B).
6.4.7. Enter a folder name and path which should not have any space(s).
6.4.8. Click on Next (B).
6.4.9. After the installation reboot the system.
6.4.10. Next is to install Service Pack 4 for Microsoft Visual Studio
6.4.11. After Service pack installation reboot the system.
6.5. MKS Toolkit
6.5.1. Download the MKS Toolkit from http://www.mks.com as a demo version for 30 days
is available for free download.
6.5.2. Start the setup.
All Rights Reserved 2006-07 44/173
Oracle Applications 11i – Administration www.erpstuff.com
6.5.3. Click on Next (B).
6.5.4. Click on Next (B).
6.5.5. On the following screen, give non-space name of the folder where you want to install
the toolkit. Click the “Browse” button to change the folder name. You may install the
toolkit to C:\mksnt folder as described in the Oracle Installation Guide.
All Rights Reserved 2006-07 45/173
Oracle Applications 11i – Administration www.erpstuff.com
6.5.6. Click on Next (B).
6.5.7. Click on Next (B).
6.5.8. Wait for the installation to complete.
6.5.9. Once the installation is complete, go to the “MS DOS Prompt” and run any Unix
command. You must be able to run all Unix commands on Windows successfully.
Like for example enter ls command which is same a dir command of windows.
6.6. GNUMake Utility
6.6.1. Download the GNU from http://www.gnu.org/ and following the instruction as
provided by GNU.
6.6.2. Now copy the gnumake.exe from c:\gnu to c:\mksnt\mksnt.
6.7. Set the Required Paths
All Rights Reserved 2006-07 46/173
Oracle Applications 11i – Administration www.erpstuff.com
6.7.1. Right Click the “My Computer” icon on the desktop and choose “Properties” from the
popup menu. Click the “Advanced” tab and then “Environment Variables”. Double
Click the “Path” variable and add the following before %system% and %system32%;
c:\mksnt\mksnt;c:\gnu.
6.8. Startup Installation
6.8.1. Open the MS DOS Prompt and goto the Rapidwiz directory
6.8.2. Run the following cmd file to start the installation wizward,
E:\Stage11i\redCD\Disk1\rapidwiz>rapidwiz.cmd
6.8.3. This will initiate the installation wizard.
6.8.4. Once the installation completes reboot the system.
Note: As the installation steps/screens are already covered in the above demonstration of
installation on Linux so will not be covered. The only difference is the paths so on the installation
screen provide the windows paths.
All Rights Reserved 2006-07 47/173
Oracle Applications 11i – Administration www.erpstuff.com
3 - Start & Stop Services
1. Start
1.1. Execute the following script in the sequence shown below,
/u01/oracle/visdb/9.2.0/appsutil/scripts/VIS_vision/addbctl.sh start
/u01/oracle/visdb/9.2.0/appsutil/scripts/VIS_vision/addlnctl.sh start VIS
/u01/oracle/viscomn/admin/scripts/VIS_vision/adstrtal.sh apps/apps
2. Stop
2.1. To stop the services execute the script in the following sequence.
/u01/oracle/viscomn/admin/scripts/VIS_vision/adstpall.sh apps/apps
/u01/oracle/visdb/9.2.0/appsutil/scripts/VIS_vision/addlnctl.sh stop VIS
/u01/oracle/visdb/9.2.0/appsutil/scripts/VIS_vision/addbctl.sh stop immediate
All Rights Reserved 2006-07 48/173
Oracle Applications 11i – Administration www.erpstuff.com
4 - Patching
1. Set Environment Variables
1.1. Login as Oracle user.
1.2. Change directory to /oracle/visappl and execute APPSORA.env
1.3. $. ./APPSORA.env
Note: Make sure that there are double dots with space between them, . ./APPSORA.env
2. Stop Apps Services (on all nodes)
2.1. Change directory to, /oracle/viscomn/admin/scripts/VIS_vision
2.2. Execute script adstpall.sh to stop apps services.
2.3. $./adstpall.sh apps/apps (apps username and password)
You are running adstpall.sh version 115.17
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/adapcctl.sh stop
script returned:
****************************************************
adapcctl.sh version 115.43
Stopping Apache Web Server Listener (dedicated HTTP) ...
Stopping Apache Web Server Listener (dedicated PLSQL) ...
/oracle/viscomn/conf/VIS_vision/iAS/Apache/Apache/bin/apachectl stop: httpd stopped
adapcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/adalnctl.sh stop
script returned:
****************************************************
adalnctl.sh version
Shutting down listener process APPS_vis.
adalnctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
All Rights Reserved 2006-07 49/173
Oracle Applications 11i – Administration www.erpstuff.com
/oracle/viscomn/admin/scripts/VIS_vision/adfrmctl.sh stop
script returned:
****************************************************
You are running adfrmctl.sh version 115.34
Stopping forms server for vis on port 9000.
adfrmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/adfmcctl.sh stop
script returned:
****************************************************
You are running adfmcctl.sh version 115.17
Stopping forms load balancing client for vis.
adfmcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/adfmsctl.sh stop
script returned:
****************************************************
You are running adfmsctl.sh version 115.13
Stopping forms metrics server for vis on port 9200.
adfmsctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/jtffmctl.sh stop
script returned:
****************************************************
You are running jtffmctl.sh version 115.16
Shutting down Fulfillment Server for vis on port 9300 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/VIS_vision/addisctl.sh stop
script returned:
****************************************************
All Rights Reserved 2006-07 50/173
Oracle Applications 11i – Administration www.erpstuff.com
addisctl.sh version 115.14
OAD is stopped
Osagent is stopped
Locator is stopped
Unable to stop gatekeeper. No process-id file found.
Unable to stop any Discoverer Sessions. No process-id file found.
Unable to stop any Discoverer Preference. No process-id file found.
Unable to stop any Discoverer Collector. No process-id file found.
addisctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services on this node are stopped.
Check logfile /oracle/viscomn/admin/log/VIS_vision/09011120.log for details
Exiting with status 0
Note: Step 1 and 2 should be applied on all nodes. For demonstration I have performed on one
node.
3. Enable Maintenance Mode
3.1. Use adadmin to change maintenance mode.
3.2. Change folder to /oracle/visappl/ad/11.5.0/bin
3.3. Execute script $./adadmin
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AD Administration
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Your default directory is '/oracle/visappl'.
Is this the correct APPL_TOP [Yes] ?
AD Administration records your AD Administration session in a text file
you specify. Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adadmin.log] :
************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Fri Sep 01 2006 11:26:39
APPL_TOP is set to /oracle/visappl
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
All Rights Reserved 2006-07 51/173
Oracle Applications 11i – Administration www.erpstuff.com
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [vis] : vis *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [NO] ? NO *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [NO] ? NO *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [vision] : vision *
You are about to use or modify Oracle Applications product tables
in your ORACLE database 'vis'
using ORACLE executables in '/oracle/visora/8.0.6'.
Is this the correct database [Yes] ?
AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
All Rights Reserved 2006-07 52/173
Oracle Applications 11i – Administration www.erpstuff.com
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Administration is verifying your username/password.
The status of various features in this run of AD Administration is:
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 YNNYNY
PREREQ Yes 6 6 YNNYNY
CONCURRENT_SESSIONS No 2 2 YYNYYN
PATCH_TIMING Yes 2 2 YNNYNY
PATCH_HIST_IN_DB Yes 6 6 YNNYNY
SCHEMA_SWAP Yes 1 1 YNNYYY
Identifier for the current session is 24933
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.2]
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
All Rights Reserved 2006-07 53/173
Oracle Applications 11i – Administration www.erpstuff.com
Enter your choice [6] : 5
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 1
sqlplus -s &un_apps/***** @/oracle/visappl/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE
Spawned Process 6370
Successfully enabled Maintenance Mode.
Review the messages above, then press [Return] to continue.
Backing up restart files, if any......Done.
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 3
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
Enter your choice [6] : 6
Backing up restart files, if any......Done.
All Rights Reserved 2006-07 54/173
Oracle Applications 11i – Administration www.erpstuff.com
There is no timing information available for the current session.
AD Administration is complete.
Errors and warnings are listed in the log file
/oracle/visappl/admin/vis/log/adadmin.log
and in other log files in the same directory.
Warning: There should be no space in the folder names where patches are placed.
4. Apply Patch using adpatch
4.1. Unzip the downloaded patch from metalink.
4.2. Open readme.html file from unzipped patch folder.
4.3. View the following readme.html of patch # 4712852. I have applied this patch for
demonstration for this document.
4.4. Follow all steps mentioned in readme.html of the patch you are going to apply.
4.5. In this patch there is no extra step and we have to apply the driver file u4712852.drv.
Oracle has changed the patch files and now only one file is included that is has prefix u
+ patch number + .drv early patch had three files to apply with prefixes (c, d, g).
All Rights Reserved 2006-07 55/173
Oracle Applications 11i – Administration www.erpstuff.com
• The c copy driver (cXXXXXXX.drv) should be applied to Concurrent Processing/Admin/Forms/Web servers.
• The d database driver (dXXXXXXX.drv) should be applied to the Admin server.
• The g generate driver (g3016463.drv) should be applied to Concurrent Processing/Forms servers.
XXXXXXX = patch 7 digit number
4.6. Change folder to /oracle/visappl/ad/11.5.0/bin.
4.7. Execute $./adpatch and follow the instructions and provide required
information.
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AutoPatch
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.
Your default directory is '/oracle/visappl'.
Is this the correct APPL_TOP [Yes] ?
AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adpatch.log] : 4712852.log
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [vis] : vis *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
All Rights Reserved 2006-07 56/173
Oracle Applications 11i – Administration www.erpstuff.com
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [NO] ? NO *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [NO] ? NO *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [vision] : vision *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'vis'
using ORACLE executables in '/oracle/visora/8.0.6'.
Is this the correct database [Yes] ?
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 YNNYNY
PREREQ Yes 6 6 YNNYNY
CONCURRENT_SESSIONS No 2 2 YYNYYN
PATCH_TIMING Yes 2 2 YNNYNY
PATCH_HIST_IN_DB Yes 6 6 YNNYNY
SCHEMA_SWAP Yes 1 1 YNNYYY
All Rights Reserved 2006-07 57/173
Oracle Applications 11i – Administration www.erpstuff.com
Identifier for the current session is 24935
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.2]
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
**************** S T A R T O F U P L O A D ****************
Start date: Fri Sep 01 2006 12:07:48
0 "left over" javaupdates.txt files uploaded to DB: Fri Sep 01 2006 12:07:48
0 patches uploaded from the ADPSV format patch history files: Fri Sep 01 2006 12:07:48
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_.txt files uploaded to DB: Fri Sep 01 2006 12:07:48
****************** E N D O F U P L O A D ******************
End date: Fri Sep 01 2006 12:07:48
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/oracle/visappl/ad/11.5.0/bin] : /DUMP/DUMP/patches/act_patch/4712852
Please enter the name of your AutoPatch driver file : u4712852.drv
Getting Oracle Applications Release...
Current installed release is 11.5.10.2
Reading patch driver file...
All Rights Reserved 2006-07 58/173
Oracle Applications 11i – Administration www.erpstuff.com
Parsing and loading patch driver file...
Processing line 10000.
16358 lines processed.
Not checking patch integrity as integrity checking flag is turned off.
Successfully read patch driver file.
Determining target release...
Current target release is 11.5.10.2
Determining which bug fixes to apply...
Done determining which bug fixes to apply.
Log and Info File sync point:
Fri Sep 01 2006 12:09:49
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Fri Sep 01 2006 12:09:49
End of unrecognized products checking.
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 91 workers.
Oracle recommends that you use between 16 and 32 workers.
Enter the number of parallel workers [16] :
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/oracle/visappl/admin/vis/log/4712852.lgi
Errors and warnings are listed in the log file
/oracle/visappl/admin/vis/log/4712852.log
and in other log files in the same directory.
4.8. The status is AutoPatch is complete. as show above means the patch applied
successfully.
4.9. If there are more than one patches then all patches should be applied before proceeding
to the next disabling maintenance mode step.
5. Disabling Maintenance Mode
5.1. The disabling steps are just same as enabling maintenance mode demonstrated above.
Just to disable this time we will select 2 instead of 1, While all other steps are same. So
I will not replicate the same text here. Please follow the topic Enable Maintenance Mode
5.2. View the following slide.
All Rights Reserved 2006-07 59/173
Oracle Applications 11i – Administration www.erpstuff.com
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 2
sqlplus -s &un_apps/***** @/oracle/visappl/ad/11.5.0/patch/115/sql/adsetmmd.sql DISABLE
Spawned Process 19922
Successfully disabled Maintenance Mode.
Review the messages above, then press [Return] to continue.
Backing up restart files, if any......Done.
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Disabled].
6. Start Apps Services
6.1. Change directory to, /oracle/viscomn/admin/scripts/VIS_vision
6.2. Execute script adstrtal.sh to stop apps services. The file name is with single “l” of all as
compere to adstpall.sh we used above to stop services.
6.3. $./adstrtal.sh apps/apps (apps username and password)
You are running adstrtal.sh version 115.14
Executing service control script:
/oracle/viscomn/admin/scripts/vis_vision/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version
Checking for FNDFS executable.
Starting listener process APPS_vis.
adalnctl.sh: exiting with status 0
.end std out.
.end err out.
All Rights Reserved 2006-07 60/173
Oracle Applications 11i – Administration www.erpstuff.com
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/vis_vision/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 115.20
Starting concurrent manager for vis ...
Starting vis_0901@vis Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/viscomn/admin/scripts/vis_vision/adrepctl.sh start
script returned:
****************************************************
You are running adrepctl.sh version 115.29
starting Reports Server for vis on port 7000.
adrepctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
Check logfile /oracle/viscomn/admin/log/vis_vision/09011226.log for details
Exiting with status 0
All Rights Reserved 2006-07 61/173
Oracle Applications 11i – Administration www.erpstuff.com
5 - Backup
Prerequisite of RMAN is that database must be in archivelog mode. If the database on which you
are going to use RMAN is not in archivelog mode then first enable archivelog mode.
1. Enabling Archivelog Mode
1.1. Login as oracle user
1.2. Set environment variables by executing VIS_vision.env as following,
$ cd /u01/oracle/visdb/9.2.0/
$ . ./VIS_vision.env
$ VIS-/u01/oracle/visdb/9.2.0> sqlplus
SQL*Plus: Release 9.2.0.6.0 - Production on Sat Sep 2 13:16:42 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
1.3. To check if database is in which status as if already in archivelog mode then we will skip
the next steps.
SQL> select Log_Mode from Sys.v$database;
LOG_MODE
------------
NOARCHIVELOG
1.4. SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
1.5. SQL> startup mount;
ORACLE instance started.
Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
All Rights Reserved 2006-07 62/173
Oracle Applications 11i – Administration www.erpstuff.com
Database mounted.
1.6. SQL> alter database archivelog;
Database altered.
1.7. SQL> alter database open;
Database altered.
1.8. SQL> exit
2. RMAN Settings
2.1. $ rman target=sys/password nocatalog
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: VIS (DBID=1772376983)
using target database controlfile instead of recovery catalog
Note: Just change the word password with your sys user password.
2.2. To check the RMAN settings execute show all command,
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DI
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/visdb/9.2.0/dbs/snapcf_vis.f'; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
2.3. To configure backup path use the configure command but first check the available space
on the target path.
RMAN> configure channel device type disk format = '/backup/df0_%d_%s_%t';
RMAN configuration parameters are successfully stored
All Rights Reserved 2006-07 63/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: Make sure that you have a folder named backup on root where files will be
copied by rman or create with mkdir command.
2.4. Verify your settings,
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/home/oracle/backup/df0_%d_%s_%t';
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/visdb/9.2.0/dbs/snapcf_vis.f'; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
2.5. Start full backup,
RMAN> backup database;
Starting backup at 02-SEP-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=51 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
All Rights Reserved 2006-07 64/173
Oracle Applications 11i – Administration www.erpstuff.com
6 - Recovery
1. Complete Recovery
1.1. Here I will delete all the data files and will restore from the backup we taken above.
Rename all data files with mv command in Linux. This is just to have a backup with us.
$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Sep 11 12:14:30 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup database mount;
SP2-0714: invalid combination of STARTUP options
SQL> startup mount;
ORACLE instance started.
Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/u01/oracle/visdata/tx_data10.dbf'
1.2. Connect rman to restore datafiles in another terminal.
$ rman target sys/sys_password
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: VIS (DBID=1772376983)
RMAN> restore database;
Starting restore at 11-SEP-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
All Rights Reserved 2006-07 65/173
Oracle Applications 11i – Administration www.erpstuff.com
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/visdata/sys1.dbf
restoring datafile 00002 to /u01/oracle/visdata/sys2.dbf
restoring datafile 00003 to /u01/oracle/visdata/sys3.dbf
restoring datafile 00004 to /u01/oracle/visdata/sys4.dbf
restoring datafile 00005 to /u01/oracle/visdata/sys5.dbf
restoring datafile 00006 to /u01/oracle/visdata/sys6.dbf
restoring datafile 00007 to /u01/oracle/visdata/sys7.dbf
restoring datafile 00008 to /u01/oracle/visdata/undo01.dbf
restoring datafile 00009 to /u01/oracle/visdata/undo02.dbf
restoring datafile 00010 to /u01/oracle/visdata/undo03.dbf
restoring datafile 00011 to /u01/oracle/visdata/undo04.dbf
restoring datafile 00012 to /u01/oracle/visdata/archive1.dbf
restoring datafile 00013 to /u01/oracle/visdata/archive2.dbf
restoring datafile 00014 to /u01/oracle/visdata/media1.dbf
restoring datafile 00015 to /u01/oracle/visdata/media2.dbf
restoring datafile 00016 to /u01/oracle/visdata/media3.dbf
restoring datafile 00017 to /u01/oracle/visdata/nologging1.dbf
restoring datafile 00018 to /u01/oracle/visdata/queues1.dbf
restoring datafile 00019 to /u01/oracle/visdata/queues2.dbf
restoring datafile 00020 to /u01/oracle/visdata/reference1.dbf
restoring datafile 00021 to /u01/oracle/visdata/reference2.dbf
restoring datafile 00022 to /u01/oracle/visdata/summary1.dbf
restoring datafile 00023 to /u01/oracle/visdata/summary2.dbf
restoring datafile 00024 to /u01/oracle/visdata/summary3.dbf
restoring datafile 00025 to /u01/oracle/visdata/summary4.dbf
restoring datafile 00026 to /u01/oracle/visdata/summary5.dbf
restoring datafile 00027 to /u01/oracle/visdata/tx_data1.dbf
restoring datafile 00028 to /u01/oracle/visdata/tx_data2.dbf
restoring datafile 00029 to /u01/oracle/visdata/tx_data3.dbf
restoring datafile 00030 to /u01/oracle/visdata/tx_data4.dbf
restoring datafile 00031 to /u01/oracle/visdata/tx_data5.dbf
restoring datafile 00032 to /u01/oracle/visdata/tx_data6.dbf
restoring datafile 00033 to /u01/oracle/visdata/tx_data7.dbf
restoring datafile 00034 to /u01/oracle/visdata/tx_data8.dbf
restoring datafile 00035 to /u01/oracle/visdata/tx_data9.dbf
restoring datafile 00036 to /u01/oracle/visdata/tx_data10.dbf
restoring datafile 00037 to /u01/oracle/visdata/tx_data11.dbf
restoring datafile 00038 to /u01/oracle/visdata/tx_idx1.dbf
restoring datafile 00039 to /u01/oracle/visdata/tx_idx2.dbf
restoring datafile 00040 to /u01/oracle/visdata/tx_idx3.dbf
restoring datafile 00041 to /u01/oracle/visdata/tx_idx4.dbf
restoring datafile 00042 to /u01/oracle/visdata/tx_idx5.dbf
restoring datafile 00043 to /u01/oracle/visdata/tx_idx6.dbf
restoring datafile 00044 to /u01/oracle/visdata/tx_idx7.dbf
restoring datafile 00045 to /u01/oracle/visdata/tx_idx8.dbf
restoring datafile 00046 to /u01/oracle/visdata/tx_idx9.dbf
restoring datafile 00047 to /u01/oracle/visdata/tx_idx10.dbf
restoring datafile 00048 to /u01/oracle/visdata/tx_idx11.dbf
restoring datafile 00049 to /u01/oracle/visdata/apps_ts_tx_interface.dbf
restoring datafile 00050 to /u01/oracle/visdata/ctx1.dbf
restoring datafile 00053 to /u01/oracle/visdata/odm.dbf
restoring datafile 00055 to /u01/oracle/visdata/olap.dbf
restoring datafile 00056 to /u01/oracle/visdata/owa1.dbf
restoring datafile 00057 to /u01/oracle/visdata/portal.dbf
restoring datafile 00058 to /u01/oracle/visdata/mobile01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/backup/data/VIS_datafiles_600565802_0ehsnq1a_1_1.bak tag=
TAG20060907T235002 params=NULL
All Rights Reserved 2006-07 66/173
Oracle Applications 11i – Administration www.erpstuff.com
channel ORA_DISK_1: restore complete
Finished restore at 11-SEP-06
1.3. After restore recover the database.
SQL> recover database;
ORA-00279: change 8173926267640 generated at 09/07/2006 23:50:02 needed for
thread 1
ORA-00289: suggestion : /u01/oracle/visdb/9.2.0/dbs/arch1_320.dbf
ORA-00280: change 8173926267640 for thread 1 is in sequence #320
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
Log applied.
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
All Rights Reserved 2006-07 67/173
Oracle Applications 11i – Administration www.erpstuff.com
7 - Cloning
1. Prepare Source System - dbTier
In the following demonstration we will clone our VISION single node instance to another VISION
instance. Even in single node cloning we still have to perform activities like dbTier and appsTier
just like two nodes. Here our source machine name is VISION and target is VISION2 while
database VIS and VIS2 accordingly. The other change is that source directory structure is
/u01/oracle while target /d01/oracle, this is not mandatory you can have same and if not then you
will have to provide this information later in the steps. So note down all such information before
proceeding.
1.1. login as: oracle
1.2. $ cd /u01/oracle/visdb/9.2.0/appsutil/scripts/VIS_vision/
1.3. $ perl adpreclone.pl dbTier pwd=apps
Running Rapid Clone with command...
perl /u01/oracle/visdb/9.2.0/appsutil/bin/adclone.pl java=/u01/oracle/visdb/9.2.0/jre/1.4.2 mode=stage
stage=/u01/oracle/visdb/9.2.0/appsutil/clone component=dbTier method=CUSTOM
dbctx=/u01/oracle/visdb/9.2.0/appsutil/VIS_vision.xml pwd=apps showProgress
Beginning database tier Stage - Tue Sep 12 09:18:13 2006
Log file located at /u01/oracle/visdb/9.2.0/appsutil/log/VIS_vision/StageDBTier_09120918.log
| 5% completed
Running Rapid Clone with command...
perl /u01/oracle/visdb/9.2.0/appsutil/bin/adclone.pl java=/u01/oracle/visdb/9.2.0/jre/1.4.2 mode=stage
stage=/u01/oracle/visdb/9.2.0/appsutil/clone component=dbTier method=CUSTOM
dbctx=/u01/oracle/visdb/9.2.0/appsutil/VIS_vision.xml pwd=apps showProgress
Beginning database tier Stage - Tue Sep 12 09:18:13 2006
Log file located at /u01/oracle/visdb/9.2.0/appsutil/log/VIS_vision/StageDBTier_09120918.log
Completed Stage...
Tue Sep 12 09:24:47 2006
2. Preparing Source System - appsTier
1.1. $ cd /u01/oracle/viscomn/admin/scripts/VIS_vision
1.2. $ perl adpreclone.pl appsTier pwd=apps
Running Rapid Clone with command...
All Rights Reserved 2006-07 68/173
Oracle Applications 11i – Administration www.erpstuff.com
perl /u01/oracle/visappl/ad/11.5.0/bin/adclone.pl java=/u01/oracle/visora/iAS/appsoui/jre/1.3.1
mode=stage stage=/u01/oracle/viscomn/clone component=appsTier method=CUSTOM
appctx=/u01/oracle/visappl/admin/VIS_vision.xml pwd=apps showProgress
Beginning application tier Stage - Tue Sep 12 09:33:58 2006
Log file located at /u01/oracle/visappl/admin/VIS_vision/log/StageAppsTier_09120933.log
\ 8% completed
Running Rapid Clone with command...
perl /u01/oracle/visappl/ad/11.5.0/bin/adclone.pl java=/u01/oracle/visora/iAS/appsoui/jre/1.3.1
mode=stage stage=/u01/oracle/viscomn/clone component=appsTier method=CUSTOM
appctx=/u01/oracle/visappl/admin/VIS_vision.xml pwd=apps showProgress
Beginning application tier Stage - Tue Sep 12 09:33:58 2006
Log file located at /u01/oracle/visappl/admin/VIS_vision/log/StageAppsTier_09120933.log
Completed Stage...
Tue Sep 12 09:40:31 2006
VIS-/u01/oracle/viscomn/admin/scripts/VIS_vision>
3. Copy the Source System to the Target System
3.1. Shut down the services on both tiers.
3.2. Copy Source System in the following order,
Application tier file system
Copy the following directories from the source node to the target node:
1.
2.
3.
4.
5. /util
6. /clone
7. /_pages (when this directory exists)
8.
9.
Database tier file system
1. Perform a normal shutdown on source database
2. Copy all the database files from the source to the target system
3. Copy the source ORACLE_HOME to the target system
Note: The above mentioned copying steps are provided by Oracle. The cloning with this selective
folders copying gave error so we copied complete Oracle folder from source to target. The cloning
with these selective folders will be provided later.
All Rights Reserved 2006-07 69/173
Oracle Applications 11i – Administration www.erpstuff.com
4. Configuring the Target System
4.1. Login as Oracle user
4.2. Run adcfgclone.pl on database tier, and provide your feedback to each prompt as
shown below.
$ cd /d01/oracle/visdb/9.2.0/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
Provide the values required for creation of the new Database Context file.
Do you want to use a virtual hostname for the target node (y/n) [n] ?:
Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:
Target System database name [VIS]:VIS2
Target system RDBMS ORACLE_HOME directory [/u01/oracle/visdb/9.2.0]:/d01/oracle/visdb/9.2.0
Target system utl_file accessible directories list [/usr/tmp]:
Number of DATA_TOP's on the target system [1]:
Target system DATA_TOP 1 [/u01/oracle/visdata]:/d01/oracle/visdata
Do you want to preserve the Display set to vision:0.0 (y/n) [y] ?:n
Target system Display [vision2:0.0]:
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n
Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.
Enter the port pool number [0-99]:
0
Checking the port pool 0
done: Port Pool 0 is free
Database port is 1521
Creating the new Database Context file from :
/d01/oracle/visdb/9.2.0/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/d01/oracle/visdb/9.2.0/appsutil/VIS2_vision2.xml
Log file located at /d01/oracle/visdb/9.2.0/appsutil/clone/bin/CloneContext_11080500.log
Running Rapid Clone with command:
All Rights Reserved 2006-07 70/173
Oracle Applications 11i – Administration www.erpstuff.com
perl /d01/oracle/visdb/9.2.0/appsutil/clone/bin/adclone.pl
java=/d01/oracle/visdb/9.2.0/appsutil/clone/bin/../jre mode=apply
stage=/d01/oracle/visdb/9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM
dbctxtg=/d01/oracle/visdb/9.2.0/appsutil/VIS2_vision2.xml showProgress contextValidated=true
Beginning database tier Apply - Wed Nov 8 17:04:19 2006
Log file located at /d01/oracle/visdb/9.2.0/appsutil/log/VIS2_vision2/ApplyDBTier_11080504.log
19% completed
----------------------------------------------Completion message--------------------------------------------------
Completed Apply...
Wed Nov 8 17:06:49 2006
Beginning APPSDB_VIS2 registration to central inventory...
ORACLE_HOME NAME : APPSDB_VIS2
ORACLE_HOME PATH : /d01/oracle/visdb/9.2.0
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_11080506.log
ORACLE_HOME /d01/oracle/visdb/9.2.0 was registered successfully.
Starting database listener for VIS2:
Running:
/d01/oracle/visdb/9.2.0/appsutil/scripts/VIS2_vision2/addlnctl.sh start VIS2
You are running addlnctl.sh version 115.6
Logfile: /d01/oracle/visdb/9.2.0/appsutil/log/VIS2_vision2/addlnctl.txt
Starting listener process VIS2 ...
Listener VIS2 has already been started.
addlnctl.sh: exiting with status 0
[oracle@vision2 bin]$
Note: The inputs in the above steps are in blue color while where default is accepted the
ENTER key is pressed. Like “Do you want to use a virtual hostname for the target node (y/n) [n] ?:” the
default is [n] so pressing just enter key means you selected n.
4.3. Login as Oracle user on Applications Server.
4.4. Now run adcfgclone.pl on Applications Tier, and provide your feedback to each
prompt as shown below.
$ cd /d01/oracle/viscomn/clone/bin
$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
apps
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
All Rights Reserved 2006-07 71/173
Oracle Applications 11i – Administration www.erpstuff.com
Provide the values required for creation of the new APPL_TOP Context file.
Do you want to use a virtual hostname for the target node (y/n) [n] ?:
Target system database SID [VIS]:VIS2
Target system database server node [vision]:vision2
Target system database domain name [erpstuff.com]:
Does the target system have more than one application tier server node (y/n) [n] ?:
Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:
Target system APPL_TOP mount point [/u01/oracle/visappl]:/d01/oracle/visappl
Target system COMMON_TOP directory [/u01/oracle/viscomn]:/d01/oracle/viscomn
Target system 8.0.6 ORACLE_HOME directory [/u01/oracle/visora/8.0.6]:/d01/oracle/visora/8.0.6
Target system iAS ORACLE_HOME directory [/u01/oracle/visora/iAS]:/d01/oracle/visora/iAS
Do you want to preserve the Display set to vision.erpstuff.com:0.0 (y/n) [y] ?:n
Target system Display [vision2:0.0]:
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n
Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.
Enter the port pool number [0-99]:
0
Checking the port pool 0
done: Port Pool 0 is free
Web Listener port is 8000
Complete port information available at /d01/oracle/visappl/admin/out/VIS2_vision2/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /d01/oracle/visdb/9.2.0/appsutil/outbound/VIS2_vision2
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:
Creating the new APPL_TOP Context file from :
/d01/oracle/visappl/ad/11.5.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/d01/oracle/visappl/admin/VIS2_vision2.xml
Log file located at /d01/oracle/viscomn/clone/bin/CloneContext_11080515.log
Running Rapid Clone with command:
perl /d01/oracle/viscomn/clone/bin/adclone.pl java=/d01/oracle/viscomn/clone/bin/../jre
mode=apply stage=/d01/oracle/viscomn/clone/bin/.. component=appsTier method=CUSTOM
appctxtg=/d01/oracle/visappl/admin/VIS2_vision2.xml showProgress contextValidated=true
All Rights Reserved 2006-07 72/173
Oracle Applications 11i – Administration www.erpstuff.com
Beginning application tier Apply - Wed Nov 8 17:18:21 2006
Log file located at /d01/oracle/visappl/admin/VIS2_vision2/log/ApplyAppsTier_11080518.log
17% completed
----------------------------------------------Completion Message--------------------------------------------------
Completed Apply...
Wed Nov 8 17:24:17 2006
Beginning APPSIAS_VIS2 registration to central inventory...
ORACLE_HOME NAME : APPSIAS_VIS2
ORACLE_HOME PATH : /d01/oracle/visora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_11080524.log
ERROR: Registration Failed... Please check log file.
You can rerun this registration with the following script:
/d01/oracle/viscomn/admin/out/VIS2_vision2/regOUI_APPSIAS_VIS2.sh
Starting application Services for VIS2:
Running:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adstrtal.sh APPS/
You are running adstrtal.sh version 115.14
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adapcctl.sh start
script returned:
****************************************************
adapcctl.sh version 115.43
Starting Apache Web Server Listener (dedicated HTTP) ...
Starting Apache Web Server Listener (dedicated PLSQL) ...
adapcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version
Checking for FNDFS executable.
Starting listener process APPS_VIS2.
adalnctl.sh: exiting with status 0
All Rights Reserved 2006-07 73/173
Oracle Applications 11i – Administration www.erpstuff.com
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 115.20
Starting concurrent manager for VIS2 ...
Starting VIS2_1108@VIS2 Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adfrmctl.sh start
script returned:
****************************************************
You are running adfrmctl.sh version 115.34
Starting forms server for VIS2 on port 9000.
adfrmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adrepctl.sh start
script returned:
****************************************************
You are running adrepctl.sh version 115.29
starting Reports Server for VIS2 on port 7000.
adrepctl.sh: exiting with status 0
All Rights Reserved 2006-07 74/173
Oracle Applications 11i – Administration www.erpstuff.com
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adfmcctl.sh start
script returned:
****************************************************
You are running adfmcctl.sh version 115.17
Starting forms load balancing client for VIS2.
adfmcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/adfmsctl.sh start
script returned:
****************************************************
You are running adfmsctl.sh version 115.13
starting forms metrics server for VIS2.
adfmsctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 115.16
Validating Fulfillment patch level via /d01/oracle/viscomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for VIS2 on port 9300 ...
jtffmctl.sh: exiting with status 0
All Rights Reserved 2006-07 75/173
Oracle Applications 11i – Administration www.erpstuff.com
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/viscomn/admin/scripts/VIS2_vision2/addisctl.sh start
script returned:
****************************************************
addisctl.sh version 115.14
/d01/oracle/visora/8.0.6/vbroker/bin/osagent
Started osagent.
Osagent logs messages to the file /d01/oracle/visora/8.0.6/discwb4/util/osagent.log.
Waiting for OAD to start...
Started OAD.
OAD logs messages to the file /d01/oracle/visora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /d01/oracle/visora/8.0.6/discwb4/util/locator.log.
Registering Discoverer Session
Completed registration of repository_id = IDL:DCISessionManager:1.0
object_name = vision2.erpstuff.com_8000OracleDiscovererSession4
reference data =
path_name = /d01/oracle/visora/8.0.6/discwb4/util/runses.sh
activation_policy = UNSHARED_SERVER
args = (length=4)[-session; vision2.erpstuff.com_8000OracleDiscovererSession4; -preference;
vision2.erpstuff.com._8000OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 192.168.0.39
Registering the Collector
Completed registration of repository_id = IDL:DCICollector:1.0
object_name = vision2.erpstuff.com_8000OracleDiscovererCollector4
reference data =
path_name = /d01/oracle/visora/8.0.6/discwb4/util/runcol.sh
activation_policy = SHARED_SERVER
args = (length=2)[-collector; vision2.erpstuff.com_8000OracleDiscovererCollector4; ]
env = NONE
for OAD on host 192.168.0.39
Applying preferences from file : /d01/oracle/visora/8.0.6/discwb4/util/pref.txt
Finished applying preferences
Closing down registry..
Registry File sync...
Registering Discoverer Preference Repository
Completed registration of repository_id = IDL:DCICORBAInterface:1.0
object_name = vision2.erpstuff.com_8000OracleDiscovererPreferences4
reference data =
path_name = /d01/oracle/visora/8.0.6/discwb4/util/runpref.sh
activation_policy = SHARED_SERVER
args = (length=2)[-preference; vision2.erpstuff.com_8000OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 192.168.0.39
addisctl.sh: exiting with status 0
All Rights Reserved 2006-07 76/173
Oracle Applications 11i – Administration www.erpstuff.com
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
Check logfile /d01/oracle/viscomn/admin/log/VIS2_vision2/11081724.log for details
Exiting with status 0
[oracle@vision2 bin]$
Note: The inputs in the above steps are in blue color while where default is accepted the
ENTER key is pressed. Like “Do you want to use a virtual hostname for the target node (y/n) [n] ?:” the
default is [n] so pressing just enter key means you selected n.
4.5. If status of all services is 0 then we have done with cloning.
4.6. Login in the application to confirm your cloning.
All Rights Reserved 2006-07 77/173
Oracle Applications 11i – Administration www.erpstuff.com
8 - Statistics Gathering
1. Gather Schema Statistics
1.1. To gather schema statistics we will submit a request using the requests window,
System Administrator: Requests > Run
1.2. Select Gather Schema Statistics from the LOV in Name field and then on Parameters
window select ALL in the Schema Name field.
Note: For further details of parameters click the Help (B) or for more details read about
GATHER_SCHEMA_STATS.
1.3. Click OK (button).
1.4. Now schedule as per your requirements. I have scheduled it to run this request every
Sunday mid night for one year.
All Rights Reserved 2006-07 78/173
Oracle Applications 11i – Administration www.erpstuff.com
1.5. On clicking OK (button) as we have selected Save this schedule the following window
will appear,
1.6. Enter Name and Description of the schedule and press OK (button).
1.7. Now on the main window Submit the request by clicking Request (button).
1.8. Also have a look on the following requests you may submit as per your requirements,
All Rights Reserved 2006-07 79/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. I had submitted a request to show the log file and next day I viewed the log file which is
show below,
Note: Please note the time taken on vision machine so it will vary on the size of data.
For this reason I scheduled it at mid night.
+---------------------------------------------------------------------------+
**Starts**15-SEP-2006 23:55:08
**Ends**16-SEP-2006 05:28:45
+---------------------------------------------------------------------------+
All Rights Reserved 2006-07 80/173
Oracle Applications 11i – Administration www.erpstuff.com
All Rights Reserved 2006-07 81/173
Oracle Applications 11i – Administration www.erpstuff.com
9 - Concurrent Manager
1. Purging Request of Concurrent Manager
1.1. Select request Purge Concurrent Request and/or Manager Data on the requests
window.
1.2. Select REQUEST in the Entity LOV.
Field Data Description
Entity REQUEST To purge the requests.
Mode Count Number of requests will be provided to retain them.
Mode Value 3 I have entered 3 which means leave latest 3 requests
and logs while purge all earlier requests. (if Age is
selected in the Mode then here the numbers mean the
number of days. Assume that we have selected Age in
the Mode field and in Mode Value we entered 365 then
last 365 days requests will not be purged so retaining 1
year data of requests and logs)
User Name XX_USER These requests and logs are very import so you must
ask the concerned departments that how long the
history need to be maintained. Here we will just purge
the requests of XX_USER.
All Rights Reserved 2006-07 82/173
Oracle Applications 11i – Administration www.erpstuff.com
1.3. Submit the request and then view the request status,
All Rights Reserved 2006-07 83/173
Oracle Applications 11i – Administration www.erpstuff.com
1.4. Our all old requests are no more in the requests window. It will also free space on hard
disk by deleting log files.
All Rights Reserved 2006-07 84/173
Oracle Applications 11i – Administration www.erpstuff.com
10 - VNC Configuration
VNC stands for Virtual Network Computing and it was developed at the Olivetti & Oracle
Research Laboratory (Cambridge, England) in 1994. Originally running on an ATM-connected thin
client device, it was ported to other platforms, including Win32, UNIX, GNU/Linux, and Mac OS. It
is a remote display system which allows a thin client (called the VNC viewer) to remotely access a
desktop GUI environment on another computer over the network. Since it is platform independent,
you can remotely run an Apple desktop from a Windows client, or a UNIX desktop from an Apple
client, and so on.
VNC allows viewing and operating the console of other computer remotely. Generally it is also
known as Remote Frame Buffer (RFB). This document covers the installation of VNC server on
Linux Redhat AS 4 and setting up VNC client on Windows XP machine to operate the Redhat Linux
server remotely.
1. Server Side Configuration
1.1. Login as root on Redhat Linux Server.
1.2. First we need to check the VNC packages installation.
rpm -qa | grep vnc
#rpm -qa | grep vnc
vnc-server-4.0-8.1
vnc-4.0-8.1
The vnc package is installed as shown above. If not then install vnc package.
1.3. To start the VNC on system boot time,
# chkconfig --level 345 vncserver on
chkconfig - is a simple command line tool to updates and queries runlevel information for system
services
--level Specifies the run levels where the operation should affect. It is given as a string of numbers
from 0 to 7. For example, --level 35 specifies runlevels 3 and 5.
0 – Halt
1 – Single User Mode
2 – User Defined
3 – Full Multi User Mode
4 – User Definable
5 – Full Multi User Mode (X-Based login screen)
6 – Reboot
All Rights Reserved 2006-07 85/173
Oracle Applications 11i – Administration www.erpstuff.com
We have used run levels 345 as shown above.
Note: On system reboot the VNC-based X sessions will be updated in the /etc/sysconfig/vncservers
file and will be start automatically.
1.4. The next step is to uncomment the following lines and add all the VNC sessions required
to start at the startup time in the /etc/sysconfig/vncservers file.
VNCSERVERS="1:root 2:oracle"
VNCSERVERARGS[1]="-geometry 800x600"
# vi /etc/sysconfig/vncservers
vncservers file before update
# The VNCSERVERS variable is a list of display:user pairs.
#
# Uncomment the line below to start a VNC server on display :1
# as my 'myusername' (adjust this to your own). You will also
# need to set a VNC password; run 'man vncpasswd' to see how
# to do that.
#
# DO NOT RUN THIS SERVICE if your local area network is
# untrusted! For a secure way of using VNC, see
# .
# VNCSERVERS="1:myusername"
# VNCSERVERARGS[1]="-geometry 800x600"
vncservers file before update
# The VNCSERVERS variable is a list of display:user pairs.
#
# Uncomment the line below to start a VNC server on display :1
# as my 'myusername' (adjust this to your own). You will also
# need to set a VNC password; run 'man vncpasswd' to see how
# to do that.
#
# DO NOT RUN THIS SERVICE if your local area network is
# untrusted! For a secure way of using VNC, see
# .
VNCSERVERS="1:root 2:oracle"
VNCSERVERARGS[1]="-geometry 800x600"
1.5. Now login as the user for whom you want to configure VNC or use this command to
login.
All Rights Reserved 2006-07 86/173
Oracle Applications 11i – Administration www.erpstuff.com
# su – oracle
1.6. Run the vncserver command to configure the VNC-based X session.
Note: Replace N (vncserver :N) with a number greater than zero. N represents the
VNC-based X session permanently assigned for a particular user. We will assign 1 as
number of sessions.
$ vncserver :1
You will require a password to access your desktops.
Password:
Verify:
xauth: creating new authority file /home/oracle/.Xauthority
New 'vision.erpstuff.com:1 (oracle)' desktop is vision.erpstuff.com:1
Creating default startup script /home/oracle/.vnc/xstartup
Starting applications specified in /home/oracle/.vnc/xstartup
Log file is /home/oracle/.vnc/vision.erpstuff.com:1.log
Note: The above command (vncserver :1) will create the $HOME/.vnc> directory for the
user and will ask for a VNC password. This password will be requested by the VNC viewer
program when connecting from a remote machine.
1.7. If the user wants to change the VNC password, in future the following command will be
used:
$ vncpasswd
Password:
Verify:
1.8. By default VNC uses the twm windows manager. We will configure GNOME (the default
environment in Red Hat Enterprise Linux) desktop environment.
Open the $HOME/.vnc/xstartup file using vi editor and comment out or delete the lines
that start with xterm and twm.
$ cd ~
$ pwd
/home/oracle
$ cd .vnc
$ vi xstartup
Add gnome-session & as shown below,
All Rights Reserved 2006-07 87/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. Save the file.
Note: If you want to use KDE, add the following line instead of gnome-session &,
startkde &
1.10. After setting the desktop, the existing VNC-based X session must be killed through this
command.
$ vncserver -kill :1
Killing Xvnc process ID 3218
1.11. Restart the VNC session for the effect of the changes. Enter the following commands to
restart the newly configured VNC session:
vncserver :1
New 'vision.erpstuff.com:1 (oracle)' desktop is vision.erpstuff.com:1
Starting applications specified in /home/oracle/.vnc/xstartup
Log file is /home/oracle/.vnc/vision.erpstuff.com:1.log
Server side configuration is competed now we will configure the Windows XP client machine.
2. Client Side Configuration
2.1. First of all we need the VNC viewer software. To download visit the following link,
http://www.realvnc.com/download.html
2.2. Download any of the following two options of VNC Free Edition Viewer for Windows.
All Rights Reserved 2006-07 88/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: If you are going to download Zip Archive then you need WinZip software to extract the
executable file.
http://www.winzip.com/
2.3. Extract or place the file in a folder on your local drive.
C:\vncviewer
2.4. On running the exe file on your windows client and the following screen will appear.
2.5. Enter IP address of your VNC server we configured above in the following format,
IP address :1
Note: For security reasons the IP address is not shown here but hope there should be
no issue in providing your server IP in this field. Don’t forget to click on Options button
to have few setting of vnc viewer.
2.6. Enter the password same we set above while configuring server side,
2.7. The following options screen will appear,
All Rights Reserved 2006-07 89/173
Oracle Applications 11i – Administration www.erpstuff.com
Note:
2.8. By default, VNC starts up only a simple window manager and a terminal window. To
avoid the above options screen we will perform the following steps and will uncomment
the unset and exec lines and will add shost + in the xstartup file as shown below,
2.9. Save the file after modification.
1.12. After setting the desktop, the existing VNC-based X session must be killed through this
command.
$ vncserver -kill :1
Killing Xvnc process ID 3218
1.13. Restart the VNC session for the effect of the changes. Enter the following commands to
restart the newly configured VNC session:
vncserver :1
New 'vision.erpstuff.com:1 (oracle)' desktop is vision.erpstuff.com:1
Starting applications specified in /home/oracle/.vnc/xstartup
Log file is /home/oracle/.vnc/vision.erpstuff.com:1.log
2.10. Here is the Linux Redhat server desktop on you windows XP client.
All Rights Reserved 2006-07 90/173
Oracle Applications 11i – Administration www.erpstuff.com
All Rights Reserved 2006-07 91/173
Oracle Applications 11i – Administration www.erpstuff.com
11 - NFS Configuration
NFS stands for the Network File System. It is used to share/map disk one Linux System to other
Linux System. NFS was developed to allow the user to access remote directory as a mapped
directory.
NFS is not a single program. It is a suite of related programs which work together.
• Portmap is the primary daemon. All other daemon rely on it. It manages connections for
applications that use the RPC (Remote Procedure Calls) specification, and it listens on port
111. The portmap daemon needs to be run on both the NFS server and client.
• NFS starts the RPC processes to serve shared NFS file systems. The NFS daemon needs to
be run on the NFS server only.
• Nfslock allows NFS client(s) to lock files on the server via RPC processes. The nfslock
daemon needs to be run on both the NFS server and client.
• Netfs allows RPC processes to run on NFS client(s) to mount server directory. The nfslock
daemon needs to be run on the NFS client only.
1. NFS Installation (Both Nodes)
1.1. Login as root on Redhat Linux Server.
1.2. First we need to check the NFS packages installation.
1.3. NFS is installed by default in Redhat Linux. To check whether the NFS installed or not
we will use the RPM command with the grep command to search NFS packages.
# rpm -qa | grep nfs
system-config-nfs-1.2.8-1
nfs-utils-1.0.6-65.EL4
or
All Rights Reserved 2006-07 92/173
Oracle Applications 11i – Administration www.erpstuff.com
# rpm -q system-config-nfs
system-config-nfs-1.2.8-1
# rpm -q nfs-utils
nfs-utils-1.0.6-65.EL4
# rpm -q portmap
portmap-4.0-63
1.4. If NFS and portmap are not installed then we use the following command to install
them. Filenames usually start with the name of software and a version number as
shown below,
# rpm -Uvh nfs-utils-1.1.3-1.i386.rpm
Note: Perform the above mentioned steps on both Server and Client machines.
2. Server Side Configuration (Host)
2.1. The first step is to login as root user.
2.2. Create a directory,
# mkdir data
# cd data
# mkdir files
2.3. Now open the /etc/exports file in vi editor and update the entries as per requirement.
Here in this tutorial we will give access to all IP’s by placing a *. The /etc/exports allows
the clients and authenticates the user coming from the remote client(s),
# vi /etc/exports
/data/files *(rw,sync)
Note(s):
o Here * means access to all IP’s while we can restrict by providing IP address like,
[/data/files IP Address(rw,sync)].
o You can force your system to re-read the /etc/exports file after changing exports file by
using following commands.
$ exportfs –a (If directories are not yet exported to NFS.)
$ exportfs –r (To export only the new entries.)
2.4. We will use chkconfig to configure NFS to auto start on system startup. The chkconfig
command configures required daemons to start at boot time.
# chkconfig --level 35 nfs on
# chkconfig --level 35 nfslock on
All Rights Reserved 2006-07 93/173
Oracle Applications 11i – Administration www.erpstuff.com
# chkconfig --level 35 portmap on
2.5. Start the NFS services and other related demons,
# service portmap start
Starting portmap: [ OK ]
# service nfs start
Starting NFS services: [ OK ]
Starting NFS quotas: [ OK ]
Starting NFS daemon: [ OK ]
Starting NFS mountd: [ OK ]
# service nfslock start
Starting NFS statd: [ OK ]
Note: To check the current status of service use status instead of start.
2.6. Check the NFS status if it is running correctly or not with the rpcinfo command,
# rpcinfo -p localhost
3. Configuring NFS on the Client (Guest)
All Rights Reserved 2006-07 94/173
Oracle Applications 11i – Administration www.erpstuff.com
3.1. Login as the root user.
3.2. To auto start NFS use chkconfig command as we used above.
# chkconfig --level 35 netfs on
# chkconfig --level 35 nfslock on
# chkconfig --level 35 portmap on
3.3. To start the services of NFS and other related daemons.
# service portmap start
Starting portmap: [ OK ]
# service netfs start
Mounting other filesystems: [ OK ]
# service nfslock start
Starting NFS statd: [ OK ]
3.4. Test NFS status with rpcinfo command.
# rpcinfo -p
3.5. Mount Points (Creation & Activation)
3.5.1. Auto & Permanent
3.5.1.1. Create a mount point directory to mount with the remote NFS directory
and activate it through these commands.
$ mkdir /mnt/nfs
3.5.1.2. To make NFS mounted directories permanent we will add entries in the
/etc/fstab file in addition to the creation of the mount point directory. The
/etc/fstab file lists all the partitions that need to be auto-mounted when
the system boots.
# vi /etc/fstab
#Directory Mount Point Type Options Dump FSCK
IP Address (server):/data/files /mnt/nfs nfs soft,nfsvers=2 0 0
All Rights Reserved 2006-07 95/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: There are many versions of NFS but the most popular is version 2. To be safe,
use the NFS server to export version 2 directories by using the nfsvers=2 option in
/etc/fstab file as shown above.
3.6. To active the above created mount point,
# mount –a
3.6.1. Manual
The manual mount will remain till you will not restart the machine so it is not
permanent.
3.6.1.1. Create the mount point directory if not created above,
$ mkdir /mnt/nfs
$ mount -t nfs IP Address (Server):/data/files /mnt/nfs
4. Deleting, Moving Or Modifying A Share
To remove an exported directory from the /etc/exports file you need to perform the following
steps on NFS client and server.
4.1. Client
4.1.1. Unmount the NFS mount point /mnt/nfs directory from the client using the
following command.
$ umount /mnt/nfs
Note: You will have to update /etc/fstab file if you have entries for auto mounting at each
reboot.
4.2. Server
4.2.1. Remove the entries in the NFS server’s /etc/exports file and reload with the
following commands.
$ exportfs -ua
All Rights Reserved 2006-07 96/173
Oracle Applications 11i – Administration www.erpstuff.com
12 - Display Settings
1. Display Settings
When you will receive the following error while running reports with output set to PDF then you
need to set Display Settings (Oracle Toolkit).
1.1. Login as Oracle user on Linux server locally.
1.2. Update the DisallowTCP and set to false in the gdm.conf file on application server
machine.
/etc/X11/gdm
1.3. Open the file in any editor
$ vi/etc/X11/gdm/gdm.conf
1.4. Open the terminal window and execute the following statements.
$ set DISPLAY=localhost:0.0
$ xhost +
$ export DISPLAY=localhost:0.0
$ xhost + localhost
localhost being added to access control list
All Rights Reserved 2006-07 97/173
Oracle Applications 11i – Administration www.erpstuff.com
1.5. To verify display settings use xclock or xterm.
$ xclock
$ xterm
Note: If these windows are displayed then it means that display settings are ok.
1.6. Alternatively make the following change in the adrepctl.sh file. This will eliminate the
above manual steps on each restart of server.
$ vi /oracle/prodcomn/admin/scripts/ VIS_vision/adrepctl.sh
1.7. Insert xhost + and save the file. Now each time when you will start the apps services
display setting will be set.
1.8. Open the .bash_profile of Oracle user,
All Rights Reserved 2006-07 98/173
Oracle Applications 11i – Administration www.erpstuff.com
$ cd ~ “go to home folder of oracle user”
$ vi .bash_profile
1.9. Insert the following line,
export DISPLAY="vision:0.0"
Note: These settings will only work if the user Oracle will remain logged in.
All Rights Reserved 2006-07 99/173
Oracle Applications 11i – Administration www.erpstuff.com
13 - OS Auto login
1. Setting Auto Login on Linux
You may be interested that the server should be auto login as Oracle user in case of restart.
1.1. Login as root user and open Login Screen,
Linux: Applications > System Settings > Login Screen
1.2. Provide the information by clicking Automatic Login,
All Rights Reserved 2006-07 100/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: To make sure that Oracle user will be logged in always the Timed Login settings are
shown in the screen. These are for DISPLAY SETTINGS as you always need the Oracle user
to be logged in.
All Rights Reserved 2006-07 101/173
Oracle Applications 11i – Administration www.erpstuff.com
14 - ADI Setup
1. ADI Setup for Oracle Apps 10.2
1.1. Enter name “Vision” and Description “ADI Setup for demo” on the following screen.
1.2. Now we will connect as System Administrator to our Oracle Applications instance to get
the GWYUID and FNDNAM.
1.3. From the menu, click Help > Diagnostics > Examine and provide the required
password like default is apps.
1.4. In Block click the down arrow and select $ENVIRONMENT$.
1.5. In the Field select FNDNAM from the drop down menu.
1.6. Note the value appeared in the Value.
All Rights Reserved 2006-07 102/173
Oracle Applications 11i – Administration www.erpstuff.com
1.7. Now to find the value of GWYUID enter same value $ENVIRONMENT$ while enter select
GWYUID in the Field.
1.8. Note down the Value appeared.
1.9. Get the connecting string from your tnsnames.ora. Here the connecting string is vis.
1.10. Now to connect 11.5.10.2 instances you need Server ID and for this you need to
perform the following steps.
1.10.1. Find the dbc file under: $FND_TOP/secure directory.
1.10.2. Note the APPL_SERVER_ID value from the dbc file.
1.10.3. In my case it is,
“0DC6A6EC525DC79EE040A8C02400763C16703932431758261858402452316640
”.
or login as apps user and execute the following query.
select node_name, server_id
from fnd_nodes
Note: This Server ID is required for 11.5.10.2 instances.
1.11. We will enter all the values as show in the following screen.
All Rights Reserved 2006-07 103/173
Oracle Applications 11i – Administration www.erpstuff.com
1.12. Click on the Tick sign and provide Username, password and Database to connect.
All Rights Reserved 2006-07 104/173
Oracle Applications 11i – Administration www.erpstuff.com
15 - Reports Integration
1. Sample report Development
For Development and deployment you should have Oracle Reports Builder 6i with latest patch
applied and Access to deploy reports and copy file on server.
1.1. For demonstration I have developed a simple listing report using Oracle Report Builder
and here is the query with single parameter.
Note: Note the parameters (TOKENS) like here it is :P_SET_OF_BOOKS_ID.
All Rights Reserved 2006-07 105/173
Oracle Applications 11i – Administration www.erpstuff.com
1.2. Save the report as CGLTESTREP where I have used C for customized reports. While
saving be careful that extension rdf must be in small characters as by default reports
builder saves in capital letters.
1.3. Copy the file on server in /u01/oracle/visappl/gl/11.5.0/reports/US folder.
1.4. Verify file extension as it should be is small letters.
$>ls CGLTESTREP.*
CGLTESTREP.rdf
2. Integration in Applications
1.1. Login to Oracle Applications with System Administrator Responsibility.
1.2. Open the Executable screen to register the report.
Sys Admin : Concurrent > Program > Executable
1.3. Provide the information as shown below and save the record.
All Rights Reserved 2006-07 106/173
Oracle Applications 11i – Administration www.erpstuff.com
1.4. The next step is to define the report and its parameters by using the Define screen.
Sys Admin : Concurrent > Program > Define
1.5. Select your desired Output Format from the list (HTML, PCL, PDF, PostScript, Text and
XML), here I have selected PDF.
1.6. After providing all the required information on Definition main screen click Parameters
(button) to provide parameters of the report.
All Rights Reserved 2006-07 107/173
Oracle Applications 11i – Administration www.erpstuff.com
Sr. Parameter Value Set Default Default Value Prompt Token
# Name Type
10 Set of GL_SRS_NULL_NUM Profile GL_SET_OF_BKS_ID Set Of P_SET_OF_BOOKS_ID
Books ID Books
ID
Note: Define all the parameters of report as here we have only one so we will just save the record
and will close the form.
1.7. Now the next question is who can access this report? To do so we have to assign a
Request Group.
1.8. To find the Request Group open the responsibility screen and search “General Ledger
Super user” responsibility.
Sys Admin : Security > Responsibility > Define
All Rights Reserved 2006-07 108/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. Copy or note the Request Group Name which is “GL Concurrent Program Group”.
1.10. Now to add the report to this Request Group we will open the Request screen,
Sys Admin : Security > Responsibility > Request
1.11. Query to find the Request Group “GL Concurrent Program Group”.
1.12. Add a record and enter report name in the name field as shown below.
All Rights Reserved 2006-07 109/173
Oracle Applications 11i – Administration www.erpstuff.com
1.13. Save the information.
1.14. Now to check the integrated report switch to General Ledger responsibility and submit a
request.
All Rights Reserved 2006-07 110/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: If the report failed and following error of Oracle Toolkit appears then you will have to set
the Display Settings. For this search Display Settings in this document.
3. Reports output in Excel
We can get the text reports output in excel instead of browser. The steps are as below,
1.1. Login as System Administrator and open the Viewer Options screen,
Sys Admin : Install > Viewer Options
1.2. Create a new Viewer option with the following input data,
File Format Text
Mime Type application/vnd.ms-excel
All Rights Reserved 2006-07 111/173
Oracle Applications 11i – Administration www.erpstuff.com
Description Microsoft Excel 11i (Your choice)
1.3. Save the data.
1.4. Open System Profile screen and search Viewer: Application for Text,
1.5. Select the defined viewer option. Like here we had defined Microsoft Excel 11i for user
XX_USER.
All Rights Reserved 2006-07 112/173
Oracle Applications 11i – Administration www.erpstuff.com
1.6. Logout and login again to submit a report.
1.7. Submit a text report like Active Users and the view its output.
1.8. After completion click View Output (button) and a MS Internet Explorer dialog will
appear. Click Open (button) on the dialog and the report will be displayed in MS Excel.
All Rights Reserved 2006-07 113/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: If this dialog is not appearing then follow the following steps to enable download
settings of MS Internet Explorer.
1.9. To enable download settings,
IE Menu: Tools > Security > Internet > Custom Level > Downloads
All Rights Reserved 2006-07 114/173
Oracle Applications 11i – Administration www.erpstuff.com
1.10. Ensure that Download settings are enabled.
Note: These download settings are important to set if you are trying to export data from a
form of any module using Menu > File > Export.
All Rights Reserved 2006-07 115/173
Oracle Applications 11i – Administration www.erpstuff.com
16 - Browser Settings
The following are recommended Microsoft Internet Explorer settings for Oracle Applications.
1. Security Zones
There are four security zones in MSIE and Oracle recommends security setting at Medium. Which
zone is used is dependant how you are accessing your site (Internet or Local Intranet) and set up
within the zones themselves (Trusted sites & restricted sites).
Zone Usage Default
Internet Web sites not placed in other zones Medium
Local intranet Web sites on your organization's intranet Medium-Low
Trusted sites Web sites you trust not to damage your computer Low
Restricted sites Web sites that could potentially damage your computer High
1.1. The Trusted Sites zone is recommended with a 'Medium' Security Setting. Open the
Security tab,
MSIE: Menu > Tools > Internet Options > Security tab > Trusted Sites icon > Sites
All Rights Reserved 2006-07 116/173
Oracle Applications 11i – Administration www.erpstuff.com
1.2. Uncheck the check box “Require server verification (https:() for all sites in this zone”.
All Rights Reserved 2006-07 117/173
Oracle Applications 11i – Administration www.erpstuff.com
1.3. Add the applications hostname and domain.
1.4. Click add (button) to add the link in the Trusted Websites.
2. JInitiator
JInitiator 1.3.1.x versions will download and install on any security setting except High, therefore
the security setting should not need any adjustments at download and install time.
3. Page Refresh
When using Oracle Self-Service products to view the most current data the following settings need
to be set in MSIE.
3.1. To set 'Page Refresh',
MSIE: Menu > Tools > Internet Options > General tab > Settings
3.2. The option 'Every visit to the page' should be checked.
4. Shared Desktop Security
If a PC is shared by multiple users then encrypted pages should not be saved on the pc locally.
4.1. Open the Advanced tab of Internet Options,
MSIE: Menu > Tools > Internet Options > Advanced tab > Security
All Rights Reserved 2006-07 118/173
Oracle Applications 11i – Administration www.erpstuff.com
4.2. Check the box of 'Do not save encrypted pages to Disk'. Click OK to confirm changes.
5. Auto complete in Internet Explorer
MSIE automatically displays the last entered values so for security reason it is better to disable this
option.
5.1. Open Content tab,
MSIE: Menu > Tools > Internet Options > Content
All Rights Reserved 2006-07 119/173
Oracle Applications 11i – Administration www.erpstuff.com
5.2. Click Settings (button) of AutoComplete region and uncheck 'Forms' and 'User names
and passwords on forms'. Click OK to confirm the changes.
6. HTTP 1.1/Keep Alive Settings
All Rights Reserved 2006-07 120/173
Oracle Applications 11i – Administration www.erpstuff.com
For Oracle Applications version 11.5.9 or later “HTTP 1.1/Keep Alive” should be enabled.
6.1. Open the Advanced tab,
MSIE: Menu > Tools > Internet Options > Advanced
6.2. Under HTTP 1.1 Settings both options “Use HTTP 1.1” and “Use HTTP 1.1 through proxy
connections” should bi checked.
All Rights Reserved 2006-07 121/173
Oracle Applications 11i – Administration www.erpstuff.com
17 - Forms Personalization
1. Personalize fields properties
In this topic we will personalize three properties of user definition form.
Field Action
Person Change title to Employee
E-Mail Hide the field.
Fax Hide the field.
1.5. Login as Sys Admin and open the user form,
Sys Admin: Security > User > Define
1.6. Open the personalize form,
Menu > Help > Diagnostics > Custom Code > Personalize
All Rights Reserved 2006-07 122/173
Oracle Applications 11i – Administration www.erpstuff.com
1.7. Provide apps password on the displayed dialog.
1.8. Enter the required data and select WHEN-NEW-FORM-INSTANCE as trigger event.
1.9. Click the Actions (tab) and click in the first row,
1.10. Now click in the next row to set properties of E-Mail field.
All Rights Reserved 2006-07 123/173
Oracle Applications 11i – Administration www.erpstuff.com
1.11. Click in the next row to set properties of Fax field.
1.12. Save the information.
1.13. Close both Personalization and Users form.
1.14. Open the user definition form as this time our trigger will execute.
All Rights Reserved 2006-07 124/173
Oracle Applications 11i – Administration www.erpstuff.com
1.15. View the changes.
All Rights Reserved 2006-07 125/173
Oracle Applications 11i – Administration www.erpstuff.com
18 - Change Color Scheme
1. Changing color scheme
1.1. Login as Sys Admin and open the System profiles,
Sys Admin: Profile > System
1.2. As we will change the color scheme only for our XX_USER so enter the user name in the
User field and Java Color Scheme in the Profile field.
1.3. Click on Find (button).
All Rights Reserved 2006-07 126/173
Oracle Applications 11i – Administration www.erpstuff.com
1.4. Under the User name open LOV and select a color like I have selected blue.
1.5. Click the OK (button).
1.6. Save the data and logout from the Oracle Applications.
1.7. Now login as XX_USER and view the color change.
All Rights Reserved 2006-07 127/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: The above change will only work for XX_USER as we changed color scheme only for
this user. For a Site level change do not provide user.
All Rights Reserved 2006-07 128/173
Oracle Applications 11i – Administration www.erpstuff.com
19 - Printer Configturation
1. Configuring Windows Shared Printer on Linux
1.1. Login as root on Linux Server (Oracle Applications Server),
Linux AS 4 : Applications > System Settings > Printing
1.2. Click New (button).
1.3. Click Forward (button).
All Rights Reserved 2006-07 129/173
Oracle Applications 11i – Administration www.erpstuff.com
1.4. Enter Queue name in the name field and a short description.
1.5. Click Forward (button).
1.6. Select a queue type by clicking on LOV.
All Rights Reserved 2006-07 130/173
Oracle Applications 11i – Administration www.erpstuff.com
1.7. Select Networked Windows (SMB).
Note: For security reasons the Share names are removed from the above window.
1.8. Click Specify (button).
All Rights Reserved 2006-07 131/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. Here the Server is the windows XP machine (name / IP address) where printer is
installed. In the Share field enter windows XP machine (name / IP address) and the
printer share name. The next field is User name here provide domain name ,user name
and provided windows domain password in the Password field.
1.10. Click OK (button).
1.11. Select the Queue and click Forward (button).
All Rights Reserved 2006-07 132/173
Oracle Applications 11i – Administration www.erpstuff.com
1.12. Select the manufacturer.
1.13. Select HP as the manufacturer.
All Rights Reserved 2006-07 133/173
Oracle Applications 11i – Administration www.erpstuff.com
1.14. Select or type LaserJet 1200.
Note: The text box will appear when you will start typing.
1.15. Click Forward (button).
1.16. Confirm the Type, Share and Printer and Click Finish (button).
All Rights Reserved 2006-07 134/173
Oracle Applications 11i – Administration www.erpstuff.com
1.17. Click Yes if you want to print a test print.
Note: If you will not take a test print then on next screen you will have to click Apply (button)
to save the settings.
1.18. If test print is printed then click Apply (button).
All Rights Reserved 2006-07 135/173
Oracle Applications 11i – Administration www.erpstuff.com
2. Defining Printer in Oracle Applications
We will use default definitions of Printer Drivers, Print Styles and Printer Types as most of the
drivers of common printer are already provided by Oracle in Oracle Applications. In case you have
a printer of which drivers are not defined then you will have to provide information on these
screens.
2.1. Login as XX_USER and switch to SYSADMIN responsibility,
Sysadmin : Install > Printer > Driver
2.2. To define Printer Drivers the SRW Driver will be used while defining Print Styles so
keep in mind while entering information in this field. The Arguments, Initialization and
Reset settings will be available in the printer manual or ask your hardware vendor.
2.3. To define Printer Style open the Style screen,
Sysadmin : Install > Printer > Style
2.4. Provide Style Name, SRW Driver and other required information.
All Rights Reserved 2006-07 136/173
Oracle Applications 11i – Administration www.erpstuff.com
2.5. The next step is to define Printer Type.
Sysadmin : Install > Printer > Types
2.6. Provide Style defined earlier.
2.7. Now we will define the printer by providing Printer name which we configured on Linux
machine.
Sysadmin : Install > Printer > Register
2.8. Enter HPLaser in the Printer field and select HPLJ4 in the Type field.
All Rights Reserved 2006-07 137/173
Oracle Applications 11i – Administration www.erpstuff.com
3. Reports Printing using above Defined Printer
3.1. Submit a new request of Active Users Report,
3.2. Click Options (button).
All Rights Reserved 2006-07 138/173
Oracle Applications 11i – Administration www.erpstuff.com
3.3. Select HPLaser in the Printer field and enter 1 in the Copies field.
3.4. Click OK (button).
3.5. Report should be printed otherwise verify the above steps.
3.6. We can also assign Printer to Concurrent Programs. Open the Concurrent Programs
screen,
Sysadmin : Concurrent > Program > Define
3.7. Search Active Users program.
All Rights Reserved 2006-07 139/173
Oracle Applications 11i – Administration www.erpstuff.com
3.8. Select HPLaser in the Output Printer.
3.9. Save the information.
3.10. Submit a new request of Active Users and check that HPLaser is the default printer in
the Print to field.
All Rights Reserved 2006-07 140/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: Default is 0 in the Copies field and you can change it by changing system profile
Concurrent:Report Copies. Here you can provide by clicking the Options (button).
All Rights Reserved 2006-07 141/173
Oracle Applications 11i – Administration www.erpstuff.com
20 - Printer Page
Customization
1. Page Size Customization
While printing checks (cheques) and invoices there is always a requirement to customize the page
size on dot matrix printers while printing on the scroll (continuous paper sheet). Here for
demonstration I have selected EPSON LQ-300+ and will demonstrate on Windows XP operating
system.
1.1. Login as local administrator on your Windows XP machine,
Windows : Start > Printer and Faxes
All Rights Reserved 2006-07 142/173
Oracle Applications 11i – Administration www.erpstuff.com
1.2. Install the drivers of your printer if not already installed. Here we have EPSON LQ-
300+ESC/P 2 installed.
1.3. Click (single) on the installed printer and from menu File > Server Properties
All Rights Reserved 2006-07 143/173
Oracle Applications 11i – Administration www.erpstuff.com
1.4. Select any Form and enable the check box Create a new form.
1.5. Provide Form name and provide your desired Paper size (Width & Height) in inches.
Form name Erpstuff paper size 8.50x4.00
Width 8.50in (inches)
Heigh 4.00in (inches)
1.6. Click OK (button) to save the settings.
1.7. Now open the properties page of your printer by right clicking the printer icon.
All Rights Reserved 2006-07 144/173
Oracle Applications 11i – Administration www.erpstuff.com
1.8. Click Printing Preferences (button) and select Paper Size erpstuff paper size
8.50x4.00.
All Rights Reserved 2006-07 145/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. Click OK (button) on all screens to save the changes.
1.10. Send a print from Oracle Report Builder.
All Rights Reserved 2006-07 146/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: The layout of the reports developed in Oracle Report Builder 6i based on scott
schema.
1.11. Make sure the proper Printer Name is selected.
1.12. Make sure the proper Printer Name is selected and also verify the Properties.
1.13. Take the printout from the printer and match with your requirements.
All Rights Reserved 2006-07 147/173
Oracle Applications 11i – Administration www.erpstuff.com
All Rights Reserved 2006-07 148/173
Oracle Applications 11i – Administration www.erpstuff.com
All Rights Reserved 2006-07 149/173
Oracle Applications 11i – Administration www.erpstuff.com
21 - Menu, Responsibility &
User
1. Customized Menu Definition
Here we will create a customized menu and a responsibility. Then menu will be assigned to this
responsibility. I have selected AP Super User menu to find the name of Invoices Submenu.
1.1. Open the Menu form,
Sys Admin : Application > Menu
1.2. Search AP_NAVIGATE_GUI12 menu,
1.3. Note/Copy the Submenu of Invoices which is AP_INVOICES_GUI12 so we will assign the
entire invoice related Functions to our new menu.
1.4. Again query the menu AP_INVOICES_GUI12.
All Rights Reserved 2006-07 150/173
Oracle Applications 11i – Administration www.erpstuff.com
1.5. So we will assign this menu to our responsibility and the user will have these functions
to which we will assign that responsibility.
2. Responsibility Creation to Assign Menu
2.1. Open the Define form,
Sys Admin: Security > Responsibility > Define
2.2. Enter the required information and in Menu enter AP_INVOICES_GUI12.
All Rights Reserved 2006-07 151/173
Oracle Applications 11i – Administration www.erpstuff.com
2.3. Save the data.
3. Responsibility Assignment to User
3.1. Open the User form,
Sys Admin: Security > User > Define
3.2. Search the XX_USER (you can search the user to which you want to assign) and assign
XX AP Invoice Entry responsibility.
All Rights Reserved 2006-07 152/173
Oracle Applications 11i – Administration www.erpstuff.com
3.3. Save the data.
3.4. Switch to XX AP Invoice Entry responsibility and the following functions will be
displayed.
All Rights Reserved 2006-07 153/173
Oracle Applications 11i – Administration www.erpstuff.com
22 - Descriptive Flexfields
(DFF)
The most powerful feature of Oracle Applications is the Flexfield feature. It can be defined as “A
flexfield is a field which contains sub-fields or segments”. There are two types of flexfields,
accounting flexfield (AFF) and descriptive flexfield (DFF). Both flexfields contain segments where
each segment has a name and set of valid values.
DFF is used to capture descriptive information. As Oracle has provided maximum fields to capture
information on each screen but few companies still want to capture more data on certain screen
but in a different way. For example on Oracle Assets you want to capture computers detailed
information like RAM, HDD, CDD, Mother board etc. So one way for Oracle was to add such fields
on the form for you but just think that Oracle Applications is not specific to computer companies.
Here there is a need of DFF. It is context sensitive and for each context value different fields
would be available. Just for understanding let me give another example as DFF is bit confusing. A
company requirement is to capture different detail of computer parts CDD, RAM, HDD, Monitor for
each will have different sort of info,
CDD: Make, Speed
Monitor: Make, Size, Serial no
So in the context value when the user will select CDD two fields Make, Speed will be displayed for
input while on select of Monitor Make, Size and Serial no. I hope it would be enough for
understanding DFF.
1. Locating Descriptive Flexfield (DFF) on the Form
In this topic we will define a DFF on Paybles Invoice Distributions form. The first question is how
we can know which DFF is for that form. So we will discuss that how to locate a DFF on a form.
1.1. Open the Invoices form,
Payables: Invoices > Entry > Invoices
1.2. Search any entered invoice so you can move in the form or enter a new one.
All Rights Reserved 2006-07 154/173
Oracle Applications 11i – Administration www.erpstuff.com
1.3. Click on Distributions (button).
1.4. Open the Examine from Menu: Help > Diagnostic > Examine.
1.5. Provide the APPS password if prompted.
All Rights Reserved 2006-07 155/173
Oracle Applications 11i – Administration www.erpstuff.com
1.6. Note the value of Block D_SUM_FOLDER field and click the LOV button of Block field.
1.7. Select $DESCRIPTIVE_FLEXFIELD$ and click OK (button).
1.8. Locate D_SUM_FOLDER here it is D_SUM_FOLDER.DIST_DF and click OK (button).
All Rights Reserved 2006-07 156/173
Oracle Applications 11i – Administration www.erpstuff.com
1.9. Note the value displayed Invoice Distribution (Payables). Here the Invoice
Distribution is DFF name and Payables is the name of application.
2. Defining Descriptive Flexfield (DFF)
2.1. Open the Segments form,
Payables: Setup > Flexfield > Descriptive > Segments
Or
Sys Admin: Application > Flexfield > Descriptive > Segments
2.2. Search for Application Payables and Title Invoice Distribution.
2.3. Elements defined as Global Data Elements will be for each transaction so we can also
call that these will be used as header. Soon you will know.
2.4. Enter the information in the required fields.
All Rights Reserved 2006-07 157/173
Oracle Applications 11i – Administration www.erpstuff.com
2.5. I have assigned Value Set 16 Characters so the length will be of 16 characters. If you
will not assign Value Set then a warning message will appear that it will truncate the
field. I have created only one element so you can create more.
2.6. Save the data.
All Rights Reserved 2006-07 158/173
Oracle Applications 11i – Administration www.erpstuff.com
2.7. In the second line enter Freight as code and then click Segments (button).
2.8. Enter the following information.
Number Name Window Prompt Column
10 Common Common ATTRIBUTE1
2.9. Save the data.
2.10. Now we will define for Imports.
All Rights Reserved 2006-07 159/173
Oracle Applications 11i – Administration www.erpstuff.com
2.11. Click Segments (button).
2.12. Enter the following information.
Number Name Window Prompt Column
10 LC Number LC No ATTRIBUTE1
20 Shipment Number Shipment No ATTRIBUTE13
30 Expense Head Expense Head ATTRIBUTE15
40 Expense Sub Head Expense Subhead ATTRIBUTE2
All Rights Reserved 2006-07 160/173
Oracle Applications 11i – Administration www.erpstuff.com
2.13. Save and close this form.
2.14. Create another line for Insurance.
2.15. Click Segments (button).
2.16. Enter the following information.
Number Name Window Prompt Column
10 Name of Insurer Name of Insurer ATTRIBUTE1
20 Nature of Policy Nature of Policy ATTRIBUTE2
30 Next Premium Due Next Premium Due ATTRIBUTE3
All Rights Reserved 2006-07 161/173
Oracle Applications 11i – Administration www.erpstuff.com
2.17. Save and close this form.
2.18. On the main form create a line for Rent and enter the following information.
Number Name Window Prompt Column
10 Location Location ATTRIBUTE1
20 Address Address ATTRIBUTE2
30 Nature Nature ATTRIBUTE3
40 Monthly Rent Monthly Rent ATTRIBUTE4
50 Lease Term Lease Term ATTRIBUTE5
2.19. Save and close this form.
All Rights Reserved 2006-07 162/173
Oracle Applications 11i – Administration www.erpstuff.com
2.20. On the main form create a line for Utilities and enter the following information.
Number Name Window Prompt Column
10 Type of Expense Type of Expense ATTRIBUTE1
20 Period of Expense Period of Expense ATTRIBUTE2
30 Meter Number Meter Number ATTRIBUTE3
40 Telephone Number Telephone Number ATTRIBUTE4
2.21. Save and close this form.
2.22. On the main form create a line for Vehicle Running and enter the following information.
Number Name Window Prompt Column
10 Common Common ATTRIBUTE1
All Rights Reserved 2006-07 163/173
Oracle Applications 11i – Administration www.erpstuff.com
2.23. Save and close this form.
2.24. Enable Check box Freeze Flexfield Definition and save. The DFF definition will be
compiled.
All Rights Reserved 2006-07 164/173
Oracle Applications 11i – Administration www.erpstuff.com
2.25. Click OK (button).
3. Entry in Defining Descriptive Flexfield (DFF)
3.1. Open the Invoices form,
Payables: Invoices > Entry > Invoices
3.2. Create a new invoice.
3.3. Click Distribution (button).
3.4. Enter the required information.
All Rights Reserved 2006-07 165/173
Oracle Applications 11i – Administration www.erpstuff.com
3.5. Click the field labeled [].
3.6. Here Customer Invoice No is our Global and this will be entered for all type of expenses.
3.7. Click the Select the Expense Type field.
3.8. Select Insurance (or any which you want to enter information for) and enter the
information in the fields displayed for that Expense type.
All Rights Reserved 2006-07 166/173
Oracle Applications 11i – Administration www.erpstuff.com
Note: As we have not assigned any Value Set so here we can see that our fields length is
truncated and we need to scroll.
3.9. Here I have selected Utilities and the fields are displayed which were defined for
Utilities.
All Rights Reserved 2006-07 167/173
Oracle Applications 11i – Administration www.erpstuff.com
23 - FNDCPASS
1. Using FNDCPASS to change APPS password
1.1. Login as oracle user on application tier,
1.2. Set environment variables,
$ cd /d01/oracle/visappl
$. ./ APPSORA.env
$ echo $ORACLE_HOME
/d01/oracle/visora/8.0.6
1.3. Enter FNDCPASS on command line to get help.
1.4. Now we will change the password of APPS and APPLSYS with the following command,
$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS welcome
Log filename : L381345.log
Report filename : O381345.out
1.5. Open the log file using vi editor as above our log file is L381345.log as shown below.
All Rights Reserved 2006-07 168/173
Oracle Applications 11i – Administration www.erpstuff.com
1.6. Check the status which is showing completed successfully.
1.7. Now execute autoconfig.
$ cd /d01/oracle/viscomn/admin/scripts/VIS_vision
$ adautocfg.sh
Enter the APPS user password: [here give our new password which is welcome]
All Rights Reserved 2006-07 169/173
Oracle Applications 11i – Administration www.erpstuff.com
1.8. Wait for autoconfig completion and check the log file for any error using vi editor.
1.9. If successful then login to the application using browser. You can also check from
sqlplus by login with new password.
$ sqlplus apps/welcome
2. Changing Application User (sysadmin) Password
2.1. Now we will use the USER mode to change the application user password like sysadmin.
2.2. Enter the following command in which the new password is be welcome.
$ FNDCPASS apps/apps 0 Y system/manager USER sysadmin welcome
2.3. Check the log file if any error.
2.4. Open the application and login as sysadmin with this new password.
3. Change Single Oracle User Password
3.1. To change single Oracle user password like changing the password of GL, AP, AR etc we
will use the following command with ORACLE mode.
$ FNDCPASS apps/apps 0 Y system/manager ORACLE GL gl123
3.2. Check the log file if any error.
3.3. To verify the change open sqlplus,
$ sqlplus gl/gl123
All Rights Reserved 2006-07 170/173
Oracle Applications 11i – Administration www.erpstuff.com
4. Change All Oracle Users Passwords
4.1. To use ALLORACLE mode of FNDCPASS you will have to apply a stand alone patch#
4745998 (30MB) or its latest replacement patch# 4676589 (330MB). You will have to
download it from metalink and apply.
Note: There are 3 types of schema passwords,
All Rights Reserved 2006-07 171/173
Oracle Applications 11i – Administration www.erpstuff.com
1. First type is APPLSYSPUB and the default password is 'PUB'.
2. The 2nd type are schemas APPLSYS and APPS and the default password of both is
'APPS'.
3. In 3rd type the product-specific base schemas having same passwords as schema name
like GL/GL.
Important: The ALLORACLE mode is used to change password of 3rd type schemas.
4.2. Execute the following command
$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome
4.3. Check the log file if any error.
4.4. Now execute autoconfig.
4.5. Check the log file if not successfully completed.
All Rights Reserved 2006-07 172/173
Oracle Applications 11i – Administration www.erpstuff.com
Notes:
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
…………………………………………………………………………………………………………………………………….
All Rights Reserved 2006-07 173/173