Tag Archives: linux

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

Acfs, Database Administration, Linux, node, Oracle, RAC

Step by Step Create ACFS File System Using RAC Commands

May 21, 2021 fouaddba Leave a comment

ACFS Oracle ASM Cluster File System is cluster file system service used for High availability services.
Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS for goldengate relate files.
In this article, we will show how to create a ACFS file system in oracle RAC using command line.

ENVIRONMENT DETAILS

ORACLE GRID VERSION – 12.1.0.2
NODES – NODE3 , NODE4
OS – Linux OEL

1.Create an ASM DISKGROUP( ON NODE 3)

echo $ORACLE_HOME
/crsapp/app/oracle/product/grid12c

echo $ORACLE_SID
+ASM1

sqlplus / as sysasm

SQL> CREATE DISKGROUP ACFSPOC EXTERNAL REDUNDANCY
D

How to configure Logminer in oracle step by step

May 15, 2021 fouaddba 58 Comments

LOGMINER :-

Logminer is a utility provided with the Oracle database server which mines the redologs or Archivelogs and data dictionary information to build the SQL statements and keeps the contents of the redolog file in the fixed view called ” V$logmnr_contents “.
LogMiner tool can help the DBA to the find changed records in redo log files by using a set of PL/SQL procedures and functions .
Internally Oracle uses the Log Miner technology for several other features,such as Flashback Transaction Backout,Streams, and Logical Standby Databases .Most often LogMiner is used for recovery purpo… Read more

Database Administration, Grid Infrastructure, Linux, node, Oracle

How To Downgrade Oracle 19c Grid To 12c Grid

May 12, 2021 fouaddba 1 Comment

In the pervious article we have explained the Upgrade Grid Infrastructure 12c To 19c Oracle Now We will explain the steps for downgrade oracle 19c 2 node GRID to oracle 12.1.0.2 GRID.

ENVIRONMENT DETAILS:
2 NODES – localhost1 and localhost2
Grid owner – oracle
19C ORACLE_HOME(current) – > /sharearea/crs/grid19c
12C ORACLE_HOME (old) -> /crs/app/oracle/product/grid12c

1. Check the current grid version:( check on both the nodes)

oracle@localhost1:/$ crsctl query crs softwareversion
Oracle Clusterware version on node [dbhost1] is [19.0.0.0.0]
oracle@localhost1:$ crsctl

Upgrade Grid Infrastructure 12c To 19c Oracle

May 11, 2021 fouaddba 4 Comments

The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c . The upgrade will be done in rolling mode.

Current configuration – >

No of nodes – 2 node
current version – 12.1.0.2
os platform – Linux
grid owner – oracle

Check software version :

oracle@node1~$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]

oracle@node2~$ crsctl query crs softwareversion
Oracle Clusterware version on node node1 is [12.1.0.2.0]

2. Download the software and unzip on your first … Read more