Tag Archives: Timing Statistics

Data Mover Log Files

After the fsdmomss.dms script is run Data Mover to create the database, the following log files are created:

epengs.log
epengl.log
encrypt.log
triggers.log
views.log

The script was started at 15:57:52 and it completed at 17:25:19, taking about 1½ hours.

The general structure of the log file is:

Started: Mon Dec 01 17:25:13 2008
Data Mover Release: 8.49.15
Database: FSDMO (ENG)

SQL Triggers: 195
Ended: Mon Dec 01 17:25:19 2008
Successful completion

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