Running nscd daemon will help with the too many open files issue (encountered with poster error ORA-12560). With NSCD being active, library functions--such as getpwent ( ), gethostbyname ( ), etc.--which implicitly call fopen ( ) to open UNIX configuration files--such as /etc/passwd or /etc/hosts or /etc/nsswitch.conf, etc.--that are invoked by OCI code will be subverted. This will help Shareplex OCI code not to exceed the 256 fopen() limit.
NSCD caches the contents of the standard UNIX system files and presents this information to interested parties, unifying and simplifying the process dramatically, while obviating the widespread reliance on buffered I/O to fulfill these requests. It supplies the Oracle logon function, as invoked by poster and reader, with all of the system information it required, removing the need for it to physically open and retrieve the contents of the various individual files, effectively circumventing the problem.
Stopping and shutting down NSCD:
/etc/init.d/nscd stop
/etc/init.d/nscd start
Shareplex needs the following configuration settings for NSCD to have cache enabled for passwd, group, hosts, and ipnodes.
cat /etc/nscd.conf
Make sure you have the following lines commented out as shown below to enable caching on ipnodes, passwd, group and hosts.
#enable-cache ipnodes no
#enable-cache passwd no
#enable-cache group no
#enable-cache hosts no
NOTE: In some cases, you may need to increase nofiles limit (ulimit -n xxxx) if you are truly running out of file descriptors. Refer to Solution 14128 - "Error: "Error: 12032 - OCIServerAttach failed with ORA-12560. [sp_opst_mt(osp)/3999] Notice: ORA-12560: TNS:protocol adapter error. [sp_opst_mt(osp)/3999]" and MTP Poster crashes" for more information:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL14128