ITPub博客

首页 > 数据库 > Oracle > Oracle_Discoverer10G_Server安装配置

Oracle_Discoverer10G_Server安装配置

原创 Oracle 作者:luckyfriends 时间:2014-02-14 17:57:17 0 删除 编辑

密 级:机密

总页数:3页

clip_image002[4]

Oracle_Discoverer10G_Server安装配置

(V 1.0)

文章版权所有Jusin Haoluckyfriends),支持原创,转载请注明。

20128

版本信息

日期

版本

描述

作者/修改人

备注

2012-8-31

1.0

创建

Jusin Hao

 
         
         
         

目 录

1. 介绍... 5

1.1. 编写目的... 5

1.2. 文档说明... 5

1.3. 定义... 5

1.4. 参考文档... 5

2. 安装Discoverer 5

2.1. 检查系统设置、环境变量等值的设置... 5

2.2. 开始安装Discoverer 9

2.3. 安装完毕显示结果和浏览URL. 21

2.4. 修改环境变量及重启... 22

3. 安装相关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. 创建到数据库的连接... 44

4.3. 创建表空间... 48

4.4. 命令方式创建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. 设置EBS Profile(配置文件) 61

5.4. 命令方式给EUL授权... 64

5.5. 刷新EUL层... 65

5.6. EBS调用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)的安装介绍。包括:

· 源系统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:

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

检查系统组件是否安装齐全(可使用命令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]

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]

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]

clip_image014[4]

clip_image016[4]

指定端口,这里使用默认的自动分配;如果选用手动分配可以在/ora1206/bi/staticports.ini 查看端口信息:

clip_image018[4]

clip_image020[4]

clip_image022[4]

clip_image024[4]

clip_image026[4]

clip_image028[4]

提示运行/ora1206/bi/root.sh 文件

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]

可是我这里报错,如上图所示,因此我一句提示查看日志:

查看日志

[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]

退出,完成安装。

clip_image036[4]

2.3. 安装完毕显示结果和浏览URL

clip_image038[4]

在客户段打开IE浏览器,输入上面的网址,以及用户名密码:ias_admin/discoverer1

clip_image040[4]

登陆到Discoverer的管理界面;

clip_image042[4]

2.4. 修改环境变量及重启

[disprod@myerp ~]$ vi .bash_profile

PATH=$PATH:$HOME/bin

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

ORACLE_HOME=/ora1206/bi

export ORACLE_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

export PATH

unset USERNAME

[disprod@myerp ~]$ source .bash_profile

[disprod@myerp ~]$ emctl status iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Oracle Enterprise Manager 10g Application Server Control is running.

------------------------------------------------------------------

Logs are generated in directory /ora1206/bi/sysman/log

[disprod@myerp ~]$ opmnctl status

Processes in Instance: discoverer.myerp.testdomain.com

-------------------+--------------------+---------+---------

ias-component | process-type | pid | status

-------------------+--------------------+---------+---------

LogLoader | logloaderd | N/A | Down

dcm-daemon | dcm-daemon | 26384 | Alive

WebCache | WebCache | 26701 | Alive

WebCache | WebCacheAdmin | 26671 | Alive

OC4J | home | 26672 | Alive

OC4J | OC4J_BI_Forms | 26673 | Alive

HTTP_Server | HTTP_Server | 26674 | Alive

Discoverer | ServicesStatus | 26675 | Alive

Discoverer | PreferenceServer | 26676 | Alive

DSA | DSA | N/A | Down

[disprod@myerp ~]$

[disprod@myerp ~]$ opmnctl stopall

opmnctl: stopping opmn and all managed processes...

[disprod@myerp ~]$ emctl stop iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.

[disprod@myerp ~]$ opmnctl startall

opmnctl: starting opmn and all managed processes...

opmnctl: opmn start failed

[disprod@myerp ~]$ emctl start iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Starting Oracle Enterprise Manager 10g Application Server Control ............. started successfully.

3. 安装相关Patch

3.1. 安装p4960210

下载p4960210_10122_LINUX.zip

解压缩安装包

[disprod@myerp ~]$ unzip p4960210_10122_LINUX.zip

[disprod@myerp ~]$ ll

total 1979980

drwxr-xr-x 6 disprod dba 4096 Dec 9 2006 Disk1

[disprod@myerp ~]$ cd Disk1/

[disprod@myerp Disk1]$ ls

doc install readme.html runInstaller stage utils

[disprod@myerp Disk1]$ ./runInstaller

-------------------------------------------------------------------------------------------------------------------

The OUI Screen may take around 5 to 30 seconds to come up depending upon system performance. Please Wait .......

-------------------------------------------------------------------------------------------------------------------

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-2.1, redhat-3, redhat-4, SuSE-8, SuSE-9 or UnitedLinux-1.0

Passed

All installer requirements met.

Checking Temp space: must be greater than 400 MB. Actual 5538 MB Passed

Checking swap space: must be greater than 1536 MB. Actual 3472MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed

Checking if CPU speed is above 450 MHz. Actual 1200 MHz Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-07_01-35-44PM. Please wait ...[disprod@myerp Disk1]$ Oracle Universal Installer, Version 10.1.0.5.0 Production

Copyright (C) 1999, 2005, Oracle. All rights reserved.

Val: 0

Val: 0

Val: 0

Val: 0

Val: 0

clip_image044[4]

clip_image046[4]

选择安装 Oracle Application server and Developer Suite 10g Rel 2 Software Update 10.1.2.2.0

clip_image048[4]

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]

如果不行可以手动关闭IAS,关闭应用、数据库,然后再“Retry”

[applseed@myerp ~]$

[disprod@myerp bi]$ emctl status iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Oracle Enterprise Manager 10g Application Server Control is running.

------------------------------------------------------------------

Logs are generated in directory /myclone/bi/sysman/log

[disprod@myerp bi]$ opmnctl stopall

opmnctl: stopping opmn and all managed processes...

[disprod@myerp bi]$ emctl stop iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.

[disprod@myerp bi]$

[applseed@myerp ~]$ /ora1206/inst/apps/came_myerp/admin/scripts/adstpall.sh apps/rich08ll

clip_image054[4]

clip_image056[4]

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]

clip_image062[4]

如果应用和数据库已经关闭,依次启动数据库、应用;IAS这时候已经自动起来了;

[disprod@myerp ~]$ emctl status iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Oracle Enterprise Manager 10g Application Server Control is running.

------------------------------------------------------------------

Logs are generated in directory /ora1206/bi/sysman/log

3.2. 安装opatch:p6880880

[disprod@myerp ~]$ ls

disk1 disk2 p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip readme.html

Disk1 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip

p6880880_102000_LINUX.zip

[disprod@myerp ~]$ more .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

ORACLE_HOME=/ora1206/bi

export ORACLE_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

export PATH

unset USERNAME

因为我的OUI version 10.1.0.5.0 ,所以如果我安装p6880880_102000_LINUX.zip 的话会提示如下错误;所以我 安装的是p6880880_101000_LINUX.zip;这里要注意;

Patch history file: /ora1206/bi/cfgtoollogs/opatch/opatch_history.txt

LsInventorySession failed:

--------------------------------------------------------------------------------

The Oracle Home does not meet OUI version requirement.

This OPatch (version 10.2.0.4.5) detects OUI version 10.1.0.5.0 in the home.

