Error Oracle Step4 Database

[bibi92]

Hi,

I have this error when I try to setup Elxis on Oracle Database :

Warning: ocilogon() [function.ocilogon]: ORA-12154: TNS:could not resolve the connect identifier specified in C:\wamp\www\elxis_2009\includes\adodb\drivers\adodb-oci8.inc.php on line 228

Do you have a solutions,please ?

Thanks

Regards

Bibi92

[datahell]

Take a look here:
http://ora-12154.ora-code.com/
and here:
http://www.orafaq.com/wiki/ORA-12154

[bibi92]

Hi,

Thanks
Elxis is installed on another machine.
How it is possible to use the tns via the interface ?

Thanks

Regards

Bibi92

[datahell]

You should ask an Oracle expert. I am not such a guy

[bibi92]

Hi,

Thanks
I'm dba Oracle but  how I can configure the db connection settings with :

Enter the database name or pathway. To avoid problems creating the database by the Elxis installer make sure database already exists., I use Oracle SID, but where can I use tnsnames.ora, please or which php file I have to modify ?

Thanks

Regards

Bibi92

[bibi92]

Hi,

is it possible de setup elxis if the oracle db is on another machine ?

Thanks

Regards

Bibi92

[datahell]

Yes, but I guess you have to permit that in db settings.

[bibi92]

Hi,

Thanks, exactly, I don't understand why It doesn't work, which php file have I to modify ?

Regards

Bibi

[datahell]

Here is my local settings for oracle

$mosConfig_host = 'localhost';
$mosConfig_user = 'xxxxx';
$mosConfig_password = 'xxxxx';
$mosConfig_db = 'elxis';
$mosConfig_dbtype = 'oci8';

And it just works....
If the database is on an other machine then you have to set he proper value for the $mosConfig_host parameter.

Elxis database handler: includes/Core/database.php
ADOdb: includes/adodb/adodb.inc.php
oci8 ADOdb extension: includes/adodb/drivers/adodb-oci8.inc.php

[bibi92]

Thanks, But which php file I have to modify ?

Regards

Bibi

[bibi92]

Sorry, You have always reply to my question.

Regards

Bibi

[bibi92]

Thanks, I have another error now :

Deprecated: Function ereg() is deprecated in C:\wamp\www\elxis_2009\installation\includes\elxisinstaller.php on line 419


Regards

Bibi

[datahell]

You use php 5.3 or php 6....
ereg functions are deprecated in these versions....
Elxis is not yet ready for php 5.3/6. Use php 5.2

[fhahim987]

I'm dba Oracle but  how I can configure the db connection settings with :

Enter the database name or pathway. To avoid problems creating the database by the Elxis installer make sure database already exists., I use Oracle SID, but where can I use tnsnames.ora, please or which php file I have to modify ?

[datahell]

I guess you want to SPAM rather than ask.