Did you ever change lock_sga = true for an Oracle Instance on AIX 5.3, and did see ORA-27126: unable to lock shared memory segment in core IBM AIX RISC System/6000 Error: 1: Not owner in Return? Do the following: # vmo -o v_pinshm v_pinshm = 0 # vmo -o v_pinshm=1 Setting v_pinshm to 1 # […]
Month: September 2009
Oracle 11gR2 ASM / ACFS: A first benchmark (poorly)
Hi folks, since Oracle 11g Release 2 is out now, I had to test one of the most-missed ASM features: the ASM cluster file system ACFS. My Setup: Two VMware nodes with 2 CPUs and 1,5GB of RAM each Oracle Enterprise Linux 5.3 x86_64 Four virtual cluster disks from the ESX server, 10GB in size […]
Oracle 11gR2 ASM: Changed permission policy (ORA-15260)
Did you recently see the new error ‘ORA-15260: permission denied on ASM disk group’ in your ASM administration? Maybe you are still connected as SYSDBA, old habit from 10g? A quick citation from the Oracle Docs: The SYSOPER privilege permits the following subset of the ALTER DISKGROUP operations: diskgroup_availability, rebalance_diskgroup_clause, check_diskgroup_clause (without the REPAIR option). […]
Oracle 11g Release 2 documentation
The long-awaited 11gR2 is out, at least for Linux x86 and x86_64 now. Marketing will show you all the features, but the most important link is to the documentations: http://www.oracle.com/pls/db112/homepage Use it well! Usn […]