Expert Blogs

Blogs

John Pocknell

Welcome to the new Code Tester for Oracle community!

Hello everyone and welcome to this the newly reinstated, dedicated Code Tester for Oracle community. Previously a part of the Toad for Oracle community, we felt that, because PL/SQL unit testing is particularly important right now as more organisations...
4 0 /
Syed Jaffar Hussain
Follow /18 Feb 2018 at 12:24pm / Oracle Blog

Oracle ERP DB Exadata migration + AC-50480: Internal error occurred + ORA-12154

I was recently involved in a project to migrate an Oracle ERP database to an Exadata server. The ERP database was a non-RAC Oracle 12cR1 running on RHEL with Oracle EBusiness suite 12.1.3. The migration involved only migrating the ERP database from traditional...
57 0 /
Brendan Tierney
Follow /18 Feb 2018 at 11:32am / Oracle Blog

18c is now available (but only on the Cloud)

On Friday afternoon (16th February) we started to see tweets and blog posts from people in Oracle saying that Oracle 18c was now available. But is only available on Oracle Cloud and Engineered Systems. It looks like we will have to wait until the Autumn...
56 0 /
Porus Homi Havewala
Follow /16 Feb 2018 at 6:33pm / Oracle Blog

Oracle Hybrid Database Cloud Using Enterprise Manager - Part IX

In this article series, we are looking at the steps for setting up the Oracle Hybrid Cloud via the latest version – Enterprise Manager Cloud Control 13c installed on premises. The main intention is to install an Enterprise Manager hybrid cloud agent...
88 0 /
Porus Homi Havewala
Follow /16 Feb 2018 at 6:12pm / Oracle Blog

Database as a Service using Enterprise Manager – Part IX

In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) cloud – including the setup of such a cloud. In the previous parts , we started the setup of the...
70 0 /
Dan Hotka
Follow /16 Feb 2018 at 5:03pm / Toad DevOps Toolkit Blog

Get More Agile: A Toad DevOps Toolkit Primer

Hi, This article will focus on a new set of tools from Quest called Toad DevOps Toolkit. The Quest people are providing useful Toad functionality that is easily integrated into today’s continuous-flow project management environments. This...
18 0 /
Deepak Vohra
Follow /16 Feb 2018 at 3:52pm / Toad DevOps Toolkit Blog

Using Toad DevOps Toolkit with Oracle Database 12c on Docker

Introduction In the Modularization by using Oracle Database Containers and PDBs on Docker Engine article we discussed using a Docker image for Oracle Database to run Oracle Database 12c in a Docker container. The benefits of using Oracle Database PDBs...
21 0 /
Gary.Jerep
Follow /14 Feb 2018 at 11:37pm / Toad for Oracle Blog

Toad Turnpike: Real Stories from the Road - Interruptions Part 2

Real stories. Real people. Doing real things. With Toad solutions. Forget the Training Manuals Part two in my three-part series: Interruptions can be game changers. An online ad service provider paid Quest Software to conduct three one-day training...
103 0 /
Deepak Vohra
Follow /13 Feb 2018 at 2:12pm / Toad DevOps Toolkit Blog

Using Toad DevOps Toolkit with Jenkins

Introduction Jenkins is an open source automation server suitable for automating Continuous Integration and Continuous Delivery pipelines. Toad DevOps Toolkit is a COM objects based tool for developing DevOps evaluations and workflows. Toad DevOps...
29 0 /
Brendan Tierney
Follow /13 Feb 2018 at 12:06pm / Oracle Blog

Oracle and Python setup with cx_Oracle

Is Python the new R? Maybe, maybe not, but that I'm finding in recent months is more companies are asking me to use Python instead of R for some of my work. In this blog post I will walk through the steps of setting up the Oracle driver for Python...
122 0 /
Gokhan Atil
Follow /13 Feb 2018 at 8:08am / Oracle Blog

Build a Cassandra Cluster on Docker

