Oracle Developer Suite 10g Report Server configuration

rwservlet.properties :

SERVER_IN_PROCESS=YES

RELOAD_KEYMAP=YES

#DIAGNOSTIC=YES

#TRACEOPTS=TRACE_ALL

#TRACEFILE=rwservlet.trc

#TRACEMODE=TRACE_REPLACE

SERVER=repsrvr

#IMAGEURL=http://<web_server_name>:<port_num>/reports/rwservlet

#KEYMAPFILE=CGICMD.DAT

#DBAUTH=RWDBAUTH.HTM

#SYSAUTH=RWSYSAUTH.HTM

#ERRORTEMPLATE=RWERROR.HTM

#COOKIEEXPIRE=30

#ENCRYPTIONKEY=reports9i

#DIAGBODYTAGS=<reports_servlet_help_file_title>

#DIAGHEADTAGS=<reports_servlet_help_file_body_tag>

#HELPURL=<url_of_customized_help_file_for_reports_servlet>

#SINGLESIGNON=YES

OID_ENTITY=%REPORTS_OID_ENTITY%

#ALLOWHTMLTAGS=NO

#REPORTS_NETWORK_CONFIG=rwnetwork.conf

#OIDCON_INIT=10

#OIDCON_INCREMENT=10

#OIDCON_TIMEOUT=0

cgicmd :

sgmh: Userid=SGMH/S@ORCLPDB server=repsrvr destype=cache desformat=pdf %*

create bat file :

set ORACLE_HOME=c:\DevSuiteHome_1

set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jlib;%ORACLE_HOME%\jdk\bin

c:\DEVSUITEHOME_1\BIN\rwserver server=repsrvr autostart=yes

--:--:--:--:--:--:--:--:--:--:--:--

CREATE TABLE LIERP.REPPARA

(

ID NUMBER(10),

IP VARCHAR2(30 BYTE),

PORT VARCHAR2(30 BYTE),

URL VARCHAR2(30 BYTE),

CMDKEY VARCHAR2(30 BYTE),

DESFORMAT VARCHAR2(30 BYTE),

DESTYPE VARCHAR2(30 BYTE)

);

insert into reppara values

(1,'192.168.0.201','8889','/reports/rwservlet','sgmh','pdf','cache');