"Translated from MOS article" Rman backup times: ora-02396:exceeded Maximum idle time

Rman backup times: ora-02396:exceeded Maximum idle time

References:
RMAN backup faling with ora-02396:exceeded maximum idle time, please connect again (DOC ID 1446182.1)

Suitable for:
Oracle server-enterprise edition-version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms:
Rman reports the following errors when backing up DB and Archiving logs:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============
RMAN-00571: ===========================================================
Rman-03002:failure of Backup plus archivelog command at 03/26/2012 00:19:36
RMAN-03014:IMPLICIT Resync of Recovery catalog failed
Rman-06004:oracle Error from Recovery catalog database:ora-02396:exceeded maximum idle time, please connect again
ORACLE Error from Recovery catalog Database:ora-01012:not logged on
Process id:4060
Session id:24 Serial number:23229

Reason:
ORA-02396 is most likely caused by profile (with Idle_time), which refers to the catalog owner in Recovery Catalog

When running Rman backup, Rman has little or no communication with Recovery Catalog.
Only when the Rman backup is complete, the relevant information is synchronized from the control file to the Recovery catalog, when Rman tries to update the Recovery catalog, then the error is generated.

Rman backup takes longer than the idle_time defined in the catalog user's profile, so the error occurs.

How to resolve:
Check to see if recovery catalog owner is using Idle_time profile. If used, disable or increase idle_time to a larger value

Sql> SELECT * from Dba_profiles where resource_name= ' idle_time ';

Sql> Select profile from dba_users where Username= ' <username of CATALOG owner> ';

If the profile of the user matches the profiles with a idle_time <> UNLIMITED, you should consider using a different Profile for this user with idle_time=unlimited.

sql> alter user XX profile < name of a profile> with idle_time=unlimited >

"Translated from MOS article" Rman backup times: ora-02396:exceeded Maximum idle time