Friday, March 13, 2009

Oracle BIP publisher throws nasty errors if you don't have the sample datasets installed. Can only trace this with wireshark !
Adding the Examples Tables back into a database.

With 11g they are not just a DDL create, there is a special RMAN pl/sql call and everything.

The best thing to do is :

1: $OH/demo/schemas/mkplug.sql copy to m2.sql and edit.

remove all defines and set the variables to hardcode.

The missing DFB files can be found at $OH/assistants/dbca/templates, as can the hotplug example.dmp, also fill in the output DBF file in the normal oradata location.

Make sure the log file location has a / at the end for Linux, as the spool won't work properly otherwise.

Then it just runs !!!!