ORA-12582: TNS invalid operation

Hi,

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 12.1.0.2

workaround:

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.

_diag_adr_enabled=FALSE

and/or:

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.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/