[TYPO3] How to connect to ORACLE

[Santiago Galindo Hidalgo]

Hi everybody

I could to connect to oracle 10XE and 9i R2 following the steps in this direction: 
http://wiki.typo3.org/index.php/Oracle

Add this lines to localconf.php

$typo_db_username = 'admin';	//put your own fields
$typo_db_password = 'admin';
$typo_db_host = 'localhost';
$typo_db = 'ora92';

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

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

but after install oracle I had to create a new tablespace and a 
temporary tablespace for the database and a dba user for that tablespace.
Like this:

Create Tablespace TYPO3
Datafile 'C:\oracle\oradata\typo3\typo3.dbf'
Size 200M Autoextend On;

Create Temporary Tablespace TYPO3TEMP
Tempfile 'C:\oracle\oradata\typo3\typo3temp.dbf'
Size 10M Autoextend On;

Create User admin Identified By admin
Default Tablespace TYPO3
Temporary Tablespace TYPO3TEMP;

Grant dba to admin;

I could achieve it using typo3wamp.

If someone has a cuestion... let me know, this is my email: 
sp_galindo at hotmail.com

greetings




_________________________________________________________________
La vida de los famosos al desnudo en MSN Entretenimiento
http://entretenimiento.es.msn.com/