It requires OUI version 10.2 or above.

OPatch failed with error code 73

[disprod@myerp ~]$ unzip p6880880_101000_LINUX.zip

inflating: OPatch/docs/FAQ

inflating: OPatch/docs/README.txt

inflating: OPatch/docs/Users_Guide.txt

inflating: OPatch/docs/bt1.txt

inflating: OPatch/docs/bt2.txt

inflating: OPatch/emdpatch.pl

inflating: OPatch/jlib/opatch.jar

inflating: OPatch/ocm/bin/emocmrsp

inflating: OPatch/ocm/lib/emocmutl.jar

extracting: OPatch/ocm/ocm.zip

inflating: OPatch/opatch

inflating: OPatch/opatch.bat

extracting: OPatch/opatch.ini

inflating: OPatch/opatch.pl

creating: OPatch/perl_modules/

inflating: OPatch/perl_modules/Apply.pm

inflating: OPatch/perl_modules/AttachHome.pm

inflating: OPatch/perl_modules/Command.pm

inflating: OPatch/perl_modules/LsInventory.pm

inflating: OPatch/perl_modules/NApply.pm

inflating: OPatch/perl_modules/NRollBack.pm

inflating: OPatch/perl_modules/Query.pm

inflating: OPatch/perl_modules/RollBack.pm

inflating: OPatch/perl_modules/Util.pm

inflating: OPatch/perl_modules/Version.pm

inflating: OPatch/perl_modules/XML.pm

inflating: OPatch/perl_modules/compile.csh

inflating: OPatch/perl_modules/opatchIO.pm

inflating: OPatch/README.txt

[disprod@myerp ~]$

查看解压后的文件OPatch

[disprod@myerp ~]$ ls

disk1 disk2 oraInventory p4960210_10122_LINUX.zip p6472361_10122_LINUX.zip p6880880_102000_LINUX.zip

Disk1 OPatch p2617419_10102_GENERIC.zip p5861907_10122_LINUX.zip p6880880_101000_LINUX.zip

[disprod@myerp ~]$ cd OPatch/

[disprod@myerp OPatch]$ ls

docs emdpatch.pl jlib ocm opatch opatch.bat opatch.ini opatch.pl opatchprereqs perl_modules README.txt

[disprod@myerp OPatch]$

[disprod@myerp ~]$ cd /ora1206/bi

[disprod@myerp bi]$ rm -r OPatch/

[disprod@myerp bi]$ mv /home/disprod/OPatch/ .

[disprod@myerp bi]$ opatch version

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

OPatch Version: 1.0.0.0.60

[disprod@myerp bi]$ opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /ora1206/bi

Oracle Home Inventory : /ora1206/bi/inventory

Central Inventory : /home/disprod/oraInventory

from : /etc/oraInst.loc

OUI location : /ora1206/bi/oui

OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so

Java location : /ora1206/bi/jre/1.4.2/bin/java

Log file location : /ora1206/bi/.patch_storage//*.log

Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_14-58-10.log"

Result:

There is no Interim Patch

OPatch succeeded.

[disprod@myerp bi]$ cd

[disprod@myerp ~]$ source .bash_profile

[disprod@myerp ~]$ opatch lsinventory –details

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /ora1206/bi

Oracle Home Inventory : /ora1206/bi/inventory

Central Inventory : /home/disprod/oraInventory

from : /etc/oraInst.loc

OUI location : /ora1206/bi/oui

OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so

Java location : /ora1206/bi/jre/1.4.2/bin/java

Log file location : /ora1206/bi/.patch_storage//*.log

Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_15-01-50.log"

Result:

There is no Interim Patch

OPatch succeeded.

[disprod@myerp ~]$ opatch version

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

OPatch Version: 1.0.0.0.60

3.3. 安装p6472361

[disprod@myerp ~]$ unzip p6472361_10122_LINUX.zip

[disprod@myerp ~]$ ls

6472361

[disprod@myerp 6472361]$ ls

etc files README.txt

[disprod@myerp 6472361]$ cd files/

[disprod@myerp files]$ ls

bibeans bin discoverer j2ee jlib sysman

[disprod@myerp 6472361]$ cd

[disprod@myerp ~]$ more .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

ORACLE_HOME=/ora1206/bi

export ORACLE_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

export PATH

unset USERNAME

[disprod@myerp 6472361]$ opmnctl stopall

opmnctl: stopping opmn and all managed processes...

[disprod@myerp 6472361]$ opmnctl status

Unable to connect to opmn.

Opmn may not be up.

[disprod@myerp 6472361]$ pwd

/home/disprod/6472361

[disprod@myerp 6472361]$ ls

etc files README.txt

[disprod@myerp 6472361]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /ora1206/bi

Oracle Home Inventory : /ora1206/bi/inventory

Central Inventory : /home/disprod/oraInventory

from : /etc/oraInst.loc

OUI location : /ora1206/bi/oui

OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so

Java location : /ora1206/bi/jre/1.4.2/bin/java

Log file location : /ora1206/bi/.patch_storage//*.log

Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-09-20.log"

Invoking fuser to check for active processes.

OPatch detects your platform as 23 while this patch 6472361 supports platforms:

46 (Linux Intel)

226 (Linux x86-64)

This patch is not suitable for this operating system.

Please contact support for the correct patch.

ERROR: OPatch failed during pre-reqs check.

[disprod@myerp ~]$ export OPATCH_PLATFORM_ID=46

[disprod@myerp ~]$ echo $OPATCH_PLATFORM_ID

46

[disprod@myerp ~]$ ls

6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt

disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip

disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html

[disprod@myerp ~]$ cd 6472361/

[disprod@myerp 6472361]$ ls

etc files README.txt

[disprod@myerp 6472361]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /ora1206/bi

Oracle Home Inventory : /ora1206/bi/inventory

Central Inventory : /home/disprod/oraInventory

from : /etc/oraInst.loc

OUI location : /ora1206/bi/oui

OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so

Java location : /ora1206/bi/jre/1.4.2/bin/java

Log file location : /ora1206/bi/.patch_storage//*.log

Creating log file "/ora1206/bi/.patch_storage/6472361/Apply_6472361_10-07-2009_18-24-26.log"

Invoking fuser to check for active processes.

*****

Only the Oracle home owner can install or configure the Oracle Configuration Manager in an

ORACLE_HOME structure. The ORACLE_HOME (/ora1206/bi) is owned by the UID 0

*****

Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

(我先前已经执行了opmnctl stopall)

Please shut down Oracle instances running out of this ORACLE_HOME

(Oracle Home = /ora1206/bi)

Is this system ready for updating?

Please respond Y|N >

Y

Applying patch 6472361...

Patching copy files...

Inventory is good and does not have any dangling patches.

Updating inventory...

Verifying patch...

Backing up comps.xml ...

OPatch succeeded.

[disprod@myerp 6472361]$

查看Application Server Control显示在运行,因为我并没有关闭

[disprod@myerp 6472361]$ emctl status iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Oracle Enterprise Manager 10g Application Server Control is running.

------------------------------------------------------------------

Logs are generated in directory /ora1206/bi/sysman/log

以上参考 README for 6472361

3.4. 安装patch 5861907

[disprod@myerp ~]$ opmnctl status

Unable to connect to opmn.

Opmn may not be up.

[disprod@myerp ~]$ cd /ora1206/bi/

[disprod@myerp bi]$ ls

