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.