Safe Harbor Statement All the posts are intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and […]
Category: ARTICLES
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 […]
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/ […]
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 […]
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 […]
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 […]
Oracle Engineered System MiniCluster S7-2 installation, step by step, short info
Here , I will write about how to initial software setup MiniCluster S7-2. (short guide) Pre-Installation Checklist DNS server NTP server at least 12 ip addresses for initial setup. Additional 7 ip addresses for 2 nodes RAC setup. (3 scan , 2 vm, 2 vip) More IP addresses for additional virtual machines or more grid […]
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 […]
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 […]
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 […]