My database is 184.108.40.206 and 220.127.116.11 with TDE tablespace encryption, ASM db storage.
The wallet needs to be opened for MRP to work in physical standby database. I already have the solution for the primary instances to automate wallet open (e.g. using startup trigger for 18.104.22.168). However, I cannot find solution to automate wallet open operation in standby instances (to issue ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY ""').
Manual operation everytime standby instance is started is not feasible. Has anyone come across the solution for this?
You can create auto open wallet (open owm utility, go to File -> Open (to open your wallet in owm), then go to File -> Auto Login (check) then go to File -> Save). You can do this on primary and standby instance.
Now every time database is opened, wallet will be automatically opened too. You shouldn't use triggers.