just follow the below steps top setup dataguard:

Environment Server Database Name

Production Primary 192.168.31.100 ORACLE

Production Standby 192.168.31.101 ORACLE

2.2 Setup the Primary Site (192.168.31.100)

Assumptions: The db_unique_name parameter has to be set to ORACLE_A in the initORACLE.ora.

Step Procedure

1.Logon to the dm3cvs server has the oradpi user

Confirm that the ORACLE_SID and ORACLE_BASE environment variables are set properly

ORACLE_BASE= /u01/app/oracle

ORACLE_SID= ORACLE

$ env | grep ORA

2.Start a sqlplus session connected as sysdba

$ sqlplus / as sysdba

S… Read more

Golden Gate, Oracle

Step by Step Installation GoldenGate 12c

July 6, 2021 fouaddba Leave a comment

Installation Goldengate on 12c linux 7.7

Step1: – Create directory for the software and extract it to the directory

root@dbaserver1 ~]# su – oracle

Last login: Fri Jun 11 19:30:59 IST 2021 on pts/0

[oracle@dbaserver1 ~]$ mkdir -p /home/oracle/app/oracle/product/gg

[oracle@dbaserver1 u01]$ cd /home/oracle/app/oracle/product

Step2: – Enter the goldengate home in bash_profile

[oracle@dbaserver1 ~]$ ls -a

. .. .bash_history .bash_logout .bash_profile .bashrc .cache .config .java .local .mozilla .oracle_jre_usage .ssh .viminfo .Xauthori… Read more

Golden Gate, Oracle

Step by Step Installation of 19c GoldenGate

July 6, 2021 fouaddba Leave a comment

Installation Goldengate on 19c linux 7.7

Step1: – Create directory for the software and extract it to the directory

root@dbaserver1 ~]# su – oracle
Last login: Thu May 20 19:30:59 IST 2021 on pts/0
[oracle@dbaserver1 ~]$ mkdir -p /u01/app/oracle/product/gg
[oracle@dbaserver1 u01]$ cd /u01/app/oracle/product

Step2: – Enter the goldengate home in bash_profile

[oracle@dbaserver1 ~]$ ls -a

. .. .bash_history .bash_logout .bash_profile .bashrc .cache .config .java .local .mozilla

.oracle_jre_usage .ssh .viminfo .Xauthority

[oracle@dbaserv… Read more

Grid Infrastructure, Linux, Oracle, Silent Installation

How to install Oracle 18c in silent mode

June 1, 2021 fouaddba 1 Comment

installation Of Oracle 18c in silent mode

This installation is for:

Oracle Linux Server release 7.7
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0

Disabling SELINUX:

[root@dba18 ~]# vi /etc/selinux/config
[root@dba18 ~]# cat /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted

Disabling the Firewall:

[root@dba18 ~]# service firewalld stop
Redirecting to /bin/systemctl stop firewalld.service
[root@dba18 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/syst

Linux

Installing Oracle18c Grid Infrastructure for New cluster

June 1, 2021 fouaddba Leave a comment

After Installation of oracle 18c binaries

If you haven’t install 18c Please go through with the links: https://fouaddba.com/installation-of-18c-oracle-binaries-and-database-at-same-time/

Setup Grid user Profile
$ vi .bash_profile
...
umask 022

ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/18.3.0/grid
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_BASE/bin:$ORACLE_HOME/bin
export PATH ORACLE_SID ORACLE_BASE ORACLE_HOME

Grid software is unzipped and installed in the Grid Home directory. In this case ‘/u01/app/18.3.0/grid/’.… Read more

Linux, Oracle, ssh key

Generating a SSH key pair using the PuTTY Key Generator

May 26, 2021 fouaddba Leave a comment

How To generate a SSH key pair using PuTTY Key Generator,

1. Find puttygen.exe in the PuTTY folder on your computer, for example, C:\Program Files (x86)\PuTTY. Double-click puttygen.exe to open it.

2. Accept the default key type, SSH-2 RSA.
SSH-2 is the most recent version of the SSH protocol (and is incompatible with SSH-1). RSA and DSA are algorithms for computing digital signatures

3. Set the Number of bits in a generated key to 2048 bits, if it is not already set with that value.
This sets the size of your key and thus the security level. A minimum of 2048 bits is recommended for SSH-2 RSA.

4. Cli… Read more

Database Administration, diag and trace, Grid Infrastructure, Linux, Oracle

How to Delete alert log files, Trace Files Automated in Oracle Database

May 22, 2021 fouaddba Leave a comment

Deleting alert log files, Trace Files Automated in Oracle Database

[oracle@localhost ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Tue Mar 7 10:42:16 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/grid"
adrci> show homes
ADR Homes:
diag/rdbms/_mgmtdb/-MGMTDB
diag/asm/+asm/+ASM2
diag/clients/user_root/host_1450230238_82
diag/clients/user_grid/host_1450230238_82
diag/crs/node2/crs
diag/tnslsnr/node2/mgmtlsnr
diag/tnslsnr/node2/listener
diag/tnslsnr/node2/listener_scan1
adrci> show h