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 November, 2023

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

Posted by Mir Sayeed Hassan on 22nd November 2023

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

Posted in UNIX for DBA | Comments Off on How to install a RPM Linux Packages by using the Ansible Playbook

Basic understandbing of the SSH, SSH-KEYGEN, SSH-COPY-ID

Posted by Mir Sayeed Hassan on 21st November 2023

Basic understandbing of the SSH, SSH-KEYGEN, SSH-COPY-ID Before you proceed make sure the OpenSSH is Installed on your server. 1st time when you connect with the server as SSH “Prompt yes” [s.hassan@test-ansible ~]$ ssh 192.168.***.131 The authenticity of host ‘192.168.***.131 (192.168.***.131)’ can’t be established. ECDSA… Read more..

Posted in UNIX for DBA | Comments Off on Basic understandbing of the SSH, SSH-KEYGEN, SSH-COPY-ID

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

Apply the latest DB RU Patch_19.20 (35320081) on Oracle Database 19C

Posted by Mir Sayeed Hassan on 1st November 2023

Apply the latest DB RU Patch_19.20 (35320081) on 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 —————- —————————— testdb1 19.0.0.0.0 READ WRITE Verify the lastest OPatch… Read more..

Posted in DB Patch | Comments Off on Apply the latest DB RU Patch_19.20 (35320081) on Oracle Database 19C