Issue: Recently we had issue with Concurrent requests which having print format of PDF or XML, and the exact error is. REP-3000: Internal error starting Oracle Toolkit. Solution: 1. Log on as root on the UNIX box. 2. Start The VNC server: Example: $ vncserver :0 If it's not installed on the box, have your Unix Admin's to install the VNC on the server. 3. Set the DISPLAY environment variable for Oracle Reports by performing the following steps: a. $ set DISPLAY=hostname:0; export DISPLAY b. $ xhost + c. Set the DISPLAY parameter in adcmctl.sh, adrepctl.sh,adfrmctl.sh and gsmstart.sh to hostname:0 d. Restart concurrent manager and report server How to Verify: 1. Login with system administrator responsibility 2. Concurrent – program-Define-Query Active Users-Change Print format to PDF- save 3. Run the Active Users Concurrent Request 4. It should be completed without any issue.
Yet another blog for dba's. Shared my work experience here. Hope it will be useful for you guys all.