Tag: IOUG

Understanding database security is critical for every DBA and beginning DBAs may not have all the necessary knowledge or resources to properly secure their databases. This session will introduce DBAs to the basics of database security and how to secure their databases by highlighting key database risks and providing resources useful in database hardening. Starting with a discussion of common database security risks and attack vectors, learn why and how your databases are under attack by both insiders and outsiders and the processes, tools, and techniques frequently used to compromise Oracle Databases. Key database features and processes impacting security including authentication, authorization, privileges, auditing, networking, security patches, and encryption will be explained highlighting both benefits and limitations of these features. The goal of this session is to show you database security in a different light in order for you to understand the most effective approach to securing your databases and highlight limitations and issues you may encounter.

Many DBAs and Architects think they understand Oracle database replication. But it is often only physical replication, as performed by Data Guard, rather than logical replication as done by GoldenGate, Streams and others. There are 3 fundamental principles that govern how these logical replication tools operate, centred on conversion, identification, and conflict handling of the…

This article, part three of a three-part series, explores a DBAs journey to APEX.

The frenetic pace of application development in modern IT organizations means it’s not unusual to demand an application be built with minimal requirements gathering – literally, from a napkin-based sketch – to a working first draft of the app within extremely short time frames – even a weekend! – with production deployment to follow just a few days later. This article – the third in this ongoing series – demonstrates how simple it is to improve a basic prototype of the existing APEX application as well as construct a simple yet functional application for volunteer canvassers to connect with registered voters in a huge northwest suburban Chicago voting district, right from their mobile devices. Missed Part 2? Catch up here first.

Recent years have shown an upshift of open source technologies with an evident increase in hybrid applications from licensed and proprietary tools. One such popular technology is Python programming language, which has made its way to the top. Most of its popularity can be attributed to the variety of options it provides for visualization and machine learning alongside the application development and automation. This article will primarily focus on how Python’s graphing libraries can be used to understand data from a database administrator’s (DBA’s) perspective.

Last month I wrote about lists and the thought process in choosing between a bulleted list versus a numbered list. Recall that I suggested using bulleted lists for collections of items, and numbered lists for sequences of steps. While that’s good advice, some cases can be spun in either direction. Sometimes the decision between a collection of items and process has more to do with your specific approach to a topic than to the nature of the list items.

The frenetic pace of application development in modern IT organizations means it’s not unusual to demand an application be built with minimal requirements gathering – literally, from a napkin-based sketch – to a working first draft of the app within extremely short time frames – even a weekend! – with production deployment to follow just a few days later. This article – the second in this ongoing series – focuses on how easy it is to leverage Oracle APEX to build the first of several components of a sufficiently-robust application for election canvassers to identify, classify, and inform voters in a huge northwest suburban Chicago voting district.

With growing demands from businesses for real-time, analytical capabilities, maintaining data environments that can grow with these demands is a necessity. This is pressuring data administrators to deliver responsive, high-performing systems that can scale with the business. However, many enterprises are encumbered by the licensing and support issues that typically accompany database systems, resulting in…

With growing demands from businesses for real-time,analytical capabilities, maintaining data environments that cangrow with these demands is a necessity. This is pressuring dataadministrators to deliver responsive, high-performing systemsthat can scale with the business. However, many enterprises areencumbered by the licensing and support issues that typicallyaccompany database systems, resulting in potentially high andunexpected costs, as well…

Hear from the SELECT Editors about what's on the top of their DBA wishlist for 2019.

This article explains how to configure Oracle API Gateway as a cluster on Solaris SPARC. The software can be download from the Oracle Technology Network. Before installing the API Gateway, you need to consider which components you require. Some components — for example, API Gateway Analytics — have additional requirements, such as a database. There are different components that could be installed, too, such as Policy Studio. There is not much documentation that discusses how to configure the Cluster for this product, so I chose to write one and be the first. The version of the API Gateway used in this article is Release 11.1.2.4.0, which is the latest at the time of writing.