Oracle E-BUSINESS SUITE R12 Installation (Demo Environment VIS)

1. Oracle E-BUSINESS SUITE R12 Installation (Demo Environment VIS)

   1.System hardware for 

   System hardware configuration is as follows. First, note that this configuration is generally used for single-user test, then can still barely competent. Bu Zhiyu feel very uncomfortable. (Of course, if what you want to run MRP and other large-scale computing, then you have to have patience)

1.1. Configuration List 

Project	Configuration
CPU	P4-1.6GHZ
Memory	SDRAM100MHZ-1GB
Hard drive	120GB +200 GB
Other	128MB graphics card, monitor 15

CPU 

1.6GHZ Pentium 4. I found in the actual use of CPU usage or getting bigger, especially when you run ConCurrent. Able to do so or just playing a little faster in the CPU.

Memory 

Memory for the Oracle is always the key. 1G of memory is a little small, I was reduced after the installation of the PGA and the SGA of the database. By default, then, 1G of memory is very tired. After doing a little can also be optimized. Proposed 2G of memory.

Hard drive 

In accordance with the Oracle ® Applications Installation Guide: Using Release 12 Part No. B31295-02of the instructions to install EBS R12 version of the drive demand as follows:

Project	Demand for hard disk (GB)
Applications node file system (includes AS 10.1.2 ORACLE_HOME, AS 10.1.3 ORACLE_HOME, COMMON_TOP, APPL_TOP, and INST_TOP)	28
Database node file system (Fresh install)	45
Database node file system (Vision Demo database install)	133
Stage erea installation file storage area	33
Language Pack installation file storage area	5
Space required for installation language pack	10
Space required for the operating system	5

My installation is: Install Vision Demo Database and Simplified Chinese Language Pack, you need 28 +133 +33 +5 +10 +5 = 214G.

In order to leave some room for more than 250G of hard disk space.

1. Operating system installation and configuration 

   I chose Oracle's Enterprise Linux. Because of this, then very easy to obtain

2.1. Operating system installation 

Operating system type and version 

Enterprise Linux 4 Update4. Download address is: http://www.oracle.com/technologies/linux/index.html

For the installation on the i386 for a total of four installation disk, but just download the first three disks is sufficient to install EBS R12 has. If you have to install anything else extra, please download the first four.

Download to burn to CD ready to install!

Operating system installation 

1. Choose automatic partitioning, LVM is recommended to install Lunux. Here is the side to adjust the size of Swap. Swap adjust the size of 2G.
2. Do not enable the firewall.
3. Installed components, select the customized installation. General installation of a graphical interface (such as GOME, KDE), install all the development components. For server components, then you can not choose one (note, must not select Internet services).

2.2. Operating system configuration 

HOST file 

The root user login system.

In the directory / etc / hosts file to find, in accordance with the following manner on the host name and other information. 
 

127.0.0.1 localhost.localdomain localhost

192.168.0.10 dbserv.company.com dbserv

One to note is: 192.168.0.10 is your system IP address set, dbserv is the host name, company.com is the domain name. In the same line, the host name written in the host name. Domain name back. For example dbserv written in dbserv.company.com behind.

Check / etc / sysconfig / network file is included below this line , if not, then append this line. 

HOSTNAME = dbserv.company.com

Check / etc / sysconfig / networking / profiles / default / network file exists. If there is to delete or rename.

Execute ping command to ensure that the following command to. (Depending on the specific value of each ping the setting)

ping dbserv

ping 192.168.0.10

ping dbserv.company.com

Adjust system parameters 

Edit / etc / sysctl.conf file, add the following content.

kernel.sem 256 32000 100 142 
kernel.shmall 2097152 
kernel.shmmax 2147483648 
kernel.shmmni 4096 
kernel.msgmax 8192 
kernel.msgmnb 65535 
kernel.msgmni 2878 
fs.file-max 65536 
net.ipv4.ip_local_port_range 1024 65000 
net.core.rmem_default 262144 
net.core.rmem_max 262144 
net.core.wmem_default 262144 
net.core.wmem_max 262144 

Save the file, execute sysctl-p command to reflect these changes to the current system. 

Edit / etc / security / limits.conf file. At the end of the file add the following contents: 

hard nofile 65535 
soft nofile 4096 
hard nproc 16384 
soft nproc 2047 

Create User 

To create two users according to the standard were used to manage databases and applications. Because I created here is a test for learning with the environment, so simplified as to create a user on it.

Root user login to the system, execute the following command:

# Usr / sbin / groupadd dba

# Usr / sbin / useradd-g dba oracle

Create the installation directory 

Root user login to the system, execute the following command:

