MSM 3.18.8 and Oracle 10g

Squiz Matrix Installation
1

Hi all


It’s been a while since I ventured onto this board. I’m trying to install MSM onto RHEL5 with apache2.2.3 and PHP5.2.8. I am trying to backend onto a separate Oracle 10g server.



Installed the 11g Oracle basic and sdk instant client zip files available at http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html and compiled PHP with oci8 support.



Following this guide http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html, I need to populate the new db.inc file with the connection string to Oracle and have done so but it’s failing at step 2.



First question, as I only have one database, do I only fill in the section for “db” and ignore “db2” and “db3” in db.inc?



Second question, what is the correct format I need to put into the DSN? I’ve tried just the database name (eg oracle.domain.local) and this format “//oracle.domain.local:1521/servicename” but both fail with:


[quote]Fatal error: Uncaught exception 'Exception' with message 'Could not create database connection: DBError!:invalid data source name' in /opt/mysource_matrix/core/include/mysource.inc:2313[/quote]



TIA

2

Got it working!


1: Yes you need to fill in db2 and db3

2: //oracle.domain.local:1521/servicename works for me



I was having Oracle authentication errors in step 2 but this turned out to be a trailing slash problem on the Oracle server itself. Now to step 3 and beyond!

3

Just a note that Oracle Enterprise Linux now includes the Instant Client and php-oci8 RPMs, obtainable from Unbreakable Linux Network. You will need at least Network level support to access ULN, but that's a lot cheaper than Red Hat.


Not that I have a vested interested or anything. :slight_smile:

4

The last step in the oracle guide from http://matrix.squiz.net/resources/installation/oracle-setup which has the following

    DROP INDEX sq_sch_idx_value;
    CREATE INDEX sq_sch_idx_value ON sq_sch_idx (value)
    	INDEXTYPE IS CTXSYS.CONTEXT
    	PARAMETERS('STOPLIST ctxsys.default_stoplist SYNC (EVERY "SYSDATE+(30/1440)")');
    COMMIT;


Says that there is no sq_sch_idx and is confirmed when using toad to view the database. Is this safe to ignore?
5

If you don't have the search package installed, ignore it.