Archive for September, 2009

AIX: Avoiding “ORA-27126: unable to lock shared memory segment in core”

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
# lsuser -a capabilities oracle
oracle
# chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
# lsuser -a capabilities oracle
oracle capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE

It should do now.

Regards
Usn


By Martin Klier in Linux / Unix,Oracle  .::. Read Comment (1)

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 each
  • Building disk group DATA from them, with redundancy NORMAL
  • containing four failgroups with each one of the disks within
  • In DATA, one ACFS volume of 1 GB in size, mounted to /acfs1

Read more…


By Martin Klier in Linux / Unix,Oracle  .::. Read Comments (3)

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). All other ALTER DISKGROUP clauses require the SYSASM privilege.

Just connect with

sqlplus / as sysasm

and you are happy.

Have fun
Usn


By Martin Klier in Oracle  .::. Read Comments (3)

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


By Martin Klier in Oracle  .::. (Add your comment)


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.