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

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

Posted by Mir Sayeed Hassan on November 21st, 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 November 1st, 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 & password, Password will...
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 November 1st, 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 November 1st, 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

Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19c

Posted by Mir Sayeed Hassan on October 31st, 2023

Apply the Latest OPatch (12.2.0.1.40) 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
----------------------------------------------
testdb1            19.0.0.0.0      READ WRITE

Check the last updated OPatch

[oracle@test19cdb... 
Read more..

Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19c

Installation of Ansible Packages on Oracle Linux 7

Posted by Mir Sayeed Hassan on October 29th, 2023

Installation of Ansible Packages in Oracle Linux

Download the below require Packages to configure ansible.

[root@ansible-test]# cd /u02/SOURCE/RPM_PKG/ansible/

[root@ansible-test]# ll
total 17808
-rwxrwxrwx. 1 root root 17832207 Oct 29 15:26 ansible-2.9.27-1.el7.noarch (2).rpm
-rwxrwxrwx. 1 root root 42303 Oct 29 15:26 python2-jmespath-0.9.4-2.el7.noarch... 
Read more..

Posted in DBA Administration | Comments Off on Installation of Ansible Packages on Oracle Linux 7