Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me




  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for the 'DBA Administration' Category

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

Posted by Mir Sayeed Hassan on 23rd April 2024

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..

Posted in DBA Administration | No Comments »

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

Posted by Mir Sayeed Hassan on 17th April 2024

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 Read More

Posted in DBA Administration | No Comments »

Configuration & Generating database report with DBSAT in Oracle 19C

Posted by Mir Sayeed Hassan on 6th April 2024

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..

Posted in DBA Administration | No Comments »

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

Posted by Mir Sayeed Hassan on 24th March 2024

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..

Posted in DBA Administration | Comments Off on Various methods to STARTUP,SHUTDOWN the Container(CDB) and Pluggable Databases(PDBs) in Oracle 19C

How to set up the Oracle Wallets in Oracle Database 21C/19C

Posted by Mir Sayeed Hassan on 1st November 2023

How to set up the Oracle Wallets in Oracle Database Brief about the Oracle Wallets The Oracle Wallet is a container or we can called it as repository that stores authentication and credentials such as certificates, certificate requests, and private keys., By using this we can connect to db without providing the schema name & Read More

Posted in DBA Administration | Comments Off on How to set up the Oracle Wallets in Oracle Database 21C/19C

How to Install Docker on UBUNTU Server

Posted by Mir Sayeed Hassan on 1st November 2023

How to Install Docker on UBUNTU Server Check the IP address to assign into the resolv.conf file nameserver 178.22.***.*** ubuntu@mir-docker-test:~$ sudo cat /etc/resolv.conf nameserver 178.22.***.***— this file is added nameserver 127.0.0.53 options edns0 search openstacklocal This command will remove if any Docker is… Read more..

Posted in DBA Administration | Comments Off on How to Install Docker on UBUNTU Server