Tuesday, October 14, 2008

OWB reports ORA-01882 when connecting to Oracle 9i databases

vi $ORACLE_HOME/owb/bin/unix/run_service.sh

# add -Duser.timezone="+00:00" as follows

$JAVAPATH/bin/java -Xmx768M -Duser.timezone="+00:00" -Djava.awt.headless=true -DORACLE_HOME="${RTHOME}" -
DOCM_HOME="${RTHOME}" -DOCM_ORACLE_HOME="${RTHOME}" $CLASSPATH_LAUNCHER oracle.wh.runtime.platform.servic
e.Service ${STARTUP_TYPE} ${NODEID} ${RTUSER} ${HOST} ${PORT} ${SERVICE}

#Restart the OWB services using stop_service.sql/start_service.sql.