CMS V7 and Oracle

[gorsty]

Hi all,

I work on a site that uses CMS with an Oracle back end. We have had no end of troubles and many seem to be related to the fact that we don't use SQL server. I was wondering whether there were any other sites out there that are using Oracle and Reddot CMS

[digitalclouds]

.. out of interest (we use SQL 2000), which exact version of Oracle (server/client) are you using?

[gorsty]

I'm not sure of the exact version, I do know we recently upgraded to Oracle 10.

It does seem that there is a bias (for want of a better term) towards SQL server when it comes to the support of CMS. For example many plugins are written to work directly with sql server.

[digitalclouds]

yeah .. this seems to be a common problem .. in a way it is understandable since many people do not have access to Oracle (not to mention cost of ownership when you do have it) .. but even if they do have access to it, it is not as simple as MS SQL when it comes to quickly creating a db .. I think this is probably the main cause for most things leaning towards MS SQL ..

I was wondering about the version because we have found that certain aspects in regards to Oracle over ODBC are very version specific (we have had some general Oracle problems in regards to the way it handles unicode .. don't ask me what exactly as I am not 100% sure .. I am not an Oracle DBA .. this is just from stuff I have heard) ..

[gorsty]

Oracle is definately more complex I suppose it just annoys me that although the product is supposed to be compatible with Oracle there's almost no one able to support it either due to licencing issues or lack of training. Any way enough of my rant.

[smitcham]

Hi Guys,

We've just impleented a RedDot/Oracle installation and it's great. So much faster and more stable than MSSQL.

It is a bit fiddly to set up, and the version of the client tools have to be very specific (OraClient 9.2.0.7.00, the backend DB can be any version, but 10g seems to work best).

If you use the following script to create your schemas, you shouldn't have any problems.

CREATE USER [ProjectName]
IDENTIFIED BY [ProjectName]
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT UNLIMITED TABLESPACE TO [ProjectName];
GRANT connect TO [ProjectName];
GRANT resource TO [ProjectName];
GRANT ctxapp TO [ProjectName];

Just run it in SQL+ then create your projects in RD referencing schema [ProjectName].

It's all good
_________________
Stuart
(He is not the Messiah, he's a very naughty boy)