In this blog post, I’ll show how we can build a three-node cassandra cluster on Docker for testing. I’ll use official cassandra images instead of creating my own images, so all process will take only a few minutes (depending on your network...
97 0 /
Deepak Vohra
Follow /12 Feb 2018 at 8:36pm / Toad DevOps Toolkit Blog

Using Toad DevOps Toolkit with Oracle Database on AWS EC2

Introduction AWS EC2 provides several AMIs for Oracle Database in addition to the managed service for relational databases, Relation Database Service (RDS). RDS cannot be used with Toad DevOps Toolkit because Toad DevOps Toolkit requires a user with...
29 0 /
Anju Garg
Follow /12 Feb 2018 at 5:02pm / Oracle Blog

Oracle Multitenant Application Containers - Part VIII - Application Load Balancing Using Proxy PDBs

Introduction As we saw in my previous article , if application containers in multiple CDBs need to have the same application definition (for example, same tables and PL/SQL packages), then the application can be kept synchronized across CDBs by the...
1126 0 /
Dan Hotka
Follow /12 Feb 2018 at 4:27pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #8 - PL/SQL Templates

(Please visit the site to view this video) Here's my Toad Tip on PL/SQL Templates. I'll be back in March with four more tips to complete my Dan's Dozen Quick Toad Tips. Hope you're finding them useful.
77 0 /
Dan Hotka
Follow /12 Feb 2018 at 4:23pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #7 - SQL Templates

SQL Templates are shortcuts that you can drop into your SQL code. Hope you find this tip useful! (Please visit the site to view this video)
59 0 /
Dan Hotka
Follow /12 Feb 2018 at 4:16pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #6 - Start Page Options

Here's one on Start Page Options. (Please visit the site to view this video)
57 0 /
Dan Hotka
Follow /12 Feb 2018 at 4:07pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #5 - Advanced Explain Plans

Hope you find this post on Advanced Explain Plans useful! (Please visit the site to view this video)
48 0 /
Denny Cherry
Follow /12 Feb 2018 at 4:00pm / SQL Server Blog

When Using Availability Group Listeners, Why Can I See Non-AG Databases?

Yep. This is actually by design; and is because listeners can be tricky little fellas.  When using a SQL Server Availability Group Listener, you can see any databases on the server that is hosting the Availability Group Listener.  The reason for this...
103 0 /
Dan Hotka
Follow /12 Feb 2018 at 3:59pm / Oracle Blog

Oracle PL/SQL Performance Tips - Coding Best Practices - Part 8

Hi, This article will discuss some PL/SQL performance tuning tips as well as make reference to a variety of good coding practices. There are several things you can do to get your PL/SQL code to run optimally. These are my top tuning tips right out...
158 0 /
Syed Jaffar Hussain
Follow /12 Feb 2018 at 8:46am / Oracle Blog

Oracle Cloud Infrastructure services and third-party backup tools (CloudBerry)

As part of the Cloud Infrastructure services, Oracle offers below persistent I/O intensive block storage and high-throughput storage options, which is manageable through the console and by CLI: Oracle Cloud Infrastructure Block Volumes Oracle Cloud Infrastructure...
80 0 /
Gokhan Atil
Follow /12 Feb 2018 at 7:58am / Oracle Blog

Introduction to Apache Cassandra

On Friday, I gave a presentation about Apache Cassandra at Big Talk event organized by Komtaş Information Management company. Cassandra is a top level Apache project which is born at Facebook. It is a distributed database for managing large amounts of...
104 0 /
DaleB
Follow /8 Feb 2018 at 5:24pm / Toad Data Point Blog

Create and Automate Pivot Grids in Toad Data Point

This tutorial applies to Toad Data Point 4.3 or later. Summary This tutorial demonstrates how to create a Toad Pivot Grid file and how to use Automation to refresh the pivot grid and generate a report. In this tutorial you will learn: How...
83 0 /
Clarisa Maman Orfali

Getting to Know the Toad for Oracle Schema Browser

The Schema Browser is an interface that allows us to work with various objects in the database. To learn about this interface, we first open Toad and connect to a database schema. For this example, we are using the SCOTT schema of Oracle Express...
137 0 /
Tim Fritz
Follow /2 Feb 2018 at 10:04pm / Toad for Oracle Blog

Ensure PL/SQL Accuracy and Quality in the Age of DevOps: Join Quest on February 8 for a new Toad webcast series

Agile methodologies and DevOps workflows for application development are becoming common, but database development workflows have been left behind, resulting in a major bottleneck when application updates require database changes. Quest believes that...
122 0 /
Clarisa Maman Orfali

Conociendo el Navegador de Esquema del Toad for Oracle

El navegador de Esquema del “Toad for Oracle” es una interfaz que nos permite trabajar con los diversos objetos de la base de datos. Para conocer esta interfaz, abrimos el Toad y nos conectamos a un esquema de la base de datos. Para...
105 0 /