Apache ccr deconfig install jlib nls perl reports sso upgrade

assistants cfgtoollogs diagnostics inventory jpi OPatch plsql root.sh syndication ut

backup_restore chgip discoverer j2ee jre opmn portal root.sh.old sysman wcs

BC4J clone dsa javacache jsp oracore precomp slax tk webcache

bi config error.txt javavm ldap oraInst.loc procbuilder soap tools webservices

bibeans datadirect guicommon jdbc lib ord rdbms sqlj uat wireless

bin dbs has jdk mesg oui README.htm sqlplus uddi xdk

browser dcm iaspt jinit network owm relnotes srvm uix

[disprod@myerp bi]$ cd inventory/

[disprod@myerp inventory]$ ls

Actions21 Components21 Dialogs21 invDetails.properties Patches21 prereqs Scripts

Clone ContentsXML filemap oneoffs PatchSets21 Queries21 Templates

[disprod@myerp inventory]$ cd ContentsXML/

[disprod@myerp ContentsXML]$ ls

comps.xml configtools.xml config.xml libs.xml oraclehomeproperties.xml

[disprod@myerp ContentsXML]$ pwd

/ora1206/bi/inventory/ContentsXML

[disprod@myerp ContentsXML]$ cd ../..

[disprod@myerp bi]$ cp -ap inventory/ inventory_bak

[disprod@myerp bi]$ ls -al inventory_bak/

[disprod@myerp bi]$ cd

[disprod@myerp ~]$ unzip p5861907_10122_LINUX.zip

[disprod@myerp ~]$ ls

6472361 oraclehomeproperties.xml p4960210_10122_LINUX.zip p6880880_101000_LINUX.zip README.txt

disk1 oraInventory p5861907_10122_LINUX.zip p6880880_102000_LINUX.zip

disk2 p2617419_10102_GENERIC.zip p6472361_10122_LINUX.zip readme.html

[disprod@myerp ~]$ cp oraclehomeproperties.xml /ora1206/bi/inventory/ContentsXML/

[disprod@myerp ~]$ opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.60

Copyright (c) 2008 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /ora1206/bi

Oracle Home Inventory : /ora1206/bi/inventory

Central Inventory : /home/disprod/oraInventory

from : /etc/oraInst.loc

OUI location : /ora1206/bi/oui

OUI shared library : /ora1206/bi/oui/lib/linux/liboraInstaller.so

Java location : /ora1206/bi/jre/1.4.2/bin/java

Log file location : /ora1206/bi/.patch_storage//*.log

Creating log file "/ora1206/bi/.patch_storage/LsInventory__10-07-2009_18-58-39.log"

Result:

Installed Patch List:

=====================

1) Patch 6472361 applied on Wed Oct 07 18:29:42 CST 2009

[ Base Bug(s): 5592580 5922891 6215863 5601311 5887565 5117216 4021063 5450764 6280716 6281519 5733442 5874608 6524850 5156055 6142101 3891259 5045120 6408161 5675183 5844020 6211732 5026541 5513118 5733380 6033718 5414271 5695725 6200167 5505532 5941634 5845334 5372331 5882138 5938059 5513051 5644523 6087336 5946580 5672507 4942563 5399782 5759749 6215389 5948836 5950469 6131998 5622397 6059509 6210014 6047200 5926918 5955554 6411910 6488750 5531425 6416859 5571494 5633035 5517786 5451810 5205897 6601738 5462238 5414006 6417086 6163906 5951782 5185518 5394787 5615830 6409713 5639863 5704846 6028993 5186826 5591608 5746156 4901641 6110024 6024356 5475786 5902903 5451758 6626145 5765688 6439239 5230981 5686940 5769537 5969985 5547386 6009122 6455857 6161749 6110031 6523741 6062038 4969310 6047668 6151989 4901223 5527718 5668736 5719064 5017919 5703057 6319785 6151052 5482224 4377151 6394762 5404340 5182568 5842046 6192712 5360227 5210171 5932508 5975552 4297543 5700591 5736563 5154809 6406196 5462419 5931061 5697966 5738745 5559923 5664108 6275246 6401901 6338458 6048127 5458617 5100123 5757331 5646832 6243564 5514492 6450367 5465401 6144867 5650574 6192806 6472361 5460689 5511802 5736074 5901130 6521161 6046898 6471566 6405620 5888236 6033938 6158845 6392752 6193039 4895141 6621751 5688150 5964077 5208063 6037141 6280013 5608740 5647142 5704032 5175015 6009097 5511743 5674250 6008002 5549319 5606063 5979500 6061924 6262095 5338161 5509976 5123374 5131394 5505404 5523984 5116591 6006847 5899757 6621404 5046741 5079665 5160684 6408043 5936322 6067310 5673463 5818607 5594149 5045873 6480045 5400823 5466302 5744401 4741477 5965613 6274627 5899762 6138043 5704057 6163989 5718465 5857955 6004179 6488047 5589983 5924970 4135528 5961773 5981660 5731674 6142363 5859997 4074428 5051945 5182332 4901433 5668944 6648794 5413004 5662488 6231017 6351275 5576526 5988357 5702104 5548112 6124085 6450125 5183143 4622470 6142011 5579945 6505247 5443532 5956310 5340118 6488133 5984587 5490603 5596428 5475150 6196131 5702043 5168275 5621127 5528097 5981827 5900969 6072532 6024597 4628944 5534228 ]

OPatch succeeded.

参考 README for 5861907

[disprod@myerp ~]$ opmnctl startall

opmnctl: starting opmn and all managed processes...

[disprod@myerp ~]$ emctl status iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Oracle Enterprise Manager 10g Application Server Control is running.

------------------------------------------------------------------

Logs are generated in directory /ora1206/bi/sysman/log

[disprod@myerp ~]$ opmnctl status

Processes in Instance: discoverer.myerp.testdomain.com

-------------------+--------------------+---------+---------

ias-component | process-type | pid | status

-------------------+--------------------+---------+---------

LogLoader | logloaderd | N/A | Down

dcm-daemon | dcm-daemon | 16054 | Alive

WebCache | WebCache | 15337 | Alive

WebCache | WebCacheAdmin | 15320 | Alive

OC4J | home | 15321 | Alive

OC4J | OC4J_BI_Forms | 15322 | Alive

HTTP_Server | HTTP_Server | 15323 | Alive

Discoverer | ServicesStatus | 15324 | Alive

Discoverer | PreferenceServer | 15325 | Alive

DSA | DSA | N/A | Down

[disprod@myerp ~]$

4. 配置Discoverer

4.1. 拷贝PROD.DBC

ERP系统的$FND_SECURE目录(应用用户)下拷贝PROD.DBC文件到$ORACLE_HOME/discoverer/securediscoverer用户,如果没有这个目录,请手动创建)

