This Log Buffer Edition cuts through the crowd and picks some of the outstanding blog posts from Oracle, SQL Server and MySQL.
- Continuous Delivery (CD) is a software engineering approach in which teams keep producing valuable software in short cycles and ensure that the software can be reliably released at any time.
- Query existing HBase tables with SQL using Apache Phoenix.
- Even though WebLogic with Active GridlLink are Oracle’s suggested approach to deploy (more...)
Despite Ludovica’s disclaimer, there is, nevertheless, some smoke… And Twitter quite quickly filled up (at least the early where I take interest). Dominic Giles stated: “More to come soon!” And Ann Sjökvist urged calmness by saying: “let’s wait for facts! (more...)
We’ve all heard it before. Computers are totally logical, they do exactly what they are told. After all, Central Processing Units (CPUs) are built out of fundamental units called Logic Gates. With perhaps the exception when a stray cosmic ray gets lucky, the circuits in a computer chip and memory act in a totally logical and predicted manner.
And of course, anything built on top of computers will be utterly logical as well. All those (more...)
You’ve been google-ing and you’ve seen articles (for example) like http://www.oracle.com/technetwork/articles/sql/11g-securefiles-084075.html and you’re pretty pumped about using SECUREFILE features. You’ve got lots of existing CLOB data and moving to SECUREFILE is going to make your life much easier. You’re also excited about the fact that none of your code has to change – you just change the existing CLOB columns to be stored as SECUREFILE and you’ll have set yourself (more...)
Today is another anniversary, but this time it’s the website, which is 15 years old.
OK. This is a bit of a cheat because:
- The website originally had a different name, so you could say the website with it’s current name is 13 months younger, but it’s the same site, so whatever.
- I don’t actually know the exact day the first page went online, but I do know the date I bought the original (more...)
“Continuous Delivery (CD) is a software engineering approach in which teams keep producing valuable software in short cycles and ensure that the software can be reliably released at any time”
Perhaps a simpler definition is “CD is the currently the cool thing to do”
Sarcasm aside, there’s a lot of common sense in being able to rapidly push out software changes in a safe manner.
Many years ago, I (more...)
I think this is cool as it gives you the ability to use SQL on an HBase table.
To test this, let's say you login to HBase and you create an HBase table like (more...)
You can now restore single tables from backup! It is a simple command although it leads to much effort by RMAN. See it as an enhancement over a ‘normal’ Point In Time Recovery:
After a full restore from a sufficiently old backup, archived logs are being applied in direction of the presence until before the logical error. Then a new incarnation comes up (with RESETLOGS) and the whole database is as (more...)
I had an interesting request recently from a developer.
“ I have a table created as per below
create table C_TEST (
The rows defined by col_1, col_2, col_3 must be unique but only when col_3 is present. If col_3 is not present, then we allow anything. Hence if the table is populated like this:
insert into c_test values (‘a’,’b’,null);
I was reading the following post today http://stevenfeuersteinonplsql.blogspot.com.au/2015/06/the-oracle-database-developer-choice.html
Oracle are planning on rewarding developers in the following areas:
- Oracle REST Data Services
- Oracle Application Express
- Database Design
At first glance I had a bit of a cynical view…it could easily be one of those things where if you come from a company that has massive investment in Oracle, then surprise surprise you float to the top of the (more...)
Have you guessed what today is?
It’s amazing, finally reaching the age of 26 (+20).
PS. There’s another anniversary coming tomorrow.
Happy Birthday to Me! was first posted on July 2, 2015 at 6:40 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
If you’ve run an exachk report, y0u may have seen the following message with regard to your databases:
|FAIL||Database Check||Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value||db01:dbm011, db02:dbm012||View|
This check is commonly seen when a database is created on Exadata without using the custom “Exadata” templates included with the database creation assistant. These customized templates include a multitude of recommended parameter settings found in (more...)
I had a chance to take a closer look at the Zero Data Loss Recovery Appliance, (ZDLRA) via Cloud Control today and really liked the dashboard that’s included in the plugin for the product. This post isn’t going to cover the installation of the plugin or configuration- I was just intrigued by the dashboard and wanted to go over the great features that are part of it.
Accessing the ZDLRA
As with any Targets, (more...)
While deploying an X5 Full Rack recently it happened that the Grid Infrastructure Management Repository was not created by onecommand. The GIMR database was optional in 126.96.36.199 and became mandatory in 188.8.131.52 and should be automatically installed with Oracle Grid Infrastructure 12c release 1 (184.108.40.206). For unknown reason to me that didn’t happen and I had to create it manually. I’ve checked all the log files (more...)