Koneksi Database Oracle di CodeIgniter

Buka nama Project/application/config/database.php

Masukan data-data berikut ini :

1. Masukan Host IP
2. Masukan Port
3. Masukan Server
4. Masukan Service_name
5. Masukan Username Database
6. Masukan Password Database


$active_group = ‘default’;
$query_builder = TRUE;
$tnsname = ‘(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XXX.XX)(PORT = XXXX))
)
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = XXXXXX)
(SERVICE_NAME = XXXX)
)
)’;

$db[‘default’][‘hostname’] = $tnsname;
$db[‘default’][‘username’] = ‘username‘;
$db[‘default’][‘password’] = ‘password‘;
$db[‘default’][‘database’] = ”;
$db[‘default’][‘dbdriver’] = ‘oci8’;
$db[‘default’][‘dbprefix’] = ”;
$db[‘default’][‘pconnect’] = TRUE;
$db[‘default’][‘db_debug’] = TRUE;
$db[‘default’][‘cache_on’] = FALSE;
$db[‘default’][‘cachedir’] = ”;
$db[‘default’][‘char_set’] = ‘utf8’;
$db[‘default’][‘dbcollat’] = ‘utf8_general_ci’;
$db[‘default’][‘swap_pre’] = ”;
$db[‘default’][‘autoinit’] = TRUE;
$db[‘default’][‘stricton’] = FALSE;