Welcome Guest, Not a member yet? Register   Sign In
getting message: oci_execute(): ORA-00942: table or view does not exist
#20

(This post was last modified: 11-14-2018, 09:49 PM by Ahmed Haroon.)

(11-14-2018, 09:46 AM)php_rocs Wrote: @ahmed Haroon,

How is Oracle configured with PHP?  What does your PHP.ini file say for oracle?

i have modified php.ini file ( in C:\wamp64\bin\apache\apache2.4.35\bin ), line un-remarked for
extension=oci8_12c

is there anything else to do in this file, i don't know about. i have tried various entries found on web but didn't worked yet. the following entries i have to mention with Error messages: ( now i removed entry in database.php for mysql and keep for oracle only as default and here i am posting partial entries to avoid long list )
PHP Code:
//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"
Reply


Messages In This Thread
RE: getting message: oci_execute(): ORA-00942: table or view does not exist - by Ahmed Haroon - 11-14-2018, 09:48 PM



Theme © iAndrew 2016 - Forum software by © MyBB