Oracle SESSIONS_PER_USER
Connecting to Oracle with a proxy connection like this:
DBI->connect( $dsn, 'user[otheruser]', 'password', $option_list)
We recently updated DBI to 1.620 and DBD::Oracle to 1.44 (late last week I think). Today I saw an error that I have never seen before (but should have). "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit" You see otheruser has a profile that limits SESSIONS_PER_USER to one. We're creating between one and eleven of these database connections simultaneously in different processes.
So I tried it with the older install that was using DBI 1.616 and DBD::Oracle 1.30. I didn't receive the error so it appears that the SESSIONS_PER_USER profile limit was not being respected.
We're bumping up the SESSIONS_PER_USER where appropriate and adding some checks for this error condition now that it's being thrown.
I'm curious if anyone is aware of which change may have caused this to start working correctly?
I'm married with 2 girls. By day, I work as a Senior Design Engineer (full time Perl programmer) for EFJohnson Technologies, a Land Mobile Radio company, in the Dallas/Fort Worth area. By night, I play various games as the mood strikes me. (Lately it's CPAN smoke testing.)
I also just noticed that proxy connections are not documented in the DBD::Oracle documentation.
I feel better now (although really stupid at the same time) because it has nothing to do with the version of DBI or DBD::Oracle. We have never really tried to limit the kernel resources so RESOURCE_LIMIT is set to false on all of our servers but one. That one being the dev box running our latest install.