Re: Anyone ever need more file handles on Solaris 8/Oracle 8.1.7

In comp.sys.sun.admin Chucky <chuck.carson_at_syrrx.com> wrote:

> I believe the default hard limit on Solaris 8 is 1024. It is very 
> dangerous to raise this limit above 1024. Has anyone had to do this? 
> Does anyone have any other ideas that might be causing these 
> intermittent ORA-12154 errors?

Well, oerr from 8.1.7 says:

12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray
// characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

I'd try using sqlplus from the command line to cycle through all of the DB service names you're using and make sure they all work, just as a basic sanity check. I'd also try doing that the next time the system encounters these errors, if they happen often enough.

Also check $ORACLE_HOME/network/log/listener.log. Have your apps log the Oracle connection info they were using and make sure that matches what you expected them to do...

-Chuck

PS: I agree with whoever else that you should go over your /etc/system settings; the Oracle client libraries are not a seperate codebase from Oracle's RDBMS product itself. Even if they aren't supposed to need special tuning of SysV shmem and so forth, you may have fewer problems if you replicate the Oracle settings from the DB server to the Oracle clients.

       Chuck Swiger | chuck_at_codefab.com | All your packets are belong to us.
       -------------+-------------------+-----------------------------------
       "The human race's favorite method for being in control of the facts
        is to ignore them."  -Celia Green