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

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

Step by Step Create ACFS File System Using RAC Commands

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

How to clean diag and Trace file in Oracle Database

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

Plugging an Unplugged Pluggable Database with No copy method

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.
We are going to unplug the PDB to plug them with No copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
----------------
Read more

Plugging an Unplugged Pluggable Database with copy method

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.

We are going to unplug the PDB to plug them with Copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
------------------
Read more

Upgrade RAC Grid and Database from 11g To 12c

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Main steps:
Grid: –
1. Check all services are up and running from 11gR2 GRID_HOME
2. Perform backup of OCR, voting disk and Database.
3. Create new directory for installing 12C software on both RAC nodes.
4. Run “runcluvfy.sh” to verify errors.
5. Install and upgrade GRID from 11gR2 to 12cR1
6. Verify upgrade version
Database: –
1. Backup the database before the upgrade
2. Database upgrade Pre-check
Creating Stage for 12c database software
Creating directory for 12c oracle home
Check the pre upgrade status.
3.Unzip 12c database software in stage
4Install the 12.1.0.2 using the … Read more

How to configure Logminer in oracle step by step

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail
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 purpoRead more