Users intermittently fail to log in with a `DB_SWITCH_SESSION: Could not switch database proxy session to user` error (an ORA-00022 or similar variant), even though all accounts are confirmed granted CONNECT, and the error resolves itself after one or more retry attempts.

All FAQ questions / Security and access

Answer

Check the "idle time" setting across your Oracle profiles — setting it to UNLIMITED (rather than a finite idle-timeout value) has resolved this specific intermittent database-proxy-session-switch failure in a confirmed case; a finite idle-time setting closing out sessions unexpectedly in the background has been the underlying cause behind this particular error signature, even when the more commonly-suspected CONNECT-privilege angle checks out fine.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions