This post is to share the links for Oracle books for better understanding of Oracle Internals and other exam guides to prepare for Oracle exam. Oracle 12c Books:- OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c Installation…
This post is to describe all the clauses available with Oracle datapump export (expdp). This article assumes that the reader has basic knowledge of database administration. If not gone through yet please go through the articles Oracle datapump Architecture & Internals so that you have basic architecture understanding of datapump. Oracle 12c datapump have following clauses, which…
This post is to cover the queries that could be used to monitor the running Datapump Jobs. Without wasting anytime just posting the methods/queries which can be used to monitor the details of the datapump jobs:- 1) Using the datapump client (expdp & impdp) STATUS command:- When the export or import job is running press +C…
Ever got into a scenario where you have a dump file without the logfile and not even sure what was the Oracle database version from where this was exported, the characterset, Operating system and other details of the Source Database ? Or even when you are not aware of which utility was used to export…
Made some changes related to Automatic Memory Management (MEMORY_TARGET, MEMORY_MAX_TARGET) and when re-started the database got ORA-00845 ? Or starting another Oracle Instance on the server which was down from quite a while and facing ORA-00845 ? In any case if you ever face ORA-00845 and unable to start your Oracle instance this post would…
This is a quick note on how to install Oracle XE on Linux/CentOS env. This article assumes that you have downloaded the Oracle Database Express Edition setup binaries from here. Also you would require a minimum of 256MB RAM dedicated to oracle and 1.5 GB disk space. So if you have all the resources mentioned above proceed…
In this series we’ll share the internals of the Oracle datapump, how to improve performance of a datapump job, how to monitor datapump jobs, how to read the header information from the dump file. Please feel free to comment if you want any other details regarding datapump to be covered. Datapump Architecture & Internals. How…
Oracle Datapump was introduced with 10gR1 as a replacement to the classic export/import utilities. In this post we’ll go through the internals of Datapump to see how it works. Oracle added two new packages DBMS_DATAPUMP & DBMS_METADATA which forms the base for the datapump export import operations. So either you use the command line functionality or…
This post details how to resolve listener connection issues when DB & listener are started but still connect fails with following errors:- ORA-12505 TNS:listener could not resolve SID given in connect descriptor TNS-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor TNS-12514 TNS:listener could…
Since 11g Oracle resolves hostnames directly by querying DNS rather than from /etc/hosts, this can introduce delays in establishing a connection to the remote database server. This could be observed in the strace for a SQL*Plus connection:- As you can see from the above trace that after reading the nsswitch.conf, library “libnss_dns.so” is loaded, and…
Oracle Database Internal Mechanism 