Situation:
We're running two Oracle installations (11+12) on one host (no RAC). Since we're migrating our instances step by step from 11 to 12, we're facing some issue with mkstore command. The Wallet is used for Backup and Archiving.
The sqlnet.ora (/oracle/.sqlnet.ora) looks like this:
SQLNET.WALLET_OVERRIDE=TRUE
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/oracle/product/11.2.0)))
According this, the Wallet is installed under Oracle 11.
Problem:
When I add a new Oracle 12 instance, I'm using mkstore (/oracle/product/12.1.0/dbhome_1/bin) for the Wallet in "/oracle/product/11.2.0". Before that I'm using export and oraenv command to switch between the Oracle installations.
After adding the Oracle 12 instance with mkstore (12), all Oracle 11 instances cannot use the Wallet anymore (even sqlplus is not working on the local host). This error mesage occurs:
ORA-12578: TNS:wallet open failed
The Oracle 12 instance is working. But when I modify an Oracle 11 credential via "modifyCredential" with mkstore 11 everything is working again. The Oracle 12 instances are still working.
When I add an Oracle 12 instance with mkstore 11 the TNS could not be resolved:
ORA-12154: TNS:could not resolve the connect identifier specified
But I don't want to insert an Oracle 12 database to my Oracle 11 tnsnames.ora.
Questions:
1. How can we handle this situation?
2. Is it possible to add 2 Wallet location in sqlnet.ora?