壹佰网|ERP100 - 企业信息化知识门户

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 15487|回复: 39

Oracle E-Business Suite R12 的安装

    [复制链接]
发表于 2007/8/17 11:26:16 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622  。

您需要 登录 才可以下载或查看,没有帐号?注册

x
Oracle E-Business Suite R12 Installation on Windows 2003 Server
1) Install Windows 2003 Server.

2) Set 'Computer Name' as well as 'Domain Name'.

3) Create a new user 'hsawwan' and make this user a member of:
- Administrators (local user)

4) Install Visual C++ 8.0 (Which is included in Microsoft Visual Studio 2005) in 'C:\VCPlus' -- Make sure not to install VC++ in a directory that contains spaces.

5) Download 'Cygwin' and install the required packages as listed in Note: 414992.1 (Using Cygwin to Maintain Oracle E-Business Suite Release 12 on Windows). Install 'Cygwin' in 'C:\cygwin' -- Make sure not to install 'Cygwin' in a directory that contains spaces.

6) GNUMake is not required when using 'Cygwin' since it comes as a part of the 'Cygwin'.

C:\cygwin\bin>copy gawk.exe awk.exe
C:\cygwin\bin>copy grep.exe egrep.exe
C:\cygwin\bin>copy make.exe gnumake.exe
C:\cygwin\bin>copy gcc.exe cc.exe

7) Add 'C:\cygwin\bin' to the system path.

8) No JDK installation is required, JDK 5.0 (java version "1.5.0_08") is bundled with Oracle Applications R12 installation.

9) Set Up the Stage Area:

Stage Area (C:\Stage12) requires a 26 GB hard disk space.

Extract the zip files (25 files) which have been downloaded from (http://edelivery.oracle.com). Nothing special to do since the extracted files will create the stage area directory structure by itself. You should see the following structure under 'C:\Stage12' once you are done with the files extraction:

- startCD > Disk1
- oraAppDB > (Disk 1 to Disk 35)
- oraApps > (Disk 1 to Disk 7)
- oraAS > (Disk 1 to Disk 2)
- oraDB > (Disk 1 to Disk 3)

10) Start the installation:

C:\> cd Stage12\startCD\Disk1\rapidwiz
C:\Stage12\startCD\Disk1\rapidwiz> RapidWiz.cmd

[ 本帖最后由 bob 于 2007-8-17 12:03 编辑 ]
发表于 2007/8/17 11:39:15 | 显示全部楼层
终于有for windows的出来了,太好了
 楼主| 发表于 2007/8/17 11:44:37 | 显示全部楼层
对windows平台而言,要装 VC++ 8.0,MKSToolkit / Cygwin ,java  JDK 5.0 等等
 楼主| 发表于 2007/8/17 11:54:12 | 显示全部楼层
Release 12 Installation on Sun Solaris

Ever since the release of Oracle Applications release 12 i have been waiting do a post on the installation but never did get the chance. Now finally here it is.
The current post is a step by step documentation of install ting Oracle Applications Release 12 on Sun Solaris 8, 64 bit.

Before you begin the installation make you have staged your software. If you are staging from the DVD pack you can use the adautostg.pl script.
If you have downloaded from edelivery you can just unzip the various parts.

The staged directory structure should look something similar.
oraAS/
oraAppDB/
oraApps/
oraDB/
startCD/

Creating OS Users
The next step is to create two OS users for the database and the primary application tier.

useradd -g dba -d /home/applsam applsam
useradd -g dba -d /home/applsam orasam

Oracle Inventory.
Next i will set up my global inventory to a different location. It better to have this specially when you have multiple instances of different versions on the same box.

cd /var/opt/oracle/
vi oraInst.loc
inventory_loc=/d01/rel12/rel12inv
inst_group=dba

Pre requisite Patches and Packages
Make sure you have all the pre requisite patches and the packages for your OS platform.
You can find the list in the metalink note 402312.1
also you will need an approximate of 140GB to complete a VISION installation of Release 12.More Detailed space requirements can be found in the above mentioned release notes.

Starting The installation.
You can start the installation by setting the appropriate DISPLAY and the running rapidwiz. In a multi user installation you must start the installation from root

/startCD/Disk1/rapidwiz
./rapidwiz

The first screen is the rapid install welcome screen



Next you will be asked to select the type of installation you want to go ahead with. You can choose a standard or an express install. you can also choose to upgrade you oracle applications.



Release 12 comes bundled with Oracle Configuration Manager(OCM).OCM is a tool which allows oracle to gather system information about your instances to help provide support. In case you are planning to install OCM make sure the user through which the installation is  is being done is access to crontab.



If you have chosen to install OCM you will be provided with a screen to enter your CSI number and metalink account name.  Also your proxy details to connect to the internet.



If you have an existing configuration file yo can choose that here or choose to create a new config file for your installation.



Next you specify the port pool for your instance.



The Next screen allows you to specify your Database tier configuration details.



Now you specify the configuration details of your primary application tier.



The following screen shows your nodes and configuration, it also allows you to add a new server to this configuration.



After this a quick pre installation validation check is done,



The next screen allows you to review the components you are about to install.



The installation now begins.




After the installation a post validation similar to 11.5.10 is done and you can log on into the instance.

[ 本帖最后由 bob 于 2007-8-17 12:01 编辑 ]
 楼主| 发表于 2007/8/17 12:00:55 | 显示全部楼层
Installing Oracle Applications Release 12 on SUSE Linux EntERPrise Server 10
Please have 250GB of Disk free and 3GB of ram. It might install with 2GB of ram, but will likely swap heavily until SGA and concurrent managers are scaled back.
Install and configure SLES10 per the note below:
Installing Oracle10g R2 Database on SLES10 for i386 http://www.novell.com/products/server/oracle/oracle10g_install.html
Verify the following packages are installed, either during install or after.
  • glibc
  • gcc-
  • gcc-c++
  • libaio
  • libaio-devel
  • libgcc
  • libstdc++
  • libstdc++
  • openmotif21-libs-2.1.30MLI4
  • pdksh
  • make
  • gnome-libs
  • gnome-libs-devel
  • sysstat
  • binutils
  • db1
  • compat
  • xscreensaver
  • orarun
Can skip Editing the /etc/SuSE-release file
Work down to Set the right kernel parameters
Verify that the /etc/hosts file is formatted as follows:
      127.0.0.1 localhost.localdomain      <ip_address> <node_name>.<domain_name> <node_name>Modifying the Number of Open File Descriptors
Open the /etc/security/limits.conf file and change the existing values for "hard" and "soft" parameters as follows. Restart the system after making changes.
hard nofile 65535soft nofile 4096hard nproc 16384soft nproc 2047Download the Release 12 installation media from http://edelivery.oracle.com

Figure 1: Oracle E-Delivery Web Site

Search for E-Business Suite on the Linux x86 platform. Click on the Oracle E-Business Suite Applications Release 12.0 Media Pack for Linux x86. Download each CD image into the same directory until you get to the Documentation DC. Once all the CD images have been downloaded, unzip each one. The proper staging directory structure will be created as long as you unzip with no options other than the filename. The Documentation Library is available online at http://download-west.oracle.com/docs/cd/B34956_01/current/html/homeset.html
Once all of the CD images have been unzipped, cd to /startCD/Disk1/rapidwiz, and run rapidwiz as root.

Figure 2: Initial Rapid Install Welcome Screen

Select Next to proceed to the next screen.

Figure 3: Select Wizard Option

Chose Install Oracle Applications Release 12 skipping the Use Express Install if you want more control over the installation process.

Figure 4: Oracle Configuration Manager

At this point, decline the Oracle Connection Tools Agreement as SLES10 is not yet a certified Operating System for Oracle Applications Release 12.

Figure 5: Configuration Choice

If you had already completed an installation of Release 12, you could reload the configuration file from the previous installation.

Figure 6: Global System Settings

Select a Port Pool here. Since using the database port 1521 is a known security risk, select a port pool of 1 or higher. If there are any existing 11i systems on the same server, select a port pool that is not already in use.

Figure 7: Database Node Configuration

Select the host name, database SID, and base directory for installation.

Figure 8: Primary Applications Node Configuration

If the applications OS group is different from the database OS group, the base directory will need to be writable to others. If the host name is the same as the database host name, then the installation will be single node, otherwise, you will have a multiple node installation.

Figure 9: Node Information

Additional nodes can be configured on this screen.

Figure 10: System Checks

Rapid Install performs some system checks to verify disk space, permissions, ports and availability of system utilities.

Figure 11: Validate System Configuration

If all went well, you will see six green check marks indicating you may proceed with the installation.

Figure 12: Component Installation Review

Press Next to proceed to the next screen

Figure 13: Rapid Install Wizard Alert

Last chance to back out.

Figure 14: Installing Oracle Applications

The Rapid Install process will begin unzipping files into the previously selected locations.

Figure 15: Configuration of 10.2.0 Oracle Home


Figure 16: Unzipping of Datafiles


Figure 17: Configuration of the Database


Figure 18: Installation of the 10.1.2 and 10.1.3 Oracle Homes


Figure 19: Installation of $APPL_TOP and $COMMON_TOP


Figure 20: Autoconfig and Services Startup Phase


Figure 21: Validate System Configuration

At this point all 11i services have been verified to be working.

Figure 22: Rapid Install Completion Screen

If the Connect to Oracle Applications Release 12 button does not spawn a browser correctly, use Firefox and navigate to host.domain:8000 (+ port pool). If port pool was 1, as shown above, use 8001. You will be redirected to http://host.domain:8001/oa_servlets/AppsLogin.
At this point, use standard Vision login accounts, sysadmin/sysadmin, operations/welcome, wtucker/welcome, mfg/welcome. etc.
Log in and verify everything is working.

Figure 23: Oracle Applications R12 Login Screen


Figure 24: R12 OA Framework Navigator Page

If you want to open the professional forms from Suse Linux Machine (Suse 10.1 or higher), you need to verify that the Sun Java Plugin is installed and working. In a terminal window, cd to /usr/lib/jvm/jre/bin, and type ./ControlPanel. If you do not see the Sun Java Plug-in Control Panel as shown in figure 25, there is a problem with the default look and feel configured in /usr/lib/jvm/jre/lib/swing.properties. If the file is not there, it may be in a directory from a previously installed plug-in like /usr/lib/jvm/java-1.5.0-sun-1.5.0_07/jre/lib.
Change the line swing.defaultlaf=com.birosoft.liquid.LiquidLookAndFeel to swing.defaultlaf=com.sun.java.swing.plaf.motif.MotifLookAndFeel, and try to open the Control Panel again.
On Suse 10.1, you may need to register the Sun Java Plug-in with the browsers. In a terminal window, cd to /usr/lib/browser-plugins, and create a soft link to the current plugin directory via ln -s /usr/lib/jvm/java-1.5.0-sun-1.5.0_10/jre/plugin/i386/ns7/libjavaplugin_oji.so.
Oracle Applications Release 12 is configured to render forms applets via the Sun Java Plug-in 1.5.0 Update 10. Fortunately, this is currently the same version used by Suse 10.1 and Suse 10.2. If the OS version gets updated to a version higher than 1.5.0 Update 10, update the context file of the applications. This file is located in your base install directory /inst/apps/{sid}_{host}/appl/admin. The file is called {sid}_{host}.xml. Search for sun_plugin_ver, and change 1.5.0_10 to your current version.

Figure 25: Sun Java Plug-in Control Panel

Once the plug-in is working, Click on a forms link like System Profile Options, and allow popups from the R12 host if popup blocking is enabled.

Figure 26; Allow popups from your host

You need to trust the java from Oracle Applications.

Figure 27: R12 Java Security Warning

Forms will not open without Always trust content from this publisher checked. Then hit run.

Figure 28: R12 Professional Applet forms in the swan color scheme

There are a few links in the R12 (and 11.5.10) applications that only open on the Windows operating system. If you do not have a Windows PC handy, go to http://virtualbox.org, and download the binaries for the VirtualBox virtual machine. VirtualBox is considerable faster than qemu, even with kqemu kernel acceleration, and is easier to configure and install on Suse Linux compared to vmware. Hardware virtualization support on the CPU is not required.
Once VirtualBox (or your favorite virtual machine) has been installed, you can install CADView 3D plugin, Oracle Product Workbench, Oracle Workflow Builder, Oracle Discoverer Admininstrator, XML Publisher, etc.

Figure 29: R12 Navigator under VirtualBox


Figure 30: Installation of CADView 3D Desktop Plugin


Figure 31: CADView 3D Motorcycle Model Displayed in a VM


Figure 32: Oracle Product Workbench under displayed in a VM

