Toys for when You & I are bored

https://github.com/terrywang/vagrantboxes/blob/master/oraclelinux-7-x86_64.md

https://github.com/yasushiyy/vagrant-oracle11g-rac
https://github.com/yasushiyy/vagrant-oracle12c-rac

https://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_Automation

https://github.com/racattack/vagrantfile

http://oracleprof.blogspot.com/2015/08/automation-for-dba-vagrant-part-1.html
http://oracleprof.blogspot.com/2015/09/automation-for-dba-vagrant-part-2.html

http://vxcompany.com/2016/08/12/vagrant-for-you-rac-test-environment/

http://myofwexperiments.blogspot.com/2015/10/oracle-12c-database-installation-on.html

https://www.centos.org/download/


Podcast Show Notes: Building a Real Cloud Solution by Bob Rhubart

image

This program was recorded on Wednesday, September 21, 2016, during Oracle OpenWorld in San Francisco. "During" is the operative word, since the podcast was actually recorded in my hotel room, several blocks from Moscone Center, where OOW16 was held. The topic was suggested by Oracle ACE and frequent OTN contributor Arturo Viveros, who, along with other panelists, was in town for the big Oracle event. Listen.

The Panelists

Oracle ACE Arturo Viveros
Principal Architect, SYSCO (more...)

Histogram Upgrade

I’ve written notes in the past about the improvements 12c introduces for histograms – particularly the frequency and top-N histograms which can be generated “free of charge” while the basic “approximate NDV” scans are taking place to gather stats. Gathering histograms in 12c is much safer than it used to be in earlier versions of Oracle even in the case of the new hybrid histograms (which are still sampled on a very small sample and (more...)

Oracle SIN Function with Examples

In this article, I’ll explain what the Oracle SIN function is and show you some examples. Purpose of the Oracle SIN Function The purpose of the SIN function is to calculate the sine of a number. The sine is the ratio of the length of the side of the triangle opposite the angle to the […]

Oracle COS Function with Examples

In this article, we look at the Oracle COS function and see some examples. Purpose of the Oracle COS Function The COS function will return the cosine of a number. If your knowledge of cosine is a bit rusty (like mine), then you might find this definition helpful.   Syntax The syntax of the COS […]

Do you suffer from Storage Stockholm Syndrome?

The last year at DSSD (now a part of Dell EMC) has been an extremely interesting one for me, and I’ve learned a great deal, which is always good. Some of the lessons have been surprising, though… One of them is what I will rather dramatically refer to as Storage Stockholm Syndrome. Stockholm Syndrome is … Continue reading "Do you suffer from Storage Stockholm Syndrome?"

Moving a VM- 100 Ways to Skin a Cat

I love technology-   ALL TECHNOLOGY.  This includes loving my Mac Air and loving my Microsoft Surface Pro 4.  I’ve recently went back to a Mac when I joined Delphix, trimming down the power I had on my Surface Pro 4, knowing the content I was providing would be required to run on hardware with lesser resources.

With the release of Microsoft SQL Server 2016 on Linux, I (more...)

Delete/Insert #2

In the previous post I threw out a couple of options for addressing the requirement to transfer data from one table to another (“cut and paste” rather than just “copy”) without running into odd inconsistency errors. This triggered of a wonderful comment trail of alternatives based on how large the volume might be, how relaxed the concurrency requirements might be, and so on.

A comment by SydOracle1 picked up on my failure to get Oracle (more...)

A Guide to the Oracle DROP TABLE Statement to Delete Tables in SQL

How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article. How Can I Delete a Table in Oracle SQL? To delete a table in Oracle SQL (or any SQL for that matter), you run a statement called DROP TABLE. It’s called DROP because […]

#DOAG2016, definitely a crazy week.

#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!

In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)

Oracle VARIANCE Function with Examples

In this article, I’ll explain what the Oracle VARIANCE function is, and show you some examples. Purpose of the Oracle VARIANCE Function The purpose of the VARIANCE function is to, well, return the variance of a set of numbers. A variance is a mathematical concept, which represents how different the values are in a set […]

