Re: Help with Windows error

Interesting. It appears that at least one of the following may be true:

• There's bug in Windows/Oracle reporting an error that is not used Good luck finding the real error. It will require tech support.
• The documentation is incorrect and somebody snuck POSIX compliant error codes into Windows.
• You forgot to sacrafice a Mac to the PC gods.

Jared

On 6/28/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> Good luck
>
> http://support.microsoft.com/kb/47692/en-us suggests that the
> underlying OS error isn't valid on that OS!
>
> I'd certainly be raising a tar if I can (though they might come back
> with "out of support"), I'd also check for
>
> large numbers of open files
> hitting the 32bit process memory limit
> permissions issues (is Oracle running as LocalSystem are the
> %ORACLE_HOME% permissions right and so on.
>
> cheers
>
>
> On 6/27/06, Jared Still <jkstill_at_gmail.com> wrote:
> > Have a look at http://www.wlug.org.nz/ErrorMessages
> >
> > Then click on EMLINK.
> >
> > Yes, I know it is Linux, but read the description of possible causes.
> >
> > This is a POSIX error, which could very likely be your Error 31.
> > FAT filesystems do not use hard links, but NTFS can, though I
> > don't know if hard links are a special case on NTFS.
> >
> > Do these apps create a lot of sub-directories?
> >
> > Or perhaps NTFS Hard Links?
> >
> > Jared
> >
> >
> >
> > On 6/27/06, Sweetser, Joe <Joe.Sweetser_at_infocrossing.com> wrote:
> > > Oracle 8.1.7.4.1
> > > Windows 2000 SP4
> > >
> > > Intermittent error that (so far) is only resolved with a server
> reboot.
> > > Error manifests itself many ways but the most obvious are inability to
> > > connect to the database and/or inability to log into the server
> itself.
> > > If you do get logged in to the server...inability to start an
> > > application; be it cmd or sqlplus. The error at that point is "Failed
> > > to initialize application". No errors in alert.log and database comes
> > > up fine after reboot.
> > >
> > > The only error I've found is in the listener.log and I can't figure
> what
> > > the underlying Windows error truly means. I have googled and
> metalink'd
> > > to no avail.
> > >
> > > 26-JUN-2006 10:23:18 * <snip> * establish * limsprod * 12500
> > > TNS-12500: TNS:listener failed to start a dedicated server process
> > > TNS-12560: TNS:protocol adapter error
> > > TNS-00530: Protocol adapter error
> > > 32-bit Windows Error: 31: Too many links
> > >
> > > Can anyone shed some light on what "Too many links" means? Open
> files?
> > > Network connections? Sockets?
> > >
> > > Thanks in advance,
> > > -joe
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l