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