Re: Resource issues Solaris 7 and 8.1.5

From: Yong Huang <yong321_at_yahoo.com>
Date: 4 Nov 2002 10:31:14 -0800
Message-ID: <b3cb12d6.0211041031.7693b9ae@posting.google.com>

"Tom" <tomNOSPAM_at_eazyriders.com> wrote in message news:<PCbx9.9159$VO2.63539228_at_news-text.cableinet.net>...
> bash-2.02$ sqlplus user/pass_at_AUDI2
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Thu Oct 31 16:53:42 2002
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12500: TNS:listener failed to start a dedicated server process

Does the listener log show any more errors? Did you check the system memory and swap space usage? Is /tmp full? When we got this error twice on Solaris, listener.log showed OS error 12 (Not enough core). Deleting huge files under /tmp cleared that up.

> bash-2.02$ ORACLE_SID=AUDI2
> bash-2.02$ svrmgrl /nolog
>
> Oracle Server Manager Release 3.1.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> ld.so.1: oracleAUDI2: fatal: /u01/app/oracle/product/8.1.5/lib/libjox8.so:
> mprotect failed: Resource temporarily unavailable
...

Why is ORACLE_SID not exported? Is ORACLE_HOME set?

Yong Huang Received on Mon Nov 04 2002 - 12:31:14 CST