Posts Categorized: Technical Blog

Database 12c: What’s New with Data Pump? Lots.

Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.

Database Validation in Data Guard 12c

Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.

Oracle Database 12c: Network Recovery in RMAN

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner’s Guide for Oracle Database 12c. Many of the new 12c features have fascinated me and my peers. I have thirsted in particular for the following handful of rman enhancements that are bundled with Database 12c…

How to Secure Microsoft SQL Server

Security! This is a top-of-mind word for every concerned person when it comes to storing,  accessing, and sharing data, databases, or database servers. When applications are running in a restricted area, they are less likely to be exploited. However, with the increasing popularity of the Internet and the availability of applications, the security of data, databases, and database servers has…

Be Warned: cmclean.sql Is Dangerous!

I’m sure one of the most popular scripts for Apps DBAs on My Oracle Support is cmclean.sql from MOS Article ID 134007.1 “Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables”. DBAs usually use the script to clean up stale data from concurrent processing tables (FND_CONCURRENT_%) after incidents like a crash…

SLOB2 Kick start

A few of my friends asked me to assist them with getting up to speed with SLOB2 testings. I have decided to publish this quick blog post and give people to a few hints. Additional Scripts Here are some of the scripts I have used to simplify SLOB testing management for my testing efforts: SLOB2…

Duplicate Database from Active Database — Just Works!

My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in this tweet. @yvelik Me too, then I store the script in a safe place :-) Duplicate jobs reminds me how important it is to practice restore. — Øyvind Isene (@OyvindIsene) July 1, 2013 I couldn’t find a…

Exchange Server 2010 with Oracle Workflow Mailer

Almost all Oracle E-Business Suite DBAs will run into this problem if they are using exchange server as their Workflow IMAP server. Workflow is a important component of Oracle E-Business Suite, and its mailer component adds a biggest oracle EBS feature of inbound mail processing of workflow approval and rejection email replies from end users….

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

Page 7 of 55« First...56789...203040...Last »