When you create a PDB, the database automatically creates and starts a service inside the CDB.The service has the same name as the PDB. It is possible that the name of the service will collide with an existing service name which is registered with the same listener. For example if two or more CDBs on the same computer system use the same listener, and the newly established PDB has the same service name as another PDB in these CDBs, then a collision occurs.
You must not attempt to operate a PDB that causes a collision with an existing service name.
Top 12 Features of Oracle 12C Summarized. This article is also available at www.ondemanddb.com
Summary: The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 12 Features of Oracle 12C as I see it. I have summarized below, the top 12 which I found interesting.
Oracle is doing every thing to jump into the cloud bandwagon.
Apps clone is like cloning a human being. Please read the detail below.
1) Run adpreclone on DB/CM/AP tiers
This is pre-requisite step of cloning 11i prod and will not change anything in any system. This script will only create on $COMMON_TOP, a directory called "clone", with a basic structure of executable, scripts, templates and java files.
The COST column cannot be used to compare execution plans. Punkt.
Hi Oracle geeks,
Last Friday, I’ve noticed a strange thing happening in my 18.104.22.168 Database: I’m able to create objects in a tablespace which is marked READ ONLY !!!
Don’t believe this??
OS:Red Hat Linux As 5
[=16]In 9i,we open the database with resetlogs just only once when we do the incomplete recover,but in the 10g, it can open the database with resetlogs more than once,the flowing test is show how to open the database with resetlogs many times.
I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.
Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.
Conventional Dependency Model If an Object B is being referrd from object A (ie Object A refers another Object B) , Object A is known as Dependant Object and Object B is Known as referenced Object.
Basics of Partition Tables
Partitioning is a method of splitting an object (a table or index) into separate parts (called partitions) based on some criterion that is assigned to the partition. The criterion might be a date range, a number range, or any other possible value. Imagine, for example, that you have a huge table that is driving you crazy because queries on it are really slow. You get so mad at this table that you take a logical hatchet and begin to slice the table up into many smaller tables is a partition.
Below are some ORA-ERROR which every DBA face:
Clause: Most likely it is related to bug
Solution: go to metalink and apply patch set.
Clause: It is generic error means lots of reason behind this.
Solution: Depends on condition but best way to search on google/forms.
Clause: Mis-configuration of SGA, insufficient memory
Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory