Complément: Mettre en place AWR Warehouse

Le patch permettant la mise en place d'AWR Warehouse dans Enterprise Manager 12.1.0.4 est disponible ( cf note 1907335.1) !

Pour activer AWR Warehouse, l'administrateur d'Enterprise Manager doit :
  • Créer une instance de base de données Oracle Database 12.1.0.2 (recommandé) ou 11.2.0.4+ pour le référentiel AWR
  • Découvrir l'instance dans EM12c
  • Appliquer le patch sur l'OMS (cela permet d'avoir AWR Warehouse dans le menu)
  • Appliquer le (more...)

New AWR Report Format: Oracle 11.2.0.4 and 12c

statistics-and-graphs

This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)

Partner Webcast – Oracle Database 12c Recovery Manager (RMAN): Next Generation Backup and Recovery

Oracle is offering a comprehensive set of Database High Availability capabilities that seamlessly work together to help reduce both planned and unplanned downtime. Oracle Maximum Availability Architecture (MAA) provides with a best practices blueprint that can significantly reduce the cost and complexity of database high availability deployments. In our webcast we will provide an overview of the latest technologies for backup and recovery of the Oracle Database, guiding you through Oracle Recovery Manager, common configuration (more...)

Oracle Database 12.1.0.2 がリリースされました!

本日、Oracle Database 12.1.0.2の提供を開始しました。(プレスリリース資料はこちら



まずはイベントのリマインダーです。

明日、7月24日(木)「Oracle DBaaS & Big Data Summit」が東京・恵比寿で開催されます。

最新のOracle Databaseの新機能、In-Memoryオプションについて今すぐ知りたい方は「Oracle Database In-Memory Option徹底解剖」セッションを是非ご視聴ください。その他にもOracle Databaseの最新技術の活用方法、お客様事例など、お客様の課題解決に役立つ情報が満載のビッグ・イベントです。まだお席がございますので是非ご参加下さい。(要登録)  
(※同イベントは、8月7日(木)に大阪でも開催します。)


(以下は、米国オラクルのDatabaseテクノロジストMike Dietrichのブログ「Update your Database-NOW!」の抄訳です。)


Oracle Database 12.1.0.2が、OTNサイト(US)からダウンロード可能になりました。これまでのビルドで最も広範囲に及ぶパッチセットとなります。

Oracle Database In-Memoryのほか、様々な新機能の追加・機能向上が行われています。是非、最新のOracle Database 12cをお試し下さい。

Point 1) フル・リリースです。前バージョン12.1.0.1を入手する必要はありません。
Point 2) OTNおよびeDeliveryで入手可能です。(12.1.0.1はまもなく削除されます)
Point 3) とりあえず、Enterprise Editionのみです。SEならびにSE Oneは後日リリース予定です。(詳細は、MOS Note:1905806.1(英語)をご覧下さい)

新しい機能および機能強化分野はざっと以下のとおりです。

    Oracle Database In-Memory
    Oracle Big Data SQL
    Oracle (more...)

Watch Replay: Oracle Database Technology and Specialization Update PartnerCast

Missed the live PartnerCast? On-demand segments are now available! PartnerCast: Oracle Database In-Memory PartnerCast: Oracle Enterprise Manager 12c R4 PartnerCast: ODB Performance & Tuning Specialization

New! ACS Whitepaper On Migrating Oracle Databases

A new customer-facing ACS whitepaper entitled, “Migrating Oracle Databases” featuring (ACS’) Oracle Migration Service is now available. Review it today!

Oracle 12c: Modern Platform For The Modern Business

Oracle 12c BPM, 12c SOA and 12c In-Memory are here, making it easier than ever to deploy and manage reliable, high-performance database platforms while seamlessly extending and integrating applications. Evites now available for 12c Database and Fusion Middleware events!

New section: Oracle SLOB Testing

slob ghost

For some time now I have preferred Oracle SLOB as my tool for generating I/O workloads using Oracle databases. I’ve previously blogged some information on how to use SLOB for PIO testing, as well as shared some scripts for running tests and extracting results. I’ve now added a whole new landing page for SLOB and a complete guide to running sustained throughput testing.

Why would you want to run sustained throughput tests? Well, one (more...)

Cloud Control: How a Camel can make you cross a Data Guard Mountain

In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. And it doesn’t have to be.

But first a short description of the situation. I have a working Data Guard broker configuration between two Cluster Databases running Oracle 11.2.0.4 on linux x86-64. Both clusters have an Cloud Control agent (12.1.0.4) (more...)

Invoker Rights in Oracle Database 12c : Some more articles

I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back.

I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and views respectively.

Connecting Oracle 11g to RDB database with Oracle Heterogenous Services

One of my clients has been running an Oracle RDB database on VMS for decades.

This RDB database stores mission critical data and interfaces with COBOL applications and Oracle 8i databases.
(If you wonder what RDB is; it’s a RDBMS created by DEC in 1984 and bought by Oracle in 1994)

While modernizing the IT landscape, the client expressed the desire to reduce complexity and migrate the mission critical data in RDB to an Oracle (more...)

How to add your Standby Cluster Database to Cloud Control

The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider myself part of the people who like to work with the command line. That way you really get to understand what you are doing and you won’t have to panic when you don’t have a GUI at your disposal. Once that’s an acquired skill I will (more...)

Move That Datafile!

Moving datafiles has always been a pain.  There are several steps, it’s fairly easy to make a mistake and it requires the datafile to be offline.  There are also different steps depending on whether the database is in ARCHIVELOG mode or not.  In ARCHIVELOG mode, the steps are…

1)      Take the tablespace containing the datafile offline
2)      Copy/rename the datafile at the OS layer
3)      Use ALTER TABLESPACE…RENAME DATAFILE (more...)

Evènement : Evènement In-Memory Paris


Retrouvez les articles de presse consacrés à l'évènement de lancement d'Oracle In-Memory Paris :

Counting the many rows of Oracle GoldenGate

******NOTICE******
!The code contained in this post is meant to be  used at your own risk!
******NOTICE****** 

With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on.  One aspect that many people want to know is how can I validate that every record is being transferred to the target system.  Once such way is to use Oracle Veridata; however, some times there is not enough time to setup and (more...)

New My Oracle Support note on Advanced Format (4k) storage

advanced-format-logo

In the past I have been a little critical of Oracle’s support notes and documentation regarding the use of Advanced Format 4k storage devices. I must now take that back, as my new friends in Oracle ASM Development and Product Management very kindly offered to let me write a new support note, which they have just published on My Oracle Support. It’s only supposed to be high level, but it does confirm that the _DISK_SECTOR_SIZE_OVERRIDE (more...)

Annonce : Oracle Database In-Memory

Retrouvez l'annonce officielle d' Oracle Database In-Memory :

Oracle 12c – New SYS-level Administration Privileges

For a while now, Oracle has been moving its security model toward a more differentiated set of privileges than just SYSDBA and SYSOPER.  We saw this in 11g with the SYSASM privilege.  This is in response to the growing number of DBA shops that delineate permissions at a more granular level, even among DBAs.  Rather than saying, “Here’s my DBA team, everyone has SYSDBA,” more and more IT shops are defining DBA (more...)

Complément : Nouveautés d’Oracle Enterprise Manager 12c Release 4

https://event.on24.com/eventRegistration/EventLobbyServlet? border=

Complément : EM12 12c & ODA

Livre blanc intéressant sur l'installation d'Oracle Enterprise Manager 12c Release 3 sur une plate-forme Oracle Database Appliance :
http://www.oracle.com/technetwork/database/database-appliance/documentation/oda-oemcloudcontrol-2209378.pdf