Yii Framework Forum

Problem with Oracle connection

Archives Bug Discussions

fabiome (Fabiomezini) July 4, 2012, 8:29pm 1

Hi all,

Im new on Yii and I was trying to connect to an Oracle db with de following error when trying to create de models by gii tool:

CDbConnection failed to open the DB connection: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12514: TNS:listener has no knowledge about the service requested in currently connection descriptor

My config file:

‘db’=>array(

'class' =&gt; 'CDbConnection',


'connectionString' =&gt; 'oci:dbname=10.10.2.220:1521/db01;charset=UTF8',


'username' =&gt; 'xxxxxx',


'password' =&gt; 'xxxxxx',

),

I have this connection working fine on another application on the same server (not in Yii, just PDO).

What m’I doing wrong?

Sorry about the bad english, Im still learning it.

CeBe July 28, 2012, 7:18pm 2

can you give a stacktrace of that error?

gogo_ve (G L Velinov) November 3, 2012, 10:34am 3

Did you fix it? Because I have the same problem.

gogo_ve (G L Velinov) November 5, 2012, 5:12pm 4

The problem in my case was from Oracle (I think). I reinstalled Oracle and things started. I don’t know why.