Thales Pereira asked 12 years ago
Hi,
After setting up with success tests with mysql and postgresq, i'm having some difficulties to set up a oracle 10g connection.
excluding the queries, the config i have at moment is:
$db_conf["type"] = "oci8"; // mysql,oci8(for oracle),mssql,postgres,sybase
$db_conf["server"] = "localhost:1521";
$db_conf["user"] = "adm";
$db_conf["password"] = "somepass";
$db_conf["database"] = "TESTDB";
error received:
Couldn't execute query. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor – SELECT * FROM ( SELECT rownum rnum,a.* FROM (SELECT ENV,ISERVER from CMTOOLS_ISERVERS WHERE 1=1) a ) WHERE rnum BETWEEN 0 AND 1
Regards.
Abu Ghufran answered 12 years ago
Hi Thales,
This is perhaps something related to database config. See following urls.
Let me know if you have checked following recommendations.
http://ora-12514.ora-code.com/
http://stackoverflow.com/questions/12532939/ora-12514-errortns-listener-error
https://forums.oracle.com/forums/thread.jspa?threadID=2488394
Regards,
Samsun answered 12 years ago
May error in $db_conf["database"] = "TESTDB";
Database mean oracle service or SID, if use Oracle Express is XE.
Regards,
Samsun
Thales Pereira answered 12 years ago
Hello,
Basic and simple.
i just had to remove the line $db_conf["server"] = $DB_HOST,
Maybe it have some conflict.
Its working now =)
