Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\upg\upgBETA2toBETA3.sql

-- In-place Design Repository Upgrade from BETA2 to Production

SPOOL LOG.TXT

ACCEPT V_HOST PROMPT 'Host Name: '
ACCEPT V_PORT PROMPT 'Port Number: '
ACCEPT V_SERVICENAME PROMPT	'Service Name: '
ACCEPT V_USER_NAME PROMPT 'Existing Repository Owner Name: '
ACCEPT V_USER_PASSWORD PROMPT 'Existing Repository Owner Password: ' HIDE
PROMPT 
PROMPT Review above entries and press
ACCEPT V_DUMMY PROMPT ' <ENTER> to continue or Ctrl-C to cancel'

PROMPT Start Design Repository upgrade from BETA2 to Production...

PROMPT Connect to repository owner ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_USER_NAME/&V_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME )))
WHENEVER SQLERROR CONTINUE

PROMPT Invoke upgrade for data profiling
@dp.sql

PROMPT Invoke upgrade for bug 3927616
@fix3927616.sql

PROMPT Delete all location passwords to protect exporting in clear text
@deletePasswords.sql

PROMPT Invoke upgrade for bug 4877973
@fix4877973.sql

PROMPT End of the upgrade.
SPOOL OFF

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de