using AWR on Exadata

Oracle released a brand new Whitepaper for Exadata

How to use AWR Report on Exadata Machines

This Whitepaper gives details how the AWR reports can be used in conjunction with Exadata to monitor and analyze database performance issues

http://www.oracle.com/technetwork/database/availability/exadata-maa-best-practices-155385.html

 

 

 

ORAchk (EXAchk) und der Collection Manager (Teil 2)

Nun geht es mit Teil 2 weiter.

Nach dem nun die APEX Installation fertig ist, geht es darum den Collection Manager zu installieren und zu konfigurieren.

Dazu empfehle ich sich für das Setup parallel die Dokumentation, also das User’s Guide „Oracle® ORAchk and EXAchk“ und hier Kapitel 1.9 Oracle Health Check Collections Manager for Oracle“ zu öffnen.

Wir melden uns nun am Admin Service an:

 

http://o1:8080/apex/apex_admin

Der neue „Workspace“ wird erstellt. Im zweiten Schritt (more...)

Well, That Didn’t Work …


"There are no wrong roads to anywhere."
-- Norton Juster, The Phantom Tollbooth

Interesting behavior with the unified audit trail has been reported by Jeff Hunter and verified on at least two platforms, Solaris 10 and RedHat Enterprise Linux 6. While other ports of Oracle behave as expected (Windows and Oracle Enterprise Linux 7, to name two that I’ve tested) the problem platforms fail to return data from V$SESSION because the AUDSID values apparently (more...)

ORAchk (EXAchk) und der Collection Manager (Teil 1)

ORAchk & EXAchk sind wichtige Tools im täglichen Oracle DBA Geschäft. Allerdings habe diese Tools wenn man Sie einmalig oder mehrfach startet den großen Nachteil das man jeweils einzelne Reports erhält und diese nicht miteinander vergleichen kann, oder eine Historie erhält. Es bedeutet im Umkehrschluss man muss sich selbst eine „Ordnung“ überlegen und die Verwaltung übernehmen.

Genau an diesem Punkt kommt nun der „Collection Manager“ ins Spiel, der eine komplette APEX Anwendung ist und die (more...)

Eviction Notice


"Expectations is the place you must always go to before you get to where you're going. Of course,
some people never go beyond Expectations, but my job is to hurry them along whether they like it or not."
-- Norton Juster, The Phantom Tollbooth

Oracle has decided that Solaris needs to retire, giving those who are running Oracle on Solaris roughly two years to move to another operating system. A possible choice involves commodity (more...)

hostname in Oracle Linux 7.x ändern

Möchte man in Oracle Linux Version 7.x (ich nutze hier im Beispiel OL 7.5) den „hostname“  ändern, hat man drei Möglichkeiten:

NetworkManager text user interface tool


# nmtui

Menüpunkt auswählen Namen setzen abspeichern fertig

NetworkManager command line tool „nmcli“ 

 


# nmcli general hostname

Setzen des hotsname mit

# nmcli general hostname o2

 

Das „hostnamectl“ Kommando


# hostnamectl set-hostname o2 --static

Überprüfen kann man seine „Arbeit“ wie folgt


# hostnamectl status
Static hostname: o2
 (more...)

Oracle DB Upgrade 12.1 auf 12.2

Ich bin gerade dabei einige Datenbanken von 12.1 -> 12.2 upzugraden. Dazu setzte ich den DBUA ein und bin sehr positiv überrascht. Viele Checks werden im Dialog abfragt und diese werden dann während des Upgrade Prozess umgesetzt. Der Upgrade läuft reibungslos durch auch wie in meinem Fall auf RAC Datenbanken.

Möchte man den Pre-Upgrade vorab durchführen und dies per Skript steuern, dann kann man auf Metalink dazu ein Skript herunterladen. Dieses Skript sammelt (more...)

Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement

Today, we are very happy to release SQLdb360, a new tool that merges together eDB360 and SQLd360, under a single package.

Tools eDB360 and SQLd360 can still be used independently, but now there is only one package to download and keep updated. All the new features and updates to both tools are now in that one package.

The biggest change that comes with SQLdb360 is the kind invitation to everyone interested to contribute (more...)

