Expert Blogs

Blogs

Clarisa Maman Orfali
Follow /26 Sep 2017 at 10:34pm / Oracle Blog

Podemos monitorear la base de datos desde APEX?

Para monitorear la base de datos disponemos de una utilidad dentro del módulo del Taller de SQL llamada “Control de Base de Datos” que nos muestra información de DBA. Para poder tener acceso a dicha utilidad necesitamos primero...
304 0 /
Deepak Vohra
Follow /26 Sep 2017 at 9:05pm / Toad Data Point Blog

Using Amazon Redshift with Toad Data Point - Part I

Introduction Amazon Redshift is a data warehouse and data analytics service that makes used of standard SQL for running complex analytical queries on structured data. Redshift contrasts with relational databases such as the AWS RDS databases in that...
154 0 /
skant.gupta
Follow /25 Sep 2017 at 5:59am / Oracle Blog

Migrating Databases to Oracle Cloud Using RMAN Backup

This article was written by Skant Gupta and Joel Perez in Oracle OTN. This method is based on the traditional backup/restore/recover database. It has been one of the methods most effective to migrate/move an Oracle Database from one host to another...
221 0 /
skant.gupta
Follow /24 Sep 2017 at 6:26pm / Oracle Blog

Oracle Cloud (DBaaS): Move PDB with exporting the TDE master Key in Oracle 12.2

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud . Security has many layers, areas, sections...
145 0 /
Clarisa Maman Orfali
Follow /23 Sep 2017 at 12:03am / Oracle Blog

El timeout de la sesión en APEX, sabes dónde configurarlo?

Introducción APEX tiene incorporado un mecanismo que permite al desarrollador establecer la longitud máxima de una sesión y el tiempo de inactividad máximo de sesión permitido antes de que se termine una sesión...
272 0 /
Clarisa Maman Orfali
Follow /22 Sep 2017 at 9:08pm / Oracle Blog

Estamos a 37 días del inicio del Oracle Developer Tour 2017!

Hola mis amigos! He estado un poquito ausente en este último mes pues he estado trabajando en la actulización del sitio web del ODT y en la organización del evento que desde ya hace 5 años que venimos trabajando los distintos...
160 0 /
skant.gupta
Follow /22 Sep 2017 at 7:21pm / Oracle Blog

How to Convert Standard ASM to Flex ASM using the Command Line Interface

Prior to the Oracle Database 12c release, every node in a cluster used to run an ASM (Automatic Storage Management) instance and if an ASM instance failed on any node, then the database would become unavailable on that node. Let’s see how things...
203 0 /
Deiby Gomez
Follow /22 Sep 2017 at 3:50pm / Oracle Blog

Prepare yourself for passing the Oracle Certified Master 12c requirements!

By Deiby Gómez Introduction In 2013 I began my preparation for becoming Oracle Certified Master (OCM) 11g. I was already OCP (Oracle Certified Professional) 11g and OCP 12c, so to get to the next level, I made myself a schedule of reading...
895 0 /
Dan Hotka
Follow /21 Sep 2017 at 7:34pm / Oracle Blog

Oracle Login Profile Default Settings

Hi, I just wrote a short blog on changing the expiring password behavior of Oracle12 . I think most of these settings are valid for Oracle11 as well. The short blog was on resetting PASSWORD_LIFE_TIME (defaults to 180 days) and FAILED_LOGIN_ATTEMPTS...
182 0 /
Dan Hotka
Follow /21 Sep 2017 at 7:31pm / Oracle Blog

Oracle Password Expiring

Hi, Ever go to log into your test environment to get the “Password expires in 7 days”? Or, you have been on vacation/busy with something else and your test environment password expires? Just one of those little “gotcha’s”...
162 0 /
Debbie Peabody
Follow /20 Sep 2017 at 10:57pm / Toad Data Point Blog

Toad Data Point Automation on Intelligence Central

In Toad Data Point 3.6 we add the ability to execute Automation scripts on Toad Intelligence Central. This was a great enhancement as it freed up your working computer. In this version, 3.7 we have added a few more enhancements I think you will enjoy...
1460 0 /
Brendan Tierney
Follow /19 Sep 2017 at 5:39pm / Oracle Blog

My Oracle Open World 2017 Presentations

