SQLcl – «Create Table As Select» between databases with «bridge» and without dblinks

Adding manually the GIMR in 12.2.0.X version

Now you can add the internal database MGMTDB after the GI installation. Follow the note «MDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)» In our case we check that the GIMR not exist: [root@nodo01 tmp]# crsctl stat res -w “NAME =...

OVM: How to create virtual machines

Hi, we use one script, which base its commands on ‘ovmcli’, you can see this blog: https://arumel.com/en/connecting-to-the-oracle-vm-cli-without-password/ The most important part, when you are creating virtual machines for templates, is the order in the...

Upgrading OVM Manager from 3.4.5 to 3.4.6

You can download the software from Oracle web (version 3.4.6): ovmm-3.4.6-installer-OracleLinux-b2105.iso Mount .iso image into the dvd and install: [root@ovmmanager1 mnt]# blkid/dev/sr0: UUID=”2018-11-18-18-00-21-00″ LABEL=”OVMManagerInstaller3.4.6_b2105″...
SQLcl – «Create Table As Select» between databases with «bridge» and without dblinks

Script to configure HugePages in Linux

Script to configure HugePages in Linux     Sometimes you have just finished the installation of the operating system (OEL in our case) and you want to configure the hugepages for the SGA of Oracle.   Here you can see one script to configure the 80% from...
SQLcl – «Create Table As Select» between databases with «bridge» and without dblinks

Connecting to the Oracle VM CLI without password

Connecting to the Oracle VM CLI (Command Line Interface) without password   Sometimes you need to work with the command line interface in OVM Manager, for instance if you want to execute several commands in parallel, and it is very hard and boring if you need to...