Running sp_wallet in auto-open mode on target results in “oraerr = 942” and “Probably internal failure” (4298440)

Running sp_wallet in auto-open mode on target results in “oraerr = 942” and “Probably internal failure”

The following errors are observed when Running sp_wallet in AUTO-OPEN MODE on a target:

$./sp_wallet --auto-open     (where $ denotes the OS prompt)

Enter Oracle SID (or TNS alias if RAC) [SID]:     (here SID is the Oracle SID of the database on this server)

Enter wallet password:

Loading wallet into SharePlex as well

oraerr = 942

Probably internal failure

The running of sp_wallet is successful, though:

$./sp_wallet

Enter Oracle SID (or TNS alias if RAC) [SID]:

Enter wallet password:

Wallet loaded into SharePlex

On target (with no Capture) the running of sp_wallet is not required or supported

On target the running of sp_wallet is not required nor is it used, as SharePlex does not read the redo/archive logs. In our case running sp_wallet in auto-open mode fails and running sp_wallet without it succeeds. But SharePlex will not use the credentials for wallet file supplied by running sp_wallet. This is only required on source.

The following excerpt are taken from Reference Guide that describe the utility: sp_wallet Description Use the sp_wallet utility to provide the Oracle Wallet password to SharePlex. SharePlex uses the wallet password to access the TDE Master Encryption Key. SharePlex uses the TDE Master Encryption Key to decrypt TDE-protected data in the redo log that must be replicated. Grant read permission on the Oracle Wallet file to the dba group before using sp_wallet. Supported databases Oracle on Unix, Linux, and Windows Run sp_wallet To run sp_wallet and manually supply the password 1. On the source system, start SharePlex from the SharePlex product directory. You are prompted to run sp_wallet. *** To enable TDE replication, run sp_wallet and provide the wallet password *** 2. Run sp_wallet. ./sp_wallet [-r port_number] IMPORTANT! On Windows, if you installed SharePlex on any port other than the default of 2100, use the -r option to specify the port number. For example, in the following command the port number is 9400: ./sp_wallet -r 9400 wallet password: walletpw Wallet loaded into SharePlex To run sp_wallet in auto-open mode If you are using an auto-open wallet, you can configure SharePlex to open the TDE wallet automatically. This eliminates the need to run sp_wallet manually at SharePlex startup. The syntax is: ./sp_wallet --auto-open [-r port_number] IMPORTANT! Using the auto-open wallet feature has additional security considerations. See the Oracle documentation for more information. In addition, do not back up the SharePlex variable-data directory together with the Oracle wallet and the Oracle data files.