[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 -->

Discoverer was stopped by your Administrator.

<!-- Server connection configuration. Determines how the Discoverer

middle-tier connects to a Discoverer server session.

The session is normally defined by system property

oracle.discoverer.server.session=

but can be overridden here by an attribute

session="SESSION_NAME"

To provide middle tier trace information modify logLevel (see schema for allowed values).

To provide finer grained control of middle tier trace information, add attribute:

logKeys = "classpath discoiv.cookies server_event execute discoiv.state_machine discoiv.request discoiv.servlet_exceptio

ns exceptions"

To provide a dump of the xml communication between server and middle tier add attribute:

modelXMLFile="c:\temp\dump.xml"

-->

<!--The default command used is ORACLE_HOME\bin\dis51ws. A different command line can be provided if requried.-->

<!--command>y:\dc\bin\opt\dis51ws

<!-- Discoverer Servlet configuration. Defines behaviour of both

discoverer/plus and discoverer/viewer servlets -->

dConnections="true" logLevel="error" laf="dc_blaf" switchWorksheetBehavior="prompt" defaultLocale="en" disableBrowserCaching="false"

>

Viewer was stopped by your Administrator.

disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>

hive="disco5i.jar" d4o_archive="d4o_double.jar"/>

Plus was stopped by your Administrator.

<!-- Portlet Provider configuration. -->

tMinute="1" maxRefreshRetries="1" maxGenericParameters="10" maxNewSessionPerMinute="6" maxWaitNewSessionMinute="30" minRequestThread

PoolSize="20" peekSleepIntervalSec="2"/>

修改以上几处地方,我安装JDK版本是jdk-1.5.0_21-fcs 因此这里修改的时候我根据JDK的版本修改相应的值;

重启Discoverer

[disprod@myerp config]$ opmnctl stopall

opmnctl: stopping opmn and all managed processes...

[disprod@myerp config]$ emctl stop iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Application Server Control ... ... Stopped.

[disprod@myerp config]$ opmnctl startall

opmnctl: starting opmn and all managed processes...

[disprod@myerp config]$ emctl start iasconsole

TZ set to PRC

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

http://myerp.testdomain.com:1156/emd/console/aboutApplication

Starting Oracle Enterprise Manager 10g Application Server Control ..... started successfully.

[disprod@myerp config]$ opmnctl status

Processes in Instance: discoverer.myerp.testdomain.com

-------------------+--------------------+---------+---------

ias-component | process-type | pid | status

-------------------+--------------------+---------+---------

LogLoader | logloaderd | N/A | Down

dcm-daemon | dcm-daemon | 24463 | Alive

WebCache | WebCache | 23749 | Alive

WebCache | WebCacheAdmin | 23737 | Alive

OC4J | home | 23740 | Alive

OC4J | OC4J_BI_Forms | 23745 | Alive

HTTP_Server | HTTP_Server | 23746 | Alive

Discoverer | ServicesStatus | 23747 | Alive

Discoverer | PreferenceServer | 23748 | Alive

DSA | DSA | N/A | Down

5. 配置Discoverer到EBS

5.1. 利用OAM(Oracle Application Manager)Autoconfig 配置Discoverer

http://myerp.testdomain.com:8065 ——〉系统管理员——〉Oracle Applications 管理器 ——〉Oracle Workflow ——〉Site Map > AutoConfig > Edit Parameters

Title

Variable Name

Description

Value

Discoverer URL

s_disco_url

Set the value of this variable to the base URL where Discoverer is available.

:// :
for example: http://mybi.company.com:7778

具体操作如下图所示:

clip_image064[4]

clip_image066[4]

clip_image068[4]

clip_image070[4]

clip_image072[4]

修改节点的连接地址为当前Discoverer 的http://myerp.testdomain.com:7778,然后保存“save”

clip_image074[4]

选择OK确认配置

clip_image076[4]

选择Ok完成配置

clip_image078[4]

返回到参数编辑窗口,浏览摄制完成的参数:

clip_image080[4]

5.2. 运行autoconfig

运行% /adautocfg.sh (应用用户下的autoconfig)

[root@myerp ~]# su -l applseed

[applseed@myerp ~]$ cd $ADMIN_SCRIPTS_HOME

[applseed@myerp scripts]$ pwd

/ora1206/inst/apps/came_myerp/admin/scripts

[applseed@myerp scripts]$ ls

adalnctl.sh adcmctl.sh adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh mwactlwrpr.sh

adapcctl.sh adexecsql.pl adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh

adautocfg.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo mwactl.sh

[applseed@myerp scripts]$ adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /ora1206/inst/apps/came_myerp/admin/log/10081114/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /ora1206/inst/apps/came_myerp

Classpath : /ora1206/apps/apps_st/comn/java/lib/appsborg2.zip:/ora1206/apps/apps_st/comn/java/classes

Using Context file : /ora1206/inst/apps/came_myerp/appl/admin/came_myerp.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...

Configuring AD_TOP........COMPLETED

Configuring FND_TOP.......COMPLETED

Configuring ICX_TOP.......COMPLETED

Configuring IEO_TOP.......COMPLETED

Configuring BIS_TOP.......COMPLETED

Configuring AMS_TOP.......COMPLETED

Configuring CCT_TOP.......COMPLETED

Configuring WSH_TOP.......COMPLETED

Configuring CLN_TOP.......COMPLETED

Configuring OKE_TOP.......COMPLETED

Configuring OKL_TOP.......COMPLETED

Configuring OKS_TOP.......COMPLETED

Configuring CSF_TOP.......COMPLETED

Configuring IGS_TOP.......COMPLETED

Configuring IBY_TOP.......COMPLETED

Configuring JTF_TOP.......COMPLETED

Configuring MWA_TOP.......COMPLETED

Configuring CN_TOP........COMPLETED

Configuring CSI_TOP.......COMPLETED

Configuring WIP_TOP.......COMPLETED

Configuring CSE_TOP.......COMPLETED

Configuring EAM_TOP.......COMPLETED

Configuring FTE_TOP.......COMPLETED

Configuring ONT_TOP.......COMPLETED

Configuring AR_TOP........COMPLETED

Configuring AHL_TOP.......COMPLETED

Configuring OZF_TOP.......COMPLETED

Configuring IES_TOP.......COMPLETED

Configuring CSD_TOP.......COMPLETED

Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

5.3. 设置EBS Profile(配置文件)

系统管理员 ——〉配置文件(Profile) > 系统(System)——〉弹出 form窗口——〉设置profile

——〉输入查询条件 (搜索%Discoverer%)——〉

可以按照下表进行设置(具体情况依据生产系统配置设置)

Profile

Description

Value

ICX: Discoverer Launcher

URL that points to Discoverer Plus Servlet.

http://:
/discoverer/plus
?Connect=[APPS_SECURE]

ICX: Discoverer Viewer Launcher

URL that points to Discoverer Viewer Servlet

http://:
/discoverer/viewer
?Connect=[APPS_SECURE]

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.
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.

American English

ICX: Discoverer Parameters

This profile can be used to optionally pass additional URL parameters to Discoverer. Compare Note 186120.1 on Oracle MetaLink.

Discoverer DBC filename override

This profile can be used to specify the DBC Filename Discoverer should be using to connect to the E-Business Suite database.

By default, this profile should remain NULL, in which case Discoverer will use the default dbc file for your E-Business Suite database.

clip_image082[4]

clip_image084[4]

下图和表即是我的设置:

clip_image086[4]

clip_image088[4]

配置文件选项名

地点

应用产品

责任

服务器

服务器+责任

组织

用户

Discoverer DBC 文件名改写

             

FII:GL BIS Discoverer 访问

             

ICX:Discoverer EBS 最终用户层模式前缀

             

ICX:Discoverer EDW 最终用户层模式前缀

             

ICX:Discoverer OLTP 最终用户层模式前缀

             

ICX:Discoverer 参数

             

ICX:Discoverer 启动程序

http://myerp.testdomain.com:7778/discoverer/plus?Connect=[APPS_SECURE]

           

ICX:Discoverer 最终用户的层语言改写

简体中文

           

ICX:Discoverer 浏览器的启动程序

http://myerp.testdomain.com:7778/discoverer/viewer?Connect=[APPS_SECURE]

           

ICX:Discoverer 版本

10

           

ICX:Discoverer 默认最终用户层模式前缀

EUL

           

ICX:使用 Discoverer 浏览器

           

OAM:Discoverer Ping 频率

             

OKC:启用 Discoverer 报表

           

5.4. 命令方式给EUL授权

1)输入下面的命令进行授权:

