Files to be modified after installation.
1. boot.properties $DOMAIN_HOME/servers/WLS_FORMS/security
2. tnsnames.ora $ORACLE_INSTANCE/config
3. sqlnet.ora $ORACLE_INSTANCE/config
4. uifont.ali $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
5. uiprint.txt $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
6. datap462.ppd $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
7. screenprinter.ppd $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
8. font files in $ORACLE_HOME/guicommon/tk/admin/TTF
9. font afm files in $ORACLE_HOME/guicommon/tk/admin/AFM
10. config.xml $DOMAIN_HOME/config/config.xml Note.1162025.1 jsp changes does not work on the fly.
$DOMAIN_HOME/config/ Note : 1309168.1 DEV_DISCOVERER Discoverer Schema changes
11. jar files in $ORACLE_HOME/forms/java
12. webutilbase.htm $ORACLE_INSTANCE/config/FormsComponent/forms/server
13. webutil.cfg $ORACLE_INSTANCE/config/FormsComponent/forms/server
14. webutil dll d2kwutil.dll, JNIsharedstubs.dll ORACLE_HOME/forms/webutil
15. Registry.dat $DOMAIN_HOME/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/forms/registry/oracle/forms
17. cgicmd.dat $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.1.2.0/configuration
18. default.env $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config
19. formsweb.cfg $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config
20. machine1_fmw_DEV_DISCOVERER-2554-jdbc.xml $DOMAIN_HOME/config/jdbc - dev_discoverer schema changes
21 httpd.conf $ORACLE_INSTANCE/config/OHS/ohs1
22. Idempotent OFF
16. 10g : How To Rotate OC4J Default-Web-Access.Log Using Oracle Diagnostic Logging (ODL) ? [ID 822155.1]
How To Update Discoverer 11g When The Repository Schemas (RCU) Have Changed [ID 1309168.1]
DEV_DISCOVERER
22. jsp servlet session-timeout parameter .$DOMAIN_HOME\<YourDomain>\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.1.2.0\<SomeRandomDir>\war\WEB-INF
$DOMAIN_HOME/servers/WLS_REPORTS/tmp/_WL_user/reports_11.1.1.2.0/uqanoi/war/WEB-INF
From MBean Browser expand the "Application Defined MBeans" branch and then go to
Application Defined MBeans
- oracle.reportsApp.config
- Server: WLS_REPORTS
- Application: Reports
- ReportsApp
- cgicmd
How to Update CGICMD.DAT Using System Mbean Browser [ID 1296010.1]
http://servername.<your domain name>:port/em
1. In the MBean check if the user wants to add a key/val pair
2. Click operations TAB and then addKey
3. Enter key and value fields and click Invoke button
4. Following will be added to cgicmd.dat
<key>: <value>
1423893.1 How to Enable Discovery Cache To Avoid Long Delay During Login To Fusion Middleware Control
Weblogic Domain - ClassicDomain-Right Click-System Mbean Browser -
emoms.props, Server:AdminServer,Application:em,Properties,emoms.properties
setProperty
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_USE_CACHED_RESULTS=true
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_MAX_CACHE_AGE=7200000
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_MAX_WAIT_TIME=10000
1277681.1 configuring jvm controller for preventing memory jump in forms 11g, RUN_REPORT_OBJECT
in Oracle Weblogic EM page,
select forms node and right click,
select JVM Configuration
select Create Like (example) and give any name eg. repjvmc
set below parameters
jvmoptions = -Xms512m -Xmx1024m #Stands for initial heap and max heap. Normally you should not need to modify these.
classpath = ORACLE_HOME\jlib\zrclient.jar;ORACLE_HOME\reports\jlib\rwrun.jar # Replace ORACLE_HOME with your actual directory. These .jar files are needed for RRO.
maxsessions = 50 # Specifies how many Forms runtime processes are allowed to attach to a JVM before a new child JVM is created.
logdir = #The directory for the jvmcontroller log files. For this jvmcontroller, the file will be called repjvmc.log as the log file is named after the jvmcontroller.
Logging = on #Recommend leaving “on” until verification that all is working okay. Then turn on only when necessary.
In the default section of the formsweb.cfg, add “jvmcontroller=%jvmcontroller%” to the value of “otherparams”. For example ->
otherparams= jvmcontroller=%jvmcontroller% obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect%
Doc ID 858200.1 How to Setup jobStatusRepository Feature in Reports 11g
Doc ID 1473967.1 Setting up jobRepository/jobStatusRepository Feature in Report Server 11gR2 Development Mode Installation
1. boot.properties $DOMAIN_HOME/servers/WLS_FORMS/security
2. tnsnames.ora $ORACLE_INSTANCE/config
3. sqlnet.ora $ORACLE_INSTANCE/config
4. uifont.ali $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
5. uiprint.txt $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
6. datap462.ppd $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
7. screenprinter.ppd $ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin
8. font files in $ORACLE_HOME/guicommon/tk/admin/TTF
9. font afm files in $ORACLE_HOME/guicommon/tk/admin/AFM
10. config.xml $DOMAIN_HOME/config/config.xml Note.1162025.1 jsp changes does not work on the fly.
$DOMAIN_HOME/config/ Note : 1309168.1 DEV_DISCOVERER Discoverer Schema changes
11. jar files in $ORACLE_HOME/forms/java
12. webutilbase.htm $ORACLE_INSTANCE/config/FormsComponent/forms/server
13. webutil.cfg $ORACLE_INSTANCE/config/FormsComponent/forms/server
14. webutil dll d2kwutil.dll, JNIsharedstubs.dll ORACLE_HOME/forms/webutil
15. Registry.dat $DOMAIN_HOME/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/forms/registry/oracle/forms
17. cgicmd.dat $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.1.2.0/configuration
18. default.env $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config
19. formsweb.cfg $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config
20. machine1_fmw_DEV_DISCOVERER-2554-jdbc.xml $DOMAIN_HOME/config/jdbc - dev_discoverer schema changes
21 httpd.conf $ORACLE_INSTANCE/config/OHS/ohs1
22. Idempotent OFF
16. 10g : How To Rotate OC4J Default-Web-Access.Log Using Oracle Diagnostic Logging (ODL) ? [ID 822155.1]
How To Update Discoverer 11g When The Repository Schemas (RCU) Have Changed [ID 1309168.1]
DEV_DISCOVERER
22. jsp servlet session-timeout parameter .$DOMAIN_HOME\<YourDomain>\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.1.2.0\<SomeRandomDir>\war\WEB-INF
$DOMAIN_HOME/servers/WLS_REPORTS/tmp/_WL_user/reports_11.1.1.2.0/uqanoi/war/WEB-INF
From MBean Browser expand the "Application Defined MBeans" branch and then go to
Application Defined MBeans
- oracle.reportsApp.config
- Server: WLS_REPORTS
- Application: Reports
- ReportsApp
- cgicmd
How to Update CGICMD.DAT Using System Mbean Browser [ID 1296010.1]
http://servername.<your domain name>:port/em
1. In the MBean check if the user wants to add a key/val pair
2. Click operations TAB and then addKey
3. Enter key and value fields and click Invoke button
4. Following will be added to cgicmd.dat
<key>: <value>
1423893.1 How to Enable Discovery Cache To Avoid Long Delay During Login To Fusion Middleware Control
Weblogic Domain - ClassicDomain-Right Click-System Mbean Browser -
emoms.props, Server:AdminServer,Application:em,Properties,emoms.properties
setProperty
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_USE_CACHED_RESULTS=true
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_MAX_CACHE_AGE=7200000
oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_MAX_WAIT_TIME=10000
1277681.1 configuring jvm controller for preventing memory jump in forms 11g, RUN_REPORT_OBJECT
in Oracle Weblogic EM page,
select forms node and right click,
select JVM Configuration
select Create Like (example) and give any name eg. repjvmc
set below parameters
jvmoptions = -Xms512m -Xmx1024m #Stands for initial heap and max heap. Normally you should not need to modify these.
classpath = ORACLE_HOME\jlib\zrclient.jar;ORACLE_HOME\reports\jlib\rwrun.jar # Replace ORACLE_HOME with your actual directory. These .jar files are needed for RRO.
maxsessions = 50 # Specifies how many Forms runtime processes are allowed to attach to a JVM before a new child JVM is created.
logdir = #The directory for the jvmcontroller log files. For this jvmcontroller, the file will be called repjvmc.log as the log file is named after the jvmcontroller.
Logging = on #Recommend leaving “on” until verification that all is working okay. Then turn on only when necessary.
In the default section of the formsweb.cfg, add “jvmcontroller=%jvmcontroller%” to the value of “otherparams”. For example ->
otherparams= jvmcontroller=%jvmcontroller% obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect%
Doc ID 858200.1 How to Setup jobStatusRepository Feature in Reports 11g
Doc ID 1473967.1 Setting up jobRepository/jobStatusRepository Feature in Report Server 11gR2 Development Mode Installation