Tag Archives: 12c

Data Guard Setup Step by Step

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

SRead more

Step by Step Installation GoldenGate 12c

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  .XauthoriRead 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 Downgrade Oracle 19c Grid To 12c Grid

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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 
Read more