Oracle Open World 2017 will be happening very soon (1st-5th October). Still lots to do before I can get on that plane to San Francisco. This year I'll be giving 2 presentations (see table below). One on the Sunday during the User Groups Sunday sessions...
233 0 /
John Pocknell
Follow /19 Sep 2017 at 12:10pm / Toad for Oracle Blog

Introducing a Brand New Toad Product - Toad DevOps Toolkit

Back in July this year, I wrote a blog describing the challenges many organisations are facing as they try to embrace DevOps as a way to help increase their business agility through higher operational efficiency by enabling their IT departments to shorten...
864 0 /
skant.gupta
Follow /15 Sep 2017 at 8:38am / Oracle Blog

Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating Operations on Oracle Data Guard

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover & Failover Operations on Oracle Data Guard using the dbaascli utility. You can read it here: Oracle Cloud (DBaaS...
169 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 8:11pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VIII

by Porus Homi Havewala In this eight-part article series, we have had a good look at Amazon AWS and its Relational Database Service (Amazon RDS), in particular Amazon’s own Aurora database with PostgreSQL compatibility. In the previous part VII...
818 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 7:36pm / Oracle Blog

Database as a Service using Enterprise Manager – Part IV

by Porus Homi Havewala 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 ,...
461 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 7:17pm / Oracle Blog

Oracle Hybrid Database Cloud Using Enterprise Manager – Part IV

by Porus Homi Havewala 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...
368 0 /
Denny Cherry
Follow /13 Sep 2017 at 7:10pm / SQL Server Blog

Your PASS Summit 2017 Speaker Idol Contestants Are…

In past years I’ve been really glad that I’m just the MC of the PASS summit speaker idol because of the strong group of speakers. This year I’m really damn glad that I’m just not a judge because of the amazing group of speakers...
165 0 /
Anju Garg
Follow /13 Sep 2017 at 5:52pm / Oracle Blog

Oracle Multi-tenant Application Containers - Part IV: Cross-Container Aggregation

Overview In my last article, Oracle Multi-tenant Application Containers Part-III , we learnt about data sharing among containers in an application container by means of metadata-linked objects, data-linked objects, and extended data-linked objects...
482 0 /
skant.gupta
Follow /12 Sep 2017 at 8:34pm / Oracle Blog

Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover , Failover & Reinstate Operations on Oracle Data Guard using the DBCS Console. You can read it here: Oracle Cloud...
163 0 /
Dan Hotka
Follow /11 Sep 2017 at 3:52pm / Oracle Blog

More Coding Best Practices - PL/SQL tips - posting rows quickly from an array & more

Hi, This month is a continuation of the Bulk Binding PL/SQL technologies from Oracle from last month. Click here to review the Bulk Collect syntax in loading arrays very quickly with rows. This article will show the rest of the Bulk Binding technology...
603 0 /
Mark Kurtz
Follow /8 Sep 2017 at 10:24pm / Toad Edge - Blog

Object Versioning in Toad Edge

Working with Toad Edge you can store versions of your database objects in a file system repository. This gives you a way to reference and compare database objects without having to use a Version Control System (VCS). You can always add these objects to...
147 0 /
skant.gupta
Follow /8 Sep 2017 at 6:49pm / Oracle Blog

Oracle Cloud (DBaaS): How to become OCP & OCM Cloud!!!

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Hi everyone If you are reading this article could be for several reasons..: 1.- Perhaps you have asked me or asked to my colleague Skant Gupta the typical question "How...
190 0 /
Deepak Vohra
Follow /8 Sep 2017 at 6:03pm / Toad Edge - Blog

Using CloudSQL on Google Cloud Platform with Toad Edge

Introduction Google CloudSQL is a lightweight managed service for databases with support for MySQL and PostgreSQL. CloudSQL supports most of the features supported by a local installation of MySQL and PostgreSQL databases. Second Generation instances...
152 0 /
John Pocknell
Follow /8 Sep 2017 at 12:35pm / Toad for SQL Server Blog

What’s New in Toad for SQL Server Editions 2017 (Toad 6.8)

The wait is over – Toad for SQL Server 6.8 is here! General Availability was August 17 th and you can download the new version from here if you are current on support and maintenance or from here if you’d like to download a trial version...
107 0 /