Oracle Database 18c and it’s features

Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC).  To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]

Read More

TopicWise Interview Question on Oracle Database

Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace  Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]

Read More

LOCAL=NO & LOCAL=YES in Oracle

LOCAL = NO: non-local connection, namely a network connection. Listener connect to the server. Client application through the client listener listener sends a request to the server, the server listens received in connection with the database, perform related operations, the results returned to the client. This is the process by listening. So you need to […]

Read More

Oracle Database Maximum Availability Certified Expert

Hi Readers Finally I’ve successfully achieved  Oracle Database Maximum Availability Certified Expert. It was almost more than 6 months that I’ve been preparing for this. To achieve this certification, we must complete ALL the three certifications: Oracle Database 12c Administrator Certified Professional Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administration Oracle Certified Expert, Oracle Database […]

Read More

Difference between .bashrc and .bash_profile

Difference Between .bashrc and .bash_profile : We use .bashrc and .bash_profile frequently to set environment for Oracle. Here is the difference between both files ,which file is used when . location of .bashrc : /home/username/.bashrc location of .bash_profile : /home/oracle/.bash_profile .bashrc : This file is executed for non-login shells . .bash_profile : This file is executed […]

Read More

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 […]

Read More

Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials

Hi Readers Finally I’ve successfully passed 1Z0-337,  Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]

Read More

Oracle Exadata 18c and Database Machine X7-2

Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers, and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack. The following table lists the components included for each type of Oracle Exadata Database Machine. Components of […]

Read More

Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Loading Data into Autonomous Data Warehouse Cloud Database   Data […]

Read More