EBS R12 功能与菜单对照表

Form Menu Web Function
Security User Menu - System Administrator GUI Security->User ORACLE Usernames

.bash_profile修改后报syntax error: unexpected end of file原因与修正

profile 内容
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
unset USERNAME
PATH=$PATH:$HOME/bin:/usr/java/jdk1.5.0_15/bin:/usr/java/jdk1.5.0_15/jre/bin
export PATH
. /d01/oracle/PROD/apps/apps_st/appl/APPSPROD_ebsap.env
错误提示
login as: appl
appl@hostname's password:
Last login: Tue Mar 10 09:16:42 2009 from 10.20.25.16
: command not found
-bash: /home/appl/.bash_profile: line 17: syntax error: unexpected end of file
-bash-3.00$ : command not found

造成错误的原因：
profile的最后一行位回车。
删除回车后问题解决。

EBSr12 安装时RW-50004 错误的解决办法

注意一般产生这个错误有两个原因
1）java 环境变量设置的问题‘
如下
建立LINK：ln -s jdk /usr/java/jdk1.5.0_10
在/etc/profile增加以下变量：
export JAVA_HOME="/usr/jdk"
export CLASSPATH=$JAVA_HOME/lib:$JAVA_HOME/jre/lib:.
export PATH=$PATH:$JAVA_HOME/bin:$JAVA_HOME/jre/bin
在用户applvis/oravis目录下的.bash_profile中添加如下变量说明
PATH=$PATH:$HOME/bin:/usr/java/jdk1.5.0_10/bin:/usr/java/jdk1.5.0_10/jre/bin
export PATH
我的错误造成的原因是安装了jdk1.5.0_15但是按上述设置操作。（上面的1.5.0_10改为1.5.0_15就可以解决这个问题了）
造成了RW-50004错误
2是对安装目录是否具有完全控制的权限。
如果没有也会产生这个错误。
附件儿为metalink的解决办法，不过是针对64位版本的

附

Metalink解决办法

Subject:	Getting RW-50010 and RW-50004 Errors When Installing Oracle Applications Release 12.0 on Linux 64-bit
	Doc ID:	468695.1	Type:	PROBLEM
	Modified Date:	13-JUN-2008	Status:	MODERATED

In this Document
Symptoms
Cause
Solution
References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Application Install - Version: 12.0
Linux x86-64

Symptoms

Getting the following error when trying to install Oracle Applications Release 12.0 on a 64-bit Linux platform:

RW-50010: Error: - script has returned an error: 127
RW-50004: Error code received when running external process. Check log file for details.

Cause

The install script uses JRE from the /tmp/RapidInstall/jre/Linux/ location

This issue only occurs if running rapidwiz from a startCD outside the stage area or if installing directly from the install DVDs. This has been raised with Oracle Development in Bug 7169043

Solution

Make sure all setup steps were completed based on the following note:

Note 416305.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (64-bit)

Until Bug 7169043 is resolved, use the following workaround.

Workaround

- Create the following directory if not present:

mkdir /tmp/RapidInstall/jre/Linux

- Copy the contents of /tmp/RapidInstall/jre/Linux_x64 to this directory:

cp -r /tmp/RapidInstall/jre/Linux_x64 /tmp/RapidInstall/jre/Linux

Alternatively, stage the entire DVD media using adautostg.pl, and install from the startCD within the stage area

References

Note 416305.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (64-bit)
Bug 7169043 - NON-STAGED R12 INSTALL FAILS FOR LINUX_X64 ON ADRUN10G.SH, ADRUNIAS.SH ETC

---

Help us improve our service. Please email us your comments for this document. .

***************************************************************************

Applies to:

Application Install - Version: 12.0.4
This problem can occur on any platform.

Symptoms

On R12 in Test env :
When attempting to Fresh install the R12 using the lastest Rapidwiz version 12.0.4.7, the
following error occurs.

ERROR

Statusstring Registering Applications Technology Stack

