Oracle and MySQL Database
Oracle Database 19c Installation On Oracle Linux 7 (OL7): In this article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. An example of this type of Linux installation can … Read more
Apply Patching On Oracle 19c Database Release Update 19.8.0.0.200714: In this article we will see how to Apply Patching On Oracle 19c Database Release Update 19.8.0.0.200714. For this activity you can follow Oracle Database 19c Release Update & Release Update Revision July 2020 Known Issues (Doc ID 2663985.1) Description:- This article we are going to … Read more
Multiplexing Control Files in Oracle: In this article we will discuss about Multiplexing Control Files in Oracle. This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no more difficult than … Read more
Changing the Database Archiving Mode In Oracle: In this article we will discuss how Changing the Database Archiving Mode In Oracle. There are 2 types of logging mode in oracle database: Archivelog mode : In this mode, after the online redo logs are filled , it will move to archive location. Noarchivelog mode : In … Read more
Oracle 19c Silent Installation : In this article we will discuss about Oracle 19c Silent Installation. Here we will do this installation in Oracle 19c Database (19.3.0.0). Overview : Steps: Download Software : Download the Oracle software from OTN or MOS depending on your support status. https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html Hosts File : The “/etc/hosts” file must contain … Read more
Oracle 12c Silent Installation in Linux: In this article we will discuss Oracle 12c Silent Installation in Linux. Here we see Oracle 12c(12.2.0.1) Database installation. Overview : Steps: Download Software : Download the Oracle software from OTN or MOS depending on your support status. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html Unzip Files : Hosts File : The “/etc/hosts” file must … Read more
Managing Datafiles in Oracle Database: In this article we will discuss about Managing Datafiles in Oracle Database. Guidelines for Managing Datafiles: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle Database assigns each datafile two associated … Read more
Change Flashback mode In Oracle Database: In this article we will discuss how to Change Flashback mode In Oracle Database. By using flashback technology we can restore the database to a particular point in past. It’s like time machine.Here we will see , how to enable and disable flashback in oracle.To enable flashback we need … Read more
Tablespaces and Datafiles Status in Oracle: In this article we will discuss about How to check Tablespaces and Datafiles Status in Oracle. What is an Oracle Tablespace: Oracle divides a database into one or more logical storage units called tablespaces. Each tablespace consists of one or more files called datafiles. A datafile physically stores the … Read more
Changing Database Name in ORACLE: During this article we’ll discuss about a way to Changing Database Name in ORACLE Database. Question: I need to re-name my database to vary the ORACLE_SID value. I have already changed the instance_name parameter in the parameter file mean init.ora file, but its still now at database said showing same … Read more
