Yii2 connection to oracle hangs


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'=> [
      'defaultSchema' => 'RBT', //specify your schema here

Please, help me

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


Thanks arojohnson,

have I uncomment OCI8 settings in php.ini?


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

Please, help me

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