The last few screen shots should get you started navigating around the Oracle Applications Release 12 environment under Suse Linux. The Online Documentation Library at http://download-west.oracle.com/docs/cd/B34956_01/current/html/homeset.html is a good place to view user and administration guides for the various products you may be interested in learning more about.
The environment file for the applications is located in the base directory /apps/apps_st/appl/APPS{sid}_{host}.env. Source this environment file and cd to $ADMIN_SCRIPTS_HOME to start/stop the applications.
The environment file for the database is located in the base directory /db/tech_st/10.2.0/{sid}_{host}.env. Source this file to start/stop the database and listener.
If you want to recompile R12 executables linked to the ILOG CPLEX libraries (MSC, MSO, MSR, etc), modify the $AD_TOP/bin/adrelinknew.sh script. Look for LINUX, and add -Wl,--noinhibit-exec to the end of CPP_LDFLAGS line.
You now have a fully functional ERP demonstration system on a current OS. Since SLES10 is kernel equivalent to Suse 10.1, these instructions also work on that desktop version as well.
 楼主| 发表于 2007/8/17 12:06:48 | 显示全部楼层
Oracle EBS R12 for Linux的安装详见帖子
http://bbs.erp100.com/thread-11562-1-1.html
发表于 2007/8/17 13:48:44 | 显示全部楼层
帮顶,已经在Oracle Enterprise Linux上安装成功了
 楼主| 发表于 2007/8/17 14:44:54 | 显示全部楼层
原帖由 yanerwei 于 2007-8-17 13:48 发表
帮顶,已经在Oracle Enterprise Linux上安装成功了

希望分享你的经验给大家!赫赫!
发表于 2007/8/17 14:56:53 | 显示全部楼层
不错
发表于 2007/8/18 15:41:24 | 显示全部楼层
非常详细!谢谢
 楼主| 发表于 2007/8/19 22:04:36 | 显示全部楼层
Oracle&reg; Applications Installation Guide -Using Rapid Install

Oracle&reg; Applications Installation Guide -Using Rapid Install.pdf

2.7 MB, 下载次数: 62, 下载积分: 努力值 -5 点

 楼主| 发表于 2007/8/23 15:39:59 | 显示全部楼层

E-Business Suite Installation (11i)

E-Business Suite Installation
This section give you a guide to install Oracle Application on microsoft windows.
OS:            Windows XP With SP1
EBS: 11.5.10IP:                   192.168.1.101
PC Name:         huajhua
Domain: leiko.com, you need not add to domain in deedRAM: 512M, 1.5G Virtual Memory
Disk Space:      80G, 20G For Stage File, 60G For Installation.


1.1.
Pre-Installation

操作系统

最好是干净的系统。
如果以前装过Oracle相关产品,要删除所有Oracle安装(注册表中的Oracle和服务、系统盘下的\Program Files\Oracle\Inventory、环境变量)。
Setup Printer On Windows

添加打印机,如果无法添加,请检查“Print Spooler”服务是否启动。如果没有装打印机,RPT类型的请求将无法运行,会报REP-3002: Error initializing printer。
可以添加实际的打印机,也可以添加虚拟的打印机,后者需要选择打印端口为“文件”。
接下来是选择驱动程序,如果是虚拟打印机,则随便选一个,比如Epson Stylus COLOR 1520K ESC/PK(图略)。
给打印机命名为“noprint”。
是否打印测试纸选择“否”。
Setup Hosts

设置Host文件,否则安装过程中检查名称解析将通不过。
Setup Static IP Address And DNS Suffix

在“本地连接”的属性里面设置静态IP和DNS后缀。
Setup Microsoft Visual C++ 6.0

Oracle 安装过程中需要调用VC6的link命令。安装VC英文版即可,路径:E:\VC98。(Metalink说C:\ VC98,不知道为什么不用VC6默认的安装路径;我改成E盘根目录)。安装VC、ActiveX、Data Access三个组件即可。装完把link.exe拷贝到System32目录,重启。
Setup MKS Toolkit

必 须安装MKS Toolkit,Oracle安装过程中需要调用Unix命令(比如which/cc),这些命令在Windows下没有,而MKS Toolkit可以在Windows下模拟大部分Unix命令。安装路径:E:\MKS。(Metalink说C:\MKS,不知道为什么不用MKS Toolkit默认的安装路径;我改成E盘根目录)
Setup GNU Make

Oracle安装过程中需要调用gnumake命令。从http://ftp.gnu.org/pub/gnu/make/下载,比如make-3.80.tar.gz,解压,在命令行下build_w32.bat,第一遍有问题,再运行一遍就可以了;然后把WinRel下的gnumake.exe拷贝到J:\MKS\mksnt。运行

1.2.
Installation

Using Stage Directory

可以从DVD光盘安装,也可以把所有文件拷贝到硬盘,然后从硬盘安装,避免安装过程中不停的换光盘。从http://edelivery.oracle.com/EPD/GetUserInfo/get_form下载的文件,解压缩之后自然形成需要的目录结构,如下。
针 对11.5.10.2版本,需要Oracle&reg; Applications 11i Release 11.5.10.2 Rapid Install Start Here - Disk 1 (Part 7 of 7)(1张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install RDBMS - Disk 1(3张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install Databases - Disk 1(7张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install Databases - Disk 2(6张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install Databases - Disk 3(6张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install Tools - Disk 1(3张)、Oracle&reg; Applications 11i Release 11.5.10.2 for Microsoft Windows Rapid Install APPL_TOP - Disk 1(7张)
Start Rapidwiz

必须从命令行运行startCD\Disk1\rapidwiz下的rapidwiz,启动安装程序。
Welcome Informaiton

出来欢迎界面。
Select Wizard Operation

选择安装模式,初次安装请选择“Install Oracle Application E-Business 11i”,下面的“Use Express Configuration”不要选,这样我们可以自己配制安装选项,了解安装任务。

Load Configuration

第一次运行Rapidwiz,没有安装配置文件,所以要选择No,以后再启动Rapidwiz,就可以选择以前保存的安装配置文件。
Install Type

选 择Single-node (All Services on a single node),所有服务都装在一台机器上。如果选择Multi-node,那么可以选择数据库和Concurrent Manager装在一台机器上,HTTP/FORM/REPROT服务和Application装在另一台机器上。

Define Database Type

选择Vision Demo的话会装一个演示环境,需要90G的空间。选择Fresh Database,会安装一个空的数据库,所有模块的设置都需要从头进行。
Database Install Information

选择数据库安装目录。选择Advance,可以把DB Oracle Home/SYS数据文件/LOG文件/Transaction数据文件/归档文件装在不同的磁盘上。这里没有提供控制文件的安装路径选择,只好待安装完之后,再来移动控制文件。

Select Licensing Type

这里的License选择,仅仅代表你买了什么产品,并不会影响功能模块的使用。安装完之后也可以通过OAM来添加License。
E-Business Suite Licensing模式默认选择了一些常用的模块。
Component Applications Licensing模式则需要我们手工选择,如Order Management /Inventory Management/Purchasing/Discrete Manufaturing/Financials/Human Resources。

Select Country-specific Functionalities

选择本地化功能,很多国家和地区都有一些特殊的本地化功能,比如Europe。为使安装最小化,这里我不选。
Select Additional Languages

默认只有American English,可以添加其他语言,比如Chinese,启用NLS。这里的选择还不够,需要在安装完之后打相应的语言包。为使安装最小化,这里我不加新的。

Select Inernationalization Settings

选择主语言、区域、数据库字符集、应用字符集,如果选择非US7ASCII,那么安装过程中,会自动对数据库进行字符集转换(我猜是针对数据库)。(注,在Adadmin里面也有字符集转换功能,我猜是针对应用)。
Configuration Information for Node

选择工具文件的路径和Application及Application Server的路径;这里同样可以分别定义APPL/ORA/IAS的路径。

Global System Settings

必 须输入一个域名。同时选择端口的偏移量,比如登录应用默认是8000,如果偏移1则为8001,其他各个端口都是如此;这样可以做到在一台机器上安装多个 Instance而端口不会冲突;当然可以个别指定某一服务的端口,特别是当端口已被机器上的其他服务占用时,就必须个别指定了。
Save Instance-Specific Configuration

保存上面辛辛苦苦做的安装设置,以便下次重新安装或者Restart时直接使用。

System Check Status

加查各种环境是否满足安装要求,比如端口是否可用、域名解析是否通过、需要的基本命令是否可用、磁盘空间是否足够等等
Validate System Configuration

加查结果。必须所有项目均OK,否则必须查出原因,直到检查通过。我碰到过两个问题:某一端口被其他程序占用(于是我Back到前面步骤改了该端口)、System Unilities Chek通不过(查看明细发现Which命令不成功,于是我卸载MKS后重新安装)。
Component Installation Review

最后Review所有设置,后悔还来得及。
Installation Confirm

确认开始安装。


Step 1 Of 5

安装数据库,没有问题。
Step 2 Of 5

安装数据库文件,并进行字符集转换,没有问题。



Step 3 Of 5

安装应用服务IAS和8.0.6,有问题,最后一直停留在100%,硬盘也没读写。
关掉安装程序,rapidwiz -restart再次运行,这次要选择上次保存好的配置文件,安装程序自动跳过前两个Step,但Step 3依然有问题,再关掉,再用rapidwiz -restart,通过。


Step 4 Of 5

安装Application文件和Comn文件,如AU_TOP,Form,SQL,Report等,没有问题。
Step 5 Of 5

系统配置,执行AutoconfigAdadmin等,没有问题。

Post-Install Checks

安装完之后的各项检查,自动完成。
Finish

大功告成!




1.3.
Post-Installation

登录操作系统

运行%APPL_TOP下的envshell.cmd,进入命令行,envshell.cmd会调用APPSPROD_<Machine>.cmd设置应用的环境变量,比如各个TOP。Unix下用应用帐户直接Telnet上去即可。
进入adadmin

命令行下运行adadmin,除了system的密码需要输入外,各个参数默认即可。
这样就进入到Adadmin主菜单。
Update Snapshot Information

更新快照信息,以后打patch需要,这一步需要近一个小时。需要把并发管理器停掉,最好把应用也停了,只留数据库。
选择2,Maintain Applications Files and Registry Menu。
选择5,Maintain Snapshot Information
选择2,Update Current View Snapshot即可
系统开始更新快照,耐心等待。
Compile Flexfields

在主菜单界面选择3,Compile/Reload Applications Database Entities menu。
进入之后选择3,Compile flexfields。
Apply Maintainace Patch

针对11.5.10,需要打Patch 3140000/346000;从Metalink下载。
下载下来解压到同一个目录,即可用adpatch工具打上去。
Apply 2451368 Patch

这里以打2451368 Patch为例。这个Patch是AR的多组织转换Patch,如果不打,在执行Convert To Multi-Org的时候会报警告。
先运行adadmin,切换到5,Change Maintenance Mode,然后Enable Mainenance Mode。

退出adadmin,进入到2451368 Patch所在的目录,如E:\Stage11i\patch\2451368,直接运行adpatch,按照提示操作即可。
打完Patch,再进入adadmin,disable maintenace mode。

1.4.
Installation Test

启停数据库、应用服务

进入Windows服务界面,启动顺序如下:
1、起来数据库服务
2、起来数据库侦听
3、起来应用侦听
4、这几个随便:apache服务,reports服务,forms服务,并发管理器服务

停止的时候反过来即可。
也可以通过命令来完成,请参考本文档相关章节;也可参考下面主页的Machine Admin Scripts。
登录

http://192.168.1.101:8000//OA_HTML/US/ICXINDEX.htm,以sysadmin登录。
选择System Adminsitrator职责
定义用户

请参考本文档相关章节。
Assign Responsibility To User

请参考本文档相关章节。
测试报表

运行Active Users报表。
View Output/View Log/Copy File

选择View Output,View Log,并在Tools菜单下选择Copy File…,看是否正常。
测试Export功能

查出上面建的用户,把鼠标移入Responsibility,选择File/Export,看是否弹出保存文件的窗口。
测试TCF Port

进入IE,输入http://192.168.1.101:8000/OA_HTML/jsp/fnd/aolj_tcf_test.jsp?t=1,报“无法显示网页”,烦。
测试Jserv Port

进入IE,输入http://192.168.1.101:8000/OA_HTML/jsp/fnd/aoljtest.jsp,看是否正常。
我的系统报:
Missing e:\oracle\prodcomn\java\apps.zip
Missing e:\oracle\prodora\iAS\portal30\jpdk\lib\partnerApp.jar
Missing e:\oracle\prodora\iAS\mapviewer\lib\sdoapi101.jar
Missing e:\oracle\prodora\iAS\mapviewer\lib\sdovis.jar
Missing e:\oracle\prodora\iAS\mapviewer\lib\mapviewer118.jar

不管它,很多人都碰到;Metalink说可以在jserv.properties等文件中把相关条目注释掉。
选择页面底部的Enter AOL/J Setup Test以进行更多的测试,我的大部分是“无法显示网页”,懒得上Metalink查了,以后用系统有问题再说。
CGI方式登录

http://huajhua.leiko.com:8000/dev60cgi/ifcgi60.exe,登录报APP-FND-01542,打开$APPL_TOP/admin/<SID>_<hostname>.xml,把里面的s_appserverid_authentication从SECURE改为OFF,adautocfg一下。
不过以后打Patch之前要记得改回来。
测试Workflow

以sysadmin登录,选择Workflow Administrator Web Applications职责,选择Item Type Definition,随便找一个,然后Run,参数随便填。下面是成功运行的工作流Requisition的Diagram。
2.
维护


2.1.
Patch

打Patch通用步骤

检查已安装模块版本:
SELECT app.application_short_name, app.application_name, pi.patch_level
FROM fnd_product_installations pi, fnd_application_vl app
WHERE app.application_id = pi.application_id

检查已安装Patch:
SELECT * FROM ad_applied_patches WHERE patch_name = '2451368'。

从Metalink找到需要的Patch,然后
0.
阅读Read readme document,看有没有条件,下载,用Unzip解压

1.      applmgr用户登录操作系统
2.
设置环境变量( $APPL_TOP/APPSORA.env)

3.
停应用 adstpall.sh (至少要停并发服务器),数据库和监听保持启动状态

4.
用adadmin Enable Maintenance Mode

5.
之后,运行adpatch命令,从cxxx.drv开始打,然后是dxxx.drv,gxxx.drv

6.
用adadmin Disable Maintenance Mode

7.
启动应用 adstrall.sh


2.2.
小系统性能调整
由于我的笔记本只有512M内存,所以有必要调整系统性能,否则跑起来太慢。对于内存超过1G的系统,可以不用考虑。
原来系统起来约用内存1.2G,登录系统后约1.3G-1.5G;经过调整,系统起来约用内存600M,进入系统之后700M多。
停止不必要的Windows系统服务

Windows本身有很多服务是可以停止的。具体可查看网上资料;最后我系统启动之后内存占用不到100M;启动Word2003之后约125M。
停止MKS相关程序和服务

MKS Secure Shell Service/MKS Telnetd/MKSAUTH/NuTCRACKER Service都不需要,可以设为手动。此外还有一个伴随Windows一起启动的MKS程序也干掉。
Oracle相关服务

把所有的Oracle服务设为手动,有些原来自动起来的服务其实一般都用不上,比如:
Oracle Fulfillment Server PROD_huajhua
Oracle Metrics Client PROD_huajhua
Oracle Metrics Server
PROD_huajhuaOracleDiscoverer4i_PROD。

以后可以根据需要启动,要用数据库,可启动:
OraclePROD_db920_RDBMSTNSListenerPROD
OracleServicePROD

如果要用Application,先启动数据库,再启动应用服务:
OraclePRODOra806_2TNSListener80APPS_PROD
Oracle Apache Server PROD_huajhua
O OracleFormsServer-Forms60PROD_huajhua

如果要运行请求,那么再启动
racleConcMgrPROD_huajhua

如果要运行报表,那么再启动
Oracle Reports Server [Rep60_PROD]

Init<SID>.ora

编辑DB Oracle_Home/9.2.0/dbs下的Init<SID>.ora文件,调整内存参数:
db_cache_size                  = 40000000 #HUAJHUA#Default 163577856
pga_aggregate_target     =150M          #HUAJHUA#Default 1G
shared_pool_size   = 50000000 #HUAJHUA#Default 300000000
shared_pool_reserved_size= 10000000         #HUAJHUA#Default 30000000
java_pool_size                  = 10000000 #HUAJHUA#Default 52428800

由于9i采取自动内存管理(workarea_size_policy=AUTO),所以只要保证后面3个加起来不超过pga_aggregate_target即可。
这时再启动数据库,发现总共内存只用300M多,原来需要700-800M左右。
Apache JServ

Apache一起来就用掉500-600M的内存,我发现可以调整Jserv的配置文件以减少不必要的加载,主要是jar文件。
先备份%IAS_ORACLE_HOME%\Apache\Jserv\etc文件夹
编 辑jserv.conf、jserv.properties、jserv.properties.org、 jserv_restrict.properties这4个文件,注释掉所有和disco4iviewer、emailcenter、mobile、 viewer4i、xmlsvcs、Portal有关的语句。这一步可以减掉约200M内存;数据库、Form/Report、Apache起来之后只有 500M。#HUAJHUA#

应该还有其他地方可以调,有空再研究。
注意,运行adautocfg之后,这些都会被覆盖,所以要重新配置,不然会奇怪为什么内存突然又长上去了。
Concurrent Manager

通过Windows Task Manager可以发现,里面有大量的exe文件在运行,有的5个,有的3个。
FNDLIBR.exe
FNDCRM.exe           Conflict Resolution Manager
POXCON.exe
INVLIBR.exe
RCVOLTM.exe
CONCSUB.exe
……

其实这些都是并发管理器,如果把它们调为1,这样又可以少占一些内存,而且可以提高系统运行速度。
N: System Administrator\Concurrent\Manager\Define
查 出全部Enabled的并发管理器,点击Work Shifts,可以调整每个管理器的Processes数。Conflict Resolution Manager定2个,Standard Manager定2个,其他的全部调为1。以后如果碰到请求处于Pending状态,再来调整也不迟。如果做得绝一点,只留Internal Manager和Standard Manager,其它的等运行相关请求时报“No Manager”再来调也可以!
这样,整个系统起来之后,加一个Word,一个IE,一个SnagIT,约630M内存!
Scheduled Concurrent Program

参见下个主题。
JVM参数

最 近又发现%APPLTOP%\Admin\PROD_huajhua.xml的内容通过adautocfg写到各个地方的配置文件。其中关于JVM的参数 很值得怀疑,因为每次Apache起来,系统都有3个java.exe进程,而且狂占内存,我想这个跟JVM的内存参数有关:< jvm_options oa_var="s_jvm_options" osd="NT">-verbose:gc -Xmx512M -Xms128M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB </jvm_options>。这样的内存参数在文件有几个地方。
我把上面的改为-Xmx128M -Xms64M -XX:MaxPermSize=64M;还有几个地方也作类似的调整。
重新运行auto config,然后重新调整了上面提到的“Apache JServ”,发现内存果然锐减!

2.3.
Seeded Concurrent Program Scheduled

系统安装之后,有几个Scheduled的程序。
OAM Applications Dashboard Collection

如 果进入OAM页面,即下面的Oracle Application Manager,那么可以看到很多管理参数和性能参数;OAM Applications Dashboard Collection就是用来动态收集这些信息的。可以考虑把它取消,以后需要的时候手工运行。
Purge Debug Log and System Alerts

还没研究清楚;本来是每天运行,先停掉再说。
Workflow Control Queue Cleanup

还没研究清楚;本来是每天运行,先停掉再说。
Synchronize Workflow LOCAL tables (Report Set)

还没研究清楚,Metalink说是用来同步各个模块的User和Role信息;本来是每天运行,先停掉再说。




[ 本帖最后由 bob 于 2007-8-23 15:42 编辑 ]
发表于 2007/8/23 16:27:07 | 显示全部楼层
版本够多的
发表于 2007/8/30 10:36:32 | 显示全部楼层
哇,好详细.帮忙顶一下.谢谢楼主.
发表于 2007/9/4 10:21:50 | 显示全部楼层
好文章!好文章!支持!
发表于 2007/9/5 11:45:15 | 显示全部楼层
謝謝樓主!~~幫忙頂一下.............up
发表于 2007/9/9 22:44:15 | 显示全部楼层
请问 Add 'C:\cygwin\bin' to the system path.  是什么意思,是将哪几个文件COPY到 system32 下吗?
发表于 2007/9/9 22:49:22 | 显示全部楼层
Add 'C:\cygwin\bin' to the system path.

是加入“环境变量”吗?
发表于 2007/12/7 22:21:05 | 显示全部楼层
顶顶顶顶 谢谢共享
发表于 2008/5/30 10:14:02 | 显示全部楼层
真是好贴!
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|小黑屋|手机版|壹佰网 ERP100 ( 京ICP备19053597号-2 )

Copyright © 2005-2012 北京海之大网络技术有限责任公司 服务器托管由互联互通
手机:13911575376
网站技术点击发送消息给对方83569622   广告&合作 点击发送消息给对方27675401   点击发送消息给对方634043306   咨询及人才点击发送消息给对方138011526

GMT+8, 2025/11/29 22:25 , Processed in 0.045682 second(s), 15 queries , File On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表