Change asm password file of diskgroup
Changing asm password file of diskgroup If you need to change asm password file of diskgroup… you can follow these steps: Check password file path: [root@nodo1 ~]# asmcmd pwget –asm +PROVOTOCR/orapwASM We change the path from old to new...
Previous steps with Oracle 12.2 and OEL 7.3 on VirtualBox
Linux OEL 7.3 and Oracle 12.2 on VirtualBox Before install Oracle 12.2 with OEL 7.3 on VirtualBox, I advise you to follow these steps for avoiding problems later: Update operating system OEL Modify Selinux Stop Firewall Install X packages to use graphic interface...
Install OEL 7.3 on VirtualBox
How to Install Oracle Enterprise Linux 7.3 on VirtualBox We are going to install Oracle Enterprise Linux 7.3 on a virtual machine (VirtualBox) beforely created here. Startup vritual machine Language Keyboard Time zone Partitioning hard disk Kdump Network configuration...
Create machine on VirtualBox
Create machine on VirtualBox Our intention is to have a machine on VirtualBox which is a base for some of our publications… Create a new virtual machine Modify cpus number Add disks (storage) Startup DVD (image .iso) Shared folders Network configuration Network...
RAC interconnect recommendations
Interconnect network is a critical component in a RAC environment. It’s very important to minimize latencies, increase its throughput and avoid lost of UPD packages. There’s more than a heartbeat Sometimes, when we work with sysadmin or network...
Do you want to benefit from Flex Asm with a 11.2.0.4 database?
The Oracle’s documentation is pretty clear regarding restrictions when using Flex Asm with databases: Table 4-4 Oracle ASM features enabled by disk group compatibility attribute settings Disk Group Features Enabled COMPATIBLE.ASM COMPATIBLE.RDBMS COMPATIBLE.ADVM...
Stored Outlines en Standard Edition
Can I use Stored Outlines with Standard Edition? YES since 10g. This could seem a simple answer, but that’s not the real thing as this is a poorly and confusedly documented Oracle functionality. Plan Stability vs SQL Plan Management There are two concepts...
Installing sample schemas in Oracle 12.2
Oracle Sample Schemas in 12.2 Sometimes you need, or maybe you only want them, some of the typical schemas from Oracle like HR, SCOTT, etc… in your database, well, we are going to install all of them on Oracle 12.2. We can see the documentation:...