[disprod@myerp ~]$ eulapi \

> -CONNECT eul_zhs/eul_zhs@came \

> -GRANT_PRIVILEGE \

> -USER SYSADMIN \

> -PRIVILEGE administration \

> -PRIVILEGE all_admin_privs\

> -LOG eul2.log

下面是我的执行过程(命令相同,只是没有按照上面的格式)

[root@myerp ~]# su -l disprod

[disprod@myerp ~]$ eulapi -CONNECT eul_zhs/eul_zhs@came -GRANT_PRIVILEGE -USER SYSADMIN -PRIVILEGE administration -PRIVILEGE all_admin_privs -LOG eul2.log

-connect <**********>

-log eul2.log

-grant_privilege

-privilege administration

-user SYSADMIN

-privilege all_admin_privs

Command completed.

[disprod@myerp ~]$

2) 执行下面命令授权

[disprod@myerp ~]$ eulapi \

> -CONNECT eul_zhs/eul_zhs@came \

> -GRANT_PRIVILEGE \

> -USER SYSADMIN \

> -BUSINESS_AREA_ADMIN_ACCESS % \

> -WILDCARD \

> -LOG eul_privilege.log

[disprod@erp ~]$ eulapi -CONNECT eul_zhs/eul_zhs@came -GRANT_PRIVILEGE -USER SYSADMIN -BUSINESS_AREA_ADMIN_ACCESS % -WILDCARD -LOG eul_privilege.log

-connect <**********>

-log eul_privilege.log

-grant_privilege

-business_area_admin_access %

-user SYSADMIN

-wildcard

Command completed.

[disprod@myerp ~]$

5.5. 刷新EUL层

1)查看applseed用户下面的$AU_TOP/discoverer目录

[applseed@myerp ~]$ cd $AU_TOP

[applseed@myerp 12.0.0]$ pwd

/ora1206/apps/apps_st/appl/au/12.0.0

[applseed@myerp 12.0.0]$ ls

admin discover graphs lib mesg patch plsql sql

bin forms java log out perl resource

[applseed@myerp 12.0.0]$ cd discover/

[applseed@myerp discover]$ ls

adrfseul.sh u4440000.drv u6394500.drv u6728000.drv US

adupdeul.sh u6141000.drv u6719036.drv u6836355.drv ZHS

[applseed@myerp discover]$

2)查看cd /ora1206/bi/discoverer 目录

[disprod@myerp discoverer]$ cd /ora1206/bi/discoverer

[disprod@myerp discoverer]$ ls

config discwb.sh error.txt logs plus_files util

deploy doc lib mesg secure

3)拷贝$AU_TOP/discoverer 为$ORACLE_HOME/discoverer/exx

[root@myerp ~]# cp -ap /ora1206/apps/apps_st/appl/au/12.0.0/discover /ora1206/bi/discoverer/exx

[root@myerp ~]# cd /ora1206/bi/discoverer/

[root@myerp discoverer]# chown -R disprod:dba exx/

[root@myerp discoverer]# chmod -R 777 exx/

[root@myerp discoverer]# ll

total 44

drwxr-xrwx 2 disprod dba 4096 Oct 8 09:03 config

drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 deploy

-rwxr-xrwx 1 disprod dba 825 Oct 7 12:06 discwb.sh

drwxr-xrwx 31 disprod dba 4096 Oct 7 11:58 doc

-rw-r----- 1 disprod dba 0 Oct 8 09:12 error.txt

drwxrwxrwx 4 disprod dba 4096 Feb 7 2009 exx

drwxr-xrwx 2 disprod dba 4096 Oct 7 18:29 lib

drwxr-xrwx 2 disprod dba 4096 Oct 7 12:05 logs

drwxr-xrwx 2 disprod dba 4096 Oct 7 11:59 mesg

drwxr-xrwx 5 disprod dba 4096 Oct 7 12:04 plus_files

drwxr-x--- 2 disprod dba 4096 Oct 7 19:24 secure

drwxr-xrwx 2 disprod dba 4096 Oct 7 14:07 util

[root@myerp discoverer]# du -sh exx/

503M exx/

4)开始刷新EUL层

[root@myerp discoverer]# su -l disprod

[disprod@myerp ~]$ cd $ORACLE_HOME/discoverer/exx/

[disprod@myerp exx]$ pwd

/ora1206/bi/discoverer/exx

[disprod@myerp exx]$ ls

adrfseul.sh adupdeul.sh u4440000.drv u6141000.drv u6394500.drv u6719036.drv u6728000.drv u6836355.drv US ZHS

[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log

[disprod@myerp exx]$ sh adrfseul.sh \

> connect=sysadmin/meimima@came \

> resp="System Administrator" \

> gwyuid=APPLSYSPUB/PUB \

> fndnam=APPS \

> secgroup="Standard" \

> eulschema=eul_zhs \

> eulpassword=eul_zhs \

> twotask=came \

> iashome=/ora1206/bi \

> logfile=refresh_eul_us_mydb.log

/ora1206/bi/discoverer/exx/objfilelst8932.lst

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

You are running adrfseul, version 120.6.12000000.4

Start of adrfseul session

Date/time is Thu Oct 8 12:55:08 CST 2009

Log file is refresh_eul_us_mydb.log

Command line arguments are

"connect=sysadmin/meimima@came"

"resp=System Administrator"

"gwyuid=APPLSYSPUB/PUB"

"fndnam=APPS"

"secgroup=Standard"

"eulschema=eul_zhs"

"eulpassword=eul_zhs"

"twotask=came"

"iashome=/ora1206/bi"

"logfile=refresh_eul_us_mydb.log"

Testing connection to database using sqlplus -s ...

Connection to database using sqlplus -s is OK ...

Extracting eul folder information ...

CUSTOMFOLDER

CUSTOMFOLDER1

CUSTOMFOLDER2

CUSTOMFOLDER3

CUSTOMFOLDER4

CUSTOMFOLDER5

CUSTOMFOLDER6

CUSTOMFOLDER7

ELEMENT

ELEMENT1

ELEMENT2

ELEMENT3

MDS1

RICH

RICH_

RICH_1

RICH_10

RICH_11

RICH_12

RICH_13

RICH_14

RICH_15

RICH_16

RICH_2

RICH_3

RICH_4

RICH_5

RICH_6

RICH_61

RICH_7

RICH_8

RICH_9

Done obtaining folder information

Calling discoverer refresh utility ...

32 folders to process:

Do you want to start refreshing the folders (Y|N)?

Type or 'Y' to continue, or 'N' to exit (with failure).

Y

(You entered "Y")

1 of 32 : Refreshing folder: CUSTOMFOLDER ...

-connect <**********>

-refresh_folder CUSTOMFOLDER

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

2 of 32 : Refreshing folder: CUSTOMFOLDER1 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER1

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

3 of 32 : Refreshing folder: CUSTOMFOLDER2 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER2

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

4 of 32 : Refreshing folder: CUSTOMFOLDER3 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER3

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

5 of 32 : Refreshing folder: CUSTOMFOLDER4 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER4

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

6 of 32 : Refreshing folder: CUSTOMFOLDER5 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER5

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

7 of 32 : Refreshing folder: CUSTOMFOLDER6 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER6

-log /ora1206/bi/discoverer/exx/logfile8932.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

DC Logger(9203): Logging Signal Caught

DC Logger(9204): Logging Signal Caught

DC Logger(9206): Logging Signal Caught

DC Logger(9207): Logging Signal Caught

DC Logger(9208): Logging Signal Caught

DC Logger(9212): Logging Signal Caught

DC Logger(9175): Logging Signal Caught

DC Logger(9176): Logging Signal Caught

DC Logger(9179): Logging Signal Caught

DC Logger(9183): Logging Signal Caught

DC Logger(9201): Logging Signal Caught

DC Logger(9205): Logging Signal Caught

An unexpected exception has been detected in native code outside the VM.

Unexpected Signal : 11 occurred at PC=0xAAFB5F34 during VM shutdown

Function=uninitialized_copy__H3ZPPcZPPcZt9allocator1ZPc_X01X01X11X21_X11+0x24

Library=/ora1206/bi/discoverer/lib/libdcecm51.so

Current Java thread:

at java.lang.Object.wait(Native Method)

- waiting on <0xab9201a0> (a java.lang.ref.Reference$Lock)

at java.lang.Object.wait(Object.java:429)

at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)

