List Error Hari ini
“lckpwdf: Lockf deadlock detection Cannot obtain lock for /etc/.pwd.lock”
“WARNING: Failed to lock file: /var/opt/ignite/recovery/mnr_lockfile: Lockf deadlock detection (errno = 45)”
“Oracle instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance degradation”
“ORA-00313: open failed for members of log group 2 of thread 1″
“ORA-00312: online log 2 thread 1: ‘/rdbms/oracle/users/oracle_sid/log_oracle-sid.ora’”
“ORA-27086: skgfglk: unable to lock file - already in use”
“HP-UX Error: 46: No locks available”

Machine Detail

• Model: 9000/800/SD32A
• Main Memory: 143277 MB
• Processors: 20
• OS mode: 64 bit
• OS: HP-UX B.11.11 U 9000/800

Solving with tuning the kernel parameter below here..

• nflocks = 200 + sum of database files for all instance
• maxfiles = 25% x current value
• maxfiles_lim = 25% x current value
• maxusers = No of connection oracle + 64
• maxuprc = maxusers * 5