20100204

PHP Oracle [notice] child pid NNNN exit signal Bus error (10)

After some frustration I learned from a forum post that the default password time limit for Oracle 11g is 120 days. Once you get close to that you will go into a grace period, where PHP's oci connection dies on you with no explanation. You will notice a message like this in you apache log:
  • [notice] child pid NNNN exit signal Bus error (10) in the apache log.
Step 1: Change your password, or rather lets just keep it as it is...
  • ALTER USER myname IDENTIFIED BY mypassword
Step 2: Make us not have to do this again:
  • ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Hope this helps someone.