Executing command: /u050/stage/ebus/StageR12/startCD/D
isk1/rapidwiz/jre/Solaris/1.5.0//bin/java -DCONTEXT_VALIDATED=true -mx512M -cla
sspath /u050/stage/ebus/StageR12/startCD/Disk1/rapidwiz/jlib/java:/u050/stage/eb
us/StageR12/startCD/Disk1/rapidwiz/jlib/xmlparserv2.jar:/u050/stage/ebus/StageR1
2/startCD/Disk1/rapidwiz/jlib/ojdbc14.jar:/u050/stage/ebus/StageR12/startCD/Disk
1/rapidwiz/jlib/oui/OraInstaller.jar:/u050/stage/ebus/StageR12/startCD/Disk1/rap
idwiz/jlib/oui/ewt3.jar:/u050/stage/ebus/StageR12/startCD/Disk1/rapidwiz/jlib/ou
i/share.jar:/u050/stage/ebus/StageR12/startCD/Disk1/rapidwiz/jlib/oui/srvm.jar o
racle.apps.ad.clone.ApplyAppsTechStack -e /u036/oracle/UATE/inst/apps/UATE_dev1z
one5/appl/admin/UATE_dev1zone5.xml -stage /u050/stage/ebus/StageR12/startCD/Disk
1/rapidwiz -showProgress -phase reg

RW-50010: Error: - script has returned an error: 1
RW-50004: Error code received when running external process. Check log file
for details.
Running APPL_TOP Install Driver for UATE instance
Please refer to the remaining logs on applications node at -
/u036/oracle/UATE/inst/apps/UATE_dev1zone5/logs/06170857.log

Processing DriverFile = /u050/stage/ebus/St

Cause

The newer Rapidwiz version 12.0.4.7 or 12.0.4.8 looks corrupted.

This cause is outlined in the following bug :

Bug 7138936 10.2.0.3 INSTALL 12.0.4
Abstract: RAPID INSTALL 12.0.4.7 FAILING WITH RW-50004

PROBLEM STATEMENT:
------------------
Attempting to install eBiz R12.0.4 using the latest Rapid Install wizard
12.0.4.7(supplied by The Patch 6796703) but it is failing with the error:
.
RW-50004: Error code received when running external process.

Solution

To implement the solution, please execute the following steps:

1) Make sure that the user who is executing Rapidwiz has write permission on the OraInventory.

Check if you are not in the scenario for this Bug 7138936 , NOT A BUG.

Please find the extract of the bug :

a- The owner of the installation is "ora1" user.

more /var/opt/oracle/oraInst.loc

shows :
inventory_loc=/test/oracle/ora3/home/oraInventory
install_group=dba

The owner of that inventory location is "ora3", but "ora1" user cannot write on that directory...

$ id
uid=100417(ora1) gid=101(dba)
$ pwd
/test/oracle/ora3/home/oraInventory/logs

$ touch test
touch: test cannot create

Fix:

a- As "ora3" user, do : chmod 777 /test/oracle/ora3/home/oraInventory

b- As "ora1", cd /test/oracle/ora3/home/oraInventory/logs, touch test

Dev's explanation :

===========

When there is a failure on the OH registration, the rest of actions don't
take place (ex relink, sym link recreation, library generation, etc).
This issue was caused by an incorrect registration.

2) If this bug 7138936 above is not relevant to your situation, to fix, please use the workaround below :

1. Rename this startCD(rapidwiz12.0.4.7) direcrtory to startCD12047

and download, unzip the working "startCD Rapidwiz version 12.0.4.6"

Nb: At the time of this note was written, this Rapidwiz version 12.0.4.6 Patch 6502109 was available

on Metalink.

2. Clean up the previous failed installation :

Use Note 110372.1 - 11i: How to Clean up the UNIX Environment After Install Fails

3 Restat the R12.0.4 installtion using startCD Rapidwiz version 12.0.4.6.

Error: An error has occurred in a Lotus Notes application. Data about the error is being collected for your company's helpdesk for use in error analys

Error: An error has occurred in a Lotus Notes application. Data about the error is being collected for your company's helpdesk for use in error analys

Problem:

Error: "An error has occurred in a Lotus Notes application. Data about the error is being collected for your company's helpdesk for use in error analysis.The Lotus Notes application will close when data collection is complete ". This error occurs during what seems to be normal processing.

Resolution: To resolve this problem, follow the steps below:

1. Close Notes and delete the log.nsf and cache.ndk files from the C:\notes\data directory.

2. Rename names.nsf bookmark.nsf

4. Reconfigure Notes

EBS R12 在 FF3.05上运行 windows 环境

