Skip to main content
Delphix

KBA1244 Resource limitations on HP-UX target host

 

Issue 

Unable to provision or start a virtual database (VDB) once there are 16 VDBs on one HP-UX Target Environment.

Troubleshooting

Verify that you are running 16 (or more) VDBs on one HP-UX target and have received an error similar to the below when provisioning or starting a VDB:

Encountered User Exception in changeArchivelogMode()
exception.oracle.target.set.no.archivelog.mode {D04A| Failed to change archivelog mode}

If you have received the above error then verify in the Oracle alert log that this output is present:

ORA-09968: unable to lock file
HPUX-ia64 Error: 46: No locks available
Additional information: 1330464000
ORACLE_RECOVERY_ERROR 
 
Completed: ALTER DATABASE OPEN
sculkget: failed to lock /u01/app/oracle/product/11.2.0.3.rdbms/dbs/lkinstD04A exclusive
sculkget: lock held by PID: 1330464000
Oracle Instance Shutdown operation failed. Another process may be attempting to startup or shutdown this Instance.
Failed to acquire instance startup/shutdown serialization primitive
sculkget: failed to lock /u01/app/oracle/product/11.2.0.3.rdbms/dbs/lkinstD04A exclusive
sculkget: lock held by PID: 1330464000

Resolution

Double the number nflocks per the suggestion in the Oracle alert log from 4096 to 8192 using kctune

root# kctune nflocks=8192

Note: this does not require a reboot of the Target Environment nor of the Delphix Engine.