【收集】RPE01012：不能将PLSQL映射部署到此目标方案。

最新推荐文章于 2020-03-27 16:28:50 发布

haiross

最新推荐文章于 2020-03-27 16:28:50 发布

阅读量2.1k

点赞数

分类专栏：数据仓库和数据挖掘 oracle故障排除 oracle疑问集

本文链接：https://blog.csdn.net/haiross/article/details/22302683

版权

oracle故障排除同时被 3 个专栏收录

116 篇文章 1 订阅

订阅专栏

oracle疑问集

81 篇文章 1 订阅

订阅专栏

数据仓库和数据挖掘

28 篇文章 0 订阅

订阅专栏

本人遇到问题RPE01012的背景：

源数据库模块（的位置，即源方案）在主机A上，owb资料库和目标数据库模块（的位置，即目标方案）在主机B上，但是在不同数据库上。

这样，在部署整个项目（还是部署某个映射，忘了）时，发生错误ORA-04052: error occurred when lookingup remote object(如，ORA-04052: error occurred when lookingup remote object test_OWNER.ALL_TAB_COLUMNS@db_test_LINK)。该问题未解决。

于是，将源数据库模块（的位置，即源方案）改为放在主机B上与owb资料库同个数据库上的另一个与owb资料库所在用户不同的用户。

这样，在部署整个项目（还是部署某个映射，忘了）时，发生错误RPE01012。

注释：

在上面实验环境下，部署映射时遇到上述问题的，而部署表时则成功没有遇到问题。

解决方法：

将源数据库模块、owb资料库和目标数据库模块都设置在一个主机上的同一个数据库上。

之后，使用OWB安全UI使目标方案称为OWB用户，具体如下操作：

以owb资料库里的一个工作区所有者用户登录到设计中心，选择全局选项卡，选择安全节点，选择用户，右键选择新建，跳出的窗口上选择目标方案即可使之成为OWB用户。

或者，用repository assistant ，选择创建一个新的repository 用户，然后选择该新的repository 用户要作为target schema（目标方案），点击完成。

疑问：

1、目标数据库模块只能和owb资料库在同一个数据库下吗？貌似oracle官文里的owb运行架构模式图里目标数据库模块和owb资料库、源数据库模块都是在同一个数据库下。

2、部署映射时会遇到RPE01012，而部署表时则成功没有遇到问题？

参看：owb的组成部件以及运行架构模式

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

不同版本的owb组件里的RPE01012

Bruce Alexander 2004-8-10 下午1:51

RPE-01012:Cannot deploy to the target location because it is owned by a different runtimeplatform.

owb version is 10.1.0.4.0.

RPE-01012:Cannot deploy PL/SQL maps to the target schema because it is not owned by theControl Center.

发表于 2007-7-17 17:09:37 |只看该作者 |倒序浏览

10g的 owb 发布的时候报这个错误

RPE-01012: 无法将 PL/SQL 映射部署到目标方案, 因为它不是由该控制中心所有。

估计：owb version is 10.2

RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted. Please use the OWB Security UI to make the target schema be an OWB User.

RPE01012：不能将PLSQL映射部署到此目标方案。目标方案必须位于与控制中心相同的实例中,并且必须已授予OWB_USER角色。请使用OWB安全UI使目标方案称为OWB用户。

注释：

目标方案必须位于与控制中心相同的实例中？？这个如何理解？在rac下，又如何理解？

目标方案应该位于数据库文件里吧，控制中心是操作系统上的一个进程吧，不是oracle实例上的进程呀！

从owb11版本的RPE01012提示内容里，有点不好理解，说不明白。

从owb10.1版本的RPE01012提示内容里，就好理解了：

RPE-01012:Cannot deploy to the target location because it is owned by a different runtime platform。

这里的it指的是target location，也就是说目标位置被另一个运行时资料库（非当前运行部署的运行时资料库）所拥有。这句话的意思是，目标位置里填写的目标用户并没有注册到当前运行部署的运行时资料库（解决方法：使用OWB安全UI使目标方案称为OWB用户）。owned就是注册的意思其实。这样，从owb11版本的RPE01012提示内容里说的“目标方案必须位于与控制中心相同的实例中”就不难理解了，控制中心的位置为工作区所有者用户，该用户是已经注册到运行时资料库A，若目标用户此时注册到别的运行时资料库上，也会报错“目标方案必须位于与控制中心相同的实例中”，只有目标用户也注册到运行时资料库A上，即工作区所有者用户和目标用户都是某一工作区注册过的owb用户，这样控制中心才能部署owb对象的脚本到目标用户。“目标方案必须位于与控制中心相同的实例中”里的实例应该就是指的是运行时资料库，更确切地说，是该运行时资料库上的一个工作区。目标方案必须位于与控制中心相同的实例中，就是说，目标用户（填写在数据库目标模块对应的位置里）和工作区所有者用户（填写在控制中心对应的位置里）要注册到同一个owb工作区上。