# Mkdir / d01

# Chmod-R 777 / d01

Testing installed packages 

Verify the existence of the following packages:

rpm-q glibc-2.3.4-2.25

rpm-q glibc-common-2.3.4-2.25

rpm-q binutils-2.15.92.0.2-21

rpm-q compat-libstdc + + -296-2.96-132.7.2

rpm-q gcc-3.4.6-3

rpm-q gcc-c + + -3.4.6-3

rpm-q libgcc-3.4.6-3

rpm-q libstdc + + -3.4.6-3

rpm-q libstdc + +-devel-3.4.6-3 

rpm - q libaio_0.3.105-2 (name: libaio-0.3.105-2) 

rpm - q libaio_devel_0.3.105-2 (name: libaio-devel_0.3.105-2) 

rpm-q openmotif21-2.1.30-11.RHEL4.6 (ok) 

rpm-q pdksh-5.2.14-30.3

rpm-q setarch-1.6-1

rpm-q make-3.80-6.EL4

rpm-q gnome-libs-1.4.1.2.90-44.1

rpm-q sysstat-5.0.5-11.rhel4

rpm-q compat-db-4.1.25-9

rpm-q control-center-2.8.0-12.rhel4.5

rpm-q xscreensaver-4.18-5.rhel4.11

Do not overlook this step, do not think the time has Linux installed all the development packages installed by default everything will be fine. In fact, the package above the red font is not installed by default. The gaps in these three documents will result in the installation process were to install a database connection error and the installation is complete when the Forms error FRM-92101 .

When the package in the test above, but also through the following fuzzy query command:

# Rpm-qa | grep few characters in front of the package

If you do not find the above package is installed, or installed version lower than listed, then Linux installation disk in the third go to find and install it. Installation methods, if it is in the graphics environment, then double click to run on it. And Windows is no different.

Modify the oracle user created above the system registry file 

The oracle user login system, modify the oracle user's login file. Bash_profile, add the following two lines:

LD_ASSUME_KERNEL = 2.4.21 

export LD_ASSUME_KERNEL 

2.3. Other complementary subjects 

Linux system if your original hard disk space, additional hard drive, then you can refer to the following:

If the original system directly using raw device, then (that is directly used ext3 partition) 

1. Using fdisk / dev / hdb command to partition the hard disk. (Assuming you added a second IDE hard drive)
2. Using mkfs-t ext3 / dev/hdb1 command to format the hard drive formatted as ext3
3. Mount-t ext3 / dev/hdb1 / mount to the hard drive to the root directory / bottom.
   Of course, you also need to add the mount command into / etc / fstab file, so the system is started automatically mount the hard drive. (Refer to the specific format of / etc / fstab file inside the device has been written.)

If the original equipment used in the words of LVM 

1. Using fdisk / dev / hdb command to partition the hard disk. (Assuming you added a second IDE hard drive)
2. Format the hard disk when not in use ext3 format, but the use of t option, set the id = 8e. If the partition that the partition is LVM. Assumed name is created out of partition / dev/hdb1.
3. Create a physical volume: pvcreate / dev/hdb1
4. Show the existing volume group: vgdisplay default will display two: one swap, and the other is the root directory of the mount point. Remember the name of the second volume group, assumed to be lvmdisk.
5. Show the existing logical volume: lvdisplay logical assumption called lvdisk.
6. Additional logical volume: lvextend-l +10000 / dev / lvmdisk / lvdisk. Inside the +10000 number is PE, the number displayed in step 5 can be seen.
7. Begin to modify: ext2online /

3. E-Business Suite R12 Installation 

Edge over established oracle user login system.

3.1. Installing EBS R12 

Start 

# Cd / d01/stage12/startCD/Disk1/rapidwiz

#. / Rapidwiz

Welcome screen 

Directly by the Next

Installation or upgrade 

Select the first item: Install ORACLE Applications Release 12 and check Use Express Install

Installing Configuration Manager 

Did not buy it, then the choice of the following items Decline Oracle Connection Tools Agreement

Database node 

Here is the need to determine the Host Name is not dbserv, Domain Name is not company.com

If not, then change the settings above.

Pre-installation testing 

If not through the installation of detection, then click on the project to trace the reasons for problems.

Installation to determine 

Press Yes

To begin the installation 

Testing after installation 

Complete 

Login 

Press the Connect to Oracle Applications Release 12

Below the login screen if there is

3.2. Installation Configuration 

Establishment of a database user's startup files 

Because when I install EBS R12 with only one user oracle. So I created two boot files to execute the database and application server environment variables.

Copy oracle user. Bash_profile file into a. Ora documentation and add the following contents:

