RTC-5301错误的解决办法!

使用OWB时，在“设计中心”中菜单中选择“控制中心管理器”时出错。

RTC-5260: Failed to connect to Control Center, Please check you have provided the correct Host, user, password and Service Name

RTC-5301: The Control Center Service is not currently available

解决办法： 1. Start SQL*Plus, and connect as the OWB_OWNER database account.

# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ cd $ORACLE_HOME
$ cd builder
$ cd owb
$ cd rtp
$ ls
sql
$ cd sql
$ ls
abort_exec_request.sql purge_audit_template.sql
abort_unit_request.sql reset_repository.sql
deactivate_all.sql rtrepos_report.sql
deactivate_deployment.sql service_doctor.sql
deactivate_execution.sql set_oem_home.sql
delete_warehouse_object.sql set_platform_property.sql
display_platform_property.sql set_repository_password.sql
expedite_exec_request.sql show_service.sql
grant_upgrade_privileges.sql sqlplus_exec_background_template.sql
list_requests.sql sqlplus_exec_template.sql
oem_exec_background_template.sql start_service_nv.sql
oem_exec_template.sql start_service.sql
patch_lemans_autosys_properties.sql stop_service.sql
print_exec_details.sql wb_rt_api_exec_example.txt
print_running_exec_details.sql
$ sqlplus owb/owb@owb

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 3 17:27:35 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @reset_repository.sql
Enter value for repos_password: owb
old 2: wb_rti_util.reset('&REPOS_PASSWORD.');
new 2: wb_rti_util.reset('owb');

PL/SQL procedure successfully completed.


Commit complete.

SQL> set_repository_passowrd.sql
SP2-0735: unknown SET option beginning "_repositor..."
SQL> @set_repository_password.sql
Enter value for 1: owb

PL/SQL procedure successfully completed.


Commit complete.

