Tag Archives: oracle

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

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

Step by Step Create ACFS File System Using RAC Commands

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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
… Read more
Database Administration, diag and trace, Linux, Oracle

How to clean diag and Trace file in Oracle Database

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

oracle clean up trace, alert, aud, listener and other log files

The path of each log file of the database
The method of viewing various Oracle logs: if it is rac, the query method under the asm instance is the same

1.View the diagnostic log:
The new diagnostic information structure of 11g and above versions, view v$diag_info information, display log directory:

show parameter diag;
select * from v$diag_info
The output example is as follows:
1 ADR Base
/u01/app/oracle
1 ADR Home
/u01/app/oracle/diag/rdbms/orcl11g/orcl11g
1 Diag Trace
/u01/app/oracle/diag/rdbms/orcl11g/orcl11g/trac
… Read more