Zend Framework 2 - Setup Oracle DB connection

gistfile1.php

<?PHP

return array(
  'adapters' => array(
    'db' => array(
      'connection1' => array(
        'driver' => 'Oci8',
        'connection' => 'orcl',
        'username' => 'username',
        'password' => 'password',
        'character_set' => 'AL32UTF8',
      ),
      'connection2' => array(
        'driver' => 'Oci8',
        'connection' => 'orcl',
        'username' => 'username',
        'password' => 'password',
        'character_set' => 'AL32UTF8',
    )
  )
);

gistfile2.php

<?php

return array(
  'db' => array(
    'driver' => 'Oci8',
    'connection' => 'orcl', // Name of conenction in tnsnames.ora
    'username' => 'username', // Username to access db
    'password' => 'password', // Password to access db
    
    /*
     * Explictly set the character set here or the oracle driver will create null characters where
     * special characters are used.
     */
    'character_set' => 'AL32UTF8',
  )
);