Re: Problem with Linux and Oracle 8.0.5 and listener

Hello Ferran,

I think you mean ORA-12500. If so, the error means that there is either an account or system level resource restriction that is preventing a shadow process (dedicated server) from starting. These things can be damn hard to trace. It could be simply the maximum processes allowed per user, etc.

You might try running a sqlnet loopback on the linux server (ie, make sure the tnsnames.ora alias for the database is defined correctly and doing a "sqlplus <username>/<password>@tnsnamesalias") and run a strace against it. For example:

# strace -aef -o /tmp/trace.txt sqlplus system/manager_at_dev4

You might get lucky and see the failed resource allocation in the trace output.

If not, call Oracle support and let them have a wack at it.

Hope this helps.

Later,
Gene

Ferran Moreno wrote in message <7pgbkh$r72$1_at_talia.mad.ttd.net>...
>Hello!
>
>Sorry for my english ... but someone could help me ...
>I have instaled Oracle 8.0.5 for Linux in a Red Hat 5.2
>All it's OK , I can enter to the database whith sqlplus but if
>I try to enter from another machine on a network the server
>returns this message:
>
>ORA-XXXX The server couldn't start a dedicated server process.
>
>Thanks ...
>
>
Received on Fri Aug 20 1999 - 22:21:20 CDT