Oracle 10g connection

QuestionsOracle 10g connection
Thales Pereira asked 8 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.

3 Answers
Abu Ghufran answered 8 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 8 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 8 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 =)

Your Answer

6 + 3 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?