- locked <0xab9201a0> (a java.lang.ref.Reference$Lock)

这里抛出一个错误,无法继续刷新了

Dynamic libraries:

0043e000-00454000 r-xp 00000000 08:01 1895519 /lib/ld-2.3.4.so

00454000-00455000 r-xp 00015000 08:01 1895519 /lib/ld-2.3.4.so

00455000-00456000 rwxp 00016000 08:01 1895519 /lib/ld-2.3.4.so

005b0000-005b2000 r-xp 00000000 08:01 1896367 /lib/libdl-2.3.4.so

005b2000-005b3000 r-xp 00001000 08:01 1896367 /lib/libdl-2.3.4.so

005b3000-005b4000 rwxp 00002000 08:01 1896367 /lib/libdl-2.3.4.so

007eb000-007f4000 r-xp 00000000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1

007f4000-007f5000 rwxp 00009000 08:01 1896369 /lib/libgcc_s-3.4.6-20060404.so.1

00d5b000-00d6e000 r-xp 00000000 08:01 1896376 /lib/libnsl-2.3.4.so

00d6e000-00d6f000 r-xp 00012000 08:01 1896376 /lib/libnsl-2.3.4.so

00d6f000-00d70000 rwxp 00013000 08:01 1896376 /lib/libnsl-2.3.4.so

08048000-08056000 r-xp 00000000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java

08056000-08059000 rwxp 0000d000 08:03 33193986 /ora1206/bi/jdk/jre/bin/java

a81c7000-a81cd000 r-xs 00000000 08:01 1159554 /usr/lib/gconv/gconv-modules.cache

a81cd000-a8205000 r-xp 00000000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so

a8205000-a8210000 rwxp 00037000 08:01 1557452 /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so

a8212000-a8d4a000 r-xp 00000000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1

a8d4a000-a8db7000 rwxp 00b37000 08:03 18321903 /ora1206/bi/lib/libclntsh.so.10.1

a8dcd000-a8f46000 r-xp 00000000 08:03 33374267 /ora1206/bi/lib/libnnz10.so

a8f46000-a8f60000 rwxp 00178000 08:03 33374267 /ora1206/bi/lib/libnnz10.so

a8f61000-a954f000 r-xp 00000000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so

a954f000-a966a000 rwxp 005ed000 08:03 25231378 /ora1206/bi/discoverer/lib/libdceeul51.so

a96bd000-a971d000 r-xp 00000000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so

a971d000-a972c000 rwxp 0005f000 08:03 18319604 /ora1206/bi/discoverer/lib/libdcf51.so

a972d000-aa702000 r-xp 00000000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so

aa702000-aaa35000 rwxp 00fd4000 08:03 25231379 /ora1206/bi/discoverer/lib/libdce51.so

aaa3c000-aac81000 r-xp 00000000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so

aac81000-aacc3000 rwxp 00244000 08:03 25231377 /ora1206/bi/discoverer/lib/libdcell51.so

aacd5000-aadd2000 r-xp 00000000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so

aadd2000-aae09000 rwxp 000fc000 08:03 18319608 /ora1206/bi/discoverer/lib/libdcwio51.so

aae2e000-aafce000 r-xp 00000000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so

aafce000-ab016000 rwxp 0019f000 08:03 18319587 /ora1206/bi/discoverer/lib/libdcecm51.so

ab017000-ab0cf000 r-xp 00000000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so

ab0cf000-ab0f7000 rwxp 000b7000 08:03 25231362 /ora1206/bi/discoverer/lib/libdcjni51.so

ab0f7000-ab0fd000 r-xs 00000000 08:03 18321245 /ora1206/bi/jdk/jre/lib/ext/ojmisc.jar

ab0fd000-ab0fe000 r-xs 00000000 08:03 33308681 /ora1206/bi/jdk/jre/lib/ext/sslqueries.jar

ab0fe000-ab10c000 r-xs 00000000 08:03 33308680 /ora1206/bi/jdk/jre/lib/ext/activation.jar

ab10c000-ab10f000 r-xs 00000000 08:03 33308679 /ora1206/bi/jdk/jre/lib/ext/smtp.jar

ab10f000-ab135000 r-xs 00000000 08:03 33308678 /ora1206/bi/jdk/jre/lib/ext/mailapi.jar

ab135000-ab17a000 r-xs 00000000 08:03 33308677 /ora1206/bi/jdk/jre/lib/ext/mail.jar

ab17a000-ab17d000 r-xs 00000000 08:03 33308676 /ora1206/bi/jdk/jre/lib/ext/jta.jar

ab17d000-ab239000 r-xs 00000000 08:03 30168147 /ora1206/bi/jdk/jre/lib/ext/localedata.jar

ab239000-ab246000 r-xs 00000000 08:03 30168146 /ora1206/bi/jdk/jre/lib/ext/ldapsec.jar

ab246000-ab249000 r-xs 00000000 08:03 30168145 /ora1206/bi/jdk/jre/lib/ext/dnsns.jar

ab249000-ab265000 r-xs 00000000 08:03 30168144 /ora1206/bi/jdk/jre/lib/ext/sunjce_provider.jar

ab265000-ab289000 r-xs 00000000 08:03 18321937 /ora1206/bi/bin/eulbuilder.jar

ab48d000-ab68d000 r-xp 00000000 08:01 1130496 /usr/lib/locale/locale-archive

b5940000-b5e99000 r-xs 00000000 08:03 33243206 /ora1206/bi/jdk/jre/lib/charsets.jar

b5e99000-b5eaa000 r-xs 00000000 08:03 33243160 /ora1206/bi/jdk/jre/lib/jce.jar

