Oracle_Discoverer10G_Server安裝配置
|
密 級：機密 |
|
總頁數：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 |
|
目 錄
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.
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.
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.
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.
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.
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.
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/
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/
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/
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/
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.
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/
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.
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
<!-- 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 -->
<!-- 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"
>
disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>
hive="disco5i.jar" d4o_archive="d4o_double.jar"/>
<!-- 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.
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.
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
——〉系統管理員——〉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.
具體操作如下圖所示：
修改節點的連線地址為當前Discoverer 的，然後儲存“save”
選擇OK確認配置
選擇Ｏｋ完成配置
返回到引數編輯視窗，瀏覽攝製完成的引數：
執行%
[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.
——〉配置檔案（Profile） > 系統（System）——〉彈出 form視窗——〉設定profile
——〉輸入查詢條件 (搜尋%Discoverer%)——〉
可以按照下表進行設定（具體情況依據生產系統配置設定）
Profile
Description
Value
ICX: Discoverer Launcher
URL that points to Discoverer Plus Servlet.
Server>:
ICX: Discoverer Viewer Launcher
URL that points to Discoverer Viewer Servlet
Server>:
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 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.
下圖和表即是我的設定：
配置檔案選項名
地點
應用產品
責任
伺服器
伺服器+責任
組織
使用者
Discoverer DBC 檔名改寫
FII：GL BIS Discoverer 訪問
ICX：Discoverer EBS 終端使用者層模式字首
ICX：Discoverer EDW 終端使用者層模式字首
ICX：Discoverer OLTP 終端使用者層模式字首
ICX：Discoverer 引數
ICX：Discoverer 啟動程式
[APPS_SECURE]
ICX：Discoverer 終端使用者的層語言改寫
簡體中文
ICX：Discoverer 瀏覽器的啟動程式
[APPS_SECURE]
ICX：Discoverer 版本
10
ICX：Discoverer 預設終端使用者層模式字首
EUL
ICX：使用 Discoverer 瀏覽器
否
OAM：Discoverer Ping 頻率
OKC：啟用 Discoverer 報表
否
5. 配置Discoverer到EBS
5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer
for example:
![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]")
![clip_image074[4]](http://img.blog.itpub.net/blog/attachment/201402/14/14710393_1392371753LxWP.jpg "clip_image074[4]")
![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
5.3. 設定EBS Profile(配置檔案)
/discoverer/plus
?Connect=[APPS_SECURE]
/discoverer/viewer
?Connect=[APPS_SECURE]
This profile does not affect the National Language Support parameters passed to Discoverer. The Discoverer User Interface will still appear according to the users ICX_LANGUAGE and ICX_TERRITORY profiles. The User Interface language will only change for valid combinations of ICX_LANGUAGE and ICX_TERRITORY.
![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}
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
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
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.csdn.net/mumu210/archive/2009/05/26/4218424.aspx
http://www.itpub.net/archiver/tid-1153010.html
http://blog.chinaunix.net/u/1281/showart_297681.html
http://blog.itjaj.com/?264/viewspace-126
http://blog.itpub.net/category/15182/30662
http://moonsoft.itpub.net/post/15182/305321
http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!1030.entry
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/14710393/viewspace-1081608/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 本地windows搭建spark環境，安裝與詳細配置(jdk安裝與配置,scala安裝與配置,hadoop安裝與配置,spark安裝與配置)WindowsSparkJDKHadoop
- centos7 (阿里雲、linux) 單機spark的安裝與配置詳解(jdk安裝與配置,scala安裝與配置,hadoop安裝與配置,spark安裝與配置)CentOS阿里LinuxSparkJDKHadoop
- ccache安裝配置
- alertmanager安裝配置
- Hive安裝配置Hive
- 安裝配置ETCD
- SwitchOmega 安裝配置
- MySQL安裝配置MySql
- JWT安裝配置JWT
- Prometheus安裝配置Prometheus
- MariaDB 安裝配置
- Zookeeper 安裝配置
- leanote安裝配置
- JENKINS安裝配置Jenkins
- oracle安裝配置Oracle
- ceph安裝配置
- 【mongodb安裝配置】MongoDB
- ELK 安裝配置
- VNC安裝配置VNC
- SSH免密登入+JDK安裝配置+Hadoop安裝配置JDKHadoop
- CentOS 7 安裝、配置、使用 PostgreSQL 10 安裝及基礎配置CentOSSQL
- Mysql for Linux安裝配置之—— rpm（bundle）安裝MySqlLinux
- Mysql for Linux安裝配置之—— 原始碼安裝MySqlLinux原始碼
- MySQL安裝之二_安裝配置泥潭版MySql
- Linux下安裝java及配置(yum安裝)LinuxJava
- mysql安裝及配置MySql
- Nginx 安裝與配置Nginx
- JDK的安裝配置JDK
- helm安裝及配置
- OpenEuler安裝配置PostgreSQLSQL
- 【Python】安裝配置gymPython
- OpenWrt安裝配置TailscaleAI
- Spark安裝與配置Spark
- Telnet安裝與配置
- rsync的安裝配置
- yii 安裝及配置
- Docker 安裝配置 GitLabDockerGitlab
- 【Redis】安裝與配置Redis
- [Redis] 安裝與配置Redis