I have created a DBaaS instance three weeks ago, and now it was time to attach new storage in the Oracle Compute Cloud Service to have additional disk space for some Trivadis tools. But after a reboot with a mouse-click in the DBaaS Cloud Service Console, the disk was lost and had to be re-attached. The procedure to add additional storage is documented in this Oracle tutorial: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/OU/IntroDBaaS/AddStorageDBaaSInstance/AddStorageDBaaSInstance.html Creating additional Storage in the Oracle Compute Cloud Service In the Create Storage Volume menu, I have created a new storage volume of 10GB and attached it to my running DBaaS instance called TrivadisExPerf. OS Verfication After some minutes waiting, I logged in on the database server to verify the operation. The…
Read MoreCategory: Oracle RDBMS
Patching a DBaaS Database in the Oracle Cloud
To apply a Patch on a Database which is hosted by Oracle is done with one mouse click. This service is available only if you have selected the full database service during the DBaaS order process. To the manual: https://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/GUID-50BDEF7D-A30E-4B32-BAE7-486538413E2D.htm#CSDBI3422 Patchset Availability As soon as a new Oracle patchset is available, you can see that in the database management dashboard of the selected database. The precheck function verifies if the selected database is ready to patch. Precheck Result After 2 until 3 minutes and a refresh of the page you see the result. Command Line Interface dbpatchm If you have no web access, all these steps can be executed manually in the shell.…
Read MoreOracle Enterprise Manager 12cR5 – Let’s connect to the Oracle Cloud
Since EM12c Release 5 Oracle has integrated the connection to the Oracle cloud, databases can be monitored and handled very easy, on-premise databases and cloud databases are now managed in one tool. Adding a cloud database to an on-premise EM12c from cloud.oracle.com is very easy and done in a few steps: Create a SSH key Create a DBaaS instance on cloud.oracle.com Configure a local Linux agent as Hybrid Cloud Gateway Agent Create an EM12c credential for SSH login Install EM12c Agent via push method on the DBaaS machine Discover and add the new targets Enjoy A few documents are available how this setup has to be done. But the best way to get some experience is just to do it.…
Read MoreEM12c Cloud Control – falsche Anzeige nach Rollentausch
Ausgangslage Nach einem manuellen Switchover auf Kommandozeile mit DGMGRL wird in EM12c Cloud Control die falsche Rolle angezeigt respektive nicht aktualisiert. Wenn man aber die Detailseite vom Target ansieht, so wird die Rolle richtig dargestellt. Analyse Das Verhalten kam mir bekannt vor, das gab es auch schon in EM11g Grid Control. Es gibt dazu die My Oracle Support Note Database Role not shown correctly in EM after switchover (Doc ID 1645496.1). Once switchover is done outside EM using dgmgrl and once this is done successfully, the roles of databases are not reflected correctly(targets > Databases. Here checking type) Hier noch der Link zur 11g Note: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1067752.1&displayIndex=1#FIX. Lösung Auf dem Server wo der Agent läuft, muss mittels emctl Kommando die Konfiguration…
Read MoreOracle 12c – Zwei Minuten bis “Connected to an idle instance.”
Ausgangslage Eine neue 12c Installation auf einer AIX 6.1 LPAR Auftrag Upgrade einer bestehenden 11.2.0.4 Datenbank mit der “Out-of-Place” Variante auf 12.1.0.2 Die Installation der 12.1.0.2 RDBMS-Software lief sauber durch SQL*Plus bleibt hängen Nach der Installation der 12c Software habe ich auf dem Server versuchsweise die Variable ORACLE_HOME auf das neu erstellte Verzeichnis gesetzt, um rudimentär SQL*Plus zu testen. ORACLE_SID wurde auf einen Dummy-Wert gesetzt damit die Meldung “Connected to an idle instance” angezeigt werden sollte. Doch wie heisst es immer so schön: Erstens kommt es anders, zweitens als man denkt! oracle@solothurn:~/ [rdbms12102] sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 14 12:45:57 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Nach ungefähr 2 Minuten kam…
Read More