疑问：

控制中心的位置里的填写的数据库用户一定要是工作区所有者用户，如果是工作区使用者用户，不知道会不会出问题？

owb version is 11.1和11.2

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

RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted.

By redyarman · August 13, 2012 · No comments
Uncategorized ·

Error Message when deploying OWB mapping

RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted.

Solution :

1. connect as OWBSYS

2. update OWBSYS.OWB$WB_RT_STORES set IS_LOCAL_TO_REPOS =1; — (default is 0)

3. commit;

Uncategorized

参考：http://redyarman.net/?p=27

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

priffert wrote:
hi,
when deploying mappings, i get
"RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted."
i´ve found some threads in this forum, tried all of the suggested actions - no result.

my setup:

- target/repository DB: 11.1.0.6.0, 64-bit SLES10
- owb client: 11.1.0.6, winXP
- applied patch 6770194 to OHome at db machine
- control center service running at repository db machine (show_service.sql says "Available")
- created a repository using repository assistant, owned by REP_OWNER
- created a repository user REP_USER
- created a target user, added user to list in global explorer -> security, granted OWB_USER role
- created a db-location with credentials of target schema
- defined a target module, selected connection details specified in previously created location
- created time dimension using wizard
- successfully deployed table + sequence to target schema

any help appreciated!

thanks,
peter

Applies to:
Oracle Warehouse Builder - Version: 11.1.0.6
This problem can occur on any platform.
Symptoms
When registering a Target Location with a SQL*NET Connection, the deployment of mappings fails with:

RPE-01012: Cannot deploy pl/sql maps to this target schema. The target schema must be in the same
instance as the control center and have OWB_USER role granted.

Both these conditions are true. It works fine when creating the location with host:port:servicename.

Cause
Bug 6761973 RPE-01012 WHEN DEPLOYING WITH SQL*NET CONNECTION

Solution

Install the following patch:

Patch 6770194PSE FOR BASEBUG 6174856 ON TOP OF 11.1.0 FOR LINUX 32BIT (46)

This patch fixes the following bugs:

Bug 6174856 OWB10GR2 USES DB LINK WHERE AS OWB10GR1 USES SCHEMA NAME WHEN USING SQL*NET
Bug 6310069 MAPPING DOES NOT GENERATED DATABASE LINK WHEN USING NET*SERVICE NAMES
Bug 6761973 RPE-01012 WHEN DEPLOYING WITH SQL*NET CONNECTION

References
Bug 6174856 - OWB10GR2 USES DB LINK WHERE AS OWB10GR1 USES SCHEMA NAME WHEN USING SQL*NET
Bug 6310069 - MAPPING DOES NOT GENERATED DATABASE LINK WHEN USING NET*SERVICE NAMES
Bug 6761973 - RPE-01012 WHEN DEPLOYING WITH SQL*NET CONNECTION

Edited by: Darthvader-647181 on Mar 31, 2009 2:08 AM

举报滥用
喜爱(0)

2.Re: RPE-01012 when deploying mappings

peter_AT2009-3-31 上午2:13（回复 650184）

thanks for your hint darthvader, but i´ve already installedpatch 6770194.

aside from that i´m creating the connection using host:port:servicename

Are you working in RAC environment? in which case i know it can cause problems.

Quote from Metalink:
=============

Bug No:      6761973
Filed      21-JAN-2008      Updated      29-JAN-2009
Product      Oracle Warehouse Builder      Product Version      11.1.0.6.0
Platform      Microsoft Windows Server 2003      Platform Version      No Data
Database Version      11.1.0.6      Affects Platforms      Generic
Severity      Severe Loss of Service      Status      Closed, Code fix resolution verified
Base Bug      N/A      Fixed in Product Version      11.2

Problem statement:

RPE-01012 WHEN DEPLOYING WITH SQL*NET CONNECTION

  

*** 01/21/08 02:33 am ***

.

Version & machine info:

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

OWB Client/OS: OWB 11.1.0.6.0/Win2003

OWB Design Repository Version: 11.1.0.1.1

Runtime Repository Server Platform/Version: Win2003/11.1.0.6.0

Oracle Database/OS : 10.2.0.3/Win2003

SOURCE & TARGET on the same machine or different machine ? yes

SOURCE database version/OS: 11.1.0.6

TARGET database version/OS: 11.1.0.6

.

Problem Description

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

When the Target Location is registered with SQL*NET Connection, the

deployment of a Map fails with:

.

RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema

must be in the same instance as the Control Center and have the OWB_USER role

granted.

.

.

Reproducible Case (For All bugs)

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

1. Create a Mapping with Source and Target

2. Register Target Location with a SQL*NET Connection

3. Deploy

.

.

Testcase

==========

.

Additional Information:

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

.

Workarounds (if any):

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

*** 01/21/08 02:34 am *** (CHG: Sta->16)

*** 01/21/08 07:06 am ***

*** 01/21/08 09:13 pm *** (CHG: Confirmed Flag->Y)

*** 01/21/08 09:13 pm *** (CHG: Asg->NEW OWNER)

*** 01/21/08 09:13 pm ***

*** 01/22/08 06:13 am *** (CHG: Sta->11 Asg->NEW OWNER)

*** 01/22/08 06:13 am ***

*** 01/22/08 06:57 am *** ESCALATED

*** 01/22/08 06:57 am ***

*** 01/22/08 07:08 am *** (CHG: Asg->NEW OWNER)

*** 01/22/08 07:08 am ***

*** 01/24/08 04:17 am ***

*** 01/24/08 06:52 am ***

*** 01/24/08 06:54 am *** (CHG: Fixed->11.2)

*** 01/24/08 06:54 am *** (CHG: Sta->80)

*** 01/24/08 06:54 am ***

*** 01/24/08 01:06 pm ***

*** 01/24/08 03:51 pm ***

*** 02/04/08 11:17 am ***

*** 02/08/08 04:42 pm *** ESCALATION -> CLOSED

*** 02/11/08 06:16 pm ***

*** 02/14/08 08:49 am ***

*** 03/06/08 08:09 pm ***

*** 03/06/08 08:34 pm ***

*** 10/29/08 12:57 am ***

*** 12/19/08 08:46 am *** (CHG: SubComp->UI)

*** 12/19/08 08:50 am *** (CHG: FixBy->8TAHOE)

*** 12/19/08 08:50 am ***

Mass update to add Fix By to bugs with Fixed Version of 11.2%

*** 12/22/08 01:09 pm ***

*** 01/23/09 03:03 pm *** (CHG: FixBy->11.2)

*** 01/28/09 05:30 pm ***

I created a target user location with SQL*NEt connection

I deployed a map to the target module pointing to this location successfully.

tested in 68.62

*** 01/29/09 02:35 pm *** (CHG: Sta->74)

参考：https://community.oracle.com/thread/881051

注释：

How to Target schema in different machine

此问题未回答。

RR 2013-2-19 上午12:46Hi all,

实验环境背景：

I am new to owb. I have installed OWB 11.2 in my local machine.

I have taken apps instance for source schema and dev instance for target schema. Both in different servers.

Warehouse builder was running in my local machine.I can able to create tables and sequences through owb in the target schema.

But while running mapping i am getting error like

RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted. Please use the OWB Security UI to make the target schema be an OWB User.

参考：https://community.oracle.com/thread/2502408

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

