This parameter is useful when you wanted get the approximate size of the dump file. Suppose you have only limited space available in the disk and if you wanted to check whether your dump will be fit into the available space then you can use this parameter to check or estimate the size of the […]
Monthly Archives: December 2017
Flashback Technology
Flashback Technology in Oracle : Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Today we will see following feature of Flashback Technology : 1. Oracle Flashback Query . 2. Flashback […]
Changing password securely in Oracle
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]
Running Oracle on Docker
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. If you want to know about Basic about Docker in the Oracle Hi everyone, here in a very brief post I will show you how to upload Oracle in a Docker container. Following the DevOps wave, this week I’m doing a course and knowing […]
Clone Database using RMAN on Windows 10
Cloning Database with RMAN : A cloning database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks to clone database: Prerequisites: You should have 2 servers , both server should have Oracle Software installed on them. Oracle Version : 11.2.0.4.0 OS : Windows 10 Database Name […]
How to use Catalog start with command
Recovery Manager(RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up,restoring and recovering database files. If you have backup files in non-FRA location , you can catalog your backup using catalog start with command of RMAN. Note : […]
ORA-08104: This Index Object Is Being Online Built Or Rebuilt
This post is about “ORA-08104”. We are going t learn how to solve this issue. Steps are mention below:- While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN00_IDX1 * ERROR at line 1: ORA-08104: this index object 94771 […]
Storage Volumes and File System Layout in Oracle Cloud
This section provides information about the storage volumes and file system layout of a newly created database deployment on Oracle Database Cloud Service. Compute Cloud Service Storage Volumes When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created. Storage Volume Description bits 60 GB volume completely […]
Explain usage of different users in Oracle Cloud
This article provides information about Linux user accounts that are provisioned on Oracle Database Cloud Service. Every Database Cloud Service compute node is provisioned with the following operating system user accounts. Both compute nodes are provisioned with the following operating system user accounts. opc: The system administrator account you use with the sudo command to perform operations that […]
Generic error(Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto)
While running the opatchauto command in oracle grid you may face the jdk version error as below. We are going to learn about the steps which we use to solve this issue. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI […]