Oracle

From TYPO3Wiki

Jump to: navigation, search

Contents

[edit]

What do I need for Oracle?

[edit]

Oracle

Hint: Use Oracle 10g Express Edition for toying around. It's free and comes with a nice GUI installer.

[edit]

PHP

PHP with support for Oracle. There are several PHP extensions that connect you to an Oracle server.

Hint: Via Oracle's XE pages you can get a copy of "Zend Core for Oracle" which bundles everything you need including Apache. This version of PHP is known to work out-of-the-box. You may experience Apache crashes (only on Windows?) when you use the binaries available from httpd.apache.org and php.net. Seems like the crashs on windows actually dont appear when using PHP 4+.

Do not use 5.1.6, it does not manage to read data stored in BLOBs, 5.2-latest from CVS (27.10.2006) does not have this problem.

[edit]

TYPO3

Use TYPO3 4.0.3 or later. TYPO3 4.0 doesn't handle some of Oracle's peculiarities. It will not work without manual changes to TYPO3's PHP code and the database layout.

[edit]

DBAL

You must manually install and configure the DBAL extension before entering the TYPO3 installer.

Hint: Do not use the 1-2-3 mode, but edit localconf.php manually.

[edit]

How do I configure my system

[edit]

PHP

You must install one of these extensions by adding them to your php.ini.

  • php_oci8
  • php_ora (deprecated)
  • php_pdo (PHP 5.1)

e.g.

Unix: 

; OCI8
extension=php_oci8.so

Windows: 

; Ora
extension=php_ora.dll

; PDO
extension=php_pdo.so
extension=php_pdo_oci.so
[edit]

TYPO3

Do not enter the TYPO3 installer before you have done the manual configuration described below. It's not possible the use 1-2-3 install wizard to connect to an Oracle server!

[edit]

Install ADOdb and DBAL

ADOdb and DBAL

There a two possible ways

1) As you need this extensions before you have access to the back-end you must install these extensions manually. Copy directories, located in "\typo3\sysext\", named "adodb" and "dbal" into "\typo3conf\ext\"

2) Just make sure to have "adodb" and "dbal" in "\typo3\sysext\". This should work too as in some cases (tried T3 v4.03 ) copying the files to "\typo3conf\ext\" makes the system not finding the required extensions.

Simply edit localconf.php and add 'adodb,dbal' to $TYPO3_CONF_VARS['EXT']['extList'].

[edit]

Configure DBAL

Edit localconf.php and add these lines. 

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
 '_DEFAULT' => array (
  'type' => 'adodb',
  'config' => array(
   'driver' => 'oci8',
  )
 ),
);

$TYPO3_CONF_VARS['EXT']['extList'] .= ',adodb,dbal';

Other possible driver types are 'oracle' (best for Oracle 7, won't work with Oracle 10g) or 'pdo_oci' (experimental PHP extension).

[edit]

Configure DB access

Edit localconf.php and add these lines. 

$typo_db_username = 'user';
$typo_db_password = 'pwd';
$typo_db_host = 'localhost';
$typo_db = 'SIDorServicename';

Unlike Mysql you don't connect to a server and select a DB. You connect as a user and use the default schema. To do this you can either enter the SID or the name of the service ('XE' when you use 10g XE). You must set the hostname and the service name in $typo_db_host and $typo_db. It's not possible to set them in one as //hostname/servicename (which means you cannot change the default port of 1521 using a service name).

Note: Of course you must use the name and password of your system. The values above are only examples.

[edit]

Create TYPO3 tables

After you have done everything as described you can use the TYPO3 installer as usual. So go to the 'Database analyzer' and use 'COMPARE' to create the necesssary tables, columns and indices.

The installer will list an number of unnecessary ALTER TABLEs which you may safely ignore. In TYPO3 4.0 DBAL cannot interpret the table definitions well enough. But see below for further steps to be done in Oracle.

[edit]

Oracle

Nothing to configure, but a few things to tweak after the installer has created all the necessary tables.

To make TYPO3 work with Oracle the following SQL statements are necessary. Otherwise TYPO3 won't work.

Hint: With 10g XE you can use the Oracle Application Express web application. The default URL is http://localhost:8080/apex (assuming you work on the same machine as the server)..

[edit]

Add column triggers for 'pages' and 'tt_content'

TYPO3 will try to insert/change some fields to '' expecting the DB to use the default like Mysql does. Oracle doesn't do this, so we must create a workaround. 

create or replace trigger "pages_defaults"
before insert or update on "pages"
for each row
 when (NEW."fe_group" is null or NEW."fe_group" = '')
begin
 :NEW."fe_group" := '0';
end; 

create or replace trigger "tt_content_defaults"
before insert or update on "tt_content"
for each row
when (NEW."fe_group" is null or NEW."fe_group" = '' or NEW."list_type" is null or NEW."list_type" = '')
begin
if :NEW."fe_group" is null or :NEW."fe_group" = '' then
 :NEW."fe_group" := '0';
end if;
if :NEW."list_type" is null or :NEW."list_type" = '' then
:NEW."list_type" := '0';
end if;
end;

The 4.0.1 release of TYPO3 will include IS NULL when checking against fe_group --k-fish 14:00, 6 July 2006 (CEST)

[edit]

Add index for versioning

The installer will use an index name which exceeds Oracle's limit of 30 characters for names. 

CREATE INDEX "pages_language_overlay_t3void" ON "pages_language_overlay" ("t3ver_oid", "t3ver_wsid")
[edit]

Possible Problems

[edit]

DB object names

Oracle allows only 30 characters for table and column names. You may encounter extensions that use longer names.

To solve this, set up a table name mapping before creating the table in TYPO3 --k-fish 14:01, 6 July 2006 (CEST)


How does this works exactly?

-> try: synonyms (this method doesn't seem to work in Oracle EE 10.2.0.1.0)

-> you can create a table or column name mapping in typo3conf/localconf.php. This is outlined in the dbal documentation at [1]

Retrieved from "http://wiki.typo3.org/index.php/Oracle"
Personal tools
content
help 'N' beginners