//Message: oci_connect(): ORA-01017: invalid username/password; logon denied
$db['default'] = array(
'dsn' => 'oci:dbname=(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb)
)
)',
'port' => 1521,
'hostname' => '',
'username' => 'hr',
'password' => 'hr',
'database' => '',
'dbdriver' => 'oci8',
'dbprefix' => '',
'pconnect' => FALSE,
);
//and this
$db['default'] = array(
'dsn' => 'oci:dbname=localhost/orclpdb',
'port' => 1521,
'hostname' => '',
'username' => 'hr',
'password' => 'hr',
'database' => '',
'dbdriver' => 'oci8',
'dbprefix' => '',
'pconnect' => FALSE,
//Message: oci_execute(): ORA-00942: table or view does not exist
$db['default'] = array(
'dsn' => '',
'port' => 1521,
'hostname' => 'localhost',
'username' => 'hr',
'password' => 'hr',
'database' => 'orclpdb',
'dbdriver' => 'oci8',
'dbprefix' => '',
'pconnect' => FALSE,
//and this
$db['default'] = array(
'dsn' => 'oci:dbname=localhost/orclpdb',
'port' => 1521,
'hostname' => 'localhost',
'username' => 'hr',
'password' => 'hr',
'database' => 'orclpdb',
'dbdriver' => 'oci8',
'dbprefix' => '',
'pconnect' => FALSE,
//and this
$dbhost = "127.0.0.1"; //host
$dbport= "1521"; //port default is 1521
$dbname = "orclpdb"; //name of database
$dbuser = "hr"; //db user with all priviliges
$dbpassword = "hr"; // password of user
$dbConnString = "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ". $dbhost .")(PORT = ". $dbport ."))
)(CONNECT_DATA =(SERVICE_NAME = ". $dbname .")))"; // connection string for this we must create TNS entry for Oracle
$db['default']['hostname'] = $dbConnString;
$db['default']['username'] = $dbuser;
$db['default']['password'] = $dbpassword;
$db['default']['database'] = "";
$db['default']['dbdriver'] = "oci8";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";