Wednesday, April 22, 2009

symptom : enabling APXS support for Apache2, no apxs2

solution : yum install httpd-devel

Building PHP with OCI8

problems occur because when configuring for build you get

checking libxml2 install dir... no
checking for xml2-config path...
configure: error: xml2-config not found. Please check your libxml2 installation.
How to solve :
yum install libxml2-devel

and then it works.

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 !!!!