Setting up Network Encryption in our Oracle environment is very easy, we just need to add these lines to the sqlnet.ora on server side: Ideally, on the client side we should add these too: But since ENCRYPTION_CLIENT by default is ACCEPTED, if we see this chart, connection would be encrypted (ACCEPTED – REQUESTED case) Lets... » read more
We had this error while trying to open a DB: Digging a bit on the enviroment, we noticed server had a power cut and DB did not stop gracefully. This is how we fixed: 1:- Start DB in mount and list log files: 2:- Recover Database: (we need to input the failed log file): 3:-... » read more
This is a weird case we had for a Customer where DB/PDB’s were running fine and after a restart, one of the PDB’s went to restricted YES.We don’t know why it went to restricted mode because there hasn’t been a patching activity for a while and DB had few restarts in the past with no... » read more