Mir Sayeed Hassan – Oracle Blog

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

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

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

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

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