Search This Blog

Monday 24 November 2008

Oracle 9i AS R2 Report Server shutting down issue

Introduction:
We faced a problem in Oracle 9i AS R2 report services, the log messages was showing as (URLEngineImpl:shutdown): Shutting down engine.

Resolution:
We tried to restart the report services from command line and from enterprise manager console, but after successfull restart it was shutting down again.

When we ran the following command

./$ORACLE_HOME/bin/rwserver.sh server=rep_server

it was throwing the following error

REP-56033: Job 67192 does not exist.

We checked the XWindows server and it was working fine, so the issue was not with the Xwindows as well.

we did the backup of the rep_server.dat file and removed this file, it is at the path $ORACLE_HOME/reports/server, having removed this file, we again restarted the reports services with the command line and it was all working, we used the following command

nohup $ORACLE_HOME/bin/rwserver.sh server=rep_server &

No comments:

Oracle 19c - patch 19.22 unavailability for Windows platform

 Oracle 19c - patch 19.22 unavailability for Windows platform  Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...