Posted by Mir Sayeed Hassan on December 7th, 2022
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..
Posted in RMAN | Comments Off on Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c
Posted by Mir Sayeed Hassan on December 6th, 2022
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..
Posted in DBA Administration | Comments Off on How to check the Failed Login Attempts in Oracle Database with time based.
Posted by Mir Sayeed Hassan on December 6th, 2022
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..
Posted in Oracle SQL | Comments Off on How to generate the ramdon User Password in Oracle Database
Posted by Mir Sayeed Hassan on December 6th, 2022
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
Posted in DB Patch | Comments Off on Apply the Latest DB RU Patch 34419443 on Oracle Database 19c
Posted by Mir Sayeed Hassan on December 6th, 2022
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..
Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c
Posted by Mir Sayeed Hassan on November 16th, 2022
Learn the basic command of Oracle ASM in Oracle Database
Login to the Oracle ASM Instance
[oracle@ractest1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? +ASM1
The Oracle base remains unchanged with value /u02/app/oracle
ls – It displays the list of disk associated to single instance.
ASMCMD> ls
DATA/
Posted in ASM | Comments Off on Learn the basic Oracle ASM Command in Oracle Database