UKOUG Conference 2016 coming up fast

The weather has turned cold, the lights are twinkling in windows and Starbucks is selling pumpkin lattes. Yes, it's starting to look a lot like Christmas. But first there's the wonder-filled advent calendar that is the UKOUG Annual Conference in Birmingham, UK. So many doors to choose from!

The Conference is the premier event for Oracle users in the UK (and beyond). This year has another cracker of an agenda: check it out.

The session (more...)

Fix “BEA-000394: Deadlock detected” for Weblogic with ADF Applications 12.2.1.2

If you try the newest version 12.2.1.2 (or maybe earlier versions too) you see, that your managed server does not restart, when

  • you have deployed your ADF application(s)
  • you try to restart the managed server with ADF
  • you use intentionally or not shared libraries in your weblogic-application.xml (see example below)
<?xml version = '1.0' encoding = 'UTF-8'?>
<weblogic-application xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                      xsi:schemaLocation="http://www.bea.com/ns/weblogic/weblogic-application http://www.bea.com/ns/weblogic/weblogic-application/1.0/weblogic-application. (more...)

New Apple Script and Perspectives in Omnifocus

The challenge of coding, is that you sometimes need to be aware of what can be impacted outside of your code to make it appear guilty.

didnt

I wrote a blog post a short time back on my first time scripting with Apple Script with a goal of automating my weekly status reports to my new manager of my tasks in OmniFocus.  After seeing some cool stuff one of (more...)

UKOUG Tech16 : I’m Speaking

tech16_300wI originally thought the BGOUG event was my last speaking event of the year, but as it happens I am now presenting at UKOUG Tech 16 in a few days time.

If you fancy coming along to my session, it’s on Wednesday 11:30 – 12:20 and it’s called Put Your Feet Up & Have a REST. Take a Tour of JSON Support in the Oracle Database.

We might be celebrating my nephew’s birthday on the Saturday this (more...)

Delete/Insert

Many of the questions that appear on OTN are deceptively simple until you start thinking carefully about the implications; one such showed up a little while ago:

What i want to do is to delete rows from table where it matches condition upper(CATEGORY_DESCRIPTION) like ‘%BOOK%’.

At the same time i want these rows to be inserted into other table.

The first problem is this: how carefully does the requirement need to be stated before (more...)

VirtualBox 5.1.10

VirtualBox 5.1.10 has been released.

Downloads and Changelog in the usual places.

I’ve only tried it on Windows 7 at work so far. I’ll try it out on Mac and Oracle Linux 6 hosts when I get home and put an update on the post. 🙂

Happy upgrading!

Cheers

Tim…


VirtualBox 5.1.10 was first posted on November 22, 2016 at 1:17 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed (more...)

EM13c: Unauthorized Access to Performance Pages

I noticed an interesting security problem (exploit?) on Oracle Enterprise Manager Cloud Control 13cR2 (I tested on EM13cR1 and it also exists on there). When you create an Enterprise Manager administrator, you need to grant some special privileges to that administrator if you want them to access the performance pages, but it seems there’s an alternative way to access the performance pages without requiring extra privileges.

Let’s say I created a new administrator with (more...)

DOAG 2016

I had a great time at DOAG 2016. It’s one of the best run conferences I’ve been to! I did a quick cameo during the keynote to talk about performance in Oracle’s cloud. Nothing like being on stage with a guy wearing a tie. :) Thanks Andrew for inviting me to say a few words.

Kerry_on_stage_doag_2016

That was fun! Here’s a link to the paper I referenced:

Oracle Cloud Performance Testing Results


 

Then I did (more...)

Which SQLcl build am I running?

This is something I discovered a few minutes ago by pure coincidence and it’s not documented as far as I know.

sqlcl_version

You can enter version or show version and it will tell you the exact SQLcl build that you’re executing.


Filed under: Oracle, SQLcl Tagged: Oracle, SQLcl