Sometimes You can get “ORA-12582: TNS:invalid operation ” error.
Details of error are as follows.
ORA-12582: TNS:invalid operation
Issue is identified as ‘Unpublished’ Bug 18650329 : OGG:CDB: RMAN ACTIVE FAILS WITH ORA-12582: TNS:INVALID OPERATION
Bug is fixed in 126.96.36.199
add SQLNET.USE_ZERO_COPY_IO=0 to sqlnet.ora
The second case is related with this error is as follows.
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.
974 views last month, 1 views today