Welcome Guest, Not a member yet? Register   Sign In
ociserverversion() error

Hi there and thanks for Code Igniter framework! It's great :O

Here is my problem:

For about 2 days I am fighting with (suppose silly) error message that obstinately appears on the screen. This is the msg:

An Error Was Encountered

Unable to connect to your database server using the provided settings.

I am trying to connect with Oracle db using oci8 driver. I tested the connection on the same server with strip php code and I see another message:

Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in /usr/local/apache2/htdocs/krzysztofk/oracle.php on line 42

from time to time there's no error from oracle.php file at all and data is received from database.

Here is my oracle.php file source:

$active_group = "default";

$db['default']['hostname'] = '(DESCRIPTION =
           (ADDRESS =
        (PROTOCOL = TCP)
        (HOST =
        (PORT = 1521)
        (HASH =1111)
         (CONNECT_DATA =(SID = devtst))
$db['default']['username'] = "ap";
$db['default']['password'] = "ap";
$db['default']['database'] = "devtst";
$db['default']['dbdriver'] = "oci8";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['active_r'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";

$db['default']['hostname'] value is taken originally from tnsnames.ora config file.

I also connect with db using Oracle PL/SQL Developers (from my computer) and everything is OK.

We have apache server on Fedora Linux and oci8 is already activated there.

I understand that this is Oracle-like problem and maybe I am knocking on wrong door, but if you see any solution here, please help!

We are planning to reinstall the server next week, so I want to be sure we do not get this error next time.

Thanks for your help!

Messages In This Thread
ociserverversion() error - by El Forum - 06-22-2007, 08:22 AM

Theme © iAndrew 2016 - Forum software by © MyBB