| 总页数：3页 |
![clip_image002[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371734lH1H.gif "clip_image002[4]")
Oracle_Discoverer10G_Server安装配置
(V 1.0)
文章版权所有Jusin Hao（luckyfriends），支持原创，转载请注明。
2012年8月
版本信息
| 日期 | 版本 | 描述 | 作者/修改人 | 备注 |
| 2012-8-31 | 1.0 | 创建 | Jusin Hao | |
目 录
5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer 54
5.6.2. 下图为打开后的Discoverer Plus 94
6.1. EUL(end user layer)是什么：... 94
1. 介绍
1.1. 编写目的
此文档主要用于 EBS R12 BI（Discoverer）的安装介绍。包括：
· 源系统clone前的准备如配置、环境变量监测
· 安装Discover er
· Patch监测安装
· 配置Discoverer
· 调用Discoverer
1.2. 文档说明
此文档用于：
· 安装EBS BI -----Discoverer
· 配置Disoverer
· 调用Discoverer
1.3. 定义
1.4. 参考文档
2. 安装Discoverer
2.1. 检查系统设置、环境变量等值的设置
| Item | Requirements |
| Operating System | Red Hat Enterprise Linux AS/ES 4.0 For more information on Red Hat, see: The minimum supported kernel versions are: kernel-2.6.9-11.EL kernel-smp-2.6.9-11.EL kernel-hugemem-2.6.9-11.EL |
| Software packages (check that these versions or higher versions are installed) | glibc-2.3.4-2.9 glibc-common-2.3.4-2.9 binutils-2.15.92.0.2-13 compat-libstdc++-296-2.96-132.7.2 gcc-3.4.3-22.1 gcc-c++-3.4.3-22.1 libstdc++-3.4.3-22.1 libstdc++-devel-3.4.3-22.1 openmotif21-2.1.30-11.RHEL4.4 pdksh-5.2.14-30 setarch-1.6-1 make-3.80-5 gnome-libs-1.4.1.2.90-44.1 sysstat-5.0.5-1 compat-db-4.1.25-9 control-center-2.8.0-12 xscreensaver-4.18-5.rhel4.2 |
检查系统组件是否安装齐全（可使用命令rpm –q |grep 包名）
修改系统内核参数 （/etc/sysctl.conf ）
| semmsl semmns semopm semmni | 256 32000 100 142 | /proc/sys/kernel/sem |
| shmall | 2097152 | /proc/sys/kernel/shmall |
| shmmax | 2147483648 | /proc/sys/kernel/shmmax |
| shmmni | 4096 | /proc/sys/kernel/shmmni |
| msgmax | 8192 | /proc/sys/kernel/msgmax |
| msgmnb | 65535 | /proc/sys/kernel/msgmnb |
| msgmni | 2878 | /proc/sys/kernel/msgmni |
| file-max | 131072 | /proc/sys/fs/file-max |
| ip_local_port_range | 10000 65000 | /proc/sys/net/ipv4/ip_local_port_range |
[root@myerp ~]# more /etc/sysctl.conf
kernel.core_uses_pid = 1
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
（我在安装EBS和Clone EBS的时候设置kernel.shmmax = 2147483648 是正常的，而在这里安装Discover会提示 需要设置为4294967295；
我在安装EBS和Clone EBS的时候设置fs.file-max = 65536 是正常的，而在这里安装Discover会提示 需要设置为206173；因此，我在这里对这两项做了修改）
如下图所示为我安装时提示的警告：
![clip_image004[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237173571ch.jpg "clip_image004[4]")
![clip_image006[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371735tkQx.jpg "clip_image006[4]")
修改后运行sysctl –p 使修改生效
在文件/etc/security/limits.conf 中添加如下内容
* soft nproc 2047
* hard nproc 16384
* soft nofile 4096
* hard nofile 65535
修改后，保存，重启服务器。
创建Discoverer用户
useradd –g dba disprod –u 502
查看目标系统linux版本
[root@myerp ora1206]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 6)
Kernel \r on an \m
查看目标系统linux 内核
[root@myerp ora1206]# uname -r
2.6.9-67.ELsmp
2.2. 开始安装Discoverer
这时EBS 系统处于运行状态；
[root@myerp ~]# xhost +
access control disabled, clients can connect from any host
[root@myerp ~]# su -l disprod
[disprod@myerp ~]$ export DISPLAY=172.18.1.18:0.0
[disprod@myerp ~]$ xhost
access control disabled, clients can connect from any host
[disprod@myerp ~]$ xclock
[disprod@myerp ~]$ cd /home/disprod/
[disprod@myerp ~]$ ls
disk1 p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip
disk2 p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip p6880880_102000_LINUX.zip
[disprod@myerp ~]$ ll
total 1979524
drwxr-xr-x 7 disprod dba 4096 Dec 3 2008 disk1
drwxr-xr-x 3 disprod dba 4096 Dec 3 2008 disk2
-rwxr-xr-x 1 disprod dba 320935 Oct 6 08:19 p2617419_10102_GENERIC.zip
-rwxr-xr-x 1 disprod dba 1803762801 Oct 6 08:22 p4960210_10122_LINUX.zip
-rwxr-xr-x 1 disprod dba 723 Oct 6 08:22 p5861907_10122_LINUX.zip
-rwxr-xr-x 1 disprod dba 170592717 Oct 6 08:22 p6472361_10122_LINUX.zip
-rwxr-xr-x 1 disprod dba 24793516 Oct 6 08:22 p6880880_101000_LINUX.zip
-rwxr-xr-x 1 disprod dba 25530781 Oct 6 08:23 p6880880_102000_LINUX.zip
[disprod@myerp ~]$ cd disk1/
[disprod@myerp disk1]$ ls
B24490-01.zip doc install quicktour runInstaller stage utils welcome.html
[disprod@myerp disk1]$ ./runInstaller 开始安装
-------------------------------------------------------------------------------------------------------------------
The OUI Screen may take around 5 to 30 seconds to come up depending upon system performance. Please Wait .......
-------------------------------------------------------------------------------------------------------------------
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-2.1, redhat-3, redhat-4, SuSE-8, SuSE-9 or UnitedLinux-1.0
Passed
All installer requirements met.
Checking Temp space: must be greater than 400 MB. Actual 7584 MB Passed
Checking swap space: must be greater than 1536 MB. Actual 3738MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed
Checking if CPU speed is above 450 MHz. Actual 1200 MHz Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-07_09-53-41AM. Please wait ...[disprod@myerp disk1]$ Oracle Universal Installer, Version 10.1.0.4.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Applying preferences from file : /ora1206/bi/discoverer/util/pref.txt
Finished applying preferences
opmnctl: opmn is already running
![clip_image008[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371736yY8J.jpg "clip_image008[4]")
![clip_image010[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_13923717364bac.jpg "clip_image010[4]")
root@myerp oraInventory]# sh orainstRoot.sh
Creating the Oracle inventory pointer file (/etc/oraInst.loc)
Changing groupname of /home/disprod/oraInventory to dba.
[root@myerp oraInventory]# cd /ora1206/
[root@myerp ora1206]# ls
allbackup apps bi db inst
[root@myerp ora1206]# chmod -R 777 bi
[root@myerp ora1206]# ll
total 20
drwxr-xr-x 2 oraseed dba 4096 Oct 6 18:15 allbackup
drwxr-xr-x 4 applseed dba 4096 Feb 6 2009 apps
drwxrwxrwx 2 root root 4096 Oct 7 09:51 bi
drwxr-xr-x 4 oraseed dba 4096 Oct 6 18:15 db
drwxr-xr-x 3 applseed dba 4096 Feb 6 2009 inst
![clip_image012[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371737RAol.jpg "clip_image012[4]")
![clip_image014[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_13923717382bw2.jpg "clip_image014[4]")
![clip_image016[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371738U5bq.jpg "clip_image016[4]")
指定端口，这里使用默认的自动分配；如果选用手动分配可以在/ora1206/bi/staticports.ini 查看端口信息：
![clip_image018[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237173830pz.jpg "clip_image018[4]")
![clip_image020[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371739H0EX.jpg "clip_image020[4]")
![clip_image022[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371739U8rG.jpg "clip_image022[4]")
![clip_image024[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371739dVt5.jpg "clip_image024[4]")
![clip_image026[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237174079so.jpg "clip_image026[4]")
![clip_image028[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371740jJMA.jpg "clip_image028[4]")
提示运行/ora1206/bi/root.sh 文件
![clip_image030[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371741z86p.jpg "clip_image030[4]")
[root@myerp ~]# cd /ora1206/bi/
[root@myerp bi]# sh root.sh
Running Oracle10 root.sh script...
\nThe following environment variables are set as:
ORACLE_OWNER= disprod
ORACLE_HOME= /ora1206/bi
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
\nCreating /etc/oratab file...
Adding entry to /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[root@myerp bi]#
开始配置服务：
![clip_image032[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371741SWN1.jpg "clip_image032[4]")
可是我这里报错，如上图所示，因此我一句提示查看日志：
查看日志
[disprod@myerp logs]$ tail -n 400 /home/disprod/oraInventory/logs/installActions2009-10-07_09-53-41AM.log
Result code for launching of configuration assistant is: 1
The OUICA command is launched from /ora1206/bi/oui/bin/ouica.sh.
Starting to execute configuration assistants
-----------------------------------------------------------------------------
Launched configuration assistant 'Oracle Net Configuration Assistant'
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Tool type is: Recommended.
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
The command being spawned is: '/ora1206/bi/jdk/jre//bin/java -Duser.dir=/ora1206/bi/network/jlib -classpath /ora1206/bi/jdk/jre//lib/i18n.jar:/ora1206/bi/jdk/jre//lib/rt.jar:/ora1206/bi/jlib/ewt3.jar:/ora1206/bi/jlib/ewtcompat-3_3_15.jar:/ora1206/bi/jlib/netcfg.jar:/ora1206/bi/network/jlib/netcam.jar:/ora1206/bi/network/jlib/netca.jar:/ora1206/bi/jlib/help4.jar:/ora1206/bi/jlib/jewt4.jar:/ora1206/bi/jlib/oracle_ice.jar:/ora1206/bi/jlib/share.jar:/ora1206/bi/jlib/swingall-1_1_1.jar:/ora1206/bi/jlib/srvmhas.jar:/ora1206/bi/jlib/srvm.jar:/ora1206/bi/network/tools:/ora1206/bi/jlib/ldapjclnt9.jar:/ora1206/bi/jlib/ldapjclnt10.jar oracle.net.ca.NetCA /orahome /ora1206/bi /orahnam oracleas1 /responseFile /ora1206/bi/network/install/netca_asinstall.rsp'
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Exception occured during spawning :java.io.IOException: /ora1206/bi/jdk/jre//bin/java: not found
Spawning the modified command :/ora1206/bi/jdk/jre//bin/java -Duser.dir=/ora1206/bi/network/jlib -classpath /ora1206/bi/jdk/jre//lib/i18n.jar:/ora1206/bi/jdk/jre//lib/rt.jar:/ora1206/bi/jlib/ewt3.jar:/ora1206/bi/jlib/ewtcompat-3_3_15.jar:/ora1206/bi/jlib/netcfg.jar:/ora1206/bi/network/jlib/netcam.jar:/ora1206/bi/network/jlib/netca.jar:/ora1206/bi/jlib/help4.jar:/ora1206/bi/jlib/jewt4.jar:/ora1206/bi/jlib/oracle_ice.jar:/ora1206/bi/jlib/share.jar:/ora1206/bi/jlib/swingall-1_1_1.jar:/ora1206/bi/jlib/srvmhas.jar:/ora1206/bi/jlib/srvm.jar:/ora1206/bi/network/tools:/ora1206/bi/jlib/ldapjclnt9.jar:/ora1206/bi/jlib/ldapjclnt10.jar oracle.net.ca.NetCA /orahome /ora1206/bi /orahnam oracleas1 /responseFile /ora1206/bi/network/install/netca_asinstall.rsp
Configuration assistant "Oracle Net Configuration Assistant" failed
Error initializing configuration assistant log /ora1206/bi/cfgtoollogs
Result code for launching of configuration assistant is: 1
The OUICA command is launched from /ora1206/bi/oui/bin/ouica.sh.
[root@myerp bi]# su -l disprod
[disprod@myerp ~]$ more .bash_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
[disprod@myerp ~]$ cd /ora1206/bi/
-bash: cd: /ora1206/bi/: Permission denied 因为全权限不足，所以我修改/ora1206/bi/权限为777
[disprod@myerp ~]$ cd /ora1206/
[disprod@myerp ora1206]$ ll
total 20
drwxr-xr-x 2 oraseed dba 4096 Oct 6 18:15 allbackup
drwxr-xr-x 4 applseed dba 4096 Feb 6 2009 apps
drwx------ 75 root root 4096 Oct 7 12:06 bi
drwxr-xr-x 4 oraseed dba 4096 Oct 6 18:15 db
drwxr-xr-x 3 applseed dba 4096 Feb 6 2009 inst
[root@myerp ora1206]# chmod -R 777 bi
[root@myerp ora1206]# ll
total 20
drwxr-xr-x 2 oraseed dba 4096 Oct 6 18:15 allbackup
drwxr-xr-x 4 applseed dba 4096 Feb 6 2009 apps
drwxrwxrwx 75 root root 4096 Oct 7 12:06 bi
drwxr-xr-x 4 oraseed dba 4096 Oct 6 18:15 db
drwxr-xr-x 3 applseed dba 4096 Feb 6 2009 inst
更改完目录权限后我再次“Retry”，成功配置服务；
![clip_image034[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371742kiwN.jpg "clip_image034[4]")
退出，完成安装。
![clip_image036[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371742oPpc.jpg "clip_image036[4]")
2.3. 安装完毕显示结果和浏览URL
![clip_image038[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371743CX7s.jpg "clip_image038[4]")
在客户段打开IE浏览器，输入上面的网址，以及用户名密码：ias_admin/discoverer1
![clip_image040[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371743fA12.jpg "clip_image040[4]")
登陆到Discoverer的管理界面；
![clip_image042[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371743xK29.jpg "clip_image042[4]")
2.4. 修改环境变量及重启
[disprod@myerp ~]$ vi .bash_profile
PATH=$PATH:$HOME/bin
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
[disprod@myerp ~]$ source .bash_profile
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
[disprod@myerp ~]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 26384 | Alive
WebCache | WebCache | 26701 | Alive
WebCache | WebCacheAdmin | 26671 | Alive
OC4J | home | 26672 | Alive
OC4J | OC4J_BI_Forms | 26673 | Alive
HTTP_Server | HTTP_Server | 26674 | Alive
Discoverer | ServicesStatus | 26675 | Alive
Discoverer | PreferenceServer | 26676 | Alive
DSA | DSA | N/A | Down
[disprod@myerp ~]$
[disprod@myerp ~]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp ~]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp ~]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
opmnctl: opmn start failed
[disprod@myerp ~]$ emctl start iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Starting Oracle Enterprise Manager 10g Application Server Control ............. started successfully.
3. 安装相关Patch
3.1. 安装p4960210
下载p4960210_10122_LINUX.zip
解压缩安装包
[disprod@myerp ~]$ unzip p4960210_10122_LINUX.zip
[disprod@myerp ~]$ ll
total 1979980
drwxr-xr-x 6 disprod dba 4096 Dec 9 2006 Disk1
[disprod@myerp ~]$ cd Disk1/
[disprod@myerp Disk1]$ ls
doc install readme.html runInstaller stage utils
[disprod@myerp Disk1]$ ./runInstaller
-------------------------------------------------------------------------------------------------------------------
The OUI Screen may take around 5 to 30 seconds to come up depending upon system performance. Please Wait .......
-------------------------------------------------------------------------------------------------------------------
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-2.1, redhat-3, redhat-4, SuSE-8, SuSE-9 or UnitedLinux-1.0
Passed
All installer requirements met.
Checking Temp space: must be greater than 400 MB. Actual 5538 MB Passed
Checking swap space: must be greater than 1536 MB. Actual 3472MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed
Checking if CPU speed is above 450 MHz. Actual 1200 MHz Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-07_01-35-44PM. Please wait ...[disprod@myerp Disk1]$ Oracle Universal Installer, Version 10.1.0.5.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Val: 0
Val: 0
Val: 0
Val: 0
Val: 0
![clip_image044[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237174428p0.jpg "clip_image044[4]")
![clip_image046[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371745hCSS.jpg "clip_image046[4]")
选择安装 Oracle Application server and Developer Suite 10g Rel 2 Software Update 10.1.2.2.0
![clip_image048[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371745btTi.jpg "clip_image048[4]")
![clip_image050[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371746jNgN.jpg "clip_image050[4]")
如果没有在/home/disprod/.bash_profile 中加入
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
可能会报下图的错误，这时可以另外打开终端加入环境变量，并单击下图中的“Retry”； ![clip_image052[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371747t513.jpg "clip_image052[4]")
如果不行可以手动关闭IAS，关闭应用、数据库，然后再“Retry”
[applseed@myerp ~]$
[disprod@myerp bi]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /myclone/bi/sysman/log
[disprod@myerp bi]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp bi]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp bi]$
[applseed@myerp ~]$ /ora1206/inst/apps/came_myerp/admin/scripts/adstpall.sh apps/rich08ll
![clip_image054[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371747sLWL.jpg "clip_image054[4]")
![clip_image056[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371748vq66.jpg "clip_image056[4]")
![clip_image058[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371748B1Z9.jpg "clip_image058[4]")
[root@myerp bi]# cd /ora1206/bi/
[root@myerp bi]# sh root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= disprod
ORACLE_HOME= /ora1206/bi
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
![clip_image060[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371749TJWH.jpg "clip_image060[4]")
![clip_image062[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371749KlVK.jpg "clip_image062[4]")
如果应用和数据库已经关闭，依次启动数据库、应用；IAS这时候已经自动起来了；
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
3.2. 安装opatch：p6880880
[disprod@myerp ~]$ ls
disk1 disk2 p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip readme.html
Disk1 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip
p6880880_102000_LINUX.zip
[disprod@myerp ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
因为我的OUI version 10.1.0.5.0 ，所以如果我安装p6880880_102000_LINUX.zip 的话会提示如下错误；所以我 安装的是p6880880_101000_LINUX.zip；这里要注意；
Patch history file: /ora1206/bi/cfgtoollogs/opatch/opatch_history.txt
LsInventorySession failed:
--------------------------------------------------------------------------------
The Oracle Home does not meet OUI version requirement.
This OPatch (version 10.2.0.4.5) detects OUI version 10.1.0.5.0 in the home.
It requires OUI version 10.2 or above.
OPatch failed with error code 73
[disprod@myerp ~]$ unzip p6880880_101000_LINUX.zip
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/README.txt
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/bt1.txt
inflating: OPatch/docs/bt2.txt
inflating: OPatch/emdpatch.pl
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/ocm/lib/emocmutl.jar
extracting: OPatch/ocm/ocm.zip
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
extracting: OPatch/opatch.ini
inflating: OPatch/opatch.pl
creating: OPatch/perl_modules/
inflating: OPatch/perl_modules/Apply.pm
inflating: OPatch/perl_modules/AttachHome.pm
inflating: OPatch/perl_modules/Command.pm
inflating: OPatch/perl_modules/LsInventory.pm
inflating: OPatch/perl_modules/NApply.pm
inflating: OPatch/perl_modules/NRollBack.pm
inflating: OPatch/perl_modules/Query.pm
inflating: OPatch/perl_modules/RollBack.pm
inflating: OPatch/perl_modules/Util.pm
inflating: OPatch/perl_modules/Version.pm
inflating: OPatch/perl_modules/XML.pm
inflating: OPatch/perl_modules/compile.csh
inflating: OPatch/perl_modules/opatchIO.pm
inflating: OPatch/README.txt
[disprod@myerp ~]$
查看解压后的文件OPatch
[disprod@myerp ~]$ ls
disk1 disk2 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip p6880880_102000_LINUX.zip
Disk1 OPatch p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip
[disprod@myerp ~]$ cd OPatch/
[disprod@myerp OPatch]$ ls
docs emdpatch.pl jlib ocm opatch opatch.bat opatch.ini opatch.pl opatchprereqs perl_modules README.txt
[disprod@myerp OPatch]$
[disprod@myerp ~]$ cd /ora1206/bi
[disprod@myerp bi]$ rm -r OPatch/
[disprod@myerp bi]$ mv /home/disprod/OPatch/ .
[disprod@myerp bi]$ opatch version
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
OPatch Version: 1.0.0.0.60
[disprod@myerp bi]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_14-58-10.log"
Result:
There is no Interim Patch
OPatch succeeded.
[disprod@myerp bi]$ cd
[disprod@myerp ~]$ source .bash_profile
[disprod@myerp ~]$ opatch lsinventory –details
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_15-01-50.log"
Result:
There is no Interim Patch
OPatch succeeded.
[disprod@myerp ~]$ opatch version
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
OPatch Version: 1.0.0.0.60
3.3. 安装p6472361
[disprod@myerp ~]$ unzip p6472361_10122_LINUX.zip
[disprod@myerp ~]$ ls
6472361
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ cd files/
[disprod@myerp files]$ ls
bibeans bin discoverer j2ee jlib sysman
[disprod@myerp 6472361]$ cd
[disprod@myerp ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
[disprod@myerp 6472361]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp 6472361]$ opmnctl status
Unable to connect to opmn.
Opmn may not be up.
[disprod@myerp 6472361]$ pwd
/home/disprod/6472361
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-09-20.log"
Invoking fuser to check for active processes.
OPatch detects your platform as 23 while this patch 6472361 supports platforms:
46 (Linux Intel)
226 (Linux x86-64)
This patch is not suitable for this operating system.
Please contact support for the correct patch.
ERROR: OPatch failed during pre-reqs check.
[disprod@myerp ~]$ export OPATCH_PLATFORM_ID=46
[disprod@myerp ~]$ echo $OPATCH_PLATFORM_ID
46
[disprod@myerp ~]$ ls
6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt
disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip
disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html
[disprod@myerp ~]$ cd 6472361/
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-24-26.log"
Invoking fuser to check for active processes.
*****
Only the Oracle home owner can install or configure the Oracle Configuration Manager in an
ORACLE_HOME structure. The ORACLE_HOME (/ora1206/bi) is owned by the UID 0
*****
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
（我先前已经执行了opmnctl stopall）
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /ora1206/bi)
Is this system ready for updating?
Please respond Y|N >
Y
Applying patch 6472361...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Backing up comps.xml ...
OPatch succeeded.
[disprod@myerp 6472361]$
查看Application Server Control显示在运行，因为我并没有关闭
[disprod@myerp 6472361]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
以上参考 README for 6472361
3.4. 安装patch 5861907
[disprod@myerp ~]$ opmnctl status
Unable to connect to opmn.
Opmn may not be up.
[disprod@myerp ~]$ cd /ora1206/bi/
[disprod@myerp bi]$ ls
Apache ccr deconfig install jlib nls perl reports sso upgrade
assistants cfgtoollogs diagnostics inventory jpi OPatch plsql root.sh syndication ut
backup_restore chgip discoverer j2ee jre opmn portal root.sh.old sysman wcs
BC4J clone dsa javacache jsp oracore precomp slax tk webcache
bi config error.txt javavm ldap oraInst.loc procbuilder soap tools webservices
bibeans datadirect guicommon jdbc lib ord rdbms sqlj uat wireless
bin dbs has jdk mesg oui README.htm sqlplus uddi xdk
browser dcm iaspt jinit network owm relnotes srvm uix
[disprod@myerp bi]$ cd inventory/
[disprod@myerp inventory]$ ls
Actions21 Components21 Dialogs21 invDetails.properties Patches21 prereqs Scripts
Clone ContentsXML filemap oneoffs PatchSets21 Queries21 Templates
[disprod@myerp inventory]$ cd ContentsXML/
[disprod@myerp ContentsXML]$ ls
comps.xml configtools.xml config.xml libs.xml oraclehomeproperties.xml
[disprod@myerp ContentsXML]$ pwd
/ora1206/bi/inventory/ContentsXML
[disprod@myerp ContentsXML]$ cd ../..
[disprod@myerp bi]$ cp -ap inventory/ inventory_bak
[disprod@myerp bi]$ ls -al inventory_bak/
[disprod@myerp bi]$ cd
[disprod@myerp ~]$ unzip p5861907_10122_LINUX.zip
[disprod@myerp ~]$ ls
6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt
disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip
disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html
[disprod@myerp ~]$ cp oraclehomeproperties.xml /ora1206/bi/inventory/ContentsXML/
[disprod@myerp ~]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_18-58-39.log"
Result:
Installed Patch List:
=====================
1) Patch 6472361 applied on Wed Oct 07 18:29:42 CST 2009
[ Base Bug(s): 5592580 5922891 6215863 5601311 5887565 5117216 4021063 5450764 6280716 6281519 5733442 5874608 6524850 5156055 6142101 3891259 5045120 6408161 5675183 5844020 6211732 5026541 5513118 5733380 6033718 5414271 5695725 6200167 5505532 5941634 5845334 5372331 5882138 5938059 5513051 5644523 6087336 5946580 5672507 4942563 5399782 5759749 6215389 5948836 5950469 6131998 5622397 6059509 6210014 6047200 5926918 5955554 6411910 6488750 5531425 6416859 5571494 5633035 5517786 5451810 5205897 6601738 5462238 5414006 6417086 6163906 5951782 5185518 5394787 5615830 6409713 5639863 5704846 6028993 5186826 5591608 5746156 4901641 6110024 6024356 5475786 5902903 5451758 6626145 5765688 6439239 5230981 5686940 5769537 5969985 5547386 6009122 6455857 6161749 6110031 6523741 6062038 4969310 6047668 6151989 4901223 5527718 5668736 5719064 5017919 5703057 6319785 6151052 5482224 4377151 6394762 5404340 5182568 5842046 6192712 5360227 5210171 5932508 5975552 4297543 5700591 5736563 5154809 6406196 5462419 5931061 5697966 5738745 5559923 5664108 6275246 6401901 6338458 6048127 5458617 5100123 5757331 5646832 6243564 5514492 6450367 5465401 6144867 5650574 6192806 6472361 5460689 5511802 5736074 5901130 6521161 6046898 6471566 6405620 5888236 6033938 6158845 6392752 6193039 4895141 6621751 5688150 5964077 5208063 6037141 6280013 5608740 5647142 5704032 5175015 6009097 5511743 5674250 6008002 5549319 5606063 5979500 6061924 6262095 5338161 5509976 5123374 5131394 5505404 5523984 5116591 6006847 5899757 6621404 5046741 5079665 5160684 6408043 5936322 6067310 5673463 5818607 5594149 5045873 6480045 5400823 5466302 5744401 4741477 5965613 6274627 5899762 6138043 5704057 6163989 5718465 5857955 6004179 6488047 5589983 5924970 4135528 5961773 5981660 5731674 6142363 5859997 4074428 5051945 5182332 4901433 5668944 6648794 5413004 5662488 6231017 6351275 5576526 5988357 5702104 5548112 6124085 6450125 5183143 4622470 6142011 5579945 6505247 5443532 5956310 5340118 6488133 5984587 5490603 5596428 5475150 6196131 5702043 5168275 5621127 5528097 5981827 5900969 6072532 6024597 4628944 5534228 ]
OPatch succeeded.
参考 README for 5861907
[disprod@myerp ~]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
[disprod@myerp ~]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 16054 | Alive
WebCache | WebCache | 15337 | Alive
WebCache | WebCacheAdmin | 15320 | Alive
OC4J | home | 15321 | Alive
OC4J | OC4J_BI_Forms | 15322 | Alive
HTTP_Server | HTTP_Server | 15323 | Alive
Discoverer | ServicesStatus | 15324 | Alive
Discoverer | PreferenceServer | 15325 | Alive
DSA | DSA | N/A | Down
[disprod@myerp ~]$
4. 配置Discoverer
4.1. 拷贝PROD.DBC
从ERP系统的$FND_SECURE目录（应用用户）下拷贝PROD.DBC文件到$ORACLE_HOME/discoverer/secure（discoverer用户，如果没有这个目录，请手动创建）
[root@myerp ~]# su -l applseed
[applseed@myerp ~]$ echo $FND_SECURE
/ora1206/inst/apps/came_myerp/appl/fnd/12.0.0/secure
[applseed@myerp ~]$
[applseed@myerp ~]$ cd $FND_SECURE
[applseed@myerp secure]$ ls
came.dbc
[applseed@myerp secure]$ more came.dbc
#DB Settings
#Tue Oct 06 20:33:09 CST 2009
GUEST_USER_PWD=GUEST/ORACLE
APPL_SERVER_ID=75446DA02A2EF1EFE04012AC12014FFE24259722934783143403046503729212
FND_JDBC_BUFFER_DECAY_INTERVAL=300
APPS_JDBC_DRIVER_TYPE=THIN
FND_JDBC_BUFFER_MIN=1
GWYUID=APPLSYSPUB/PUB
FND_JDBC_BUFFER_MAX=5
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=my
erp.testdomain.com)(PORT\=1586)))(CONNECT_DATA\=(SID\=came)))
FND_JDBC_STMT_CACHE_SIZE=100
TWO_TASK=came
JDBC\:processEscapes=true
FND_MAX_JDBC_CONNECTIONS=500
FND_JDBC_USABLE_CHECK=false
FNDNAM=APPS
FND_JDBC_PLSQL_RESET=false
DB_PORT=1586
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5
DB_HOST=myerp.testdomain.com
[applseed@myerp secure]$ su -l disprod
Password:
[disprod@myerp ~]$ cd /ora1206/bi/discoverer/
[disprod@myerp discoverer]$ ls
config deploy discwb.sh doc error.txt lib logs mesg plus_files secure util
[disprod@myerp discoverer]$ cd secure/
[disprod@myerp secure]$ ls
[disprod@myerp secure]$ cd ..
[disprod@myerp discoverer]$ exit
logout
[applseed@myerp secure]$ exit
logout
[root@myerp ~]# cp /ora1206/inst/apps/came_myerp/appl/fnd/12.0.0/secure/came.dbc /ora1206/bi/discoverer/secure/
[root@myerp ~]#
[root@myerp ~]# su -l disprod
[disprod@myerp ~]$ cd /ora1206/bi/discoverer/secure/
[disprod@myerp secure]$ ls
came.dbc
[disprod@myerp secure]$ ll
total 4
-rw------- 1 root root 733 Oct 7 19:24 came.dbc
[disprod@myerp secure]$ exit
[root@myerp ~]# chown disprod:dba /ora1206/bi/discoverer/secure/came.dbc
[root@myerp ~]# chmod 755 /ora1206/bi/discoverer/secure/came.dbc
[root@myerp ~]# cd /ora1206/bi/discoverer/secure/
[root@myerp secure]# ll
total 4
-rwxr-xr-x 1 disprod dba 733 Oct 7 19:24 came.dbc
[root@myerp secure]#
4.2. 创建到数据库的连接
[root@myerp secure]# su -l oraseed
[oraseed@myerp came_myerp]$ cd /ora1206/db/tech_st/10.2.0/network/admin/came_myerp
[oraseed@myerp came_myerp]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora
[oraseed@myerp came_myerp]$ more tnsnames.ora
###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
#$Header: NetServiceHandler.java 120.16.12000000.4 2008/04/28 06:39:48 schagant ship $
#
###############################################################
came=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
(CONNECT_DATA=
(SID=came)
)
)
came_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
(CONNECT_DATA=
(SID=came)
)
)
came_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
)
came_BALANCE=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
)
(CONNECT_DATA=
(SID=came)
)
)
came_REMOTE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
)
)
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCcame))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )
IFILE=/ora1206/db/tech_st/10.2.0/network/admin/came_myerp/came_myerp_ifile.ora
[oraseed@myerp came_myerp]$ exit
logout
[root@myerp secure]# su -l disprod
[disprod@myerp ~]$ cd /ora1206/bi/network/admin/
samples/ sqlnet.ora tnsnames.ora
shrept.lst tnsnames09100712PM2012.bak
[disprod@myerp ~]$ cd /ora1206/bi/network/admin/
[disprod@myerp admin]$
[disprod@myerp admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /ora1206/bi/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
REP_MYERP_ORACLEAS1.TESTDOMAIN.COM =
(ADDRESS = (PROTOCOL = tcp)(HOST = myerp)(PORT = 1950))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myerp.testdomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
为Discoverer增加ERP连接配置
[disprod@myerp admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /ora1206/bi/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
REP_MYERP_ORACLEAS1.TESTDOMAIN.COM =
(ADDRESS = (PROTOCOL = tcp)(HOST = myerp)(PORT = 1950))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myerp.testdomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
CAME =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=myerp.testdomain.com)(PORT=1586))
(CONNECT_DATA=
(SERVICE_NAME=CAME)
(INSTANCE_NAME=CAME)
)
)
或则也可以直接拷贝数据库用户oraseed下的tnsnames.ora到Discover用户的$ORACLE_HOME/network/admin 目录下
[root@myerp ~]# cp /myclone/db/tech_st/10.2.0/network/admin/came_myerp/tnsnames.ora /myclone/bi/network/admin
cp: overwrite `/myclone/bi/network/admin/tnsnames.ora'?
[root@myerp ~]# chown disprod:dba /myclone/bi/network/admin/tnsnames.ora
[root@myerp ~]# chmod 777 /myclone/bi/network/admin/tnsnames.ora
[disprod@myerp admin]$ export ORACLE_SID=came
[disprod@myerp admin]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Oct 7 19:56:53 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /@came as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> conn apps/rich08ll@came
Connected.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
CAME READ WRITE
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_archive_enable string true
remote_dependencies_mode string TIMESTAMP
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
[disprod@myerp admin]$ exit
logout
4.3. 创建表空间
[root@myerp secure]# su -l oraseed
[oraseed@myerp ~]$ echo $ORACLE_SID
came
[oraseed@myerp ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Oct 7 20:02:15 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL>
SQL> create tablespace discoverer datafile
2 '/ora1206/db/apps_st/data/dis.dbf' size 1000M autoextend on next 50M maxsize 2500M extent management local uniform size 128K;
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
DISCOVERER ONLINE
SQL> alter user system identified by manager;
User altered.
[root@myerp secure]# su -l disprod
[disprod@myerp ~]$ cd $ORACLE_HOME/bin/
[disprod@myerp bin]$ ls -al eulapi
-rwxr-xrwx 1 disprod dba 391 Oct 7 12:06 eulapi
[disprod@myerp bin]$
[disprod@myerp bin]$ su -l oraseed
Password:
4.4. 命令方式创建EUL：
[disprod@myerp bin]$ eulapi -CREATE_EUL -APPS_MODE \
> -CONNECT system/manager@came -USER EUL_ZHS -PASSWORD EUL_ZHS \
> -DEFAULT_TABLESPACE discoverer \
> -EUL_LANGUAGE US -APPS_GRANT_DETAILS apps/rich08ll
这是创建EUL的命令，下面是我的操作过程；
[disprod@myerp bin]$ eulapi -CREATE_EUL -APPS_MODE -CONNECT system/manager@came -USER EUL_ZHS -PASSWORD EUL_ZHS -DEFAULT_TABLESPACE discoverer -EUL_LANGUAGE US -APPS_GRANT_DETAILS apps/rich08ll
-create_eul
-connect
-apps_mode
-password EUL_ZHS
-default_tablespace discoverer
-apps_grant_details apps/rich08ll
-eul_language US
-user EUL_ZHS
EUL tables already exist for user EUL_ZHS
因为我当前的EBS系统是从源系统clone 来的，源系统是安装、配置过Discoverer的，因此这里提示已经存在一个EUL；
4.5. 修改Java配置
[disprod@myerp ~]$ cd /ora1206/bi/jpi/bin/
[disprod@myerp bin]$ ls
j2re.exe
[disprod@myerp bin]$ exit
logout
[root@myerp ~]# su -l applseed
[applseed@myerp ~]$ echo $OA_HTML
/ora1206/apps/apps_st/comn/webapps/oacore/html
[applseed@myerp ~]$ cd $OA_HTML
[applseed@myerp html]$ ls -l oaj2se.exe
-rwxr-xr-x 1 applseed dba 16688520 Jan 16 2008 oaj2se.exe
拷贝oaj2se.exe
[root@myerp ~]# cp /ora1206/apps/apps_st/comn/webapps/oacore/html/oaj2se.exe /ora1206/bi/jpi/bin/
[root@myerp ~]# cd /ora1206/bi/jpi/bin/
[root@myerp bin]# ll
total 31664
-rw-r--r-- 1 disprod dba 15691488 Feb 22 2005 j2re.exe
-rwxr-xr-x 1 root root 16688520 Oct 8 08:36 oaj2se.exe
[root@myerp bin]# chown disprod:dba oaj2se.exe
[root@myerp bin]# chmod 755 oaj2se.exe
[root@myerp bin]# ll
total 31664
-rw-r--r-- 1 disprod dba 15691488 Feb 22 2005 j2re.exe
-rwxr-xr-x 1 disprod dba 16688520 Oct 8 08:36 oaj2se.exe
[root@myerp bin]#
这是我安装的JDK版本
[root@myerp tools]# rpm -qa jdk
jdk-1.5.0_21-fcs
[disprod@myerp config]$ cd /ora1206/bi/discoverer/config
[disprod@myerp config]$ cp configuration.xml configuration.bak
[disprod@myerp config]$ ls
configuration.bak configuration.xml.1254895654154 disco.conf.smibak disco.policy
configuration.basecopy configuration.xsd discoConsole2Add.xml discoTarget2Add.xml
configuration.xml disco.conf discoOpmn2Add.xml preference_port.ini
configuration.xml.1254895654012 discoconfig5.properties discoPluginReg.xml uix-config.xml
[disprod@myerp config]$
[disprod@myerp config]$ vi configuration.xml
<?xml version = '1.0' encoding = 'UTF-8'?>
<!-- Copyright (c) 2001 Oracle Corporation. All rights reserved -->
<!-- Example configuration file. The schema rules are defined in
the schema definition file configuration.xsd which also
includes explanatory comments -->
Discoverer was stopped by your Administrator.
<!-- Server connection configuration. Determines how the Discoverer
middle-tier connects to a Discoverer server session.
The session is normally defined by system property
oracle.discoverer.server.session=
but can be overridden here by an attribute
session="SESSION_NAME"
To provide middle tier trace information modify logLevel (see schema for allowed values).
To provide finer grained control of middle tier trace information, add attribute:
logKeys = "classpath discoiv.cookies server_event execute discoiv.state_machine discoiv.request discoiv.servlet_exceptio
ns exceptions"
To provide a dump of the xml communication between server and middle tier add attribute:
modelXMLFile="c:\temp\dump.xml"
-->
<!--The default command used is ORACLE_HOME\bin\dis51ws. A different command line can be provided if requried.-->
<!--command>y:\dc\bin\opt\dis51ws
<!-- Discoverer Servlet configuration. Defines behaviour of both
discoverer/plus and discoverer/viewer servlets -->
dConnections="true" logLevel="error" laf="dc_blaf" switchWorksheetBehavior="prompt" defaultLocale="en" disableBrowserCaching="false"
>
Viewer was stopped by your Administrator.
disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>
hive="disco5i.jar" d4o_archive="d4o_double.jar"/>
Plus was stopped by your Administrator.
<!-- Portlet Provider configuration. -->
tMinute="1" maxRefreshRetries="1" maxGenericParameters="10" maxNewSessionPerMinute="6" maxWaitNewSessionMinute="30" minRequestThread
PoolSize="20" peekSleepIntervalSec="2"/>
修改以上几处地方，我安装JDK版本是jdk-1.5.0_21-fcs 因此这里修改的时候我根据JDK的版本修改相应的值；
重启Discoverer；
[disprod@myerp config]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp config]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp config]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
[disprod@myerp config]$ emctl start iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Starting Oracle Enterprise Manager 10g Application Server Control ..... started successfully.
[disprod@myerp config]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 24463 | Alive
WebCache | WebCache | 23749 | Alive
WebCache | WebCacheAdmin | 23737 | Alive
OC4J | home | 23740 | Alive
OC4J | OC4J_BI_Forms | 23745 | Alive
HTTP_Server | HTTP_Server | 23746 | Alive
Discoverer | ServicesStatus | 23747 | Alive
Discoverer | PreferenceServer | 23748 | Alive
DSA | DSA | N/A | Down
5. 配置Discoverer到EBS
5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer
http://myerp.testdomain.com:8065 ——〉系统管理员——〉Oracle Applications 管理器 ——〉Oracle Workflow ——〉Site Map > AutoConfig > Edit Parameters
| Title | Variable Name | Description | Value |
| Discoverer URL | s_disco_url | Set the value of this variable to the base URL where Discoverer is available. | :// : |
具体操作如下图所示：
![clip_image064[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_13923717504E6E.jpg "clip_image064[4]")
![clip_image066[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371750RD64.jpg "clip_image066[4]")
![clip_image068[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371751TaNt.jpg "clip_image068[4]")
![clip_image070[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371751Y6fl.jpg "clip_image070[4]")
![clip_image072[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237175221H4.jpg "clip_image072[4]")
修改节点的连接地址为当前Discoverer 的http://myerp.testdomain.com:7778，然后保存“save”
![clip_image074[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371753LxWP.jpg "clip_image074[4]")
选择OK确认配置
![clip_image076[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371753JBTq.jpg "clip_image076[4]")
选择Ｏｋ完成配置
![clip_image078[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_13923717543eOo.jpg "clip_image078[4]")
返回到参数编辑窗口，浏览摄制完成的参数：
![clip_image080[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371754ipnG.jpg "clip_image080[4]")
5.2. 运行autoconfig
运行% /adautocfg.sh （应用用户下的autoconfig）
[root@myerp ~]# su -l applseed
[applseed@myerp ~]$ cd $ADMIN_SCRIPTS_HOME
[applseed@myerp scripts]$ pwd
/ora1206/inst/apps/came_myerp/admin/scripts
[applseed@myerp scripts]$ ls
adalnctl.sh adcmctl.sh adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh mwactlwrpr.sh
adapcctl.sh adexecsql.pl adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh
adautocfg.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo mwactl.sh
[applseed@myerp scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /ora1206/inst/apps/came_myerp/admin/log/10081114/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /ora1206/inst/apps/came_myerp
Classpath : /ora1206/apps/apps_st/comn/java/lib/appsborg2.zip:/ora1206/apps/apps_st/comn/java/classes
Using Context file : /ora1206/inst/apps/came_myerp/appl/admin/came_myerp.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
5.3. 设置EBS Profile(配置文件)
系统管理员 ——〉配置文件（Profile） > 系统（System）——〉弹出 form窗口——〉设置profile
——〉输入查询条件 (搜索%Discoverer%)——〉
可以按照下表进行设置（具体情况依据生产系统配置设置）
| Description | Value | |
| ICX: Discoverer Launcher | URL that points to Discoverer Plus Servlet. | http://: |
| ICX: Discoverer Viewer Launcher | URL that points to Discoverer Viewer Servlet | http://: |
| ICX: Discoverer Release | Single number specifying the Discoverer release | 10 |
| ICX: Discoverer use Viewer | Specify whether Discoverer Viewer should be launched instead of Discoverer Plus (default). | Yes | No |
| ICX: Discoverer Default End User Layer Schema Prefix | The EUL prefix in combination with the Language code make up the EUL owner at runtime. For example EUL owner EUL_US has EUL prefix EUL. | EUL |
| ICX: Discoverer End User Layer Language Override | Since the End User Layer content is currently available in US English only, it is possible to override the user's general language preference for the Discoverer End User Layer using this profile option. The specified End User Layer language will be used regardless of the individual user's language preferences. | American English |
| ICX: Discoverer Parameters | This profile can be used to optionally pass additional URL parameters to Discoverer. Compare Note 186120.1 on Oracle MetaLink. |
|
| Discoverer DBC filename override | This profile can be used to specify the DBC Filename Discoverer should be using to connect to the E-Business Suite database. By default, this profile should remain NULL, in which case Discoverer will use the default dbc file for your E-Business Suite database. |
|
![clip_image082[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371755iJSo.jpg "clip_image082[4]")
![clip_image084[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_139237175551Eb.jpg "clip_image084[4]")
下图和表即是我的设置：
![clip_image086[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371756lH86.jpg "clip_image086[4]")
![clip_image088[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371756mxHQ.jpg "clip_image088[4]"){kind=small}
| 配置文件选项名 | 地点 | 应用产品 | 责任 | 服务器 | 服务器+责任 | 组织 | 用户 |
| Discoverer DBC 文件名改写 | |||||||
| FII：GL BIS Discoverer 访问 | |||||||
| ICX：Discoverer EBS 最终用户层模式前缀 | |||||||
| ICX：Discoverer EDW 最终用户层模式前缀 | |||||||
| ICX：Discoverer OLTP 最终用户层模式前缀 | |||||||
| ICX：Discoverer 参数 | |||||||
| ICX：Discoverer 启动程序 | http://myerp.testdomain.com:7778/discoverer/plus?Connect=[APPS_SECURE] | ||||||
| ICX：Discoverer 最终用户的层语言改写 | 简体中文 | ||||||
| ICX：Discoverer 浏览器的启动程序 | http://myerp.testdomain.com:7778/discoverer/viewer?Connect=[APPS_SECURE] | ||||||
| ICX：Discoverer 版本 | 10 | ||||||
| ICX：Discoverer 默认最终用户层模式前缀 | EUL | ||||||
| ICX：使用 Discoverer 浏览器 | 否 | ||||||
| OAM：Discoverer Ping 频率 | |||||||
| OKC：启用 Discoverer 报表 | 否 |
5.4. 命令方式给EUL授权
1）输入下面的命令进行授权：
[disprod@myerp ~]$ eulapi \
> -CONNECT eul_zhs/eul_zhs@came \
> -GRANT_PRIVILEGE \
> -USER SYSADMIN \
> -PRIVILEGE administration \
> -PRIVILEGE all_admin_privs\
> -LOG eul2.log
下面是我的执行过程（命令相同，只是没有按照上面的格式）
[root@myerp ~]# su -l disprod
[disprod@myerp ~]$ eulapi -CONNECT eul_zhs/eul_zhs@came -GRANT_PRIVILEGE -USER SYSADMIN -PRIVILEGE administration -PRIVILEGE all_admin_privs -LOG eul2.log
-connect
-log eul2.log
-grant_privilege
-privilege administration
-user SYSADMIN
-privilege all_admin_privs
Command completed.
[disprod@myerp ~]$
2） 执行下面命令授权
[disprod@myerp ~]$ eulapi \
> -CONNECT eul_zhs/eul_zhs@came \
> -GRANT_PRIVILEGE \
> -USER SYSADMIN \
> -BUSINESS_AREA_ADMIN_ACCESS % \
> -WILDCARD \
> -LOG eul_privilege.log
[disprod@erp ~]$ eulapi -CONNECT eul_zhs/eul_zhs@came -GRANT_PRIVILEGE -USER SYSADMIN -BUSINESS_AREA_ADMIN_ACCESS % -WILDCARD -LOG eul_privilege.log
-connect
-log eul_privilege.log
-grant_privilege
-business_area_admin_access %
-user SYSADMIN
-wildcard
Command completed.
[disprod@myerp ~]$
5.5. 刷新EUL层
1）查看applseed用户下面的$AU_TOP/discoverer目录
[applseed@myerp ~]$ cd $AU_TOP
[applseed@myerp 12.0.0]$ pwd
/ora1206/apps/apps_st/appl/au/12.0.0
[applseed@myerp 12.0.0]$ ls
admin discover graphs lib mesg patch plsql sql
bin forms java log out perl resource
[applseed@myerp 12.0.0]$ cd discover/
[applseed@myerp discover]$ ls
adrfseul.sh u4440000.drv u6394500.drv u6728000.drv US
adupdeul.sh u6141000.drv u6719036.drv u6836355.drv ZHS
[applseed@myerp discover]$
2）查看cd /ora1206/bi/discoverer 目录
[disprod@myerp discoverer]$ cd /ora1206/bi/discoverer
[disprod@myerp discoverer]$ ls
config discwb.sh error.txt logs plus_files util
deploy doc lib mesg secure
3）拷贝$AU_TOP/discoverer 为$ORACLE_HOME/discoverer/exx
[root@myerp ~]# cp -ap /ora1206/apps/apps_st/appl/au/12.0.0/discover /ora1206/bi/discoverer/exx
[root@myerp ~]# cd /ora1206/bi/discoverer/
[root@myerp discoverer]# chown -R disprod:dba exx/
[root@myerp discoverer]# chmod -R 777 exx/
[root@myerp discoverer]# ll
total 44
drwxr-xrwx 2 disprod dba 4096 Oct 8 09:03 config
drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 deploy
-rwxr-xrwx 1 disprod dba 825 Oct 7 12:06 discwb.sh
drwxr-xrwx 31 disprod dba 4096 Oct 7 11:58 doc
-rw-r----- 1 disprod dba 0 Oct 8 09:12 error.txt
drwxrwxrwx 4 disprod dba 4096 Feb 7 2009 exx
drwxr-xrwx 2 disprod dba 4096 Oct 7 18:29 lib
drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 logs
drwxr-xrwx 2 disprod dba 4096 Oct 7 11:59 mesg
drwxr-xrwx 5 disprod dba 4096 Oct 7 12:04 plus_files
drwxr-x--- 2 disprod dba 4096 Oct 7 19:24 secure
drwxr-xrwx 2 disprod dba 4096 Oct 7 14:07 util
[root@myerp discoverer]# du -sh exx/
503M exx/
4）开始刷新ＥＵＬ层
[root@myerp discoverer]# su -l disprod
[disprod@myerp ~]$ cd $ORACLE_HOME/discoverer/exx/
[disprod@myerp exx]$ pwd
/ora1206/bi/discoverer/exx
[disprod@myerp exx]$ ls
adrfseul.sh adupdeul.sh u4440000.drv u6141000.drv u6394500.drv u6719036.drv u6728000.drv u6836355.drv US ZHS
[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
[disprod@myerp exx]$ sh adrfseul.sh \
> connect=sysadmin/meimima@came \
> resp="System Administrator" \
> gwyuid=APPLSYSPUB/PUB \
> fndnam=APPS \
> secgroup="Standard" \
> eulschema=eul_zhs \
> eulpassword=eul_zhs \
> twotask=came \
> iashome=/ora1206/bi \
> logfile=refresh_eul_us_mydb.log
/ora1206/bi/discoverer/exx/objfilelst8932.lst
**********************************************************
You are running adrfseul, version 120.6.12000000.4
Start of adrfseul session
Date/time is Thu Oct 8 12:55:08 CST 2009
Log file is refresh_eul_us_mydb.log
Command line arguments are
"connect=sysadmin/meimima@came"
"resp=System Administrator"
"gwyuid=APPLSYSPUB/PUB"
"fndnam=APPS"
"secgroup=Standard"
"eulschema=eul_zhs"
"eulpassword=eul_zhs"
"twotask=came"
"iashome=/ora1206/bi"
"logfile=refresh_eul_us_mydb.log"
Testing connection to database using sqlplus -s ...
Connection to database using sqlplus -s is OK ...
Extracting eul folder information ...
CUSTOMFOLDER
CUSTOMFOLDER1
CUSTOMFOLDER2
CUSTOMFOLDER3
CUSTOMFOLDER4
CUSTOMFOLDER5
CUSTOMFOLDER6
CUSTOMFOLDER7
ELEMENT
ELEMENT1
ELEMENT2
ELEMENT3
MDS1
RICH
RICH_
RICH_1
RICH_10
RICH_11
RICH_12
RICH_13
RICH_14
RICH_15
RICH_16
RICH_2
RICH_3
RICH_4
RICH_5
RICH_6
RICH_61
RICH_7
RICH_8
RICH_9
Done obtaining folder information
Calling discoverer refresh utility ...
32 folders to process:
Do you want to start refreshing the folders (Y|N)?
Type or 'Y' to continue, or 'N' to exit (with failure).
Y
(You entered "Y")
1 of 32 : Refreshing folder: CUSTOMFOLDER ...
-connect
-refresh_folder CUSTOMFOLDER
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
2 of 32 : Refreshing folder: CUSTOMFOLDER1 ...
-connect
-refresh_folder CUSTOMFOLDER1
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
3 of 32 : Refreshing folder: CUSTOMFOLDER2 ...
-connect
-refresh_folder CUSTOMFOLDER2
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
4 of 32 : Refreshing folder: CUSTOMFOLDER3 ...
-connect
-refresh_folder CUSTOMFOLDER3
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
5 of 32 : Refreshing folder: CUSTOMFOLDER4 ...
-connect
-refresh_folder CUSTOMFOLDER4
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
6 of 32 : Refreshing folder: CUSTOMFOLDER5 ...
-connect
-refresh_folder CUSTOMFOLDER5
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
7 of 32 : Refreshing folder: CUSTOMFOLDER6 ...
-connect
-refresh_folder CUSTOMFOLDER6
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
DC Logger(9203): Logging Signal Caught
DC Logger(9204): Logging Signal Caught
DC Logger(9206): Logging Signal Caught
DC Logger(9207): Logging Signal Caught
DC Logger(9208): Logging Signal Caught
DC Logger(9212): Logging Signal Caught
DC Logger(9175): Logging Signal Caught
DC Logger(9176): Logging Signal Caught
DC Logger(9179): Logging Signal Caught
DC Logger(9183): Logging Signal Caught
DC Logger(9201): Logging Signal Caught
DC Logger(9205): Logging Signal Caught
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0xAAFB5F34 during VM shutdown
Function=uninitialized_copy__H3ZPPcZPPcZt9allocator1ZPc_X01X01X11X21_X11+0x24
Library=/ora1206/bi/discoverer/lib/libdcecm51.so
Current Java thread:
at java.lang.Object.wait(Native Method)
- waiting on <0xab9201a0> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:429)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
- locked <0xab9201a0> (a java.lang.ref.Reference$Lock)
这里抛出一个错误，无法继续刷新了
Dynamic libraries:
0043e000-00454000 r-xp 00000000 08:01 1895519 /lib/ld-2.3.4.so
00454000-00455000 r-xp 00015000 08:01 1895519 /lib/ld-2.3.4.so
00455000-00456000 rwxp 00016000 08:01 1895519 /lib/ld-2.3.4.so
005b0000-005b2000 r-xp 00000000 08:01 1896367 /lib/libdl-2.3.4.so
005b2000-005b3000 r-xp 00001000 08:01 1896367 /lib/libdl-2.3.4.so
005b3000-005b4000 rwxp 00002000 08:01 1896367 /lib/libdl-2.3.4.so
007eb000-007f4000 r-xp 00000000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1
007f4000-007f5000 rwxp 00009000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1
00d5b000-00d6e000 r-xp 00000000 08:01 1896376 /lib/libnsl-2.3.4.so
00d6e000-00d6f000 r-xp 00012000 08:01 1896376 /lib/libnsl-2.3.4.so
00d6f000-00d70000 rwxp 00013000 08:01 1896376 /lib/libnsl-2.3.4.so
08048000-08056000 r-xp 00000000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java
08056000-08059000 rwxp 0000d000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java
a81c7000-a81cd000 r-xs 00000000 08:01 1159554 /usr/lib/gconv/gconv-modules.cache
a81cd000-a8205000 r-xp 00000000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
a8205000-a8210000 rwxp 00037000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
a8212000-a8d4a000 r-xp 00000000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1
a8d4a000-a8db7000 rwxp 00b37000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1
a8dcd000-a8f46000 r-xp 00000000 08:03 33374267 /ora1206/bi/lib/libnnz10.so
a8f46000-a8f60000 rwxp 00178000 08:03 33374267 /ora1206/bi/lib/libnnz10.so
a8f61000-a954f000 r-xp 00000000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so
a954f000-a966a000 rwxp 005ed000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so
a96bd000-a971d000 r-xp 00000000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so
a971d000-a972c000 rwxp 0005f000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so
a972d000-aa702000 r-xp 00000000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so
aa702000-aaa35000 rwxp 00fd4000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so
aaa3c000-aac81000 r-xp 00000000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so
aac81000-aacc3000 rwxp 00244000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so
aacd5000-aadd2000 r-xp 00000000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so
aadd2000-aae09000 rwxp 000fc000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so
aae2e000-aafce000 r-xp 00000000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so
aafce000-ab016000 rwxp 0019f000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so
ab017000-ab0cf000 r-xp 00000000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so
ab0cf000-ab0f7000 rwxp 000b7000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so
ab0f7000-ab0fd000 r-xs 00000000 08:03 18321245 /ora1206/bi/jdk/jre/lib/ext/ojmisc.jar
ab0fd000-ab0fe000 r-xs 00000000 08:03 33308681 /ora1206/bi/jdk/jre/lib/ext/sslqueries.jar
ab0fe000-ab10c000 r-xs 00000000 08:03 33308680 /ora1206/bi/jdk/jre/lib/ext/activation.jar
ab10c000-ab10f000 r-xs 00000000 08:03 33308679 /ora1206/bi/jdk/jre/lib/ext/smtp.jar
ab10f000-ab135000 r-xs 00000000 08:03 33308678 /ora1206/bi/jdk/jre/lib/ext/mailapi.jar
ab135000-ab17a000 r-xs 00000000 08:03 33308677 /ora1206/bi/jdk/jre/lib/ext/mail.jar
ab17a000-ab17d000 r-xs 00000000 08:03 33308676 /ora1206/bi/jdk/jre/lib/ext/jta.jar
ab17d000-ab239000 r-xs 00000000 08:03 30168147 /ora1206/bi/jdk/jre/lib/ext/localedata.jar
ab239000-ab246000 r-xs 00000000 08:03 30168146 /ora1206/bi/jdk/jre/lib/ext/ldapsec.jar
ab246000-ab249000 r-xs 00000000 08:03 30168145 /ora1206/bi/jdk/jre/lib/ext/dnsns.jar
ab249000-ab265000 r-xs 00000000 08:03 30168144 /ora1206/bi/jdk/jre/lib/ext/sunjce_provider.jar
ab265000-ab289000 r-xs 00000000 08:03 18321937 /ora1206/bi/bin/eulbuilder.jar
ab48d000-ab68d000 r-xp 00000000 08:01 1130496 /usr/lib/locale/locale-archive
b5940000-b5e99000 r-xs 00000000 08:03 33243206 /ora1206/bi/jdk/jre/lib/charsets.jar
b5e99000-b5eaa000 r-xs 00000000 08:03 33243160 /ora1206/bi/jdk/jre/lib/jce.jar
b5eaa000-b5f87000 r-xs 00000000 08:03 33243205 /ora1206/bi/jdk/jre/lib/jsse.jar
b5f87000-b5f9d000 r-xs 00000000 08:03 33243159 /ora1206/bi/jdk/jre/lib/sunrsasign.jar
b5fe7000-b798e000 r-xs 00000000 08:03 33243204 /ora1206/bi/jdk/jre/lib/rt.jar
b798e000-b79a2000 r-xp 00000000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so
b79a2000-b79a5000 rwxp 00013000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so
b79a5000-b79c5000 r-xp 00000000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so
b79c5000-b79c7000 rwxp 0001f000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so
b79c7000-b79d0000 r-xp 00000000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79d0000-b79d1000 r-xp 00008000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79d1000-b79d2000 rwxp 00009000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79dd000-b79ed000 r-xp 00000000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so
b79ed000-b79ef000 rwxp 0000f000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so
b79ef000-b79f3000 rwxs 00000000 08:01 2274675 /tmp/hsperfdata_disprod/9172 (deleted)
b79f3000-b7a14000 r-xp 00000000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a14000-b7a15000 r-xp 00020000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a15000-b7a16000 rwxp 00021000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a2e000-b7a36000 r-xp 00000000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so
b7a36000-b7a37000 rwxp 00007000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so
b7a37000-b7e33000 r-xp 00000000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so
b7e33000-b7e4f000 rwxp 003fb000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so
b7e61000-b7f86000 r-xp 00000000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f86000-b7f88000 r-xp 00125000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f88000-b7f8a000 rwxp 00127000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f8c000-b7f9a000 r-xp 00000000 08:01 1893131 /lib/i686/libpthread-0.10.so
b7f9a000-b7f9b000 r-xp 0000d000 08:01 1893131 /lib/i686/libpthread-0.10.so
b7f9b000-b7f9c000 rwxp 0000e000 08:01 1893131 /lib/i686/libpthread-0.10.so
Heap at VM Abort:
Heap
def new generation total 576K, used 515K [0xab890000, 0xab930000, 0xabd70000)
eden space 512K, 88% used [0xab890000, 0xab900d78, 0xab910000)
from space 64K, 99% used [0xab920000, 0xab92fff8, 0xab930000)
to space 64K, 0% used [0xab910000, 0xab910000, 0xab920000)
tenured generation total 1408K, used 57K [0xabd70000, 0xabed0000, 0xaf890000)
the space 1408K, 4% used [0xabd70000, 0xabd7e7a0, 0xabd7e800, 0xabed0000)
compacting perm gen total 4096K, used 1681K [0xaf890000, 0xafc90000, 0xb3890000)
the space 4096K, 41% used [0xaf890000, 0xafa344c8, 0xafa34600, 0xafc90000)
Local Time = Thu Oct 8 12:55:55 2009
Elapsed Time = 4
#
# The exception above was detected in native code outside the VM
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode)
#
# An error report file has been saved as hs_err_pid9172.log.
# Please refer to the file for further information.
#
[1]+ Stopped sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
我强行中止命令，然后再次运行命令开始刷新
[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
/ora1206/bi/discoverer/exx/objfilelst9831.lst
**********************************************************
You are running adrfseul, version 120.6.12000000.4
Start of adrfseul session
Date/time is Thu Oct 8 13:10:38 CST 2009
Log file is refresh_eul_us_mydb.log
Command line arguments are
"connect=sysadmin/meimima@came"
"resp=System Administrator"
"gwyuid=APPLSYSPUB/PUB"
"fndnam=APPS"
"secgroup=Standard"
"eulschema=eul_zhs"
"eulpassword=eul_zhs"
"twotask=came"
"iashome=/ora1206/bi"
"logfile=refresh_eul_us_mydb.log"
Testing connection to database using sqlplus -s ...
Connection to database using sqlplus -s is OK ...
Extracting eul folder information ...
CUSTOMFOLDER6
CUSTOMFOLDER7
ELEMENT
ELEMENT1
ELEMENT2
ELEMENT3
MDS1
RICH
RICH_
RICH_1
RICH_10
RICH_11
RICH_12
RICH_13
RICH_14
RICH_15
RICH_16
RICH_2
RICH_3
RICH_4
RICH_5
RICH_6
RICH_61
RICH_7
RICH_8
RICH_9
Done obtaining folder information
Calling discoverer refresh utility ...
26 folders to process:
Do you want to start refreshing the folders (Y|N)?
Type or 'Y' to continue, or 'N' to exit (with failure).
Y
(You entered "Y")
1 of 26 : Refreshing folder: CUSTOMFOLDER6 ...
-connect
-refresh_folder CUSTOMFOLDER6
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
2 of 26 : Refreshing folder: CUSTOMFOLDER7 ...
-connect
-refresh_folder CUSTOMFOLDER7
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
3 of 26 : Refreshing folder: ELEMENT ...
-connect
-refresh_folder ELEMENT
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
4 of 26 : Refreshing folder: ELEMENT1 ...
-connect
-refresh_folder ELEMENT1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
5 of 26 : Refreshing folder: ELEMENT2 ...
-connect
-refresh_folder ELEMENT2
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
6 of 26 : Refreshing folder: ELEMENT3 ...
-connect
-refresh_folder ELEMENT3
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
7 of 26 : Refreshing folder: MDS1 ...
-connect
-refresh_folder MDS1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
8 of 26 : Refreshing folder: RICH ...
-connect
-refresh_folder RICH
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
9 of 26 : Refreshing folder: RICH_ ...
-connect
-refresh_folder RICH_
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
10 of 26 : Refreshing folder: RICH_1 ...
-connect
-refresh_folder RICH_1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
11 of 26 : Refreshing folder: RICH_10 ...
-connect
-refresh_folder RICH_10
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
12 of 26 : Refreshing folder: RICH_11 ...
-connect
-refresh_folder RICH_11
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
13 of 26 : Refreshing folder: RICH_12 ...
-connect
-refresh_folder RICH_12
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
14 of 26 : Refreshing folder: RICH_13 ...
-connect
-refresh_folder RICH_13
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
15 of 26 : Refreshing folder: RICH_14 ...
-connect
-refresh_folder RICH_14
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
16 of 26 : Refreshing folder: RICH_15 ...
-connect
-refresh_folder RICH_15
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
17 of 26 : Refreshing folder: RICH_16 ...
-connect
-refresh_folder RICH_16
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
18 of 26 : Refreshing folder: RICH_2 ...
-connect
-refresh_folder RICH_2
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
19 of 26 : Refreshing folder: RICH_3 ...
-connect
-refresh_folder RICH_3
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
20 of 26 : Refreshing folder: RICH_4 ...
-connect
-refresh_folder RICH_4
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
21 of 26 : Refreshing folder: RICH_5 ...
-connect
-refresh_folder RICH_5
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
22 of 26 : Refreshing folder: RICH_6 ...
-connect
-refresh_folder RICH_6
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
23 of 26 : Refreshing folder: RICH_61 ...
-connect
-refresh_folder RICH_61
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
24 of 26 : Refreshing folder: RICH_7 ...
-connect
-refresh_folder RICH_7
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
25 of 26 : Refreshing folder: RICH_8 ...
-connect
-refresh_folder RICH_8
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
26 of 26 : Refreshing folder: RICH_9 ...
-connect
-refresh_folder RICH_9
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
Done calling discoverer refresh utility.
Discoverer refresh exited with status 0.
----------------------------------------------------------------------
Log information from the refresh process ...
java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER6 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:10:49 CST 2009 ...
Name: ??????????, Type: Definition Unavailable, Action: ??????????
Completed Thu Oct 08 13:12:11 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER7 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:12 CST 2009 ...
Name: rich_??????, Type: Definition Unavailable, Action: rich_??????
Completed Thu Oct 08 13:12:16 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:16 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:12:19 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:20 CST 2009 ...
Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????
Completed Thu Oct 08 13:12:21 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT2 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:22 CST 2009 ...
Name: ???????, Type: Definition Unavailable, Action: ???????
Completed Thu Oct 08 13:12:24 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT3 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:24 CST 2009 ...
Name: ?????, Type: Definition Unavailable, Action: ?????
Completed Thu Oct 08 13:12:26 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder MDS1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:26 CST 2009 ...
Name: MDS?????, Type: Definition Unavailable, Action: MDS?????
Completed Thu Oct 08 13:12:28 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:28 CST 2009 ...
Name: rich????????????, Type: Definition Unavailable, Action: rich????????????
Completed Thu Oct 08 13:12:30 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_ -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:30 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:32 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:32 CST 2009 ...
Name: RICH_??????????????, Type: Definition Unavailable, Action: RICH_??????????????
Completed Thu Oct 08 13:12:34 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_10 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:34 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:36 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_11 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:36 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:38 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_12 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:38 CST 2009 ...
Name: RICH_?????????, Type: Definition Unavailable, Action: RICH_?????????
Completed Thu Oct 08 13:12:41 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_13 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:41 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:42 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_14 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:43 CST 2009 ...
Name: RICH_?????-??, Type: Definition Unavailable, Action: RICH_?????-??
Completed Thu Oct 08 13:12:44 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_15 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:44 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:46 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_16 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:46 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:12:48 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_2 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:48 CST 2009 ...
Name: RICH_??????????????????, Type: Definition Unavailable, Action: RICH_??????????????????
Completed Thu Oct 08 13:12:50 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_3 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:50 CST 2009 ...
Name: RICH_?????????????, Type: Definition Unavailable, Action: RICH_?????????????
Completed Thu Oct 08 13:12:52 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_4 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:53 CST 2009 ...
Name: RICH_??????????, Type: Definition Unavailable, Action: RICH_??????????
Completed Thu Oct 08 13:12:55 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_5 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:55 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:57 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_6 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:57 CST 2009 ...
Name: RICH_???????_????, Type: Definition Unavailable, Action: RICH_???????_????
Completed Thu Oct 08 13:12:59 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_61 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:59 CST 2009 ...
Name: RICH_???????_??, Type: Definition Unavailable, Action: RICH_???????_??
Completed Thu Oct 08 13:13:01 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_7 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:01 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:13:03 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_8 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:03 CST 2009 ...
Name: RICH_??????, Type: Definition Unavailable, Action: RICH_??????
Completed Thu Oct 08 13:13:06 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_9 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:06 CST 2009 ...
Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????
Completed Thu Oct 08 13:13:08 CST 2009.
End of refresh log
----------------------------------------------------------------------
adrfseul is exiting with status 0
End of adrfseul session
Date/time is Thu Oct 8 13:13:08 CST 2009
**********************************************************
这次正常完成刷新；
5.6. EBS调用Discoverer
5.6.1. 新建菜单Discoverer以SYSADMIN/SYSADMIN_PASSWD进入ERP系统——系统管理员——应用产品——菜单——新建
新建菜单名：Discoverer
用户菜单名：Discoverer
功能名：Invoke Web Discoverer
提示为:Discoverer
保存
![clip_image090[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371756Lj51.jpg "clip_image090[4]")
将刚建的菜单 Discoverer测试添加到 菜单 “浏览器菜单 - 系统管理员 GUI”如下图
![clip_image092[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371757VVJY.jpg "clip_image092[4]")
下图为保存后在系统管理员职责下的Discoverer
![clip_image094[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371758gnOC.jpg "clip_image094[4]")
![clip_image096[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371758x4Cc.jpg "clip_image096[4]")
6. 其他问题：
6.1.EUL(end user layer)是什么：
提供了一个为了方便最终用户对数据进行展现、分析而准备的直观的、基于业务内容的表示层，使得数据的物理存储对于最终用户来说是透明的不需考虑的；
是一种元数据，其内容包含了一或多个业务区域(business area)，每个业务区域，都是一个反映最终用户特定方面(主题)的业务需求的一系列表/视图的组合。在业务区域里，按folder/item形式来组织；
通过discoverer administrator来创建和维护；
EUL
最终用户通过discoverer desktop或discoverer plus等发出查询请求时，discoverer通过EUL实现对相应物理表的访问。这一切对用户是透明的。
从作为提供给最终用户的表示层的角度来说，EUL有点象siebel中的presentation layer，都是从展现的角度来进行内容组织。不同的是，EUL直接从物理层映射到了展现层。Siebel presentatin layer则是基于的business model and mapping 那一层，由business model来屏蔽物理表/视图的存储。
的物理存储，是一系列的表，当EUL中的内容发生了增删改等变动，相应改动存储在该表中的内容
6.2. 参考文档：
http://blog.youkuaiyun.com/mumu210/archive/2009/05/26/4218424.aspx
http://www.itpub.net/archiver/tid-1153010.html
http://www.docslib.com/html/Linuxwendang/2009/0707/48.html
http://www.diybl.com/course/6_system/linux/Linuxjs/2008727/133959.html
http://pangwords.spaces.live.com/Blog/cns!17F01800524B6479!341.entry
http://www.oraclefans.cn/forum/showtopic.jsp?rootid=5741&CPages=1
http://blog.chinaunix.net/u/1281/showart_297681.html
http://www.freelists.org/post/ora-apps-dba/discover-eul-export-and-import,2
http://blog.itjaj.com/?264/viewspace-126
http://www.trutek.com/serendipity/index.php?/archives/2009/02.html
http://download.oracle.com/docs/html/A86730_01/managing.htm
http://blog.itpub.net/category/15182/30662
http://moonsoft.itpub.net/post/15182/305321
http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!1030.entry
http://www.docin.com/app/p?id=32319535
http://bbs.erp100.com/thread-29801-1-1.html
http://bbs.erp100.com/thread-25847-1-7.html###zoom
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14710393/viewspace-1081608/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/14710393/viewspace-1081608/
扫一扫
4180
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
