The latest OTN Summit content is ready for OnDemand viewing, select a Category below.
Big Data Prep
Start Here to Transform your Cloud Implementation: Oracle Database Cloud... [Read More
Now the Known Isuses and Alerts and Recommended Patches Notes in MOS reflect the naming and classification change of the different types of patches as well.
MOS Note:1683799.1 - 22.214.171.124 Patch Set - Availability and
We don't speak about Bundle Patches for Exadata and DBIM anymore... [Read More
We've pushed out a patch release of node-oracledb to
GitHub and NPM. It has a bind fix that didn't land in time for
1.10.0. A memory leak regression with REF CURSORs was also fixed, as
was a pre-existing memory leak in the unexpected case of a REF CURSOR
The changes in node-oracledb 1.10.1 are:
Fixed a... [Read More
Great news: the latest MySQL Partner Update is here.
Stay up to date with the latest news on events and products, discover MySQL sales opportunities, check out the newest case studies, learn about upcoming trainings and events, and have all resources at your fingertips.
Learn more here.
I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date. After speaking with Jeff Moss he mentioned that we might be able to get round the problem by using a virtual
This script is used to set up the test table for the following blog posts: Oracle Database INTERVAL Partitioning Date Error With 31-12-9999 Oracle Database INTERVAL Partitioning and Virtual Columns [crayon-578913d2a047f830082062/]
You may have seen the below error when using dates at the extremes with an Oracle Database. This post focuses on the scenario where you’re inserting a high date, such as 31-12-9999 into an INTERVAL partitioned table. High dates such as this are often used in warehouse environments where from and to dates are specified
Exadata provides the highest-performing and most-available infrastructure for
running Oracle Database, whether it’s in the Oracle Cloud, on premises, or a
combination of both.
Oracle Exadata architecture features a scale-out design
with industry-standard servers and intelligent storage, including
state-of-the-art flash technology and a high-speed InfiniBand internal fabric.
This architecture provides 100 percent Oracle Database portability from on
premises to Oracle Public Cloud and back.
Top feature: Enhanced Metadata
The changes in node-oracledb 1.10 are:
Enhanced query metadata thanks to a Pull
Request from Leonardo. He kindly allowed us to take over and fine tune
Additional metadata for query and REF CURSOR columns is
available in the metaData... [Read More
A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.
Something you need to be aware of when using GTTs in Oracle Database 126.96.36.199:Prior to this release GTTs shared statistics between sessions. Statistics were SHARED between... [Read More
Credits to Chris Smids from Proximus in Belgium Thanks, Chris!!!
Upgrade to Oracle 188.8.131.52 is slow in phase: #65 ?
You are wondering why phase: #65 of the database upgrade to Oracle Database 184.108.40.206 takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a... [Read More
This blog post is an addition to:
Full Transportable Export/Import - Migration an 220.127.116.11 database to Oracle Database 12c - into the Oracle Cloud
Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you'll have to do the... [Read More
Stay up to date with the Oracle Certification Program, view exams
released into production, get information on current promotions or learn
about new program announcements below.
Achieve Your Next Certification with NEW Exams
Oracle Java Cloud Service Certified Associate | 1Z0-161
Oracle Database Cloud Service | 1Z0-160
Beta Exam – Coming Soon!
Oracle Exadata X5 Administration | 1Z1-070
Take the Next Step in Your Java Career
Now is the time to advance your Java skills (more...)
On June 21, 2016, Oracle announced two new models of Oracle Database Appliance (ODA) which bring all the performance and reliability of Oracle’s Engineered Systems to small and mid-sized partners for the first time.
Read more about these new offerings.
In my previous post Network considerations on an ODA X5-2 I described a solution where I created a private network to optimize network performance between the components running on an Oracle Database Appliance. I am talking about a Virtualized setup in this article, and rebuilding the second pair of public interfaces to become a private network bond, in order to get a faster connection between the virtual machines.
In this article I will describe the (more...)
Apache Cassandra™ is a massively scalable open source NoSQL database. Cassandra is built from day 1 to be clustered to tick the usual clustering boxes; no single point of failure, and capacity and throughput scales with cluster size. This guide will look at creating a three node basic cluster within a single data centre. It is assumed
The following process will install the DataStax distribution of Cassandra on any Debian based system, such as Debian or Ubuntu. We’ll use the official DataStax apt repositories to install Cassandra using apt-get. Cassandra is written in Java and the latest version (at the time of writing) of Cassandra requires Java 8. You can use either OpenJDK or
Full Transportable Export/Import - one of the coolest features in Oracle Database 12c
We blogged about Full Transportable Export/Import a while back. It is - no doubt - one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab - Upgrade,... [Read More
When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times 10Gb copper Ethernet (bonded into two interfaces) for public communication and two 40Gb InfiniBand (bonded into one interface) for interconnect communication between the two ODA_BASE’s. You would think that should be more than enough. Well in most cases it is. The interconnect running through InfiniBand is stunning for RAC and the public interface should be (more...)