There’s an interesting “debate” going on under AskTom at the moment. It’s hardly cause for major concern, but anyone is welcome to add their thoughts as comments to this blog post. (Naturally, if your comments agree with my opinion, then that’s great. If your comments don’t agree, then I’ll post them and ignore them – ah the joys of being a blog owner)
So here’s the issue. When we are posting (more...)
Yes! It’s that time of the year again when we start planning for the premier Oracle OpenWorld. So let’s get right into it! Read more here – Top 8 Strategies to Thrive at Oracle OpenWorld . . . . . . Realted article – Advanced Sessions at Oracle OpenWorld 2015 . . .
The post Top 8 Strategies to Thrive at Oracle OpenWorld appeared first on VitalSoftTech.
If you're read some of my older stories on this blog you'll know I've had some interesting battles with flashback over the past couple of years... don't get me wrong i think it's (arguably) the best feature introduced over the past 10 years (i'm talking about all the different flavours of flashback with that comment).
Today i hit a whole series of random errors discovered a minor new (well new to me) syntax to a (more...)
That’s not really a problem but annoying issue I had with OEM 12c. Once a standby database is promoted, the database system for the same is showing as metric collections error OR Status Pending.
The standby database doesn’t need its own system since it will join the primary database system. The solution is to associate the standby database with the primary system and then remove the standby database system.
For example – we’ve got primary (more...)
What’s the most important attribute to consider when you want to buy a new storage system? More critical than performance, more interesting than power and cooling requirements, maybe even more important than price? Whether it’s an enterprise-class All Flash Array, a new drive for your laptop or just a USB flash key, the first question on anybody’s mind is usually: how big is it?
Yet surprisingly, at least when it comes to All Flash Arrays, (more...)
I’ve lost track of the number of times I’ve worked with systems that didn’t run brilliantly because every database operation was the “row at a time” methodology. Typically you see hundreds of routines (either in the database in PL/SQL) or further up the chain in C#, Java etc, and the “alarm bells” start ringing in my head when all of those routines are prefixed with “GET_” and the input parameter looks like a primary (more...)
Since the upgrade to Cloud Control 22.214.171.124, we’ve been having a couple of issues, mostly around EMCLI.
Some of our databases use Service Guard, so you don’t know which node they are running on. Rather than having an agent per package, we have one on each node. One of my colleagues wrote a little script to check which node the instance is running on, and relocate it if it has moved. This (more...)
In the comments from yesterday’s post, Jonathan Roden mentioned the release of El Capitan. At that point, I hadn’t even heard about it. Being the naive idiot I am, I jumped head long into it.
The download was about 3G, which didn’t take too long. The upgrade itself took quite a while. That included one failure. During the installation, the system rebooted, as it said it would, and I thought it was over, but it was (more...)
I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle. But you should never stop learning. That’s why I’m participating in a cool OpenWorld session in a few weeks, all about the modern technologies and frameworks that can now be used to build awesome applications on top of the Oracle database. Come along – you’ll see some exciting stuff. This session is all about modern (more...)
There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 126.96.36.199 instances. ora_acms_bt9prod1 ora_lreg_bt9prod1 ora_p00w_bt9prod1 ora_aqpc_bt9prod1 ora_m000_bt9prod1 ora_p00x_bt9prod1 ora_asmb_bt9prod1 ora_mark_bt9prod1 ora_p00y_bt9prod1 ora_cjq0_bt9prod1 ora_mman_bt9prod1 ora_p00z_bt9prod1 ora_ckpt_bt9prod1 ora_mmnl_bt9prod1 ora_ping_bt9prod1 ora_dbrm_bt9prod1 ora_mmon_bt9prod1 ora_pmon_bt9prod1 ora_dbw0_bt9prod1 ora_o000_bt9prod1 ora_ppa6_bt9prod1 ora_dbw1_bt9prod1 ora_p000_bt9prod1 ora_ppa7_bt9prod1 ora_dbw2_bt9prod1 ora_p001_bt9prod1 ora_psp0_bt9prod1 ora_dbw3_bt9prod1 ora_p002_bt9prod1 ora_pxmn_bt9prod1 ora_dbw4_bt9prod1 […]
This post is based on a problem I was asked to look at recently.
A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 database. He was matching the rows on a key column then checking the corresponding values from a different column and reporting them if they did not match. His query returned almost 2000 rows but they appeared to have equal, not different values. Five people looked at (more...)
In 2014, myself and a few other well known speakers in the Atlanta area were added to the board of directors for the Georgia Oracle User Group (GaOUG). With us being added to the Board of Directors, we initatied a rebranding of the user group from GOUSER to GaOUG in Feburary 2015, with much success. Then followed that event up with two quarterly events in April and July 2015, which proved to be an even (more...)
A long, long time ago, people started using the following SQL idiom:
with t as (select /*+ materialize */ …..)
select …. from t
If my memory serves me right, Jonathan Lewis was the first person whom I saw using this idiom. The use of that idiom was to speed create a global temporary table and reuse the query results, without having to re-execute query again. Here is an example:
SQL> set autotrace on
Database startup fails:
ORA-16038: log one sequence 3144 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312 online log 1 thread 1 <path to redo log file>
In the alert.log:
ORA-16014 signalled during: ALTER DATABASE open …
ORA-19815: WARNING: db_recovery_file_dest_size of xxx bytes is 100.00% used, and has 0 remaining bytes available.
support id : Flash Recovery Area Full – Database Fails to Open ORA-16038 (Doc ID 337258.1)
Just a quick comment about something I noticed while rebuilding a test VM on my Mac. There is a long lead up to this, so bear with me…
I use VirtualBox on three different host operating systems.
Mac : My main desktop is a Mac, so most of my tests are done using Oracle 12c on Oracle Linux 6 or 7, running under VirtualBox. Most of the VMs I use are quite old, but I (more...)
So you may ask, why go through all the trouble?
Have you ever had to move scripts from one directories to another to find out the script is now broken?
This is due to the hard coding of the location for SQL script in the shell script.
When possible, I would like to separate shell / SQL scripts so they can be run individually and easier for debugging.
Don’t you hate it when copy/paste SQL (more...)
There are three ways of creating a pluggable database from an existing non-CDB:
• Using the DBMS_PDB package to generate metadata and then creating the pluggable database
with CREATE PLUGGABLE DATABASE SQL statement
• Data Pump (using the transportable tablespace feature)
• GoldenGate replication
When using the DBMS_PDB package to convert a non-CDB to a pluggable database, the non-CDB must be Oracle12c or higher.
Take care of your Non CDB and CDB chraceter set (more...)
VirtualBox 5.0.6 has been released.
It’s a maintenance release. You can find the downloads and changelog in the usual places.
was first posted on October 3, 2015 at 2:31 pm.
©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.
In case you haven’t heard about Oracle Database Developer Choice Awards already-this is the time to vote for the chosen finalists of various technology categories. These finalists are selected by a panel of Oracle ACE community members among the following 5 categories.
Steven Feuerstein has written about these awards here and also has published the list of the finalists.
So if you haven’t voted (more...)