Re: ORA-12154

Hi Nitin,

Did you try to increase processes parameter in init.ora to more than 200?

Andrew Protasov

nbindal_at_my-dejanews.com wrote in message <6jq72n$7h9$1_at_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 Wed May 20 1998 - 09:26:26 CDT