b5eaa000-b5f87000 r-xs 00000000 08:03 33243205 /ora1206/bi/jdk/jre/lib/jsse.jar

b5f87000-b5f9d000 r-xs 00000000 08:03 33243159 /ora1206/bi/jdk/jre/lib/sunrsasign.jar

b5fe7000-b798e000 r-xs 00000000 08:03 33243204 /ora1206/bi/jdk/jre/lib/rt.jar

b798e000-b79a2000 r-xp 00000000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so

b79a2000-b79a5000 rwxp 00013000 08:03 33341447 /ora1206/bi/jdk/jre/lib/i386/libzip.so

b79a5000-b79c5000 r-xp 00000000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so

b79c5000-b79c7000 rwxp 0001f000 08:03 33341445 /ora1206/bi/jdk/jre/lib/i386/libjava.so

b79c7000-b79d0000 r-xp 00000000 08:01 1893170 /lib/libnss_files-2.3.4.so

b79d0000-b79d1000 r-xp 00008000 08:01 1893170 /lib/libnss_files-2.3.4.so

b79d1000-b79d2000 rwxp 00009000 08:01 1893170 /lib/libnss_files-2.3.4.so

b79dd000-b79ed000 r-xp 00000000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so

b79ed000-b79ef000 rwxp 0000f000 08:03 33341444 /ora1206/bi/jdk/jre/lib/i386/libverify.so

b79ef000-b79f3000 rwxs 00000000 08:01 2274675 /tmp/hsperfdata_disprod/9172 (deleted)

b79f3000-b7a14000 r-xp 00000000 08:01 1893129 /lib/i686/libm-2.3.4.so

b7a14000-b7a15000 r-xp 00020000 08:01 1893129 /lib/i686/libm-2.3.4.so

b7a15000-b7a16000 rwxp 00021000 08:01 1893129 /lib/i686/libm-2.3.4.so

b7a2e000-b7a36000 r-xp 00000000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so

b7a36000-b7a37000 rwxp 00007000 08:03 33374309 /ora1206/bi/jdk/jre/lib/i386/native_threads/libhpi.so

b7a37000-b7e33000 r-xp 00000000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so

b7e33000-b7e4f000 rwxp 003fb000 08:03 33357838 /ora1206/bi/jdk/jre/lib/i386/client/libjvm.so

b7e61000-b7f86000 r-xp 00000000 08:01 1893127 /lib/i686/libc-2.3.4.so

b7f86000-b7f88000 r-xp 00125000 08:01 1893127 /lib/i686/libc-2.3.4.so

b7f88000-b7f8a000 rwxp 00127000 08:01 1893127 /lib/i686/libc-2.3.4.so

b7f8c000-b7f9a000 r-xp 00000000 08:01 1893131 /lib/i686/libpthread-0.10.so

b7f9a000-b7f9b000 r-xp 0000d000 08:01 1893131 /lib/i686/libpthread-0.10.so

b7f9b000-b7f9c000 rwxp 0000e000 08:01 1893131 /lib/i686/libpthread-0.10.so

Heap at VM Abort:

Heap

def new generation total 576K, used 515K [0xab890000, 0xab930000, 0xabd70000)

eden space 512K, 88% used [0xab890000, 0xab900d78, 0xab910000)

from space 64K, 99% used [0xab920000, 0xab92fff8, 0xab930000)

to space 64K, 0% used [0xab910000, 0xab910000, 0xab920000)

tenured generation total 1408K, used 57K [0xabd70000, 0xabed0000, 0xaf890000)

the space 1408K, 4% used [0xabd70000, 0xabd7e7a0, 0xabd7e800, 0xabed0000)

compacting perm gen total 4096K, used 1681K [0xaf890000, 0xafc90000, 0xb3890000)

the space 4096K, 41% used [0xaf890000, 0xafa344c8, 0xafa34600, 0xafc90000)

Local Time = Thu Oct 8 12:55:55 2009

Elapsed Time = 4

#

# The exception above was detected in native code outside the VM

#

# Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode)

#

# An error report file has been saved as hs_err_pid9172.log.

# Please refer to the file for further information.

#

[1]+ Stopped sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log

我强行中止命令,然后再次运行命令开始刷新

[disprod@myerp exx]$ sh adrfseul.sh connect=sysadmin/meimima@came resp="System Administrator" gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup="Standard" eulschema=eul_zhs eulpassword=eul_zhs twotask=came iashome=/ora1206/bi logfile=refresh_eul_us_mydb.log

/ora1206/bi/discoverer/exx/objfilelst9831.lst

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

You are running adrfseul, version 120.6.12000000.4

Start of adrfseul session

Date/time is Thu Oct 8 13:10:38 CST 2009

Log file is refresh_eul_us_mydb.log

Command line arguments are

"connect=sysadmin/meimima@came"

"resp=System Administrator"

"gwyuid=APPLSYSPUB/PUB"

"fndnam=APPS"

"secgroup=Standard"

"eulschema=eul_zhs"

"eulpassword=eul_zhs"

"twotask=came"

"iashome=/ora1206/bi"

"logfile=refresh_eul_us_mydb.log"

Testing connection to database using sqlplus -s ...

Connection to database using sqlplus -s is OK ...

Extracting eul folder information ...

CUSTOMFOLDER6

CUSTOMFOLDER7

ELEMENT

ELEMENT1

ELEMENT2

ELEMENT3

MDS1

RICH

RICH_

RICH_1

RICH_10

RICH_11

RICH_12

RICH_13

RICH_14

RICH_15

RICH_16

RICH_2

RICH_3

RICH_4

RICH_5

RICH_6

RICH_61

RICH_7

RICH_8

RICH_9

Done obtaining folder information

Calling discoverer refresh utility ...

26 folders to process:

Do you want to start refreshing the folders (Y|N)?

Type or 'Y' to continue, or 'N' to exit (with failure).

Y

(You entered "Y")

1 of 26 : Refreshing folder: CUSTOMFOLDER6 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER6

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

2 of 26 : Refreshing folder: CUSTOMFOLDER7 ...

-connect <**********>

-refresh_folder CUSTOMFOLDER7

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

3 of 26 : Refreshing folder: ELEMENT ...

-connect <**********>

-refresh_folder ELEMENT

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

4 of 26 : Refreshing folder: ELEMENT1 ...

-connect <**********>

-refresh_folder ELEMENT1

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

5 of 26 : Refreshing folder: ELEMENT2 ...

-connect <**********>

-refresh_folder ELEMENT2

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

6 of 26 : Refreshing folder: ELEMENT3 ...

-connect <**********>

-refresh_folder ELEMENT3

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

7 of 26 : Refreshing folder: MDS1 ...

-connect <**********>

-refresh_folder MDS1

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

8 of 26 : Refreshing folder: RICH ...

-connect <**********>

-refresh_folder RICH

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

9 of 26 : Refreshing folder: RICH_ ...

-connect <**********>

-refresh_folder RICH_

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

10 of 26 : Refreshing folder: RICH_1 ...

-connect <**********>

-refresh_folder RICH_1

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

11 of 26 : Refreshing folder: RICH_10 ...

-connect <**********>

-refresh_folder RICH_10

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

12 of 26 : Refreshing folder: RICH_11 ...

-connect <**********>

-refresh_folder RICH_11

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

13 of 26 : Refreshing folder: RICH_12 ...

