Oracle_Discoverer10G_Server安装配置
| 密 級：機密 |
| 總頁數(shù)：3頁 |
Oracle_Discoverer10G_Server安裝配置
(V 1.0)
文章版權(quán)所有Jusin Hao（luckyfriends），支持原創(chuàng)，轉(zhuǎn)載請注明。
2012年8月
版本信息
| 日期 | 版本 | 描述 | 作者/修改人 | 備注 |
| 2012-8-31 | 1.0 | 創(chuàng)建 | Jusin Hao | ? |
| ? | ? | ? | ? | ? |
| ? | ? | ? | ? | ? |
| ? | ? | ? | ? | ? |
目 錄
1. 介紹... 5
1.1. 編寫目的... 5
1.2. 文檔說明... 5
1.3. 定義... 5
1.4. 參考文檔... 5
2. 安裝Discoverer 5
2.1. 檢查系統(tǒng)設(shè)置、環(huán)境變量等值的設(shè)置... 5
2.2. 開始安裝Discoverer 9
2.3. 安裝完畢顯示結(jié)果和瀏覽URL. 21
2.4. 修改環(huán)境變量及重啟... 22
3. 安裝相關(guān)Patch. 24
3.1. 安裝p4960210. 24
3.2. 安裝opatch：p6880880. 32
3.3. 安裝p6472361. 35
3.4. 安裝patch 5861907. 39
4. 配置Discoverer 42
4.1. 拷貝PROD.DBC. 42
4.2. 創(chuàng)建到數(shù)據(jù)庫的連接... 44
4.3. 創(chuàng)建表空間... 48
4.4. 命令方式創(chuàng)建EUL：... 48
4.5. 修改Java配置... 49
5. 配置Discoverer到EBS. 54
5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer 54
5.2. 運行autoconfig. 59
5.3. 設(shè)置EBS Profile(配置文件) 61
5.4. 命令方式給EUL授權(quán)... 64
5.5. 刷新EUL層... 65
5.6. EBS調(diào)用Discoverer 91
5.6.1. 新建菜單Discoverer 91
5.6.2. 下圖為打開后的Discoverer Plus 94
6. 其他問題：... 94
6.1. EUL(end user layer)是什么：... 94
6.2. 參考文檔：... 95
1. 介紹
1.1. 編寫目的
此文檔主要用于 EBS R12 BI（Discoverer）的安裝介紹。包括：
· 源系統(tǒng)clone前的準備如配置、環(huán)境變量監(jiān)測
· 安裝Discover er
· Patch監(jiān)測安裝
· 配置Discoverer
· 調(diào)用Discoverer
1.2. 文檔說明
此文檔用于：
· 安裝EBS BI -----Discoverer
· 配置Disoverer
· 調(diào)用Discoverer
1.3. 定義
1.4. 參考文檔
2. 安裝Discoverer
2.1. 檢查系統(tǒng)設(shè)置、環(huán)境變量等值的設(shè)置
| Item | Requirements |
| Operating System | Red Hat Enterprise Linux AS/ES 4.0 For more information on Red Hat, see: http://www.redhat.com 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 |
檢查系統(tǒng)組件是否安裝齊全（可使用命令rpm –q |grep 包名）
修改系統(tǒng)內(nèi)核參數(shù) （/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的時候設(shè)置kernel.shmmax = 2147483648 是正常的，而在這里安裝Discover會提示 需要設(shè)置為4294967295；
我在安裝EBS和Clone EBS的時候設(shè)置fs.file-max = 65536 是正常的，而在這里安裝Discover會提示 需要設(shè)置為206173；因此，我在這里對這兩項做了修改）
如下圖所示為我安裝時提示的警告：
修改后運行sysctl –p 使修改生效
在文件/etc/security/limits.conf 中添加如下內(nèi)容
*??????? soft?? nproc????????? 2047
*??????? hard?? nproc??????? 16384
*??????? soft?? nofile???????? 4096
*??????? hard?? nofile??????? 65535
修改后，保存，重啟服務(wù)器。
創(chuàng)建Discoverer用戶
useradd –g dba disprod –u 502
查看目標系統(tǒng)linux版本
[root@myerp ora1206]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 6)
Kernel \r on an \m
查看目標系統(tǒng)linux 內(nèi)核
[root@myerp ora1206]# uname -r
2.6.9-67.ELsmp
2.2. 開始安裝Discoverer
這時EBS 系統(tǒng)處于運行狀態(tài)；
[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
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
指定端口，這里使用默認的自動分配；如果選用手動分配可以在/ora1206/bi/staticports.ini 查看端口信息：
提示運行/ora1206/bi/root.sh 文件
[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]#
開始配置服務(wù)：
可是我這里報錯，如上圖所示，因此我一句提示查看日志：
查看日志
[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 因為全權(quán)限不足，所以我修改/ora1206/bi/權(quán)限為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
更改完目錄權(quán)限后我再次“Retry”，成功配置服務(wù)；
退出，完成安裝。
2.3. 安裝完畢顯示結(jié)果和瀏覽URL
在客戶段打開IE瀏覽器，輸入上面的網(wǎng)址，以及用戶名密碼：ias_admin/discoverer1
登陸到Discoverer的管理界面；
2.4. 修改環(huán)境變量及重啟
[disprod@myerp ~]$ vi .bash_profile
PATH=$PATH:$HOME/bin
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
[disprod@myerp ~]$ source .bash_profile
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
[disprod@myerp ~]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 26384 | Alive
WebCache | WebCache | 26701 | Alive
WebCache | WebCacheAdmin | 26671 | Alive
OC4J | home | 26672 | Alive
OC4J | OC4J_BI_Forms | 26673 | Alive
HTTP_Server | HTTP_Server | 26674 | Alive
Discoverer | ServicesStatus | 26675 | Alive
Discoverer | PreferenceServer | 26676 | Alive
DSA | DSA | N/A | Down
[disprod@myerp ~]$
[disprod@myerp ~]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp ~]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp ~]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
opmnctl: opmn start failed
[disprod@myerp ~]$ emctl start iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Starting Oracle Enterprise Manager 10g Application Server Control ............. started successfully.
3. 安裝相關(guān)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
選擇安裝 Oracle Application server and Developer Suite 10g Rel 2 Software Update 10.1.2.2.0
如果沒有在/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
可能會報下圖的錯誤，這時可以另外打開終端加入環(huán)境變量，并單擊下圖中的“Retry”；
如果不行可以手動關(guān)閉IAS，關(guān)閉應(yīng)用、數(shù)據(jù)庫，然后再“Retry”
[applseed@myerp ~]$
[disprod@myerp bi]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /myclone/bi/sysman/log
[disprod@myerp bi]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp bi]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp bi]$
[applseed@myerp ~]$ /ora1206/inst/apps/came_myerp/admin/scripts/adstpall.sh apps/rich08ll
[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.
如果應(yīng)用和數(shù)據(jù)庫已經(jīng)關(guān)閉，依次啟動數(shù)據(jù)庫、應(yīng)用；IAS這時候已經(jīng)自動起來了；
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
3.2. 安裝opatch：p6880880
[disprod@myerp ~]$ ls
disk1 disk2 p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip readme.html
Disk1 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip
p6880880_102000_LINUX.zip
[disprod@myerp ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
因為我的OUI version 10.1.0.5.0 ，所以如果我安裝p6880880_102000_LINUX.zip 的話會提示如下錯誤；所以我 安裝的是p6880880_101000_LINUX.zip；這里要注意；
Patch history file: /ora1206/bi/cfgtoollogs/opatch/opatch_history.txt
LsInventorySession failed:
--------------------------------------------------------------------------------
The Oracle Home does not meet OUI version requirement.
This OPatch (version 10.2.0.4.5) detects OUI version 10.1.0.5.0 in the home.
It requires OUI version 10.2 or above.
OPatch failed with error code 73
[disprod@myerp ~]$ unzip p6880880_101000_LINUX.zip
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/README.txt
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/bt1.txt
inflating: OPatch/docs/bt2.txt
inflating: OPatch/emdpatch.pl
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/ocm/lib/emocmutl.jar
extracting: OPatch/ocm/ocm.zip
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
extracting: OPatch/opatch.ini
inflating: OPatch/opatch.pl
creating: OPatch/perl_modules/
inflating: OPatch/perl_modules/Apply.pm
inflating: OPatch/perl_modules/AttachHome.pm
inflating: OPatch/perl_modules/Command.pm
inflating: OPatch/perl_modules/LsInventory.pm
inflating: OPatch/perl_modules/NApply.pm
inflating: OPatch/perl_modules/NRollBack.pm
inflating: OPatch/perl_modules/Query.pm
inflating: OPatch/perl_modules/RollBack.pm
inflating: OPatch/perl_modules/Util.pm
inflating: OPatch/perl_modules/Version.pm
inflating: OPatch/perl_modules/XML.pm
inflating: OPatch/perl_modules/compile.csh
inflating: OPatch/perl_modules/opatchIO.pm
inflating: OPatch/README.txt
[disprod@myerp ~]$
查看解壓后的文件OPatch
[disprod@myerp ~]$ ls
disk1 disk2 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip p6880880_102000_LINUX.zip
Disk1 OPatch p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip
[disprod@myerp ~]$ cd OPatch/
[disprod@myerp OPatch]$ ls
docs emdpatch.pl jlib ocm opatch opatch.bat opatch.ini opatch.pl opatchprereqs perl_modules README.txt
[disprod@myerp OPatch]$
[disprod@myerp ~]$ cd /ora1206/bi
[disprod@myerp bi]$ rm -r OPatch/
[disprod@myerp bi]$ mv /home/disprod/OPatch/ .
[disprod@myerp bi]$ opatch version
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
OPatch Version: 1.0.0.0.60
[disprod@myerp bi]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_14-58-10.log"
Result:
There is no Interim Patch
OPatch succeeded.
[disprod@myerp bi]$ cd
[disprod@myerp ~]$ source .bash_profile
[disprod@myerp ~]$ opatch lsinventory –details
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_15-01-50.log"
Result:
There is no Interim Patch
OPatch succeeded.
[disprod@myerp ~]$ opatch version
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
OPatch Version: 1.0.0.0.60
3.3. 安裝p6472361
[disprod@myerp ~]$ unzip p6472361_10122_LINUX.zip
[disprod@myerp ~]$ ls
6472361
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ cd files/
[disprod@myerp files]$ ls
bibeans bin discoverer j2ee jlib sysman
[disprod@myerp 6472361]$ cd
[disprod@myerp ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/ora1206/bi
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH
unset USERNAME
[disprod@myerp 6472361]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp 6472361]$ opmnctl status
Unable to connect to opmn.
Opmn may not be up.
[disprod@myerp 6472361]$ pwd
/home/disprod/6472361
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-09-20.log"
Invoking fuser to check for active processes.
OPatch detects your platform as 23 while this patch 6472361 supports platforms:
46 (Linux Intel)
226 (Linux x86-64)
This patch is not suitable for this operating system.
Please contact support for the correct patch.
ERROR: OPatch failed during pre-reqs check.
[disprod@myerp ~]$ export OPATCH_PLATFORM_ID=46
[disprod@myerp ~]$ echo $OPATCH_PLATFORM_ID
46
[disprod@myerp ~]$ ls
6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt
disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip
disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html
[disprod@myerp ~]$ cd 6472361/
[disprod@myerp 6472361]$ ls
etc files README.txt
[disprod@myerp 6472361]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-24-26.log"
Invoking fuser to check for active processes.
*****
Only the Oracle home owner can install or configure the Oracle Configuration Manager in an
ORACLE_HOME structure. The ORACLE_HOME (/ora1206/bi) is owned by the UID 0
*****
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
（我先前已經(jīng)執(zhí)行了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顯示在運行，因為我并沒有關(guān)閉
[disprod@myerp 6472361]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
以上參考 README for 6472361
3.4. 安裝patch 5861907
[disprod@myerp ~]$ opmnctl status
Unable to connect to opmn.
Opmn may not be up.
[disprod@myerp ~]$ cd /ora1206/bi/
[disprod@myerp bi]$ ls
Apache ccr deconfig install jlib nls perl reports sso upgrade
assistants cfgtoollogs diagnostics inventory jpi OPatch plsql root.sh syndication ut
backup_restore chgip discoverer j2ee jre opmn portal root.sh.old sysman wcs
BC4J clone dsa javacache jsp oracore precomp slax tk webcache
bi config error.txt javavm ldap oraInst.loc procbuilder soap tools webservices
bibeans datadirect guicommon jdbc lib ord rdbms sqlj uat wireless
bin dbs has jdk mesg oui README.htm sqlplus uddi xdk
browser dcm iaspt jinit network owm relnotes srvm uix
[disprod@myerp bi]$ cd inventory/
[disprod@myerp inventory]$ ls
Actions21 Components21 Dialogs21 invDetails.properties Patches21 prereqs Scripts
Clone ContentsXML filemap oneoffs PatchSets21 Queries21 Templates
[disprod@myerp inventory]$ cd ContentsXML/
[disprod@myerp ContentsXML]$ ls
comps.xml configtools.xml config.xml libs.xml oraclehomeproperties.xml
[disprod@myerp ContentsXML]$ pwd
/ora1206/bi/inventory/ContentsXML
[disprod@myerp ContentsXML]$ cd ../..
[disprod@myerp bi]$ cp -ap inventory/ inventory_bak
[disprod@myerp bi]$ ls -al inventory_bak/
[disprod@myerp bi]$ cd
[disprod@myerp ~]$ unzip p5861907_10122_LINUX.zip
[disprod@myerp ~]$ ls
6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt
disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip
disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html
[disprod@myerp ~]$ cp oraclehomeproperties.xml /ora1206/bi/inventory/ContentsXML/
[disprod@myerp ~]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.60
Copyright (c) 2008 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home : /ora1206/bi
Oracle Home Inventory : /ora1206/bi/inventory
Central Inventory : /home/disprod/oraInventory
from : /etc/oraInst.loc
OUI location : /ora1206/bi/oui
OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so
Java location : /ora1206/bi/jre/1.4.2/bin/java
Log file location : /ora1206/bi/.patch_storage//*.log
Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_18-58-39.log"
Result:
Installed Patch List:
=====================
1) Patch 6472361 applied on Wed Oct 07 18:29:42 CST 2009
[ Base Bug(s): 5592580 5922891 6215863 5601311 5887565 5117216 4021063 5450764 6280716 6281519 5733442 5874608 6524850 5156055 6142101 3891259 5045120 6408161 5675183 5844020 6211732 5026541 5513118 5733380 6033718 5414271 5695725 6200167 5505532 5941634 5845334 5372331 5882138 5938059 5513051 5644523 6087336 5946580 5672507 4942563 5399782 5759749 6215389 5948836 5950469 6131998 5622397 6059509 6210014 6047200 5926918 5955554 6411910 6488750 5531425 6416859 5571494 5633035 5517786 5451810 5205897 6601738 5462238 5414006 6417086 6163906 5951782 5185518 5394787 5615830 6409713 5639863 5704846 6028993 5186826 5591608 5746156 4901641 6110024 6024356 5475786 5902903 5451758 6626145 5765688 6439239 5230981 5686940 5769537 5969985 5547386 6009122 6455857 6161749 6110031 6523741 6062038 4969310 6047668 6151989 4901223 5527718 5668736 5719064 5017919 5703057 6319785 6151052 5482224 4377151 6394762 5404340 5182568 5842046 6192712 5360227 5210171 5932508 5975552 4297543 5700591 5736563 5154809 6406196 5462419 5931061 5697966 5738745 5559923 5664108 6275246 6401901 6338458 6048127 5458617 5100123 5757331 5646832 6243564 5514492 6450367 5465401 6144867 5650574 6192806 6472361 5460689 5511802 5736074 5901130 6521161 6046898 6471566 6405620 5888236 6033938 6158845 6392752 6193039 4895141 6621751 5688150 5964077 5208063 6037141 6280013 5608740 5647142 5704032 5175015 6009097 5511743 5674250 6008002 5549319 5606063 5979500 6061924 6262095 5338161 5509976 5123374 5131394 5505404 5523984 5116591 6006847 5899757 6621404 5046741 5079665 5160684 6408043 5936322 6067310 5673463 5818607 5594149 5045873 6480045 5400823 5466302 5744401 4741477 5965613 6274627 5899762 6138043 5704057 6163989 5718465 5857955 6004179 6488047 5589983 5924970 4135528 5961773 5981660 5731674 6142363 5859997 4074428 5051945 5182332 4901433 5668944 6648794 5413004 5662488 6231017 6351275 5576526 5988357 5702104 5548112 6124085 6450125 5183143 4622470 6142011 5579945 6505247 5443532 5956310 5340118 6488133 5984587 5490603 5596428 5475150 6196131 5702043 5168275 5621127 5528097 5981827 5900969 6072532 6024597 4628944 5534228 ]
OPatch succeeded.
參考 README for 5861907
[disprod@myerp ~]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
[disprod@myerp ~]$ emctl status iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Oracle Enterprise Manager 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /ora1206/bi/sysman/log
[disprod@myerp ~]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 16054 | Alive
WebCache | WebCache | 15337 | Alive
WebCache | WebCacheAdmin | 15320 | Alive
OC4J | home | 15321 | Alive
OC4J | OC4J_BI_Forms | 15322 | Alive
HTTP_Server | HTTP_Server | 15323 | Alive
Discoverer | ServicesStatus | 15324 | Alive
Discoverer | PreferenceServer | 15325 | Alive
DSA | DSA | N/A | Down
[disprod@myerp ~]$
4. 配置Discoverer
4.1. 拷貝PROD.DBC
從ERP系統(tǒng)的$FND_SECURE目錄（應(yīng)用用戶）下拷貝PROD.DBC文件到$ORACLE_HOME/discoverer/secure（discoverer用戶，如果沒有這個目錄，請手動創(chuàng)建）
[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. 創(chuàng)建到數(shù)據(jù)庫的連接
[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)
)
)
或則也可以直接拷貝數(shù)據(jù)庫用戶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. 創(chuàng)建表空間
[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. 命令方式創(chuàng)建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
這是創(chuàng)建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
因為我當(dāng)前的EBS系統(tǒng)是從源系統(tǒng)clone 來的，源系統(tǒng)是安裝、配置過Discoverer的，因此這里提示已經(jīng)存在一個EUL；
4.5. 修改Java配置
[disprod@myerp ~]$ cd /ora1206/bi/jpi/bin/
[disprod@myerp bin]$ ls
j2re.exe
[disprod@myerp bin]$ exit
logout
[root@myerp ~]# su -l applseed
[applseed@myerp ~]$ echo $OA_HTML
/ora1206/apps/apps_st/comn/webapps/oacore/html
[applseed@myerp ~]$ cd $OA_HTML
[applseed@myerp html]$ ls -l oaj2se.exe
-rwxr-xr-x 1 applseed dba 16688520 Jan 16 2008 oaj2se.exe
拷貝oaj2se.exe
[root@myerp ~]# cp /ora1206/apps/apps_st/comn/webapps/oacore/html/oaj2se.exe /ora1206/bi/jpi/bin/
[root@myerp ~]# cd /ora1206/bi/jpi/bin/
[root@myerp bin]# ll
total 31664
-rw-r--r-- 1 disprod dba 15691488 Feb 22 2005 j2re.exe
-rwxr-xr-x 1 root root 16688520 Oct 8 08:36 oaj2se.exe
[root@myerp bin]# chown disprod:dba oaj2se.exe
[root@myerp bin]# chmod 755 oaj2se.exe
[root@myerp bin]# ll
total 31664
-rw-r--r-- 1 disprod dba 15691488 Feb 22 2005 j2re.exe
-rwxr-xr-x 1 disprod dba 16688520 Oct 8 08:36 oaj2se.exe
[root@myerp bin]#
這是我安裝的JDK版本
[root@myerp tools]# rpm -qa jdk
jdk-1.5.0_21-fcs
[disprod@myerp config]$ cd /ora1206/bi/discoverer/config
[disprod@myerp config]$ cp configuration.xml configuration.bak
[disprod@myerp config]$ ls
configuration.bak configuration.xml.1254895654154 disco.conf.smibak disco.policy
configuration.basecopy configuration.xsd discoConsole2Add.xml discoTarget2Add.xml
configuration.xml disco.conf discoOpmn2Add.xml preference_port.ini
configuration.xml.1254895654012 discoconfig5.properties discoPluginReg.xml uix-config.xml
[disprod@myerp config]$
[disprod@myerp config]$ vi configuration.xml
<?xml version = '1.0' encoding = 'UTF-8'?>
<!-- Copyright (c) 2001 Oracle Corporation. All rights reserved -->
<!-- Example configuration file. The schema rules are defined in
the schema definition file configuration.xsd which also
includes explanatory comments -->
Discoverer was stopped by your Administrator.
<!-- Server connection configuration. Determines how the Discoverer
middle-tier connects to a Discoverer server session.
The session is normally defined by system property
oracle.discoverer.server.session=
but can be overridden here by an attribute
session="SESSION_NAME"
To provide middle tier trace information modify logLevel (see schema for allowed values).
To provide finer grained control of middle tier trace information, add attribute:
logKeys = "classpath discoiv.cookies server_event execute discoiv.state_machine discoiv.request discoiv.servlet_exceptio
ns exceptions"
To provide a dump of the xml communication between server and middle tier add attribute:
modelXMLFile="c:\temp\dump.xml"
-->
<!--The default command used is ORACLE_HOME\bin\dis51ws. A different command line can be provided if requried.-->
<!--command>y:\dc\bin\opt\dis51ws
<!-- Discoverer Servlet configuration. Defines behaviour of both
discoverer/plus and discoverer/viewer servlets -->
dConnections="true" logLevel="error" laf="dc_blaf" switchWorksheetBehavior="prompt" defaultLocale="en" disableBrowserCaching="false"
>
Viewer was stopped by your Administrator.
disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>
hive="disco5i.jar" d4o_archive="d4o_double.jar"/>
Plus was stopped by your Administrator.
<!-- Portlet Provider configuration. -->
tMinute="1" maxRefreshRetries="1" maxGenericParameters="10" maxNewSessionPerMinute="6" maxWaitNewSessionMinute="30" minRequestThread
PoolSize="20" peekSleepIntervalSec="2"/>
修改以上幾處地方，我安裝JDK版本是jdk-1.5.0_21-fcs 因此這里修改的時候我根據(jù)JDK的版本修改相應(yīng)的值；
重啟Discoverer；
[disprod@myerp config]$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[disprod@myerp config]$ emctl stop iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.
[disprod@myerp config]$ opmnctl startall
opmnctl: starting opmn and all managed processes...
[disprod@myerp config]$ emctl start iasconsole
TZ set to PRC
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://myerp.testdomain.com:1156/emd/console/aboutApplication
Starting Oracle Enterprise Manager 10g Application Server Control ..... started successfully.
[disprod@myerp config]$ opmnctl status
Processes in Instance: discoverer.myerp.testdomain.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 24463 | Alive
WebCache | WebCache | 23749 | Alive
WebCache | WebCacheAdmin | 23737 | Alive
OC4J | home | 23740 | Alive
OC4J | OC4J_BI_Forms | 23745 | Alive
HTTP_Server | HTTP_Server | 23746 | Alive
Discoverer | ServicesStatus | 23747 | Alive
Discoverer | PreferenceServer | 23748 | Alive
DSA | DSA | N/A | Down
5. 配置Discoverer到EBS
5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer
http://myerp.testdomain.com:8065 ——〉系統(tǒng)管理員——〉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. | :// : |
具體操作如下圖所示：
修改節(jié)點的連接地址為當(dāng)前Discoverer 的http://myerp.testdomain.com:7778，然后保存“save”
選擇OK確認配置
選擇Ｏｋ完成配置
返回到參數(shù)編輯窗口，瀏覽攝制完成的參數(shù)：
5.2. 運行autoconfig
運行% /adautocfg.sh （應(yīng)用用戶下的autoconfig）
[root@myerp ~]# su -l applseed
[applseed@myerp ~]$ cd $ADMIN_SCRIPTS_HOME
[applseed@myerp scripts]$ pwd
/ora1206/inst/apps/came_myerp/admin/scripts
[applseed@myerp scripts]$ ls
adalnctl.sh adcmctl.sh adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh mwactlwrpr.sh
adapcctl.sh adexecsql.pl adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh
adautocfg.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo mwactl.sh
[applseed@myerp scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /ora1206/inst/apps/came_myerp/admin/log/10081114/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /ora1206/inst/apps/came_myerp
Classpath : /ora1206/apps/apps_st/comn/java/lib/appsborg2.zip:/ora1206/apps/apps_st/comn/java/classes
Using Context file : /ora1206/inst/apps/came_myerp/appl/admin/came_myerp.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
5.3. 設(shè)置EBS Profile(配置文件)
系統(tǒng)管理員 ——〉配置文件（Profile） > 系統(tǒng)（System）——〉彈出 form窗口——〉設(shè)置profile
——〉輸入查詢條件 (搜索%Discoverer%)——〉
可以按照下表進行設(shè)置（具體情況依據(jù)生產(chǎn)系統(tǒng)配置設(shè)置）
| Profile | Description | Value |
| ICX: Discoverer Launcher | URL that points to Discoverer Plus Servlet. | http://: |
| ICX: Discoverer Viewer Launcher | URL that points to Discoverer Viewer Servlet | http://: |
| ICX: Discoverer Release | Single number specifying the Discoverer release | 10 |
| ICX: Discoverer use Viewer | Specify whether Discoverer Viewer should be launched instead of Discoverer Plus (default). | Yes | No |
| ICX: Discoverer Default End User Layer Schema Prefix | The EUL prefix in combination with the Language code make up the EUL owner at runtime. For example EUL owner EUL_US has EUL prefix EUL. | EUL |
| ICX: Discoverer End User Layer Language Override | Since the End User Layer content is currently available in US English only, it is possible to override the user's general language preference for the Discoverer End User Layer using this profile option. The specified End User Layer language will be used regardless of the individual user's language preferences. | American English |
| ICX: Discoverer Parameters | This profile can be used to optionally pass additional URL parameters to Discoverer. Compare Note 186120.1 on Oracle MetaLink. |
|
| Discoverer DBC filename override | This profile can be used to specify the DBC Filename Discoverer should be using to connect to the E-Business Suite database. By default, this profile should remain NULL, in which case Discoverer will use the default dbc file for your E-Business Suite database. |
|
下圖和表即是我的設(shè)置：
| 配置文件選項名 | 地點 | 應(yīng)用產(chǎn)品 | 責(zé)任 | 服務(wù)器 | 服務(wù)器+責(zé)任 | 組織 | 用戶 |
| Discoverer DBC 文件名改寫 | ? | ? | ? | ? | ? | ? | ? |
| FII：GL BIS Discoverer 訪問 | ? | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer EBS 最終用戶層模式前綴 | ? | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer EDW 最終用戶層模式前綴 | ? | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer OLTP 最終用戶層模式前綴 | ? | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 參數(shù) | ? | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 啟動程序 | http://myerp.testdomain.com:7778/discoverer/plus?Connect=[APPS_SECURE] | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 最終用戶的層語言改寫 | 簡體中文 | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 瀏覽器的啟動程序 | http://myerp.testdomain.com:7778/discoverer/viewer?Connect=[APPS_SECURE] | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 版本 | 10 | ? | ? | ? | ? | ? | ? |
| ICX：Discoverer 默認最終用戶層模式前綴 | EUL | ? | ? | ? | ? | ? | ? |
| ICX：使用 Discoverer 瀏覽器 | 否 | ? | ? | ? | ? | ? | ? |
| OAM：Discoverer Ping 頻率 | ? | ? | ? | ? | ? | ? | ? |
| OKC：啟用 Discoverer 報表 | 否 | ? | ? | ? | ? | ? | ? |
5.4. 命令方式給EUL授權(quán)
1）輸入下面的命令進行授權(quán)：
[disprod@myerp ~]$ eulapi \
> -CONNECT eul_zhs/eul_zhs@came \
> -GRANT_PRIVILEGE \
> -USER SYSADMIN \
> -PRIVILEGE administration \
> -PRIVILEGE all_admin_privs\
> -LOG eul2.log
下面是我的執(zhí)行過程（命令相同，只是沒有按照上面的格式）
[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） 執(zhí)行下面命令授權(quán)
[disprod@myerp ~]$ eulapi \
> -CONNECT eul_zhs/eul_zhs@came \
> -GRANT_PRIVILEGE \
> -USER SYSADMIN \
> -BUSINESS_AREA_ADMIN_ACCESS % \
> -WILDCARD \
> -LOG eul_privilege.log
[disprod@erp ~]$ eulapi -CONNECT eul_zhs/eul_zhs@came -GRANT_PRIVILEGE -USER SYSADMIN -BUSINESS_AREA_ADMIN_ACCESS % -WILDCARD -LOG eul_privilege.log
-connect
-log eul_privilege.log
-grant_privilege
-business_area_admin_access %
-user SYSADMIN
-wildcard
Command completed.
[disprod@myerp ~]$
5.5. 刷新EUL層
1）查看applseed用戶下面的$AU_TOP/discoverer目錄
[applseed@myerp ~]$ cd $AU_TOP
[applseed@myerp 12.0.0]$ pwd
/ora1206/apps/apps_st/appl/au/12.0.0
[applseed@myerp 12.0.0]$ ls
admin discover graphs lib mesg patch plsql sql
bin forms java log out perl resource
[applseed@myerp 12.0.0]$ cd discover/
[applseed@myerp discover]$ ls
adrfseul.sh u4440000.drv u6394500.drv u6728000.drv US
adupdeul.sh u6141000.drv u6719036.drv u6836355.drv ZHS
[applseed@myerp discover]$
2）查看cd /ora1206/bi/discoverer 目錄
[disprod@myerp discoverer]$ cd /ora1206/bi/discoverer
[disprod@myerp discoverer]$ ls
config discwb.sh error.txt logs plus_files util
deploy doc lib mesg secure
3）拷貝$AU_TOP/discoverer 為$ORACLE_HOME/discoverer/exx
[root@myerp ~]# cp -ap /ora1206/apps/apps_st/appl/au/12.0.0/discover /ora1206/bi/discoverer/exx
[root@myerp ~]# cd /ora1206/bi/discoverer/
[root@myerp discoverer]# chown -R disprod:dba exx/
[root@myerp discoverer]# chmod -R 777 exx/
[root@myerp discoverer]# ll
total 44
drwxr-xrwx 2 disprod dba 4096 Oct 8 09:03 config
drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 deploy
-rwxr-xrwx 1 disprod dba 825 Oct 7 12:06 discwb.sh
drwxr-xrwx 31 disprod dba 4096 Oct 7 11:58 doc
-rw-r----- 1 disprod dba 0 Oct 8 09:12 error.txt
drwxrwxrwx 4 disprod dba 4096 Feb 7 2009 exx
drwxr-xrwx 2 disprod dba 4096 Oct 7 18:29 lib
drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 logs
drwxr-xrwx 2 disprod dba 4096 Oct 7 11:59 mesg
drwxr-xrwx 5 disprod dba 4096 Oct 7 12:04 plus_files
drwxr-x--- 2 disprod dba 4096 Oct 7 19:24 secure
drwxr-xrwx 2 disprod dba 4096 Oct 7 14:07 util
[root@myerp discoverer]# du -sh exx/
503M exx/
4）開始刷新ＥＵＬ層
[root@myerp discoverer]# su -l disprod
[disprod@myerp ~]$ cd $ORACLE_HOME/discoverer/exx/
[disprod@myerp exx]$ pwd
/ora1206/bi/discoverer/exx
[disprod@myerp exx]$ ls
adrfseul.sh adupdeul.sh u4440000.drv u6141000.drv u6394500.drv u6719036.drv u6728000.drv u6836355.drv US ZHS
[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
[disprod@myerp exx]$ sh adrfseul.sh \
> connect=sysadmin/meimima@came \
> resp="System Administrator" \
> gwyuid=APPLSYSPUB/PUB \
> fndnam=APPS \
> secgroup="Standard" \
> eulschema=eul_zhs \
> eulpassword=eul_zhs \
> twotask=came \
> iashome=/ora1206/bi \
> logfile=refresh_eul_us_mydb.log
/ora1206/bi/discoverer/exx/objfilelst8932.lst
**********************************************************
You are running adrfseul, version 120.6.12000000.4
Start of adrfseul session
Date/time is Thu Oct 8 12:55:08 CST 2009
Log file is refresh_eul_us_mydb.log
Command line arguments are
"connect=sysadmin/meimima@came"
"resp=System Administrator"
"gwyuid=APPLSYSPUB/PUB"
"fndnam=APPS"
"secgroup=Standard"
"eulschema=eul_zhs"
"eulpassword=eul_zhs"
"twotask=came"
"iashome=/ora1206/bi"
"logfile=refresh_eul_us_mydb.log"
Testing connection to database using sqlplus -s ...
Connection to database using sqlplus -s is OK ...
Extracting eul folder information ...
CUSTOMFOLDER
CUSTOMFOLDER1
CUSTOMFOLDER2
CUSTOMFOLDER3
CUSTOMFOLDER4
CUSTOMFOLDER5
CUSTOMFOLDER6
CUSTOMFOLDER7
ELEMENT
ELEMENT1
ELEMENT2
ELEMENT3
MDS1
RICH
RICH_
RICH_1
RICH_10
RICH_11
RICH_12
RICH_13
RICH_14
RICH_15
RICH_16
RICH_2
RICH_3
RICH_4
RICH_5
RICH_6
RICH_61
RICH_7
RICH_8
RICH_9
Done obtaining folder information
Calling discoverer refresh utility ...
32 folders to process:
Do you want to start refreshing the folders (Y|N)?
Type or 'Y' to continue, or 'N' to exit (with failure).
Y
(You entered "Y")
1 of 32 : Refreshing folder: CUSTOMFOLDER ...
-connect
-refresh_folder CUSTOMFOLDER
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
2 of 32 : Refreshing folder: CUSTOMFOLDER1 ...
-connect
-refresh_folder CUSTOMFOLDER1
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
3 of 32 : Refreshing folder: CUSTOMFOLDER2 ...
-connect
-refresh_folder CUSTOMFOLDER2
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
4 of 32 : Refreshing folder: CUSTOMFOLDER3 ...
-connect
-refresh_folder CUSTOMFOLDER3
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
5 of 32 : Refreshing folder: CUSTOMFOLDER4 ...
-connect
-refresh_folder CUSTOMFOLDER4
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
6 of 32 : Refreshing folder: CUSTOMFOLDER5 ...
-connect
-refresh_folder CUSTOMFOLDER5
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
7 of 32 : Refreshing folder: CUSTOMFOLDER6 ...
-connect
-refresh_folder CUSTOMFOLDER6
-log /ora1206/bi/discoverer/exx/logfile8932.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
DC Logger(9203): Logging Signal Caught
DC Logger(9204): Logging Signal Caught
DC Logger(9206): Logging Signal Caught
DC Logger(9207): Logging Signal Caught
DC Logger(9208): Logging Signal Caught
DC Logger(9212): Logging Signal Caught
DC Logger(9175): Logging Signal Caught
DC Logger(9176): Logging Signal Caught
DC Logger(9179): Logging Signal Caught
DC Logger(9183): Logging Signal Caught
DC Logger(9201): Logging Signal Caught
DC Logger(9205): Logging Signal Caught
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0xAAFB5F34 during VM shutdown
Function=uninitialized_copy__H3ZPPcZPPcZt9allocator1ZPc_X01X01X11X21_X11+0x24
Library=/ora1206/bi/discoverer/lib/libdcecm51.so
Current Java thread:
at java.lang.Object.wait(Native Method)
- waiting on <0xab9201a0> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:429)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
- locked <0xab9201a0> (a java.lang.ref.Reference$Lock)
這里拋出一個錯誤，無法繼續(xù)刷新了
Dynamic libraries:
0043e000-00454000 r-xp 00000000 08:01 1895519 /lib/ld-2.3.4.so
00454000-00455000 r-xp 00015000 08:01 1895519 /lib/ld-2.3.4.so
00455000-00456000 rwxp 00016000 08:01 1895519 /lib/ld-2.3.4.so
005b0000-005b2000 r-xp 00000000 08:01 1896367 /lib/libdl-2.3.4.so
005b2000-005b3000 r-xp 00001000 08:01 1896367 /lib/libdl-2.3.4.so
005b3000-005b4000 rwxp 00002000 08:01 1896367 /lib/libdl-2.3.4.so
007eb000-007f4000 r-xp 00000000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1
007f4000-007f5000 rwxp 00009000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1
00d5b000-00d6e000 r-xp 00000000 08:01 1896376 /lib/libnsl-2.3.4.so
00d6e000-00d6f000 r-xp 00012000 08:01 1896376 /lib/libnsl-2.3.4.so
00d6f000-00d70000 rwxp 00013000 08:01 1896376 /lib/libnsl-2.3.4.so
08048000-08056000 r-xp 00000000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java
08056000-08059000 rwxp 0000d000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java
a81c7000-a81cd000 r-xs 00000000 08:01 1159554 /usr/lib/gconv/gconv-modules.cache
a81cd000-a8205000 r-xp 00000000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
a8205000-a8210000 rwxp 00037000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
a8212000-a8d4a000 r-xp 00000000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1
a8d4a000-a8db7000 rwxp 00b37000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1
a8dcd000-a8f46000 r-xp 00000000 08:03 33374267 /ora1206/bi/lib/libnnz10.so
a8f46000-a8f60000 rwxp 00178000 08:03 33374267 /ora1206/bi/lib/libnnz10.so
a8f61000-a954f000 r-xp 00000000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so
a954f000-a966a000 rwxp 005ed000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so
a96bd000-a971d000 r-xp 00000000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so
a971d000-a972c000 rwxp 0005f000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so
a972d000-aa702000 r-xp 00000000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so
aa702000-aaa35000 rwxp 00fd4000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so
aaa3c000-aac81000 r-xp 00000000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so
aac81000-aacc3000 rwxp 00244000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so
aacd5000-aadd2000 r-xp 00000000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so
aadd2000-aae09000 rwxp 000fc000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so
aae2e000-aafce000 r-xp 00000000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so
aafce000-ab016000 rwxp 0019f000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so
ab017000-ab0cf000 r-xp 00000000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so
ab0cf000-ab0f7000 rwxp 000b7000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so
ab0f7000-ab0fd000 r-xs 00000000 08:03 18321245 /ora1206/bi/jdk/jre/lib/ext/ojmisc.jar
ab0fd000-ab0fe000 r-xs 00000000 08:03 33308681 /ora1206/bi/jdk/jre/lib/ext/sslqueries.jar
ab0fe000-ab10c000 r-xs 00000000 08:03 33308680 /ora1206/bi/jdk/jre/lib/ext/activation.jar
ab10c000-ab10f000 r-xs 00000000 08:03 33308679 /ora1206/bi/jdk/jre/lib/ext/smtp.jar
ab10f000-ab135000 r-xs 00000000 08:03 33308678 /ora1206/bi/jdk/jre/lib/ext/mailapi.jar
ab135000-ab17a000 r-xs 00000000 08:03 33308677 /ora1206/bi/jdk/jre/lib/ext/mail.jar
ab17a000-ab17d000 r-xs 00000000 08:03 33308676 /ora1206/bi/jdk/jre/lib/ext/jta.jar
ab17d000-ab239000 r-xs 00000000 08:03 30168147 /ora1206/bi/jdk/jre/lib/ext/localedata.jar
ab239000-ab246000 r-xs 00000000 08:03 30168146 /ora1206/bi/jdk/jre/lib/ext/ldapsec.jar
ab246000-ab249000 r-xs 00000000 08:03 30168145 /ora1206/bi/jdk/jre/lib/ext/dnsns.jar
ab249000-ab265000 r-xs 00000000 08:03 30168144 /ora1206/bi/jdk/jre/lib/ext/sunjce_provider.jar
ab265000-ab289000 r-xs 00000000 08:03 18321937 /ora1206/bi/bin/eulbuilder.jar
ab48d000-ab68d000 r-xp 00000000 08:01 1130496 /usr/lib/locale/locale-archive
b5940000-b5e99000 r-xs 00000000 08:03 33243206 /ora1206/bi/jdk/jre/lib/charsets.jar
b5e99000-b5eaa000 r-xs 00000000 08:03 33243160 /ora1206/bi/jdk/jre/lib/jce.jar
b5eaa000-b5f87000 r-xs 00000000 08:03 33243205 /ora1206/bi/jdk/jre/lib/jsse.jar
b5f87000-b5f9d000 r-xs 00000000 08:03 33243159 /ora1206/bi/jdk/jre/lib/sunrsasign.jar
b5fe7000-b798e000 r-xs 00000000 08:03 33243204 /ora1206/bi/jdk/jre/lib/rt.jar
b798e000-b79a2000 r-xp 00000000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so
b79a2000-b79a5000 rwxp 00013000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so
b79a5000-b79c5000 r-xp 00000000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so
b79c5000-b79c7000 rwxp 0001f000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so
b79c7000-b79d0000 r-xp 00000000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79d0000-b79d1000 r-xp 00008000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79d1000-b79d2000 rwxp 00009000 08:01 1893170 /lib/libnss_files-2.3.4.so
b79dd000-b79ed000 r-xp 00000000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so
b79ed000-b79ef000 rwxp 0000f000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so
b79ef000-b79f3000 rwxs 00000000 08:01 2274675 /tmp/hsperfdata_disprod/9172 (deleted)
b79f3000-b7a14000 r-xp 00000000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a14000-b7a15000 r-xp 00020000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a15000-b7a16000 rwxp 00021000 08:01 1893129 /lib/i686/libm-2.3.4.so
b7a2e000-b7a36000 r-xp 00000000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so
b7a36000-b7a37000 rwxp 00007000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so
b7a37000-b7e33000 r-xp 00000000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so
b7e33000-b7e4f000 rwxp 003fb000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so
b7e61000-b7f86000 r-xp 00000000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f86000-b7f88000 r-xp 00125000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f88000-b7f8a000 rwxp 00127000 08:01 1893127 /lib/i686/libc-2.3.4.so
b7f8c000-b7f9a000 r-xp 00000000 08:01 1893131 /lib/i686/libpthread-0.10.so
b7f9a000-b7f9b000 r-xp 0000d000 08:01 1893131 /lib/i686/libpthread-0.10.so
b7f9b000-b7f9c000 rwxp 0000e000 08:01 1893131 /lib/i686/libpthread-0.10.so
Heap at VM Abort:
Heap
def new generation total 576K, used 515K [0xab890000, 0xab930000, 0xabd70000)
eden space 512K, 88% used [0xab890000, 0xab900d78, 0xab910000)
from space 64K, 99% used [0xab920000, 0xab92fff8, 0xab930000)
to space 64K, 0% used [0xab910000, 0xab910000, 0xab920000)
tenured generation total 1408K, used 57K [0xabd70000, 0xabed0000, 0xaf890000)
the space 1408K, 4% used [0xabd70000, 0xabd7e7a0, 0xabd7e800, 0xabed0000)
compacting perm gen total 4096K, used 1681K [0xaf890000, 0xafc90000, 0xb3890000)
the space 4096K, 41% used [0xaf890000, 0xafa344c8, 0xafa34600, 0xafc90000)
Local Time = Thu Oct 8 12:55:55 2009
Elapsed Time = 4
#
# The exception above was detected in native code outside the VM
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode)
#
# An error report file has been saved as hs_err_pid9172.log.
# Please refer to the file for further information.
#
[1]+ Stopped sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
我強行中止命令，然后再次運行命令開始刷新
[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log
/ora1206/bi/discoverer/exx/objfilelst9831.lst
**********************************************************
You are running adrfseul, version 120.6.12000000.4
Start of adrfseul session
Date/time is Thu Oct 8 13:10:38 CST 2009
Log file is refresh_eul_us_mydb.log
Command line arguments are
"connect=sysadmin/meimima@came"
"resp=System Administrator"
"gwyuid=APPLSYSPUB/PUB"
"fndnam=APPS"
"secgroup=Standard"
"eulschema=eul_zhs"
"eulpassword=eul_zhs"
"twotask=came"
"iashome=/ora1206/bi"
"logfile=refresh_eul_us_mydb.log"
Testing connection to database using sqlplus -s ...
Connection to database using sqlplus -s is OK ...
Extracting eul folder information ...
CUSTOMFOLDER6
CUSTOMFOLDER7
ELEMENT
ELEMENT1
ELEMENT2
ELEMENT3
MDS1
RICH
RICH_
RICH_1
RICH_10
RICH_11
RICH_12
RICH_13
RICH_14
RICH_15
RICH_16
RICH_2
RICH_3
RICH_4
RICH_5
RICH_6
RICH_61
RICH_7
RICH_8
RICH_9
Done obtaining folder information
Calling discoverer refresh utility ...
26 folders to process:
Do you want to start refreshing the folders (Y|N)?
Type or 'Y' to continue, or 'N' to exit (with failure).
Y
(You entered "Y")
1 of 26 : Refreshing folder: CUSTOMFOLDER6 ...
-connect
-refresh_folder CUSTOMFOLDER6
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
2 of 26 : Refreshing folder: CUSTOMFOLDER7 ...
-connect
-refresh_folder CUSTOMFOLDER7
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
3 of 26 : Refreshing folder: ELEMENT ...
-connect
-refresh_folder ELEMENT
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
4 of 26 : Refreshing folder: ELEMENT1 ...
-connect
-refresh_folder ELEMENT1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
5 of 26 : Refreshing folder: ELEMENT2 ...
-connect
-refresh_folder ELEMENT2
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
6 of 26 : Refreshing folder: ELEMENT3 ...
-connect
-refresh_folder ELEMENT3
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
7 of 26 : Refreshing folder: MDS1 ...
-connect
-refresh_folder MDS1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
8 of 26 : Refreshing folder: RICH ...
-connect
-refresh_folder RICH
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
9 of 26 : Refreshing folder: RICH_ ...
-connect
-refresh_folder RICH_
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
10 of 26 : Refreshing folder: RICH_1 ...
-connect
-refresh_folder RICH_1
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
11 of 26 : Refreshing folder: RICH_10 ...
-connect
-refresh_folder RICH_10
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
12 of 26 : Refreshing folder: RICH_11 ...
-connect
-refresh_folder RICH_11
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
13 of 26 : Refreshing folder: RICH_12 ...
-connect
-refresh_folder RICH_12
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
14 of 26 : Refreshing folder: RICH_13 ...
-connect
-refresh_folder RICH_13
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
15 of 26 : Refreshing folder: RICH_14 ...
-connect
-refresh_folder RICH_14
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
16 of 26 : Refreshing folder: RICH_15 ...
-connect
-refresh_folder RICH_15
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
17 of 26 : Refreshing folder: RICH_16 ...
-connect
-refresh_folder RICH_16
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
18 of 26 : Refreshing folder: RICH_2 ...
-connect
-refresh_folder RICH_2
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
19 of 26 : Refreshing folder: RICH_3 ...
-connect
-refresh_folder RICH_3
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
20 of 26 : Refreshing folder: RICH_4 ...
-connect
-refresh_folder RICH_4
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
21 of 26 : Refreshing folder: RICH_5 ...
-connect
-refresh_folder RICH_5
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
22 of 26 : Refreshing folder: RICH_6 ...
-connect
-refresh_folder RICH_6
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
23 of 26 : Refreshing folder: RICH_61 ...
-connect
-refresh_folder RICH_61
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
24 of 26 : Refreshing folder: RICH_7 ...
-connect
-refresh_folder RICH_7
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
25 of 26 : Refreshing folder: RICH_8 ...
-connect
-refresh_folder RICH_8
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
26 of 26 : Refreshing folder: RICH_9 ...
-connect
-refresh_folder RICH_9
-log /ora1206/bi/discoverer/exx/logfile9831.log
-apps_user
-eul eul_zhs
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
-identifier
Command completed.
Done calling discoverer refresh utility.
Discoverer refresh exited with status 0.
----------------------------------------------------------------------
Log information from the refresh process ...
java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER6 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:10:49 CST 2009 ...
Name: ??????????, Type: Definition Unavailable, Action: ??????????
Completed Thu Oct 08 13:12:11 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER7 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:12 CST 2009 ...
Name: rich_??????, Type: Definition Unavailable, Action: rich_??????
Completed Thu Oct 08 13:12:16 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:16 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:12:19 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:20 CST 2009 ...
Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????
Completed Thu Oct 08 13:12:21 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT2 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:22 CST 2009 ...
Name: ???????, Type: Definition Unavailable, Action: ???????
Completed Thu Oct 08 13:12:24 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT3 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:24 CST 2009 ...
Name: ?????, Type: Definition Unavailable, Action: ?????
Completed Thu Oct 08 13:12:26 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder MDS1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:26 CST 2009 ...
Name: MDS?????, Type: Definition Unavailable, Action: MDS?????
Completed Thu Oct 08 13:12:28 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:28 CST 2009 ...
Name: rich????????????, Type: Definition Unavailable, Action: rich????????????
Completed Thu Oct 08 13:12:30 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_ -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:30 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:32 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_1 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:32 CST 2009 ...
Name: RICH_??????????????, Type: Definition Unavailable, Action: RICH_??????????????
Completed Thu Oct 08 13:12:34 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_10 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:34 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:36 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_11 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:36 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:38 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_12 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:38 CST 2009 ...
Name: RICH_?????????, Type: Definition Unavailable, Action: RICH_?????????
Completed Thu Oct 08 13:12:41 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_13 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:41 CST 2009 ...
Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????
Completed Thu Oct 08 13:12:42 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_14 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:43 CST 2009 ...
Name: RICH_?????-??, Type: Definition Unavailable, Action: RICH_?????-??
Completed Thu Oct 08 13:12:44 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_15 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:44 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:46 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_16 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:46 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:12:48 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_2 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:48 CST 2009 ...
Name: RICH_??????????????????, Type: Definition Unavailable, Action: RICH_??????????????????
Completed Thu Oct 08 13:12:50 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_3 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:50 CST 2009 ...
Name: RICH_?????????????, Type: Definition Unavailable, Action: RICH_?????????????
Completed Thu Oct 08 13:12:52 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_4 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:53 CST 2009 ...
Name: RICH_??????????, Type: Definition Unavailable, Action: RICH_??????????
Completed Thu Oct 08 13:12:55 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_5 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:55 CST 2009 ...
Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????
Completed Thu Oct 08 13:12:57 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_6 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:57 CST 2009 ...
Name: RICH_???????_????, Type: Definition Unavailable, Action: RICH_???????_????
Completed Thu Oct 08 13:12:59 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_61 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:12:59 CST 2009 ...
Name: RICH_???????_??, Type: Definition Unavailable, Action: RICH_???????_??
Completed Thu Oct 08 13:13:01 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_7 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:01 CST 2009 ...
Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????
Completed Thu Oct 08 13:13:03 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_8 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:03 CST 2009 ...
Name: RICH_??????, Type: Definition Unavailable, Action: RICH_??????
Completed Thu Oct 08 13:13:06 CST 2009.java EulCommandLine -connect -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_9 -log /ora1206/bi/discoverer/exx/logfile9831.log
Started Thu Oct 08 13:13:06 CST 2009 ...
Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????
Completed Thu Oct 08 13:13:08 CST 2009.
End of refresh log
----------------------------------------------------------------------
adrfseul is exiting with status 0
End of adrfseul session
Date/time is Thu Oct 8 13:13:08 CST 2009
**********************************************************
這次正常完成刷新；
5.6. EBS調(diào)用Discoverer
5.6.1. 新建菜單Discoverer以SYSADMIN/SYSADMIN_PASSWD進入ERP系統(tǒng)——系統(tǒng)管理員——應(yīng)用產(chǎn)品——菜單——新建
新建菜單名：Discoverer
用戶菜單名：Discoverer
功能名：Invoke Web Discoverer
提示為:Discoverer
保存
將剛建的菜單 Discoverer測試添加到 菜單 “瀏覽器菜單 - 系統(tǒng)管理員 GUI”如下圖
下圖為保存后在系統(tǒng)管理員職責(zé)下的Discoverer
5.6.2. 下圖為打開后的Discoverer Plus
6. 其他問題：
6.1.EUL(end user layer)是什么：
提供了一個為了方便最終用戶對數(shù)據(jù)進行展現(xiàn)、分析而準備的直觀的、基于業(yè)務(wù)內(nèi)容的表示層，使得數(shù)據(jù)的物理存儲對于最終用戶來說是透明的不需考慮的；
是一種元數(shù)據(jù)，其內(nèi)容包含了一或多個業(yè)務(wù)區(qū)域(business area)，每個業(yè)務(wù)區(qū)域，都是一個反映最終用戶特定方面(主題)的業(yè)務(wù)需求的一系列表/視圖的組合。在業(yè)務(wù)區(qū)域里，按folder/item形式來組織；
通過discoverer administrator來創(chuàng)建和維護；
EUL
最終用戶通過discoverer desktop或discoverer plus等發(fā)出查詢請求時，discoverer通過EUL實現(xiàn)對相應(yīng)物理表的訪問。這一切對用戶是透明的。
從作為提供給最終用戶的表示層的角度來說，EUL有點象siebel中的presentation layer，都是從展現(xiàn)的角度來進行內(nèi)容組織。不同的是，EUL直接從物理層映射到了展現(xiàn)層。Siebel presentatin layer則是基于的business model and mapping 那一層，由business model來屏蔽物理表/視圖的存儲。
的物理存儲，是一系列的表，當(dāng)EUL中的內(nèi)容發(fā)生了增刪改等變動，相應(yīng)改動存儲在該表中的內(nèi)容
6.2. 參考文檔：
http://blog.csdn.net/mumu210/archive/2009/05/26/4218424.aspx
http://www.itpub.net/archiver/tid-1153010.html
http://www.docslib.com/html/Linuxwendang/2009/0707/48.html
http://www.diybl.com/course/6_system/linux/Linuxjs/2008727/133959.html
http://pangwords.spaces.live.com/Blog/cns!17F01800524B6479!341.entry
http://www.oraclefans.cn/forum/showtopic.jsp?rootid=5741&CPages=1
http://blog.chinaunix.net/u/1281/showart_297681.html
http://www.trutek.com/serendipity/index.php?/archives/23-Discover-Eulapi-for-Exporting-and-Importing-the-Whole-Discoverer-Schema-from-the-Discoverer-Server-by-Kathy-Duret.html
http://www.freelists.org/post/ora-apps-dba/discover-eul-export-and-import,2
http://blog.itjaj.com/?264/viewspace-126
http://www.trutek.com/serendipity/index.php?/archives/2009/02.html
http://download.oracle.com/docs/html/A86730_01/managing.htm
http://blog.itpub.net/category/15182/30662
http://moonsoft.itpub.net/post/15182/305321
http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!1030.entry
http://ordre04.oeanet.org/discoverer/help?navId=3&navSetId=disco_vw_conn_zh_CN&locale=zh_CN&vtTopicFile=disco_vw_conn_zh_CN/vcconn01.htm
http://www.moi.go.th/discoverer/help/state/content/locale.zh_CN/vtTopicFile.disco_vw_zh_CN%7Cvstart007~htm/navId.3/navSetId.disco_vw_zh_CN/
http://www.docin.com/app/p?id=32319535
http://bbs.erp100.com/thread-29801-1-1.html
http://bbs.erp100.com/thread-25847-1-7.html###zoom
https://iasint.rtpnc.epa.gov/discoverer/help/state/content/destination.2~-2~1~-2~2~-2~2~7~-3~-2~1~6~/expanded.3~0~/locale.zh_CN/navId.0/navSetId.disco_vw_zh_CN/oldNavId.0/oldNavSetId.disco_vw_zh_CN/
來自 “ ITPUB博客 ” ，鏈接：http://blog.itpub.net/14710393/viewspace-1081608/，如需轉(zhuǎn)載，請注明出處，否則將追究法律責(zé)任。
轉(zhuǎn)載于:http://blog.itpub.net/14710393/viewspace-1081608/
總結(jié)
以上是生活随笔為你收集整理的Oracle_Discoverer10G_Server安装配置的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 解决CentOS“Zabbix disc
- 下一篇： 2021年电工（初级）考试试卷及电工（初