Introduction:
This post is related to describe the Report server issue with Oracle 9i AS R2. For this release of Application Server, the X Server is mandatory to run the report server. If there is any issue with the X Server then the Report Server will not work and users would be waiting to print their reprots.
Troubleshooting and Resolution:
We faced interesting issue with our reprot server for Oracle 9i AS R2. And following is procedure by which we successfully resolved the report server issues.
--> Report Server was not coming up, and the error message was following.
Error
REP-50001: Server is initializing
We waited a lot, but it was showing "REP-50001: Server is initializing", the command to run the report server was not throwing the following error after some time:
REP-56097: Engine rwEng-0 callback timeout
We used following command to run the report server:
./rwserver.sh server=rep_testserver4
and it was throwing error REP-56097, even we created different report server with different names, but the behavior was same, it was always throwing REP-50001, REP-56097.
Also we gathered the traces, but no clue was there, also X Server was working fine, in our case we were using vnc X Server. We raised a SR with Oracle Support, and they did many testings with the report server, but nothing worked.
And suddenly what we did we tried to check the X Server from vnc viewer and the report server windows was displayed as soon as we got the X Server console, and when we executed the reports it was all working. So the clue was we had to open the vnc X server console once to get the reports windows, and every thing was working fine. And later we closesd that vnc X Server window, and even then the reports were working all fine.
In Oracle 10g AS R2, there is no requirement for X Server for reports server. We would be migrating our Oracle 9i AS R2 to Oracle 10g AS R2 soon.
This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments. Also to make this blog more useful, please give your comments and share your experience. Thanks
Subscribe to:
Post Comments (Atom)
Oracle Weblogic 12.2.1.3.0 60820: Select a domain which is a compatible with this environment. stopComponent.sh and start Component.sh give...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: We use EMC BCV feature to clone our production database, and it was all working fine, but suddenly we started getting the erro...
-
Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports The installer will stuck on the Oracle Net ...
No comments:
Post a Comment