Return
-
Title
Error: "too many open files" and "ORA-12560" when Running NSCD (Name Server Cache Daemon). -
Description
Error received when Running NSCD (Name Server Cache Daemon):
"too many open files"
and
"ORA-12560: TNS:protocol adapter error" -
Cause
Getting too many open files on post or getting ORA-12560 due to fopen() has 256 file limit on Solaris. -
Resolution
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 -
Additional Information
Apply to Sun Solaris environment only.