Archive

Archive for the ‘Symfony’ Category

Tuning PHP for Symfony (CentOS 5.4)

May 6, 2010 admin No comments
# vi /etc/php.ini

Replace

...
upload_max_filesize = 200M
...
memory_limit = 1024M
max_execution_time = 900
...
short_open_tag = Off
...
post_max_size = 80M
# /etc/init.d/httpd restart
Categories: PHP, Symfony Tags:

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: