Tuesday, October 14, 2008

OWB reports startup errors after database server move

UPDATE OWBRT_SYS.OWBRTPS
SET value=''
WHERE key =';

UPDATE OWB10G_RUNTIME.WB_RT_SERVICE_NODES
SET host = ''
, port =
, service_name = '
, server_side_home = '
WHERE node_id = 1;

UPDATE OWB10G_RUNTIME.WB_RT_STORE_PARAMETERS
SET parameter_value = ''
WHERE parameter_name = 'Service';

UPDATE OWB10G_RUNTIME.WB_RT_STORE_PARAMETERS
SET parameter_value = ''
WHERE parameter_name = 'Host';

UPDATE OWB10G_RUNTIME.WB_RT_STORE_PARAMETERS
SET parameter_value = ''
WHERE parameter_name = 'Port';