ORA-12154

From: <nbindal_at_my-dejanews.com>
Date: Mon, 18 May 1998 20:52:38 GMT
Message-ID: <6jq72n$7h9$1@nnrp1.dejanews.com>

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.

Thanks,

-Nitin

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 15:52:38 CDT