Data Guard, Oracle

Data Guard Setup Step by Step

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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

1 Comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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
… Read more
Linux, Oracle, ssh key

Generating a SSH key pair using the PuTTY Key Generator

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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
… Read more
Linux, Oracle, Single Instance

Step by Step Installation of Oracle 19c binaries in linux 7.7

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 19cbinaries

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 /usr/bin/python2 … Read more