Re: ORA-12154

In article <6jq72n$7h9$1_at_nnrp1.dejanews.com>,   nbindal_at_my-dejanews.com wrote:
>
> Hi,
>
> We are running an application on Solaris 2.5.1 using ORACLE server version
> 8.0.4 and ORACLE client version 7.3.2. The application initially forks 50
> child processes, which establish ORACLE connections using RogueWave
> DBTools.h++ version 1.1.0. When any child process has processed 2000
> transactions, we exit that child, and spawn a new process instead. All this
> works fine till we have spawned total 200 processes. After that, for every
new
> process that is forked, we consistently get ORACLE error ORA-12154 while we
> try to connect to the database.
> We have tried following directions in ORACLE ORA-12154 FAQ, but it hsn't
> helped.
>
> In init.ora file, the current settings for ORACLE processes is 200 and
> sessions is 225. We have checked sqlnet.ora and tnsnames.ora files for any
> possible errors, but haven't found any.
>
> We would appreciate any suggestions.
>

You probably need to up the SEMMSL in the kernel, which is a hard limit beyond which PROCESSES in init.ora cannot go.

> Thanks,
>
> -Nitin
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 21 1998 - 20:22:29 CDT