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
Data Guard Protection Modes in oracle: In this article we will discuss about Data Guard Protection Modes in oracle. In some situations, a business cannot afford to lose data. In other situations, the availability of the database may be more important than the loss of data. Some applications require maximum database performance and can tolerate … Read more
Oracle Data Guard Concepts: during this article we are going to discuss about Oracle Data Guard Concepts. The main features of Oracle data guard is A Data guard configuration consists of 1 primary database and one or more standby database. The standby databases are always in sync with primary database. If primary production database is unavailable because of planned or unplanned outage , then we … 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
Changing Database Name in ORACLE: During this article we’ll discuss about a way to Changing Database Name in ORACLE Database. Question: 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 after we select instance_name from v$instance? what’s the right methods to … Read more
Changing the Archive Log Destination in Oracle: During this article we’ll see the way to Changing the Archive Log Destination in Oracle Database. If your present mount point for archivelog destination is going to FULL or for the other reason, you wish to alter the archivelog destination in the database, then follow the below steps. … Read more
How to Deinstall Oracle 12c Database and Binaries in Linux: During this article we’ll see the way to Deinstall Oracle 12c Binaries from your Linux machine. Note : You’ll run the deinstall command from an home directory after installation. Please always keep in mind this command will also delete or remove your databases and it’s … Read more
