Update – see below – create 4K redo log files.
Place the redologs on filesystem instead of ASM. The only thing that solves the problem is to : Created 4096 sector size diskgroups instead of 512 as the disks are 4096 physical size and 512 logical size. set caching in azure portal to read-only. Removed any sort of caching in Azure portal on the ASM disks. We have tried a lot of things to see if they are related to the problem, but all these were having the same corruption : Standard DS13 v2 (8 vcpus, 56 GiB memory). On every other kernel version we tried, we couldn’t reproduce the corruption, it only occured on this particular version. ORA-00312: online log 2 thread 1: '+DATA/TST/ONLINELOG/group_2.323.1079171685'Īfter some debugging and rolling back changes we were able to pinpoint the problem to the kernel+ASM combination. ORA-16038: log 2 sequence# 125 cannot be archived Since then we are receiving redolog corruption on our databases whenever we do heavy load : This is nothing new as 7.6 already brought us the UEKR5 kernel in the past. Configure aliases in.bash_profile so that rlwrap gets enabled when you start the command alias sqlplus=”rlwrap sqlplus” alias dgmgrl=”rlwrap dgmgrl” alias rman=”rlwrap rman” alias lsnrctl=”rlwrap lsnrctl” alias asmcmd=”rlwrap asmcmd” alias adrci=”rlwrap adrci” alias impdp=”rlwrap impdp” alias expdp=”rlwrap expdp” You’ll never go back again 扫码关注dbDao.After an update of one of our Oracle systems in Azure to Oracle Linux 7.9 we noticed the installation of a new UEK Kernel. For OL6 you can use this RPM instead of manually making it: Then install it with: (root) # yum install 686.rpm. 
(root) #./configure (root) # make (root) # make install
Download latest rlwrap from and unzip it somewhere and Compile it. 
Install readline-devel (root) # yum install readline-devel.I hate having to manage a Linux system without this rlwrap is an utility that allows you to use up and down arrows in the various commands like sqlplus, rman, adrci, To enable it, you only have to do the following: Formatting Many Raw Devices At Once Under Solaris → Useful Oracle Shell Aliases And SQL*Plus Settings. Solaris, HP/UX, QNX, AIX and cygwin (special thanks to PolarHome for their.
0 kommentar(er)
