Yii Framework Forum: Problem with Oracle connection - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Problem with Oracle connection Rate Topic: -----

#1 User is offline   Fabio Mezini 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 3
  • Joined: 04-July 12

Posted 04 July 2012 - 03:29 PM

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' => 'CDbConnection',
'connectionString' => 'oci:dbname=10.10.2.220:1521/db01;charset=UTF8',
'username' => 'xxxxxx',
'password' => '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.
0

#2 User is offline   CeBe 

  • Advanced Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 486
  • Joined: 16-July 10
  • Location:Berlin. Germany

Posted 28 July 2012 - 02:18 PM

can you give a stacktrace of that error?
0

#3 User is offline   Gogo 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 37
  • Joined: 17-May 12
  • Location:Sofia

Posted 03 November 2012 - 05:34 AM

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

#4 User is offline   Gogo 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 37
  • Joined: 17-May 12
  • Location:Sofia

Posted 05 November 2012 - 12:12 PM

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

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users