Mir Sayeed Hassan – Oracle Blog

Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE).

Here will implement Transparent Data Encryption method in our Oracle 19c Test Environment, The Database should contain the Pluggable database init.

Check the database status, name , version of Oracle database

SYS @ ora19cdb > select status,version,... 
Read more..			

How to use the Proxy only connect in Oracle Database 19c

Usage of the proxy only connect as if you want the application schema can be only access through a proxy user, in this case no user connects directly to the application schema even though if you known the user password.

Check the status of database

SYS @ ora19cdb > select status,... 
Read more..			

Export Dumpfile error with ORA-31617: unable to open dump file for write in RAC Database

Error occur while performing the Schema export in RAC Database.

Error Occur.

ORA-31693: Table data object "PRG1"."IRM":"P1575" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/SWITCHBKP/DUMPBKP/PRG1_08042024_07.dmp"... 
Read more..			

Configuration & Generating database report with DBSAT in Oracle 19C

Brief about DBSTAT:

– The Oracle Database Security Assessment Tool (DBSAT) is a command-line tool focused on detecting potential security vulnerabilities in database.
– This tool provides insight into the current status of users, roles, permissions, and security...
Read more..

Various methods to STARTUP,SHUTDOWN the Container(CDB) and Pluggable Databases(PDBs) in Oracle 19C

STARTUP CONTAINER AND PLUGGABLE DATABASES

Check the database env at OS Level

[oracle@ora19c ~]$ cat /etc/oratab | grep -i ora19cdb
ora19cdb:/u01/app/oracle/product/19.3.0/db_1:N

Set the above database env

[oracle@ora19c ~]$... 
Read more..			

How to install a RPM Linux Packages by using the Ansible Playbook

Install the yum package on same workstation ansible server

Create a directory

[root@test-ansible ~]# mkdir /home/ansible

Create a file as “inventory”

[root@test-ansible ansible]# vi inventory
192.168.***.131
:wq

Note: You can assign...
Read more..