Archive

March, 2010Archive for

ORA-00018 or ORA-12516 or ORA-12571 (Symfony & PDO & PHP)

March 1, 2010 admin No comments
PropelException: Unable to open PDO connection [wrapped: SQLSTATE[01002]: OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
 (ext\pdo_oci\oci_driver.c:632)]
PropelException: Unable to open PDO connection [wrapped: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12516: TNS:listener could not find available handler with matching protocol stack (ext\pdo_oci\oci_driver.c:581)]
PropelException: Unable to open PDO connection [wrapped: SQLSTATE[HY000]: OCISessionBegin: ORA-12571: TNS:packet writer failure (ext\pdo_oci\oci_driver.c:632)]
cd $ORACLE_HOME
su oracle -c "./bin/sqlplus \"/as sysdba\""
show parameter session
show parameter processes
alter system set processes=200 scope=spfile;
shutdown immediate
startup
show parameter session
show parameter processes
Categories: Oracle, PHP, Symfony, Troubleshooting Tags: