[SOLVED] Fixing OTM Oracle Reports after Patch Installation - Fixing File Permissions

[chrisplough]

After installing an OTM patch, you need to fix the directory and file permissions on your OTM Report server in order for Reports to work. Otherwise, you'll get the following error when running reports:

REP-159:

NOTE: this assumes that standard practice of running OTM as a different user from your Oracle Reports installation. If you use the same user for both, you won't experience this issue.

To resolve this issue, just login to your OTM Report Server and run the following commands:

chown o+x,o+r <otm_home_dir>
chown o+x,o+r <otm_home_dir>/glog/
chown -R o+x,o+r <otm_home_dir>/glog/reports/
chown o+x,o+r <otm_home_dir>/rptapache/
chown -R o+x,o+r,o+w <otm_home_dir>/rptapache/htdocs/

Also - don't forget to update your Oracle Reports templates after patching - this often gets overlooked!

cp -r <otm_home_dir>/glog/reports/10g/* <oracle_reports_home_dir>/reports/templates/

Hope this helps!

--Chris