Friday, May 25, 2007

Discoverer Plus access through firewall

Follow the directions below to setup the Gatekeeper. Skip the NAT & PAT steps if you are not using them.

  1. Run gkconfig.bat. You can find it E:\\VBROKER\bin
  2. You should start on the MAIN tab
  3. Put gatekeeper.ior in the IOR File
  4. Put gatekeeper.log in the Log File
  5. Change to the EXTERIOR tab
  6. Put the physical IP address of the server where the Gatekeeper is listening into Exterior Address, this is the IP address of your server running Discoverer Server
  7. Put the open port in the firewall into Exterior Port, I use port 15000, you must exclude this port on Windows Firewall
  8. File => Save As
  9. Save the file as gatekeeper.properties in the following location:
    Windows: \Apache\Apache\htdocs\discwb4\applet
  10. Start the Gatekeeper
    Ensure that HKEY_LOCAL_MACHINE\Software\Oracle\DCW4_START_GATEKEEPER in the Windows registry is set to 1 & Restart the OracleDiscoverer4i Service in Services to start the Gatekeeper
  11. Ensure a new gatekeeper.ior file was created. It should be in the same location you saved the gatekeeper.properties file, the applet directory. Check the file timestamp. This file contains information that the client applet reads to determine the settings of the gatekeeper.properties.

Thursday, May 24, 2007

Enable Thousands Separators/Delimiters

To enable thousand separator/delimiter, login as system administrator, then open system profile option Currency: Thousands Separator, set it to Yes.
If you want to change separator character, open ICX: Numeric Characters. Set it to ,. if you use . as decimal separator and , as thousand separator. Set it to ., if you use , as decimal separator and , as thousand separator.