[chrisplough]

Just a quick update. While setting up the OTM database, you will get the following error while running the create_public_synonyms.sql script as the reportowner user:

SQL> @create_public_synonyms.sql
   SELECT owner, table_owner FROM DBA_SYNONYMS WHERE SYN *
ERROR at line 8:
ORA-06550: line 8, column 35:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 8, column 4:
PL/SQL: SQL Statement ignored

In order to resolve this issue, just login to the OTM database as the SYS user and run:

grant SELECT ON DBA_SYNONYMS to rep_owner;

Then, re-run the create_public_synonyms.sql script as the reportowner user.

This will avoid several problems later down the road.

Hope this helps!

--Chris