Developing concept products that embrace emerging technologies

Editor’s note: For posterity’s sake, I’m reposting some content that we created during our time at Oracle. These statements and views are those of the author and do not reflect those of Oracle’s current user experience organization.

Developing concept products that embrace emerging technologies

Working with emerging technologies brings unique challenges for developers. There are few to no users out there one can ask about requirements.

The AppsLab, the Oracle Applications User Experience (OAUX) emerging (more...)

Designing for What’s Not Yet Here

Editor’s note: For posterity’s sake, I’m reposting some content that we created during our time at Oracle. These statements and views are those of the author and do not reflect those of Oracle’s current user experience organization.

Designing for What’s Not Yet Here

Designing for emerging technologies means seeing how these technologies can help solve user problems in the enterprise and turn invention into innovation. Because design is somewhere at the intersection of people, technologies, (more...)

User Research at the Forefront of Technology

Editor’s note: For posterity’s sake, I’m reposting some content that we created during our time at Oracle. These statements and views are those of the author and do not reflect those of Oracle’s current user experience organization.

What do you do when you don’t have users yet?

Oracle’s approach to researching emerging technologies isn’t really about the technology; it’s about the users: observing, listening, empathizing, and learning about our users and what matters to them.

(more...)

Playing at work promotes discovery, opens door to innovation

Editor’s note: For posterity’s sake, I’m reposting some content that we created during our time at Oracle. These statements and views are those of the author and do not reflect those of Oracle’s current user experience organization.

Playing at work promotes discovery, opens door to innovation

What if work could also be play? It turns out that it’s both better for the worker and for the work. As such, it’s something the Oracle Applications User (more...)

Emphasis on emerging technology shapes user experience strategy

Editor’s note: For posterity’s sake, I’m reposting some content that we created during our time at Oracle. These statements and views are those of the author and do not reflect those of Oracle’s current user experience organization.

Emphasis on emerging technology shapes user experience strategy

The AppsLab, the OAUX emerging technologies team, has a passion for investigating how emerging interactions and technologies can benefit Oracle users.

While this team has existed for many years, Oracle (more...)

Export – Import Business, Again


"At first it was difficult to tell just what had changed—it all looked the same
and it all smelled the same—but, for some reason, nothing sounded the same."
-- Norton Juster, The Phantom Tollbooth

Doing things just because “they’ve always been done that way” may not be the best reason to stick with old and accepted processes and utilities. Oracle has changed significantly over the years and those improvements shouldn’t be ignored simply because (more...)

Playing with ADWC (Autonomous Data Warehouse Cloud Service)

Oracle has launched Oracle 18c and the Autonomous Data Warehouse Cloud Service (ADWC). Many people call the Oracle 18c as the Autonomous database, and this is a huge mistake! Oracle 18c (that is in reality Oracle 12.2.0.2) is not an

Playing with Oracle Ravello – Migrating your VMs to the Cloud

Hello everyone, A few years back we had the boom of the “Private Cloud” rush, where everyone started to implement virtualization technologies to make a better use of it Infrastructure resources and improve high availability, scalability and innovation! Now to

The Forgotten Link To The Cloud

(Note: This article was also published at Oracle.com – https://blogs.oracle.com/database/the-forgotten-link-to-the-cloud) Last year when presenting a session at Collaborate’17 in Las Vegas regarding Tips and Best Practices for DBAs, I went thru the evolution of the DBA profession and also gave

A week of PostgreSQL

One of the attractive things of my job is this… Just a bit more often than every now and then, you get the opportunity to get out and meet people to talk about Postgres. I don’t mean the kind of talk I do every day, which has more of a commercial touch to it. – Don’t get me wrong, that is very important too! – But I mean, really talk about PostgreSQL, be part of (more...)

Epilogue

The AppsLab experiment ended this week as nearly all of us were laid off from Oracle.

Noel and I decided to keep this blog running, both as a historical resume of sorts and as a way for all of us who worked in ‘Lab over the years to share our ongoing adventures and talk about technology.

We had a good run, thanks to executive leaders like Paul and Jeremy, and I will always remember the (more...)

Playing with Oracle Cloud – Creating a Hybrid DR Deployment

On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high