2014

Uncategorized

OEM 12c Agent Deploy on Windows – no problem without Cygwin!

Agent 12c Deploy Windows 01

Right now the version for how to deploy the Agent on Windows without Cygwin. As I mentioned in my post “OEM 12c Agent Deoploy on Windows – no problem with Cygwin!” before, there are several and good reasons to look closer into Cygwin. The following Solution, I call it the dirty way, isn’t probably feasible for long-term deployment of several machines, but if it’s you choise, you’re welcome.

OEM 12c Agent Deploy on Windows – no problem without Cygwin! Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Restore Database after fatal User Error

4201.image001

Even though Oracle enhances the restore or fault tolerance capabilities with every release there are still fatal errors which lead into a major outage of the database. Those errors are mainly produced by human beings – sorry guys, but that’s how it is. In this blog I’ll show you how to restore the database to a specific SCN after a major incident. Actually, there is a true story behind this: Some years ago I had a customer whose production database was named “TEST”. Even though I told them to rename the database to somewhat meaningful the DBA was totally convinced

Restore Database after fatal User Error Blogbeitrag lesen »

By • • 5 minutes of reading
Uncategorized

OEM 12c Agent Deploy on Windows – no problem with Cygwin!

Agent 12c Deploy Cygwin 01

Oracle Enterprise Manager Cloud Control 12c offers an easy way to add various targets with the Add Targets Wizard over the GUI. Beside normal hosts, databases, listeners and ASM also Exadatas, Middlware, Cluster Services and many more, espacially for monitoring and also with more or less configuration options. But if you want to integrate a simple server first, you need a so called Agent. The agent is an application which monitores directly on the host and communicates with the Enterprise Manager.

OEM 12c Agent Deploy on Windows – no problem with Cygwin! Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Easy replication with SharePlex

shareplex migration

It was in 1999 when I first got some information about a replication tool for Oracle database. At that time I worked for a small consultancy company and had some experience with Oracle Advanced Replication because of a telecommunication project. SharePlex looked exciting and I began to dig into the features and functions and within the next years I became more and more familiar with that product. In 2002 we had a project where the customer already used Oracle standby for disaster recovery and was not satisfied because of the following problem. Even though there was a process to create

Easy replication with SharePlex Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Multitenant Snapshot Copy

snapshot copy

Snapshot clones are available with various techniques, like clonedb with 11.2.0.3 or the already mentioned software company Delphix. The most common ones are using storage technologies like ZFS or NetApp. Starting with Oracle 12.1.0.1 it was also possible using snapshot clones with pluggable databases within the multitenant database architecture. But it was limited to file systems that support sparseness and ACFS. With the first patch set 12.1.0.2 it’s possible to use direct NFS as well for snapshot copies. As direct NFS becomes more and more popular for database storage this is a real shift towards the usage of snapshot copies.

Multitenant Snapshot Copy Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Toad – My DBA Tool

database browser

For more than 20 years my profession is the Oracle database administration. Starting in the early 90th on DEC VMS with a VT-100 terminal I’ve worked with many different tools. SQL*Plus is of course the most important one because it’s available from the beginning and replaced sqldba and later on srvmgrl. But in 1999 I had the pleasure working with a tool which was intended to help Oracle PL/SQL developers: Tool for Oracle Application Development (T.O.A.D).

Toad – My DBA Tool Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c

Starting with Database Version 11g, Oracle offers with Direct NFS an integrated NFS-Client, which is independent from the underlying OS-based NFS-Client. This allows direct access to the NFS storage for the Oracle Instance and realizes Oracle’s own optimizations. In addition, one can implement multipathing over four parallel ports, independently from any switches, NIC bonding or teaming. The Oracle Instance configures the communication with the NFS automatically and thus facilitates the configuration under RAC. Using Oracle Direct NFS, shortly dNFS, also provides using NFS Storage with Oracle Instances on Windows systems.

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g

AMT 01

Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is not (Configuration > Used database features). In the “standard” Enterprise Manager 11g the appropriate configuration option still was installed (Server > Automated Maintenance Tasks). So the only way with 12c beside Cloud Control is the command line. The following works with both 12c and 11g.

Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

Extended Data Types with VARCHAR2(32767)

JA-Blog-042514-1

In the Oracle 12 New Features Guide you will find this sentence: “The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes“ Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.” ( Oracle® Database New Features Guide 12c Release 1 (12.1) E17906-16 Page 1-13 What great news! Especially if you want to upgrade your database to

Extended Data Types with VARCHAR2(32767) Blogbeitrag lesen »

By • • 7 minutes of reading
Scroll to Top