DISCLAIMER: The information and links provided on this site are my personal notes, based on my limited experience installing, using, and deinstalling Oracle databases and application servers on a variety of computers using Windows NT/2000/XP operating systems. The installation and deinstallation procedures found here can cause irreversable loss of data and may damage your operating system. However, you are welcome to use them AT YOUR OWN RISK. I am in no way responsible for data you lose or operating systems you damage or destroy.

Background

During installation of OracleAS 10g (9.0.4) on the Windows operating system, Oracle sets the location of temporary folder where the Reports server builds its reports before presenting them. This default location is in the installing user's My Documents folder. Recent Windows security patches have tightened the security policies, locking users out from accessing other users' My Documents folder. This prevents the Reports server from writing to its temp location, causing reports to fail.

Solution

The solution to this problem is changing the location of the Reports server folder to the C:\TEMP folder, which all users can write to. To change the location:
  1. Open the Windows registry editor (regedit)
  2. Go to HKEY_LOCAL MACHINE>SOFTWARE>ORACLE>HOME1
  3. Change the string value for the REPORTS_TMP key to C:\TEMP
  4. Reboot to make the change take effect

[Return to Lessons]

Valid XHTML 1.0!