Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\rtps

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\rtps_admin.sql

prompt
prompt This sql sets up any database server for use with
prompt OWB Control Center creation option
prompt Use it as an alternative to running
prompt OWB RTPS Configuration Assistant (physically) on the server
prompt

accept SYSTEM_USR CHAR DEF 'system' PROMPT 'Enter System User Name(system): '
accept SYSTEM_PWD CHAR DEF 'manager' PROMPT 'Enter System Password(manager): ' HIDE
accept CONNECT_STR CHAR PROMPT 'Enter TNS Connect String: '
accept RTP_version CHAR PROMPT 'RTP_version: '
accept ORACLE_HOME CHAR PROMPT 'Enter Oracle Home where OWB RTP Service is installed: '

set echo off;
set verify off

define OWBRT_USR ='owbrt_sys'
define OWBRT_PWD ='owbrt_sys'

connect &SYSTEM_USR/&SYSTEM_PWD@&CONNECT_STR

drop user &OWBRT_USR cascade;
create user &OWBRT_USR identified by &OWBRT_PWD;
grant connect to &OWBRT_USR;
grant resource to &OWBRT_USR;

connect &OWBRT_USR/&OWBRT_PWD@&CONNECT_STR
create table OWBRTPS (
KEY VARCHAR2(35),
VALUE VARCHAR2(255)
);
insert into OWBRTPS values ('&RTP_version','&ORACLE_HOME');
grant select on OWBRTPS to public;

connect &SYSTEM_USR/&SYSTEM_PWD@&CONNECT_STR
revoke connect from &OWBRT_USR;
revoke resource from &OWBRT_USR;
--exit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de