Issue Bug Closed

#20417Cannot connect to non-local Oracle database with SID

Xavier Perseguers 05/13/09, 14:04 updated 11/07/09, 19:25

Description

When accessing an external Oracle database (ie not on localhost), we have either to use

$typo_db_username = ‘username’;
$typo_db_password = ‘password’;
$typo_db_host = ‘somehost.domain’;
$typo_db = ‘servicename’;

or

$typo_db_username = ‘username’;
$typo_db_password = ‘password’;
$typo_db_host = ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=somehost.domain)(PORT=1521))(CONNECT_DATA=(SID=somesid)))’;
$typo_db = ‘’;

But then TYPO3 complains that no database was selected although it works!

To connect to an external with a SID, the trick is to use

$typo_db_username = ‘username’;
$typo_db_password = ‘password’;
$typo_db_host = ‘somehost.domain’;
$typo_db = ‘somesid’;

AND modify file ‘typo3/sysext/adodb/adodb/driversadodb-oci8.inc.php’ to set

var $connectSID = true;

instead of

var $connectSID = false;

What would be great is to be able to set this variable without modifying the ADOdb source from within localconf.php.

(issue imported from #M11076)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.