Have you always attached an OCI Block Volume to a Compute Instance? If yes, I assume by console or OCI CLI and then executed manually the iSCSI commands to attach the device on OS level. But wait, here is a magic way to attach the Block Volume – by the Oracle Cloud Agent. Prerequisites Attached Service Gateway in VCN Oracle Cloud Agent software installed on the instance Enable the Block Volume Management plugin Verify Compute Instance disk status Create a Block Volume and attach Block Volume to Compute Instance OCI Tool oci-iscsi-config The OCI CLI method – the expressway If you want to auto-attach a high-performance block volume (multipath enabled) or a block volume where auto-tune is enabled, these two…
Read MoreCategory: Oracle Linux
Oracle 11g – let’s move that old Stuff to the Oracle Cloud
This blog post describes the lift and shift of an on-prem Oracle 11g Enterprise Edition to Oracle Cloud Infrastructure by using Oracle RMAN paired with OCI Object Storage. Works for other versions > Oracle 11g / Enterprise Edition too (the tablespace encryption method may change). Architecture Q&A What’s the motivation of the lift and shift of a good old on-prem Oracle 11g database to Oracle Database Service? Hardware runs out of lifecycle Out scoping of an on-prem database which is only used for several times to compare old data Regulatory, for example we have the keep and access the data for 10 yrs Changing from on-prem licenses to the license included model Upgrade tests for 19c and convert to Multitenancy…
Read MoreMV2OCI – One-Click Move of your Data into Oracle Cloud Infrastructure Database
mv2oci is a tool which helps to migrate on-premise data to the Oracle Cloud Infrastructure based on Oracle Data Pump and works as a data load tool. The local Data Pump export is transferred and imported to/on the target cloud server automatically. There is no use of Oracle Cloud Object Storage, the dump files are transferred with rsync or scp to the target database node. This is the different behavior to mv2adb – see my blogpost here – which uses the Object Storage. As an option, the data can be transferred via Database Link (mv2oci Parameter –netlink). All you need to know about mv2oci is written in the My Oracle Support Note (OCI) MV2OCI: move data to Oracle Cloud Database…
Read MoreOracle Release Update 19.9 – Lab Update Time (Grid Infrastructure Standalone & RDBMS)
The Oracle Release update 19.9 for Linux is available since a few days. Time to upgrade my lab environment at home which consists of the following components: Oracle Grid Infrastructure Standalone 19.8.0 with ASM Normal Redundancy – +ASM Oracle 19.8.0 RDBMS as Repository for Oracle Enterprise Manager – EMREPO The running 19.8 Environment Output from Trivadis base environment tool TVD-Basenv(TM). oracle@mohnweg:/u01/app/19.0.0/grid/OPatch/ [em13cr4] u TYPE (Cluster|DG) : SID/PROCESS STATUS HOME [2020-10-25 19:47:47] ——————————————————————————— Dummy em13cr3 : em13cr4 n/a /u01/app/oracle/product/em13cr4 Dummy emagent : emagent n/a /u01/app/oracle/product/agent13c/agent_13.4.0.0.0 Dummy emagent : emagent_a n/a /u01/app/oracle/product/agent13c/agent_inst Dummy grinf : grinf19 n/a /u01/app/19.0.0/grid Dummy rdbms_ee : rdbms19 n/a /u01/app/oracle/product/19.0.0/dbhome_1 ASM-instance : +ASM up /u01/app/19.0.0/grid DB-instance (N|N) : EMREPO open /u01/app/oracle/product/19.0.0/dbhome_1 Listener : LISTENER up /u01/app/19.0.0/grid Ohs 12c…
Read MoreThe Grafana Plugins for Oracle Cloud Infrastructure Monitoring are back!
In September 2019 I wrote a blog post how to monitor an Oracle Cloud Infrastructure Autonomous database with Grafana plugin oci-datasource. But some weeks after publication, the plugin was not available on the Grafana page anymore. And only Oracle and Grafana had a clue why. Now everything will be fine now. Since the 6th of October, there are two new Grafana plugins available for download. They both don’t require a Grafana enterprise account. Oracle Cloud Infrastructure Metrics Data Source Oracle Cloud Infrastructure Logging Data Source The first one is a successor of the former oci-datasource plugin, the second allows to get logs from OCI resources like Compute or Storage. As an infrastructure guy, let’s install the Oracle Cloud Infrastructure Metrics…
Read More