Category Archives: 11i - Page 13

Configurating Oracle Diagnostics Tool Responsibility

This documentation shows how to set up the Oracle Diagnostics Tool responsibility after installing it.

The following tasks should be completed using a responsibility that can assign responsibilities (e.g. “System Administrator”).

Step 1:        To assign the “Oracle Diagnostics Tool” responsibility to eBusiness Suite users.

If “User Management” responsibility is available:

  1. Select the “User Management” responsibility
  2. Click on “Users”
  3. Query the user to which the “Oracle Diagnostics Tool” responsibility should be assigned
  4. Select the “Update” icon
  5. Click the “Assign Roles” button
  6. Search for “Oracle Diagnostics Tool”
  7. Tick the “Select” check box and then click the “Select” button
  8. Fill in the “Justification” text field and then click the “Apply” button
  9. Click the “Home” hyperlink to return to the eBusiness Suite home page

If “User Management” responsibility is not available:

  1. Open the “Users” form (Security > User > Define)
  2. Query an existing user
  3. Add a row in the Responsibilities sub-tab region
  4. Select “Oracle Diagnostics Tool” responsibility (Application: “CRM Foundation”) from the responsibility LoV
  5. Click “OK” and save the record

See Metalink Document Subject:  Diagnostics Responsibility Configuration

Doc ID:  Note:358831.1

Firewall Error Service Unavailable

Problem: When access the production instance, a web page appears stating ‘Service Unavailable’.

Solution: In Internet Explorer, enter the instance’s host name in the list of hosts for the proxy server to bypass.

Changing Title Bar and Background Colour

Step 1: Log on as user SYSADMIN and choose the System Administrator responsibility.

Step 2: Navigate to Profile > System to load System Profile Values.

Step 3: Search for “Java Color Scheme” profile to update the background colour scheme.

Step 4: Search for “Site Name” profile to change the text that appears in the title bar.

Enabling Maintenance Mode in SQL

Problem: Show how to enable or disable maintenance mode from SQL.

Solution: Run adsetmmd.sql

Step 1: Set up the environment by running APPSORA.env:

. ./$APPL_TOP/APPSORA.env

Step 2: Change directory to $AD_TOP/patch/115/sql/:

cd $AD_TOP/patch/115/sql/

Step 3: Run the SQL script:

sqlplus apps/apps @adsetmmd.sql ENABLE | DISABLE

Step 4: Bounce the Apache Web listener. (adapcctl.sh)

See Metalink Note: 291901.1 (Subject:  Maintenance Mode – A New Feature in 11.5.10)

Oracle Applications Not Printing

Problem: Printer prints a test page correct, but OA does not print.

Solution: Set up the Linux printer driver to an earlier version.

Printer Model Linux Printer Driver
LQ-870 LQ-510
LQ-670 LQ-550

Printer Not Appearing In Submit Requests

Problem: Printer not appearing in Submit Requests.

Solution: The printer does not have the style associated with the report. Set up the Style associated with the printer from System Administrator > Install > Printer > Types.

Installing Web ADI

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.

Importing Data from GL Interface Table

 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’.

Installing Oracle Applications – Timing

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:

  1. Oracle Database Technology Stack
  2. Oracle Database
  3. Oracle Applications 11i Technology Stack
  4. Oracle Applications 11i

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

Starting Oracle Applications Automatically

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