A lot of people are using Oracles KVM solution on ODA (Oracle Database Appliance). My company e.g. runs something like application servers in a Linux VM on the ODA lite models for our own software solutions (like communication server, etc.) if a customer runs ODAs (we call it "Solution-in-a-Box"). But there are also other customers, where we just act as system integrator, who want to use KVM on the ODA.
There is a really nice blog how to enable and use KVM on ODA, the starting point is this blog post by Tammy: kvm-on-oda.
It is straight forward, but one of the things are a little bit crucial. It is how to make the network configuration for the KVM on ODA. The best solution is to BRIDGE the network. Ruggero has written a blog post as part of Tammys blog, how you can enable all the different network types.
Don't use NAT or MacVTap - just follow the configuration steps for "Bridged networking (aka "shared physical device")".
Be sure you have access to the iloms host redirection function, because if there is any misconfiguration with the bridge, you lose the network connectivity und you are not able to connect internal (like you could do with ODA HA).
If you have followed the configuration steps and if you can connect to the ODA host again with the bridge configuration, you are not able to connect to the database(s) on that host anymore. Why? Because one mandatory step is missing at Ruggeros example: The configuration of the clusterware (as grid user)! Some tried to stop and start the listener, but the listener will not be started and errors out.
What you need to do as a last configuration step is to modify your clusterware network configuration. The listener is bound to Network 1, which can easily seen by issueing
$ srvctl config listener
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
To check the configuration, run the following command:
$ srvctl config network
Network 1 exists
Subnet IPv4: 10.214.0.0/255.255.248.0/btbond1, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
As you can see, the network is still configured to btbond1 instead of pubbr0.
The syntax (I use the same subnet in my example as Ruggero in his blog) to change this is:
$ srvctl modify network -netnum 1 -subnet 10.214.0.0/255.255.248.0/pubbr0
Now it is best to either restart the ODA to check if everything is running fine also after an reboot or at least to restart the listener.
$ srvctl stop listener
$ srvctl start listener
Then you are done folks, you can use the bridged device now for your KVM and the databases are reachable again.
Some more presentations... part 2 (with some corrections)
Hi all,
I have some date changes to tell regarding the post about where I do speak next about Oracle stuff.
So the new (and I hope fixed) dates in the next months are:
I have some date changes to tell regarding the post about where I do speak next about Oracle stuff.
So the new (and I hope fixed) dates in the next months are:
- 26.03.2019, Oracle Fokustag at Robotron Schweiz. I will speak about
19c New Features and a little bit about the new version of DBSAT
(Database Security Assesment Tool), I think.
Agenda und Anmeldung: Fokustag Oracle CH-Wil (St. Gallen)
- 9./10.04.2019, Oracle Database Appliance Events at Stade de Suisse,
Bern, and at Oracles Smart Innovation Center at the Prime Tower Zurich.
Main focus there is how the ODA can help you on premise to find your way
to the cloud and why Standard Edition 2 fits perfect to Oracles
Database Appliance.
Agenda und Anmeldung: Oracle Database Appliance Workshop Bern
Agenda und Anmeldung: Oracle Database Appliance Workshop Zuerich
- New: 07.05.2019 Robotron BusinessCafe at Duebendorf. I will speak a little bit about Oracle Cloud and (maybe) in addition a little bit about DBSAT (Database Security).
- CHANGED: Then, in May (14th), I will speak at the Oracle Fokustag of Robotrons
HQ at Dresden, also about 18c/19c New Features (including XE) and what a DBA need to
prepare to run 19c as a long-term release.
Agenda und Anmeldung (bald möglich): Fokustag Datenbanken in Dresden
- And last, but not least, the big Swiss Oracle User Group Day takes
part at May, 22nd at Olten. I will speak there again about 19c New
Features.
Some more presentations...
Hi all,
so many new things, so many testing, so many work to do at the moment.
But despite the fact I am testing Oracle Autonomous TP Cloud and PostgreSQL (last week I have finished the tests with pgBackRest as Robotron Standard Backup tool for our PostgreSQL customers) I am planning for some more presentations at events at Switzerland and Germany.
At the moment the following events are confirmed, unfortunately, for the english speaking people, they are all in german language.
Hope to see you at one or more events!
so many new things, so many testing, so many work to do at the moment.
But despite the fact I am testing Oracle Autonomous TP Cloud and PostgreSQL (last week I have finished the tests with pgBackRest as Robotron Standard Backup tool for our PostgreSQL customers) I am planning for some more presentations at events at Switzerland and Germany.
At the moment the following events are confirmed, unfortunately, for the english speaking people, they are all in german language.
- 26.03.2019, Oracle Fokustag at Robotron Schweiz. I will speak about 19c New Features and a little bit about the new version of DBSAT (Database Security Assesment Tool), I think.
- 9./10.04.2019, Oracle Database Appliance Events at Stade de Suisse, Bern, and at Oracles Smart Innovation Center at the Prime Tower Zurich. Main focus there is how the ODA can help you on premise to find your way to the cloud and why Standard Edition 2 fits perfect to Oracles Database Appliance.
- Then, in May (7th), I will speak at the Oracle Fokustag of Robotrons HQ at Dresden, also about 18c/19c New Features and what a DBA need to prepare to run 19c as a long-term release.
- And last, but not least, the big Swiss Oracle User Group Day takes part at May, 22nd at Olten. I will speak there again about 19c New Features.
Hope to see you at one or more events!
Guest Addition Installation "hangs" on Oracle VirtualBox after Upgrade from 5.2.22 to 6.0.4
I like running Oracles VirtualBox on my laptop for tests and demos. It is very easy to create new virtual machines, make snapshots, do test, roll back and forward to different stages.
In my holidays, Oracle now have released a new version of Virtualbox - version 6. As I was running 5.2.22 on my laptop, I downloaded the newest version (6.0.4) and installed it on my machine. The VMs started like they have done before, but as I do need the guest additions (for shared folders, etc.) I needed to upgrade them also.
When you start a VM, the VirtualBox software automatically checks for the existence of an older guest additions version and asks you, if you want to download/update to the newest version. You should do so - but in my case, after the download and the initial installation was done, the Run failed.
I was logged into my VM as root and the VBox Guest Addition iso was mounted automatically. Then it asked me to start the installation:
As I trusted this, I just started the installation by pressing the "Run" button. But the installation started a new terminal session and then it was hanging after some seconds at "Removing installed version of VirtualBox Guest Additions".
This shouldn't happen as it normally a very quick task. I tried to restart the VM, but it still stopped at the removing part of the Guest Additions.
I don't know, why this happened, but I was able to solve it by opening a terminal window as root and starting "autorun.sh" manually:
Doing this, the old Guest Additions were removed in some seconds and the new guest addition kernel was installed afterwards successfully (building was done in some minutes).
After restarting the VM, I was able to use the shared folders again.
So, if you have a problem with the Guest Additions after upgrading your VirtualBox software, try to start the Guest Addition installation from inside a root terminal window instead of using the normal autorun feature (even if you are logged in as root).
In my holidays, Oracle now have released a new version of Virtualbox - version 6. As I was running 5.2.22 on my laptop, I downloaded the newest version (6.0.4) and installed it on my machine. The VMs started like they have done before, but as I do need the guest additions (for shared folders, etc.) I needed to upgrade them also.
When you start a VM, the VirtualBox software automatically checks for the existence of an older guest additions version and asks you, if you want to download/update to the newest version. You should do so - but in my case, after the download and the initial installation was done, the Run failed.
I was logged into my VM as root and the VBox Guest Addition iso was mounted automatically. Then it asked me to start the installation:
As I trusted this, I just started the installation by pressing the "Run" button. But the installation started a new terminal session and then it was hanging after some seconds at "Removing installed version of VirtualBox Guest Additions".
This shouldn't happen as it normally a very quick task. I tried to restart the VM, but it still stopped at the removing part of the Guest Additions.
I don't know, why this happened, but I was able to solve it by opening a terminal window as root and starting "autorun.sh" manually:
Doing this, the old Guest Additions were removed in some seconds and the new guest addition kernel was installed afterwards successfully (building was done in some minutes).
After restarting the VM, I was able to use the shared folders again.
So, if you have a problem with the Guest Additions after upgrading your VirtualBox software, try to start the Guest Addition installation from inside a root terminal window instead of using the normal autorun feature (even if you are logged in as root).
Subscribe to:
Posts (Atom)