This documentation covers how to install Web ADI. To download Web ADI, refer to Metalink Doc ID: 230801.1.
Step 1: Log on to Metalink and click on the Patches & Updates.
Step 2: Click on Advanced Search.
Step 3: Search by Product of Product Family for ‘Web’. ‘Web Applications Desktop Integrator (bne)’ appears.
Step 4: View readme of the latest BNE patchset (11i.BNE.D). See also Note ID 287080.1.
Step 5: The latest patchset is 3218526, about 8.4MB. Download it.
Problem: After loading data into the GL_INTERFACE table, how is the data imported into the base tables?
Solution:
Step 1: Log on to E-Business Suite and select the General Ledger Superuser responsibility.
Step 2: Navigate to Journals, then Import and finally Run.
Step 3: On the Import Journals form, enter the date range.
Enter data into the Source, Selection Criteria and Specific Value fields, and then click Import.
For example, ‘History’, ‘Selected Group ID’ and Value ‘1’.
This documentation covers installing Oracle Applications on the Linux operating system. The installation was done on the appslinux server (\appslinux.support.com).
Refer to “Installing Oracle Applications: A Guide to Using Rapid Install” (Part No. B19296-01) for more information. (C:VasudevAppsDoc11iacrobatr115102ins.pdf)
Step 1: Log on to the appslinux server via VNC on port 1.
If you cannot log on to VNC, load Command Prompt, telnet to appslinux, log on as user applmgr and run vncserver at the prompt. Note the port, and then exit.
Step 2: The VIS3 instance has to be deleted to make space for the new installation. This instance is located in the /u3 folder.
[applmgr@appslinux oracle]$ cd /u3/oracle/ [applmgr@appslinux oracle]$ ls -al total 32 drwxr-xr-x 8 applmgr dba 4096 Apr 14 2005 . drwxr-xr-x 6 applmgr dba 4096 Apr 5 11:30 .. drwxrwxrwx 2 applmgr dba 4096 Nov 18 2005 scripts drwxr-xr-x 200 applmgr dba 4096 Apr 14 2005 vis3appl drwxr-xr-x 10 applmgr dba 4096 Sep 13 2005 vis3comn drwxr-xr-x 2 applmgr dba 4096 Dec 22 2005 vis3data drwxr-xr-x 3 applmgr dba 4096 Apr 14 2005 vis3db drwxr-xr-x 4 applmgr dba 4096 Apr 14 2005 vis3ora
Step 3: To view the disk used by a folder, use the ‘du oracle –csh’ command.
[applmgr@appslinux u3] $ du oracle -csh 88G oracle 88G total
Note: This command takes about five (5) minutes to complete. Use sparingly.
Step 4: To delete the /u3/oracle folder, issue the ‘rm –rf *’ command.
[applmgr@appslinux oracle]$ ls -al total 32 drwxr-xr-x 8 applmgr dba 4096 Apr 14 2005 . drwxr-xr-x 6 applmgr dba 4096 Apr 5 11:30 .. drwxrwxrwx 2 applmgr dba 4096 Nov 18 2005 scripts drwxr-xr-x 200 applmgr dba 4096 Apr 14 2005 vis3appl drwxr-xr-x 10 applmgr dba 4096 Sep 13 2005 vis3comn drwxr-xr-x 2 applmgr dba 4096 Dec 22 2005 vis3data drwxr-xr-x 3 applmgr dba 4096 Apr 14 2005 vis3db drwxr-xr-x 4 applmgr dba 4096 Apr 14 2005 vis3ora [applmgr@appslinux oracle]$ rm -rf *
The –f option ignores nonexistent files and never prompts.
The –r option removes the contents of directories recursively.
Note: Remember to stop services and database if you are deleting an instance.
Note: Deleting all the instance files takes about twelve (12) minutes.
[applmgr@appslinux oracle]$ PS1='[u@h W] t $ ' [applmgr@appslinux oracle] 14:53:30 $ [applmgr@appslinux applmgr] 14:53:44 $ cd /u3/oracle/ [applmgr@appslinux oracle] 14:53:57 $ ls -al total 8 drwxr-xr-x 2 applmgr dba 4096 Jul 11 14:46 . drwxr-xr-x 6 applmgr dba 4096 Apr 5 11:30 .. [applmgr@appslinux oracle] 14:53:59 $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sde7 1012M 230M 731M 24% / /dev/sda1 244M 15M 216M 7% /boot /dev/sdb2 9.9G 9.2G 237M 98% /home /dev/sde8 494M 8.1M 461M 2% /opt none 1.9G 0 1.9G 0% /dev/shm /dev/sde6 1012M 36M 925M 4% /tmp /dev/sda2 34G 19G 14G 58% /u0 /dev/sdb1 40G 36G 2.1G 95% /u1 /dev/sdc1 125G 113G 6.1G 95% /u2 /dev/sdd1 110G 163M 104G 1% /u3 /dev/sde1 110G 100G 4.6G 96% /u4 /dev/sdd2 9.9G 2.6G 6.9G 27% /usr /dev/sde5 1012M 127M 834M 14% /usr/local /dev/sde3 2.0G 151M 1.8G 8% /var
The prompt was changed to display the time so that the installation can be timed.
There are two staging areas for two versions of Oracle Applications:
[applmgr@appslinux oracle] 14:57:12 $ ls -al /u0 total 7216 drwxrwxrwx 7 root root 4096 Jul 7 16:20 . drwxr-xr-x 26 root root 4096 Jun 30 17:30 .. drwxr-xr-x 2 root root 4096 Apr 13 2005 stage1159 drwxr-xr-x 8 root root 4096 Apr 13 2005 Stage11i [applmgr@appslinux oracle] 14:57:27 $ ls -al /u1 total 5316112 -rw-r--r-- 1 applmgr dba 5168168960 Oct 26 2005 drwxrwxrwx 8 root root 4096 Jul 11 12:00 . drwxr-xr-x 26 root root 4096 Jun 30 17:30 .. drwxr-xr-x 2 root root 4096 Apr 13 2005 stage11510 drwxr-xr-x 7 root root 4096 Apr 13 2005 stage11i10
The Oracle Applications 11.5.10 version will be installed. The staging area has already been set up in the /u1/stage11i10 folder.
[applmgr@appslinux u1] 15:01:32 $ ls -al stage11510/ total 8 drwxr-xr-x 2 root root 4096 Apr 13 2005 . drwxrwxrwx 8 root root 4096 Jul 11 12:00 .. [applmgr@appslinux u1] 15:04:23 $ ls -al stage11i10/ total 28 drwxr-xr-x 7 root root 4096 Apr 13 2005 . drwxrwxrwx 8 root root 4096 Jul 11 12:00 .. drwxr-xr-x 26 root root 4096 Sep 12 2004 oraAppDB drwxr-xr-x 10 root root 4096 Sep 12 2004 oraApps drwxr-xr-x 5 root root 4096 Sep 12 2004 oraDB drwxr-xr-x 6 root root 4096 Sep 12 2004 oraiAS drwxr-xr-x 9 root root 4096 Sep 12 2004 startCD
Step 5: Start the Rapid Wizard installer by changing to the rapidwiz directory and running rapidwiz.
Note: You must run the Rapid Wizard as the applmgr or oracle user, not the root user.
[applmgr@appslinux rapidwiz] 15:09:26 $ cd /u1/stage11i10/startCD/ Disk1/rapidwiz/ [applmgr@appslinux rapidwiz] 15:09:38 $ ls -al total 176 drwxr-xr-x 13 root root 4096 Sep 12 2004 . drwxr-xr-x 6 root root 4096 Sep 12 2004 .. -rwxr-xr-x 1 root root 62854 Sep 12 2004 adautostg.pl drwxr-xr-x 2 root root 4096 Sep 12 2004 bin -rwxr-xr-x 1 root root 403 Sep 12 2004 ClientWiz.cmd drwxr-xr-x 7 root root 4096 Sep 12 2004 driver drwxr-xr-x 2 root root 4096 Sep 12 2004 etc drwxr-xr-x 2 root root 4096 Sep 12 2004 File drwxr-xr-x 4 root root 4096 Sep 12 2004 images drwxr-xr-x 3 root root 4096 Sep 12 2004 jlib drwxr-xr-x 8 root root 4096 Sep 12 2004 jre drwxr-xr-x 9 root root 4096 Sep 12 2004 lib drwxr-xr-x 3 root root 4096 Sep 12 2004 oui -rwxr-xr-x 1 root root 15972 Sep 12 2004 rapidwiz -rwxr-xr-x 1 root root 540 Sep 12 2004 RapidWiz.cmd -rwxr-xr-x 1 root root 21609 Sep 12 2004 RapidWiz.ini -rwxr-xr-x 1 root root 1088 Sep 12 2004 RapidWizVersion -rwxr-xr-x 1 root root 402 Sep 12 2004 RapidWizVersion.cmd drwxr-xr-x 2 root root 4096 Sep 12 2004 template drwxr-xr-x 8 root root 4096 Sep 12 2004 unzip [applmgr@appslinux rapidwiz] 15:09:44 $ ./rapidwiz
Rapid Install Wizard is validating your file system……
Rapid Install Wizard will now launch the Java Interface…..
Step 6: The Rapid Install Wizard starts and the Install Oracle Applications – Welcome form appears:
Note the four components that are being installed:
Click Next.
Step 7: The Select Wizard Operation form appears. Ensure that Install Oracle Applications E-Business 11i is selected and click Next. Use Express Configuration should not be checked.
Step 8: The Load Configuration form appears. There is no configuration file, so ensure that No is selected and then click Next.
Step 9: The Install Type form appears. Ensure that Single-node is selected and then click Next.
Step 10: The Database Type form appears. Enter VIS4 as the new database name, and then click Next.
Step 11: The Database Install Information form appears. Change the Base Install directory to /u3/oracle, and then click Next.
This determines where to put the Oracle Home (vis4db/9.2.0) and Data Top directories (vis4data).
Step 12: The Admin Server/Concurrent Mgr/Forms Server/Web Server form appears. Change the Base Install directory to /u3/oracle, and then click Next.
This determines where to put the APPL_TOP (vis4appl), COMMON_TOP (vis4comn) and 8.0.6 ORACLE_HOME (vis4ora/8.0.6), iAS ORACLE_HOME (vis4ora/iAS) and Temp (vis4comn/temp) directories.
Step 13: The Global System Settings form appears. Change the Port Pool value to 4. Click Next.
Database Port becomes 1525 (1521 + 4)
RPC Port becomes 1630 (1626 +4)
Web Listener Port becomes 8004 (8000 + 4)
Step 14: The Save Instance-specific Configuration form appears. Change the configuration file to /tmp/VIS4config.txt. Click Next.
Step 15: The System Check Status window appears. Rapid Wizard checks the system to ensure that it meets all requirements for installation.
Step 16: On completion, the Pre-install Checks form appears. If all pre-install tests are passed, then green check marks will appear for all tests.
Step 17: The Component Installation Review form appears. Click Next.
Step 18: The system is ready to install. Click Yes to begin installation.
The installation process begins.
The output database log file is located in:
/u3/oracle/vis4db/9.2.0/appsutil/log/VIS4_appslinux/
In this installation the database log file is named ‘08191136.log’.
The Appltop log file is located in:
/u3/oracle/vis4appl/admin/VIS4_appslinux/log/
In this installation the appltop log file is named ‘08191136.log’.
Note that the log file is the date and time that the installation started.
The installation started at 15:54:21 and ended at 17:39:29, taking 1 hour and 45 minutes. In another installation, the time taken was 1 hour and 40 minutes.
Step 19: After installation, the Post-Install Checks form appears. Ensure that there are green check marks for all the post-install tests, and then click Next.
Step 20: The Finish form appears. Click Finish to complete installation.
Step 21: Ensure that you can log on by loading the web browser on the client and pointing the URL to http://appslinux.support.com:8004.
Note that the password for user ‘sysadmin’ is sysadmin.
[applmgr@appslinux rapidwiz] 17:39:29 $ uname -a Linux appslinux.support.com 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003 i686 i686 i386 GNU/Linux
Note that there are four processors in the Oracle Applications server machine. Partial listing the /proc/cpuinfo file shows the following:
processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2790.780 cache size : 512 KB physical id : 0 siblings : 2 runqueue : 0 bogomips : 5570.56 processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2790.780 cache size : 512 KB physical id : 3 siblings : 2 runqueue : 1 bogomips : 5570.56 processor : 2 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2790.780 cache size : 512 KB physical id : 0 siblings : 2 runqueue : 0 bogomips : 5570.56 processor : 3 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2790.780 cache size : 512 KB physical id : 3 siblings : 2 runqueue : 1 bogomips : 5570.56
Output from cat /proc/meminfo is:
[applmgr@appslinux rapidwiz]$ cat /proc/meminfo total: used: free: shared: buffers: cached: Mem: 4028637184 3974754304 53882880 0 3936256 2194161664 Swap: 2146754560 71675904 2075078656 MemTotal: 3934216 kB MemFree: 52620 kB MemShared: 0 kB Buffers: 3844 kB Cached: 2141888 kB SwapCached: 848 kB Active: 2682252 kB ActiveAnon: 2209488 kB ActiveCache: 472764 kB Inact_dirty: 333892 kB Inact_laundry: 268712 kB Inact_clean: 56988 kB Inact_target: 668368 kB HighTotal: 3080168 kB HighFree: 24088 kB LowTotal: 854048 kB LowFree: 28532 kB SwapTotal: 2096440 kB SwapFree: 2026444 kB HugePages_Total: 0 HugePages_Free: 0 Hugepagesize: 2048 kB
This documentation is a start Oracle Applications automatically when the machine is rebooted.
Refer to Doc ID: Note: 61333.1 (Subject: AUTOMATIC STARTUP AND SHUTDOWN OF ORACLE DATABASE INSTANCES)
Can modify /etc/oratab script. This did not start database listener or application services.
Can also put startup script in /etc/rc.local. Must be edited as root user.
su applmgr -c /u2/oracle/scripts/startVIS2.sh su applmgr -c /u3/oracle/scripts/startVIS4.sh
This documentation covers a general backup strategy for the client.
Since a lot of work is being done on the Test instance, it is important that the server housing this instance be backed up on a regular basis.
There are several types of backup media available. For example, CD-ROMs, DVD-ROMs, secondary hard drives etc. CD-ROMs and DVD-ROMs do not possess the required capacity. Secondary hard drives are likely to fail. For example, if a power spike caused the server hard drives to fail, it may also cause the secondary hard drives to fail.
The best medium for backing up servers is tape media. The tape must be capable of backing up the database and related Oracle Application files, as well as the public folder. Storage requirements for these will grow as the project progresses, and this must be taken into consideration. A rough estimate of the tape capacity is about 200GB. This will easily back up the entire server.
Dell sells LTO tape drives (PowerVault 110T LTO Tape Drive) with some of their servers; perhaps this can be used as a starting point for research on tape drives.
There are several commercial backup and recovery solutions available, such as BrightStor ARCserve. ARCserve handles all aspects of job creation, scheduling and recovery from an intuitive GUI. In addition, ARCserve is certified by Microsoft on all of its server platforms.
Windows also comes with it’s own backup software, NT Backup. NT Backup provides much of the basic functionality as ARCserve. However, NT Backup is designed to be a more interactive solution, that is, an operator has to manually choose the files and directories to back up, and then start the backup.
Ideally, the backup should be automated so that an operator does not have to manually start the backup, and the backup can be scheduled in the middle of the night (say 10 o’clock).
NT Backup can be called from the command line with parameters, so the NT Backup command can be placed into a Windows Command Script (with a .cmd extension), which can then be scheduled. However, this method must be diligently tested to ensure that the scheduled backups are going through.
To view the syntax for NTBackup command line parameters, type ‘ntbackup /?’ at the command prompt:
C:> ntbackup /?
NT Backup loads, then the help file appears with the command-line reference.
To use NT Backup, a ‘selection’ of directories to back up has to be created and saved so that it can be referenced on the command line.
At the very least, the directories that should be backed up on oracleserver are
However, if all directories on all of the drives can be backed up, it would be even better.
Regardless of the backup software used, the backup made should be tested on a regular basis. There should be a separate machine, which can be used to test different disaster recovery scenarios.
Go to Control Panel > Administrative Tools > Computer Management.
Click Action, and then click New User.
Enter the new user and password.
Navigate to Control Panel > User Accounts to change the group membership.
Problem: The Customer Statements report prints a banner page.
Solution: On Vision, log on as user operations and access the Receivables, Vision responsibility. From the menu, access Print Documents > Statements.
Refer to Doc ID: Note:99687.1 (Subject: Printing Character Reports with Oracle Applications Release 11)
For the Printer Style MFGL_LANDSCAPE, enable the Suppress Header checkbox for the \oracleserverHPLaser printer.
From Concurrent Programs from the System Administrator responsibility, change the Print Statement program. Change Style to Landscape_mfgl and Printer to \oracleserverHPLaser.
Subject: FAQ (Application Reports)
Doc ID: Note:105105.1
Subject: Printing Character Reports with Oracle Applications Release 11
Doc ID: Note:99687.1
Subject: How to Remove The Banner Page From Printing On Reports
Doc ID: Note:163973.1
Subject: How to Suppress Banner Page when Printing Reports
Doc ID: Note:1038798.6 (No help)
Subject: How to Suppress the Header/Banner Page When Printing Report on AIX?
Doc ID: Note:302847.1 (No help)
This documentation shows the user how to load data for GL Interface.
Step 1: The data file provided by the analyst can either be a .CSV file or a .DAT file.
Step 2: Rename the data file to a name without spaces e.g. datafilename.dat.
Step 3: Copy the data file to the project folder, into folder GLDataLoadElvis.
Step 4: Load on to oracleserver (128.1.2.213) via VNC.
Step 5: Load Command Prompt.
Step 6: Change to D:PRODprodappl. Run APPSORA.cmd.
Step 7: Change to folder D:PROJECT FOLDERGLDataLoadElvis
Step 8: At the Command Prompt, run SQL Loader:
sqlldr80 apps/apps control=elvis.ctl data=datafilename.dat
Step 9: If only about 50-60 lines load, the data was incorrect (the load process fails after 50 lines have failed). Check the log file elvis.log for more information.
Problem: Unable to get application to launch.
Solution: Try the following:
Step 1: Check the hosts file (either /etc/hosts or C:WINDOWSSYSTEM32 DRIVERSETCHOSTS) and ensure that the IP address and host is in the file.
Step 2: Ensure that the local addresses are bypassed in the browser.
Step 3: Ensure that the instance is started on the server.
Problem: When accessing any menu that launches core forms, get this error:
load: class oracle/apps/fnd/formsClient/FormsLauncher.class not found
Solution: Check the proxy server settings in the browser and ensure that addresses to bypass are correct.
Use the ‘hostname*’ format in the proxy server settings.
From Metalink article Doc ID: Note:291698 (Subject: FormsLauncher.class Not Found Error When Attempting to Access Forms in Applications)
Steps for resolution:
See also: Doc ID: Note:373736.1 (Subject: Load: Class Oracle/Apps/Fnd/ Formsclient/Formslauncher.Class Not Found)
Recent Comments