Sometimes You can get “TNS-12582: TNS:invalid operation ” error.
Details of error are as follows.
TNS-12582: TNS:invalid operation
The issue is related to load and overhead related to Automatic Diagnostic Repository (ADR) functionality and IO issues on the database server. The combination of these results in slowness in spawning the database shadow processes, causing number of connection requests to be queued by the TNS Listener and internal limits restrictions to be reached.
Each new shadow process that is spawned tries to create the ADR directories, even if they already exist.
This is due to Unpublished Bug:9700115 CHECK ADR DIRECTORIES EXISTENCE AND ATTRIBUTES FIRST BEFORE CREATING THEM
As a workaround, set the following initialization parameter for the 11g Database instance(s) to disable the Automatic Diagnostic Repository (ADR) mechanism.
Apply Patch:9700115 to change the behavior of the ADR to check if the subdirectories exists before it tries to create them.
Do you want to learn more details about RMAN, then read the following articles.
672 views last month, 3 views today