. / D01/oracle/VIS/db/tech_st/10.2.0/VIS_ebs12.env 

Note above the . and / is a space between 

Create the application server startup file 

Copy oracle user. Bash_profile file into a. App files, in the last append the following:

. / D01/oracle/VIS/apps/apps_st/appl/APPSVIS_ebs12.env 

Note above the . and / is a space between 

Stop the application server: (use oracle user login system) 

cd ~ 

source. app 

cd / d01/oracle/VIS/inst/apps/VIS_ebs12/admin/scripts 

. / Adstpall.sh apps / apps

Stop the database server and database listener: (using oracle user login system) 

cd ~ 

source. ora 

cd / d01/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_ebs12 

. / Addlnctl.sh stop VIS 

. / Addbctl.sh stop 

Adjust the size of the SGA database 

The default installation is complete, the database SGA size is 1G. And my memory is a total of only 1G. It will be very very tired, I put SGA reduced to 512M. If you have more than 1.5G of memory, then there is no need to adjust.

Modify the Oracle database initialization file

/ D01/oracle/VIS/db/tech_st/10.2.0/dbs/initVIS.ora 

Modify the following 

sga_target = 500M # # # default values ​​1G 

pga_aggregate_target = 500M # # # default values ​​1G 

Restart the database and application server 

cd ~ 

source. ora 

cd / d01/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_ebs12 

. / Addlnctl.sh start VIS 

. / Addbctl.sh start 

cd ~ 

source. app 

cd / d01/oracle/VIS/inst/apps/VIS_ebs12/admin/scripts 

. / Adstatall.sh apps / apps

Start the application server when using the adstatall.sh above this Shell command. In fact, it starts the application server for all services. Can also start or stop the service, respectively. adstatall.sh services included as follows:

Project	Help	Stop mode start
adopmnctl.sh	OPMN	. / Adopmnctl.sh start or stop
adapcctl.sh	APACHE	. / Adapcctl.sh start or stop
adoacorectl.sh	OACORE	. / Adoacorectl.sh start or stop
adformsctl.sh	FORMS	. / Adformsctl.sh start or stop
adoafmctl.sh	OAFM	. / Adoafmctl.sh start or stop
adanctl.sh	Report Engin	. / Adanctl.sh start apps / apps , orstop
adcmctl.sh	concurrent manager	. / Adcmctl.sh start or stop
jttfmctl.sh	Fulfillment	. / Jttfmctl.sh or stop

4. Cultural Patch 

Chinese extract the downloaded package 

Hypotheses have been downloaded to / d01/4440000_ZHS directory below

Set language 

To sysadmin log http://192.168.0.10:8000

Select System Administration responsibility -> Oracle Application Manager-> License Manager

After setting Submit

Open the maintenance mode 

Open a Shell window. Execute the following command:

# cd ~ 

# source. app 

# NLS_LANG = "Simplified Chinese_China.UTF8 " 

# export NLS_LANG 

# Adadmin 

" 

For adadmin the implementation process requires input parameters in addition to system and the APPS password for the importation of foreign (the default was manager and APPS ) to take all other defaults, that is determined to be a carriage return. Finally, the following screen appears: 

 

Select 5 

 

Select one to open the maintenance mode. Finally back to the main menu 

 

Select 4 

 

Select 3 . After some treatment, return to the main interface, exit adadmin 

Executive adpatch 

With adadmin , requires the input system and the APPS password. Patches also need to enter the path and the Chinese u4440000.drv. 

This will take a long time, according to my configuration, I spent about 30 hours. 

Off maintenance mode 

 

Select 5 

 

Select 2 , off maintenance mode. Finally back to the main menu

5. Firefox browser 

In Oracle's Enterprise Linux operating system the browser is Firefox. In fact, the majority of Linux are equipped with this browser. Compared with the usual IE users as the client is concerned, this takes a lot of effort to configure Firefox.

Operation mode client Forms 

EBS R11i time, to the client's browser to run Forms, simply download and install Jinitiator on it. EBS R12 version of the current needs of the client if the browser can call JDK1.5.0_10 the PlugIn component. In fact, in Windows, IE, the installation is automatic. When you first when trying to open a Form, IE will give you download and install JDK1.5.0_10. For firefox it to configure it. If you have a computer installed the Windows client to do so, then you would not be necessary for the configuration of this chapter.

To capture a Windows Forms under 

Still quite beautiful!

Download JDK1.5.0_10 

Download:

http://java.sun.com/products/archive/j2se/5.0_10/index.html

Download jdk-1_5_0_10-linux-i586-rpm.bin

Installation JDK1.5.0_10 

Suppose your jdk-1_5_0_10-linux-i586-rpm.bin the download directory is / d01 

# Cd / d01 

# SH JDK-1_5_0_10-Linux-i586-rpm.bin 

Agreement will appear on screen, you press the page has been turn to the bottom. Enter yes to accept the deal. 

Start extracting. After decompression generated in the current directory jdk-1_5_0_10-linux-i586.rpm 

This file is very easy to deal with. Double-click in the graphical interface on it. 

After installation, the default in / usr / java to generate a default directory under the JDK-1_5_0_10 . 

Configure Firefox's Plugin 

Oracle's Enterprise Linux default installation of Firefox version: 1.5.0.3. Figure:

The default installation path is usually: / usr/lib/firefox-1.5.0.3 /. In this directory there is a plugins directory. We will now make a file link over the JDK to allow firefox to run Java Plugin. Operation is as follows:

(Assuming the installation path of your JDK1.5.10 is / usr / Java / jdk1.5.0_10 )

# Cd / usr/lib/firefox-1.5.0.3/plugins

# Ln - s / usr / Java / jdk1.5.0_10/jre/plugin/i386/ns7/libjavaplugin_oji.so 

. / Libjavaplugin_oji.so 

This time in the current directory you will see a link file libjavaplugin_oji.so. 

Open Firefox, in the hyperlink field, enter: about: plugins. Appears below the page is to prove that you install the plug-in was successful. (Note that version) 

Start the Forms look in firefox 

Enter the link address in the address bar, such as http://192.168.0.10:8000

After entering a username and password, such as input operations / welcome

Then enter the super user responsibility for OM, open sales orders.

Click the top right corner of the Preferences. System begins to open the Form.

To be honest, the font is hard to read. To change the font and Windows as good-looking, please refer to the next chapter.

6.Landscaping JDK Chinese fonts 

JDK under Linux using the default font in the Song, to be honest do not look good. Or change the font Windows, beautiful.

JDK1.5 default font load order 

The loading order (JavaHome means the root directory of JRE, the same below): 

JavaHome / lib / fontconfig.OS.Version.properties 

JavaHome / lib / fontconfig.OS.Version.bfc 

JavaHome / lib / fontconfig.OS.properties 

JavaHome / lib / fontconfig.OS.bfc 

JavaHome / lib / fontconfig.Version.properties 

JavaHome / lib / fontconfig.Version.bfc 

JavaHome / lib / fontconfig.properties 

JavaHome / lib / fontconfig.bfc 

One, OS field can be: 

Windows: "98", "2000", "Me", "XP", "2003". 

Solaris: empty. 

Linux: "Sun", "RedHat", "Turbo", "SuSE". 

The Version field refers to the OS version number. 

Copy Fonts 

To the bottom of the simsun.ttc fonts Window XP, the default is C: \ WINDOWS \ Fonts below.

Copied to the JRE font directory JavaHome / lib / fonts below, and renamed simsun.ttf. 

Configure JDK fonts 

Edit JavaHome / lib / fonts / fonts.dir file. 

1. The first line of data plus 1. 
2. The end of the document with the sentence below 

simsun.ttf-SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

In JavaHome / lib under the additional file. File Name: fontconfig.RedHat.properties. Additional reads as follows: 

# @ (#) Linux.fontconfig.RedHat.properties 1.2 07/03/05 

# 

# Copyright 2003 Sun Microsystems, Inc. All rights reserved. 

# 

# Version 

version = 1 

# Component Font Mappings 

serif.plain.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

serif.bold.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

serif.italic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

serif.bolditalic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

sansserif.plain.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

sansserif.bold.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

sansserif.italic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

sansserif.bolditalic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

monospaced.plain.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

monospaced.bold.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

monospaced.italic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

monospaced.bolditalic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialog.plain.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialog.bold.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialog.italic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialog.bolditalic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialoginput.plain.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialoginput.bold.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialoginput.italic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

dialoginput.bolditalic.zh-1 =- SungtiL GB-medium-r-normal-0-0-0-0-c-0-gb2312.1988-0 

# Search Sequences 

sequence.allfonts = zh-1 

# Exclusion Ranges 

# Font File Names 

Finally, delete (or transfer out as well) to the directory of all files that begin with fontconfig. 

OK. Re-enter the Form look. 

 

I found this Form just like Windows, that is almost the same. Why is almost it? Oh, because if you look carefully, and found that those who head the title character (in this case: Sales Order (Vision Operations) - [New]) did not get rid of the font. Strange, for later study. 

Can refer to: http://java.sun.com/j2se/1.5.0/docs/guide/intl/fontconfig.html

Category: