Yii2 connection to oracle hangs

Yii 2.0 General Discussions
1

Hi,

when I log in and connectiong to oracle, connection hangs. My db config:

'class' => 'yii\db\Connection',
'dsn' => 'oci:dbname=//******/TEST;charset=AL32UTF8',
'username' => '******',
'password' => '******',

// Schema cache options (for production environment)
'enableSchemaCache' => true,
'schemaCacheDuration' => 3600,
'schemaCache' => 'cache',
'attributes' => array(PDO::ATTR_CASE => PDO::CASE_UPPER),
'enableLogging' => true,
'schemaMap' => [
    'oci'=> [
      'class'=>'yii\db\oci\Schema',
      'defaultSchema' => 'RBT', //specify your schema here
    ],
],

Please, help me

2

Hi There,

May be the issue is retrieving AR records as the ORACLE DB approaches different way as it’s may have highly scaled data.

Think link may helpful : https://www.yiiframework.com/wiki/118/increasing-ar-performance-in-connections-with-oracle

Cheers!

3

Thanks arojohnson,

have I uncomment OCI8 settings in php.ini?

4

Hi,

problem is not resolved yet. I work with oracle client 64 (not instant client).

Please, help me

5

Yes you must have to enable as it’s driver important