如果想要做Firefox3上运行EBS Form。
必须安装Java Runtime Environment 5.0 Update 13
（JRE5 Update13 下载地址
http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jre-1_5_0_13-windows-i586-p.exe?BundledLineItemUUID=3aNIBe.oWBkAAAEew.5E4ejh&OrderID=Eu1IBe.op.wAAAEep.5E4ejh&ProductID=I4LACUFBa1cAAAEYhS05AXuY&FileName=/jre-1_5_0_13-windows-i586-p.exe
否则Form无法在firefox上运行
(注意，千万不要在升级了，否则form还是无法运行）

EBS R12 无法以sysdba 登陆问题的解决办法

sqlplus / as sysdba

无法登陆

如果你的application和db时装在同一台机器上的，就无法用dba权限登陆.
即使你重新创建密码文件。修改sys密码。。

原因:

如果默认的安装在同一台机器上。
默认使用的是ORACLE_HOME是8.0.6，在这个版本的客户端无法使用dba权限登陆
9.2.0.3的数据库。

解决办法:

可以临时指定到9.2.03的ORACLE_HOME，然后用这个/bin下的sqlplus，即可
正常登陆database.

VMware 与主机时间同步 （转）

vmware时间同步问题是一个难题，根据本人使用vmware经验，vmware的时间同步可以有如下几个方法：

一、用VMWARE TOOLS同步时间
注意：如果是用复制文件的方法创建虚拟系统，最好是在复制完文件之后分别安装VMWARE TOOLS。
1） 安装vmware tools
在 VMware 控制台上，以 root 用户身份登录。
1. 单击 VM，然后选择 Install VMware Tools。
2. rac1 — 虚拟机：单击 Install。
3. 双击桌面上的 VMware Tools 图标。
4. cdrom：双击 VMwareTools-1.0.1-29996.i386.rpm。
5. 完成系统准备：单击 Continue。
6. 打开一个终端并执行 vmware-config-tools.pl。(此功能用来调节分辨率）
输入所需的显示大小：2 800*600
2） 与主机同步时间
要确保成功安装 Oracle RAC，虚拟机上的时间必须与主机上的时间同步。执行下面的步骤，以 root 用户身份同步时间。
1. 执行“vmware-toolbox”以显示 VMware Tools Properties 窗口。在 Options 选项卡下，选择 Time synchronization between the virtual machine and the host operating system。您应该发现 tools.syncTime = "TRUE" 参数已经追加到虚拟机配置文件 G:\vm\rac\rac1\rac1.vmx 中。
2. 编辑 /boot/grub/grub.conf，并将选项“clock=pit nosmp noapic nolapic”添加到读取内核 /boot/ 的那一行。修改后的文件内容如下所示：
[root@rac1 ~]# more /boot/grub/grub.conf
default=0
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title Red Hat Enterprise Linux AS (2.6.9-42.ELsmp)
root (hd0,0)
kernel /vmlinuz-2.6.9-42.ELsmp ro root=LABEL=/ rhgb quiet clock=pit nosmp noapic nolapic
initrd /initrd-2.6.9-42.ELsmp.img
title Red Hat Enterprise Linux AS-up (2.6.9-42.EL)
root (hd0,0)
kernel /vmlinuz-2.6.9-42.EL ro root=LABEL=/ rhgb quiet clock=pit nosmp noapic nolapic
initrd /initrd-2.6.9-42.EL.img

二、修改配置文件的方式
如果这样做还不行，则修改文件：C:\Documents and Settings\All Users\Application Data\VMware\VMware Server\config.ini
添加如下三行：
host.cpukHz = "1700000"
host.noTSC = "TRUE"
ptsc.noTSC = "TRUE"

其中：host.cpukHz要根据你的cpu的实际主频修改，例子中表示CPU主频是1.7G。
这个方法适用于windows系统，VMWARE SERVER系列软件。

三、RAC间同步
如果要用vmware安装RAC，则各个几点间时间必须一致，可以以一个节点作为标准，其他节点与该节点进行时间同步。
假如有两个节点：
A: 200.200.200.1
B: 200.200.200.2

以A作为时间标准，B节点用A节点时间进行同步。
1、在A节点开放37端口
最简单，但也最不安全的方法是关闭防火墙：iptables -F

2、在A节点启动时间服务
chkconfig time on
如果不启动该服务，则其他节点与该节点同步时间时会报错：Connect Refused

3、在B节点与A节点同步时间
rdate -s 200.200.200.1

可以做一个定时任务，每分钟同步一次。

或

修改C:\Documents and Settings\All Users\Application Data\VMware\VMware Workstation\config.ini 并且编辑:

1. host.cpukHz = "2212495"
2. host.noTSC = "TRUE"
3. ptsc.noTSC = "TRUE"
4. processor0.use = "FALSE"
5. processor1.use = "TRUE"