-connect <**********>

-refresh_folder RICH_12

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

14 of 26 : Refreshing folder: RICH_13 ...

-connect <**********>

-refresh_folder RICH_13

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

15 of 26 : Refreshing folder: RICH_14 ...

-connect <**********>

-refresh_folder RICH_14

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

16 of 26 : Refreshing folder: RICH_15 ...

-connect <**********>

-refresh_folder RICH_15

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

17 of 26 : Refreshing folder: RICH_16 ...

-connect <**********>

-refresh_folder RICH_16

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

18 of 26 : Refreshing folder: RICH_2 ...

-connect <**********>

-refresh_folder RICH_2

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

19 of 26 : Refreshing folder: RICH_3 ...

-connect <**********>

-refresh_folder RICH_3

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

20 of 26 : Refreshing folder: RICH_4 ...

-connect <**********>

-refresh_folder RICH_4

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

21 of 26 : Refreshing folder: RICH_5 ...

-connect <**********>

-refresh_folder RICH_5

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

22 of 26 : Refreshing folder: RICH_6 ...

-connect <**********>

-refresh_folder RICH_6

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

23 of 26 : Refreshing folder: RICH_61 ...

-connect <**********>

-refresh_folder RICH_61

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

24 of 26 : Refreshing folder: RICH_7 ...

-connect <**********>

-refresh_folder RICH_7

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

25 of 26 : Refreshing folder: RICH_8 ...

-connect <**********>

-refresh_folder RICH_8

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

26 of 26 : Refreshing folder: RICH_9 ...

-connect <**********>

-refresh_folder RICH_9

-log /ora1206/bi/discoverer/exx/logfile9831.log

-apps_user

-eul eul_zhs

-apps_responsibility System Administrator

-apps_gwuid APPLSYSPUB/PUB

-apps_fndnam APPS

-apps_security_group Standard

-identifier

Command completed.

Done calling discoverer refresh utility.

Discoverer refresh exited with status 0.

----------------------------------------------------------------------

Log information from the refresh process ...

java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER6 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:10:49 CST 2009 ...

Name: ??????????, Type: Definition Unavailable, Action: ??????????

Completed Thu Oct 08 13:12:11 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder CUSTOMFOLDER7 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:12 CST 2009 ...

Name: rich_??????, Type: Definition Unavailable, Action: rich_??????

Completed Thu Oct 08 13:12:16 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:16 CST 2009 ...

Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????

Completed Thu Oct 08 13:12:19 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT1 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:20 CST 2009 ...

Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????

Completed Thu Oct 08 13:12:21 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT2 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:22 CST 2009 ...

Name: ???????, Type: Definition Unavailable, Action: ???????

Completed Thu Oct 08 13:12:24 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder ELEMENT3 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:24 CST 2009 ...

Name: ?????, Type: Definition Unavailable, Action: ?????

Completed Thu Oct 08 13:12:26 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder MDS1 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:26 CST 2009 ...

Name: MDS?????, Type: Definition Unavailable, Action: MDS?????

Completed Thu Oct 08 13:12:28 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:28 CST 2009 ...

Name: rich????????????, Type: Definition Unavailable, Action: rich????????????

Completed Thu Oct 08 13:12:30 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_ -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:30 CST 2009 ...

Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????

Completed Thu Oct 08 13:12:32 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_1 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:32 CST 2009 ...

Name: RICH_??????????????, Type: Definition Unavailable, Action: RICH_??????????????

Completed Thu Oct 08 13:12:34 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_10 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:34 CST 2009 ...

Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????

Completed Thu Oct 08 13:12:36 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_11 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:36 CST 2009 ...

Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????

Completed Thu Oct 08 13:12:38 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_12 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:38 CST 2009 ...

Name: RICH_?????????, Type: Definition Unavailable, Action: RICH_?????????

Completed Thu Oct 08 13:12:41 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_13 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:41 CST 2009 ...

Name: RICH_???????, Type: Definition Unavailable, Action: RICH_???????

Completed Thu Oct 08 13:12:42 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_14 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:43 CST 2009 ...

Name: RICH_?????-??, Type: Definition Unavailable, Action: RICH_?????-??

Completed Thu Oct 08 13:12:44 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_15 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:44 CST 2009 ...

Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????

Completed Thu Oct 08 13:12:46 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_16 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:46 CST 2009 ...

Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????

Completed Thu Oct 08 13:12:48 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_2 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:48 CST 2009 ...

Name: RICH_??????????????????, Type: Definition Unavailable, Action: RICH_??????????????????

Completed Thu Oct 08 13:12:50 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_3 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:50 CST 2009 ...

Name: RICH_?????????????, Type: Definition Unavailable, Action: RICH_?????????????

Completed Thu Oct 08 13:12:52 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_4 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:53 CST 2009 ...

Name: RICH_??????????, Type: Definition Unavailable, Action: RICH_??????????

Completed Thu Oct 08 13:12:55 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_5 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:55 CST 2009 ...

Name: RICH_????????, Type: Definition Unavailable, Action: RICH_????????

Completed Thu Oct 08 13:12:57 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_6 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:57 CST 2009 ...

Name: RICH_???????_????, Type: Definition Unavailable, Action: RICH_???????_????

Completed Thu Oct 08 13:12:59 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_61 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:12:59 CST 2009 ...

Name: RICH_???????_??, Type: Definition Unavailable, Action: RICH_???????_??

Completed Thu Oct 08 13:13:01 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_7 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:13:01 CST 2009 ...

Name: RICH_?????, Type: Definition Unavailable, Action: RICH_?????

Completed Thu Oct 08 13:13:03 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_8 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:13:03 CST 2009 ...

Name: RICH_??????, Type: Definition Unavailable, Action: RICH_??????

Completed Thu Oct 08 13:13:06 CST 2009.java EulCommandLine -connect <**********> -EUL eul_zhs -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -identifier -refresh_folder RICH_9 -log /ora1206/bi/discoverer/exx/logfile9831.log

Started Thu Oct 08 13:13:06 CST 2009 ...

Name: RICH_????????????, Type: Definition Unavailable, Action: RICH_????????????

Completed Thu Oct 08 13:13:08 CST 2009.

End of refresh log

----------------------------------------------------------------------

adrfseul is exiting with status 0

End of adrfseul session

Date/time is Thu Oct 8 13:13:08 CST 2009

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

这次正常完成刷新;

5.6. EBS调用Discoverer

5.6.1. 新建菜单Discoverer

以SYSADMIN/SYSADMIN_PASSWD进入ERP系统——系统管理员——应用产品——菜单——新建

新建菜单名:Discoverer

用户菜单名:Discoverer

功能名:Invoke Web Discoverer

提示为:Discoverer

保存

clip_image090[4]

将刚建的菜单 Discoverer测试添加到 菜单 “浏览器菜单 - 系统管理员 GUI”如下图

clip_image092[4]

下图为保存后在系统管理员职责下的Discoverer

clip_image094[4]

5.6.2. 下图为打开后的Discoverer Plus

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://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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
个人博客网 www.leosunny 长期从事数据库相关工作,涉及oracle,mysql, sqlsever,db2 , OGG, SSIS以及非关系数据库和大数据平台等。 希望一直分享一些个人案例和知识,和广大技术宅们共同进步。

注册时间:2009-06-06

  • 博文量
    467
  • 访问量
    3147915