title: yii2 with oracle and pdo_oci error ORA-01804
body: <p>Oracle 12c.
  I can connect remotely to DB with sqldeveloper.
  I can connect with sqlplus to DB.</p>
  
  <p>I can't make gii to work, shows error: </p>
  
  <blockquote>
    <p>Caused by: PDOException
    SQLSTATE[HY000]: pdo_oci_handle_factory: Error while trying to retrieve text for error ORA-01804
    (/root/rpmbuild/BUILD/php-5.4.1/ext/pdo_oci/oci_driver.c:631)</p>
  </blockquote>
  
  <p>This php code generates the same error:</p>
  
  <pre><code>  1 &lt;?php
    2         $param = $_POST;
    3         $db_username = "&lt;my username&gt;";
    4         $db_password = "&lt;my password&gt;";
    5         $db = "oci:dbname=ORCL";
    6 try{
    7         $conn = new PDO($db,$db_username,$db_password);
    8         $stmt = $conn-&gt;exec("select * from employee;");
    9 }catch(PDOException $e){
   10         echo ($e-&gt;getMessage());
   11 }
   12
   13 ?&gt;
  </code></pre>
  
  <p>My phpinfo.php shows: PDO driver sdblib, firebird, mysql, oci, odbc, pgsql, sqlite 
  but <strong>php -i | grep pdo</strong> doesn't show pdo_oci</p>
  
  <p>In phpinfo.php under the title "PDO_OCI" it has no entries. Just the title and column titles "PDO Driver for OCI 8 and later"   "enabled" no more rows with data.</p>
  
  <p>I've added "--with-pdo-oci=shared,$ORACLE_HOME" to configure php compilation and added "extension=pdo_oci.so" to a file called /etc/php.d/pdo_oci.ini</p>
  
  <p>Also this is my oracle timezone folder:</p>
  
  <pre><code> # ls /base/product/12.1.0/db_1/oracore/zoneinfo/
  big              timezlrg_11.dat  timezlrg_16.dat  timezlrg_3.dat  timezlrg_8.dat   timezone_12.dat  timezone_17.dat  timezone_4.dat  timezone_9.dat
  little           timezlrg_12.dat  timezlrg_17.dat  timezlrg_4.dat  timezlrg_9.dat   timezone_13.dat  timezone_18.dat  timezone_5.dat  timezone.dat
  readme.txt       timezlrg_13.dat  timezlrg_18.dat  timezlrg_5.dat  timezlrg.dat     timezone_14.dat  timezone_1.dat   timezone_6.dat
  timezdif.csv     timezlrg_14.dat  timezlrg_1.dat   timezlrg_6.dat  timezone_10.dat  timezone_15.dat  timezone_2.dat   timezone_7.dat
  timezlrg_10.dat  timezlrg_15.dat  timezlrg_2.dat   timezlrg_7.dat  timezone_11.dat  timezone_16.dat  timezone_3.dat   timezone_8.dat
  </code></pre>
  
  <p>timezone.dat and timezonelrg.dat are symbolic links to the biggest sufix counterpart.</p>
  
  <p>Any help will be appreciated. </p>