Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c This scenario is to test the encryption method while performing the backup & restore operation. Connect to Database [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Nov 8 04:03:38 2022 Version 19.3.0.0.0 Copyright… Read more..

How to check the Failed Login Attempts in Oracle Database. Assume you or someone else has logged to the database with failed username & password. SQL> connect systest/alksflkagf ERROR: ORA-01017: invalid username/password; logon denied Lets try to find out the failed login attempt with time based Query to find the time based… Read more..

How to generate the ramdon User Password in Oracle Database Note: – Password should be 12 characters in length or as per the organization. – Password should include at least one uppercase letter, one lower case letter, one number and one special character (&*(){}|[]+<>!@#$%^?). SQL> select translate(dbms_random.string(‘a’,… Read more..

Apply the Latest DB RU Patch 34419443 onOracle Database 19c Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ——————————————— proddb 19.0.0.0.0 READ WRITE Download the Patch from below link https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=ym4c1dobw_120&_afrLoop=189225645173189 Transfer… Read more..

Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ————– oemswdb 19.0.0.0.0 READ WRITE Check the last updated OPatch [oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch… Read more..