RPE-01012: Cannot deploy to the target location because it is owned by a different runtime platform.[message #381050]

Thu, 15 January 2009 00:18

madugular
Messages: 3
Registered: February 2008
Location: India

Junior Member

Hi,

When I am trying to deploy a mapping I am getting below error message.

RPE-01012: Cannot deploy to the target location because it is owned by a differentruntime platform.

Based on information from this forum, I ran below query

select wb_rt_platform_repository from dual;

WB_RT_PLATFORM_REPOSITORY
----------------------------------------------------------------------------

This should give the runtime repositoryowner name. But I am getting null values. Can any one suggest me how to fix this?

owb version is 10.1.0.4.0. This is running on HP-UX vsadbr1 B.11.11 U 9000/800

Thanks and Advance.

Madugular

[Updated on: Thu, 15 January 2009 01:10]

Report message to a moderator

Re: RPE-01012: Cannot deploy to the target location because it is owned by a different runtime platf[message #381241 is a reply tomessage #381050]

Fri, 16 January 2009 00:16

madugular
Messages: 3
Registered: February 2008
Location: India

Junior Member

HI
I got the fix from oracle metalink site. The data in WB_RT_PLATFORM_PROPERTIES table in target schema were some how deleted.After inserting values into this table， the mappings are successfully deployed.
Here are the 3 rows：

insert into <Target_schema>.WB_RT_PLATFORM_PROPERTIES values
(1,'property.RuntimePlatform.0.version','<owb_version>',0);

insert into <Target_schema>.WB_RT_PLATFORM_PROPERTIES values
(2,'property.RuntimePlatform.0.platform', 'FALSE' , 0);

insert into ODS_SBL_Sprint.WB_RT_PLATFORM_PROPERTIES values (3,'property.RuntimePlatform.0.platform_repository','<runtime_Repository_Owner>',0);

参考：http://www.orafaq.com/forum/t/138997/

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

RPE-01012: Cannot deploy to the target location because it is owned by a di

Bruce Alexander 2004-8-10 下午1:51Folks,

I am getting an: RPE-01012: Cannot deploy to the target location because it is owned by a different runtime platform.

I do -not- get this error all the time. It only occurs when I try to deploy a mapping that uses an external table as the data source and is mapped to a traditional db table as the target. I -am- able to deploy other mappings, only the external table fails.

Any help would be appreciated.

Thanks. Bruce

1.Re: RPE-01012: Cannot deploy to the target location because it is owned by a di

262222004-8-10 下午4:22（回复 Bruce Alexander）

Bruce,

Typically you get this message if you try to deploy a mapping to a schema that was not registered as a target schema with the runtime repository you deploy through.It could be that you runtime repository is a target schema but with an other runtime repository (this is unlikely) or the schema is not a target schema at all (this is usually the case).

To fix the issue, run the runtime assistant to make your schema a target schema in Warehouse Builder terms and/or create a new schema that you will use as your target schema.

Hope this helps,
Mark.

2.Re: RPE-01012: Cannot deploy to the target location because it is owned by a di

Bruce Alexander2004-8-11 上午5:56（回复 26222）

Mark,

If this is the case, why would I be able to deploy other mappings to the runtime repository? I am getting this error only for mappings that have external tables as the source. If I use a flat file as my source (same file as reference by the external table), the mapping deploys correctly and is subsequently run successfully.

Bruce

3.Re: RPE-01012: Cannot deploy to the target location because it is owned by

262222004-8-11 下午3:09（回复 Bruce Alexander）

Bruce,

Indeed, interesting... I did not realize you can deploy other mappings successfully, but only the mappings that use an external table as a source fail.

Could you look into the logfile that is generated in<owb home>/owb/log on your database serverfor a logfile that may contain more information on the issue? Can you submit that as a reply to this question?

Thanks,
Mark.

15.Very easy to fix this problem:

3158092005-12-21 上午9:31（回复 244356）

Step 1. Login the runtime repository as the owner.
Step 2. Locate the the table WB_RT_STORES and delete the row corresponding to the location.
Step 3. Re-register the location.

Hope this will help you.

Cheers,

Lushu

4704972005-12-22 上午12:56（回复 244356）

Hi,

If you still need help with this, do let me know.

Run the following query on the schema to which you are deploying：

select
object_type, count(1)
from
user_objects
where
to_char(created,'dd-mon-yy; hh24:mi') =
(
select
max(to_char(created,'dd-mon-yy; hh24:mi'))
from
user_objects
where
object_name='WB_ENABLE_CONSTRAINT'
)
group by
object_type
;

For OWB 9.2.x, you should get an output similar to the following：

OBJECT_TYPE,COUNT(1)
FUNCTION,33
INDEX,5
LOB,1
PACKAGE,3
PACKAGE BODY,3
PROCEDURE,17
SEQUENCE,8
SYNONYM,2
TABLE,7
TRIGGER,2

- Jojo

17.Re: RPE-01012: Cannot deploy to the target location because it is owned by a di

4855902006-1-25 上午6:54（回复 Bruce Alexander）

Hi,

I've also encountered this error. Maybe check if indexes on your OWB tables in your target scheme are (un)usable.

In my case, after rebuilding them, the deployment succeeded...

Grtz

D

参考：https://community.oracle.com/thread/261119

附加：

RPE 01012 Cannot deploy PL/SQL maps to the target schema 谷歌

RPE-01012: Cannot deploy to the target location 谷歌