On Oracle Applications 11i, the quickest method to check if the Oracle Reports server is functional is to "temporarily" enable the Oracle Reports Server diagnostic mode and bring up the "Environment" and "RWCGI Key Map" page via a web browser.
--> Enable the Oracle Reports Server diagnostic mode.
Comment out any reference to the REPORTS60_CGINODIAG and REPORTS60_OWSNODIAG parameters from the following files:
$APACHE_TOP/Apache/conf/apps.conf
$FND_TOP/resource/appsweb.cfg
$OAD_TOP/admin/scripts/
Bounce the Oracle Reports server and the Apache (Web) server.
--> Environment Check
http://
--> "RWCGI Key Map" Check
http://
An example is as follows: http://vis.oracle.com:8000/dev60cgi/rwcgi60/showenv?server=REP60_VIS
(The host and port is the same used for Apps login, the Web / Apache node)
If the Oracle Reports server installed with Oracle Applications 11i Succeeds to display the "Environment" and "RWCGI Key Map" page via a web browser, please check with the application product group who owns the troubled report for any required setup at the application level.
If the Oracle Reports server installed with Oracle Applications 11i Fails to display the "Environment" and "RWCGI Key Map" page via a web browser, please open a service request with the ATG group, upload a screen print of the error being encountered, and the following data:
1. Upload as a zip file with the following files.
a. The Apps 8.0.6 $TNS_ADMIN/tnsnames.ora file.
b. $APACHE_TOP/Apache/conf/apps.conf file
c. $ORACLE_HOME/reports60/server/CGIcmd.dat
d. $ORACLE_HOME/reports60/server/REP60_
e. $FND_TOP/resource/appsweb.cfg
f. $OAD_TOP/admin/scripts/
(The exact adrepctl.sh file used to start the report server.)
2. Upload the report server's log files.
a. The Apps report server startup log file. The variable REPSRV_LOG within the adrepctl.sh points to the log file.
b. The Oracle Reports server log file.
$ORACLE_HOME/reports60/server/REP60_
3. Is the report server currently running; what is the output of ps -ef | grep rwmt ?
No comments:
Post a Comment