All UxOra articles related to Oracle database 11g/12c and SQL/PLSQL will be published under this category.
This article will show to use UDEV instead of ASMLib on Oracle Linux 7.
If for any reason you cannot or don't want to use ASMLib, then you can use UDEV instead. This is an alternative in order to present disks to ASM and this does not required to install an extra layer.
This article will show to install ASM support with ASMLib for Oracle Linux 7 in command line only.
ASMLib is an optional support library for the Automatic Storage Management feature of the Oracle Database. Automatic Storage Management (ASM) simplifies database administration and greatly reduces kernel resource usage (e.g. the number of open file descriptors). It eliminates the need for the DBA to directly manage potentially thousands of Oracle database files, requiring only the management of groups of disks allocated to the Oracle Database. ASMLib allows an Oracle Database using ASM more efficient and capable access to the disk groups it is using.
The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel.
This article will show how to install Oracle 11gR2 RDBMS software in silent mode ( Command line only, no GUI).
It is usual that you have an shell terminal access to a server without graphical X display.
In that case, it may be usefull to install Oracle in silent mode.
Table monitoring is by default activated if
STATISTICS_LEVEL system parameter is set to
Oracle keeps table monitoring data in memory, then flush it into the dictionary when
FLUSH_DATABASE_MONITORING_INFO is called. These datas are mainly used to determine if objects need new statistics.