SQL> @start_service.sql
Not available
Diagnostics:
service startup failure using command "/app/oracle/product/10.2.0/owb/builder/o
wb/bin/unix/run_service.sh -manual 1 /app/oracle/product/10.2.0/owb/builder OWB
DHCP-CBJS07-150-108 1521 OWB" reason ORA-29532: Java call terminated by uncaug
ht Java exception: java.io.IOException: service early exit: code=255 : err=2009
/02/03-17:28:41-CST [17E6A96] oracle.wh.runtime.platform.adapter.Infrastructure
Exception: RPE-01003: An infrastructure condition prevented the request from co
mpleting.
- Io exception: The Network Adapter could not establish the connecti
on
at oracle.wh.runtime.platform.service.controller.PlatformDb.connect(Plat for
mDb.java:83)
at oracle.wh.runtime.platform.service.Service.<init>(Service

PL/SQL procedure successfully completed.

SQL> !
$ vi start_service.sql
"start_service.sql" 116 lines, 2969 characters
rem
rem This script can be used to start a Control Center Service.
rem
rem A Control Center Service provides access to the deployment and execution
rem features of a Control Center. This service is either Available or Unavailable
rem and this script can be used to make it Available.
rem
rem When the service is invoked using this script, a monitoring job is created.
rem This job monitors the service and will restart it if the service fails. This
rem monitor will also automatically start the service if the database is brought
rem back online.
rem
rem USAGE
rem Logon as the Control Center Owner
rem
rem @<OWB-HOME>/owb/rtp/sql/start_service.sql
rem
rem This script will display
rem "Available" if the Control Center service is up and Available
rem "Not Available" if the Control Center service is Not Available
rem (if this happens you could try using the
rem service_doctor.sql to determine why the service did not
rem start)
rem
rem Please use the scripts show_service.sql and stop_service.sql to show the status or
rem stop the service respectively

set serveroutput on;

begin
declare

function wait_for_is_available
return number
is
l_available number;
l_org_log_count number;
l_log_count number;
l_count number := 0;
begin

service_available(l_available);

select
count(*)
into
l_log_count
from
wb_rt_service_job_logs;
l_org_log_count := l_log_count;

while l_available = 0 and l_log_count = l_org_log_count and l_count < 90
loop
dbms_lock.sleep(2);
service_available(l_available);
select
count(*)
into
l_log_count
from
wb_rt_service_job_logs;
l_count := l_count + 1;

end loop;

return l_available;
end;

begin

wb_rt_service_management.enable_all(wb_rt_constants.STARTUP_KIND_MANUAL);
commit;

if wait_for_is_available = 0
then
dbms_output.put_line('Not available');

for d in (
select
message
from
(select * from wb_rt_service_job_logs order by time_stamp desc)
where
rownum < 2
)
loop
dbms_output.put_line('Diagnostics:');

declare
l_next number := 1;
l_length number := length(d.message);
rem monitor will also automatically start the service if the database is brought
rem back online.
rem
rem USAGE
rem Logon as the Control Center Owner
rem
rem @<OWB-HOME>/owb/rtp/sql/start_service.sql
rem
rem This script will display
rem "Available" if the Control Center service is up and Available
rem "Not Available" if the Control Center service is Not Available
rem (if this happens you could try using the
rem service_doctor.sql to determine why the service did not
rem start)
rem
rem Please use the scripts show_service.sql and stop_service.sql to show the status or
rem stop the service respectively

set serveroutput on;

begin
declare

function wait_for_is_available
return number
is
l_available number;
l_org_log_count number;
l_log_count number;
l_count number := 0;
begin

service_available(l_available);

select
count(*)
into
l_log_count
from
wb_rt_service_job_logs;
l_org_log_count := l_log_count;

rem
rem Please use the scripts show_service.sql and stop_service.sql to show the status or
rem stop the service respectively

set serveroutput on;

begin
declare

function wait_for_is_available
return number
is
l_available number;
l_org_log_count number;
l_log_count number;
l_count number := 0;
begin

service_available(l_available);

select
count(*)
into
l_log_count
from
wb_rt_service_job_logs;
l_org_log_count := l_log_count;

while l_available = 0 and l_log_count = l_org_log_count and l_count < 90
loop
dbms_lock.sleep(2);
service_available(l_available);
select
count(*)
into
l_log_count
from
wb_rt_service_job_logs;
l_count := l_count + 1;

end loop;

return l_available;
end;

begin

wb_rt_service_management.enable_all(wb_rt_constants.STARTUP_KIND_MANUAL);
commit;

if wait_for_is_available = 0
then
dbms_output.put_line('Not available');

for d in (
select
message
from
(select * from wb_rt_service_job_logs order by time_stamp desc)
where
rownum < 2
)
loop
dbms_output.put_line('Diagnostics:');

declare
l_next number := 1;
l_length number := length(d.message);
l_fraglen number;
begin
while l_next <= l_length
loop
l_fraglen := l_length - l_next + 1;
if l_fraglen > 79
then
l_fraglen := 79;
end if;
dbms_output.put_line(substr(d.message, l_next, l_fraglen));
l_next := l_next + l_fraglen;
end loop;
end;
end loop;

else
dbms_output.put_line('Available');
end if;

commit;

end;
end;
/

:q
$ su - root
Password:
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
# vi /etc/hosts
"/etc/hosts" [Read only] 7 lines, 135 characters
#
# Internet host table
#
::1 localhost
127.0.0.1 localhost
129.158.150.52 mopoc1
129.158.150.129 dhcp-cbjs07-151-84 # Added by DHCP
129.158.150.129 DHCP-CBJS07-150-108
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"/etc/hosts" 8 lines, 172 characters
# exit
$ ls -lrt
total 244
-rw-r--r-- 1 oracle dba 12318 Feb 17 2004 print_running_exec_details.sql
-rw-r--r-- 1 oracle dba 9925 Feb 17 2004 print_exec_details.sql
-rw-r--r-- 1 oracle dba 3409 May 6 2004 patch_lemans_autosys_properties.sql
-rw-r--r-- 1 oracle dba 310 Nov 15 2004 delete_warehouse_object.sql
-rw-r--r-- 1 oracle dba 7381 Feb 10 2005 rtrepos_report.sql
-rw-r--r-- 1 oracle dba 1281 Jun 6 2005 expedite_exec_request.sql
-rw-r--r-- 1 oracle dba 1498 Dec 9 2005 stop_service.sql
-rw-r--r-- 1 oracle dba 2969 Dec 9 2005 start_service.sql
-rw-r--r-- 1 oracle dba 956 Dec 9 2005 show_service.sql
-rw-r--r-- 1 oracle dba 500 Dec 9 2005 set_repository_password.sql
-rw-r--r-- 1 oracle dba 1541 Dec 9 2005 set_platform_property.sql
-rw-r--r-- 1 oracle dba 4047 Dec 9 2005 service_doctor.sql
-rw-r--r-- 1 oracle dba 370 Dec 9 2005 reset_repository.sql
-rw-r--r-- 1 oracle dba 2619 Dec 9 2005 list_requests.sql
-rw-r--r-- 1 oracle dba 1698 Dec 9 2005 display_platform_property.sql
-rw-r--r-- 1 oracle dba 511 Dec 9 2005 deactivate_execution.sql
-rw-r--r-- 1 oracle dba 546 Dec 9 2005 deactivate_deployment.sql
-rw-r--r-- 1 oracle dba 1657 Dec 9 2005 abort_unit_request.sql
-rw-r--r-- 1 oracle dba 3131 Dec 13 2005 start_service_nv.sql
-rw-r--r-- 1 oracle dba 11727 Jan 10 2006 set_oem_home.sql
-rw-r--r-- 1 oracle dba 6873 Jan 10 2006 purge_audit_template.sql
-rw-r--r-- 1 oracle dba 11877 Jan 20 2006 wb_rt_api_exec_example.txt
-rw-r--r-- 1 oracle dba 708 Feb 2 2006 deactivate_all.sql
-rw-r--r-- 1 oracle dba 4952 Feb 6 2006 sqlplus_exec_template.sql
-rw-r--r-- 1 oracle dba 5386 Feb 6 2006 sqlplus_exec_background_template.sql
-rw-r--r-- 1 oracle dba 4991 Feb 6 2006 oem_exec_template.sql
-rw-r--r-- 1 oracle dba 5471 Feb 6 2006 oem_exec_background_template.sql
-rw-r--r-- 1 oracle dba 1426 Feb 22 2006 abort_exec_request.sql
-rw-r--r-- 1 oracle dba 654 Mar 8 2006 grant_upgrade_privileges.sql
$ @start_service.sql
/bin/ksh: @start_service.sql: not found
$ sqlplus owb/owb@owb

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 3 17:33:04 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @start_service.sql
Available

PL/SQL procedure successfully completed.