Re: ORA-12500: TNS:Listener failed to start a dedicated server process

In article <36C5B81D.1A8141AA_at_idc.karoo.co.uk>,   Ian Dawson <IDawson_at_idc.karoo.co.uk> wrote:
> I am trying to setup Oracle 8 on a Linux box and Oracle Client on an NT
> 4 workstation using TCP/IP. I have started the Oracle database and
> ensured the Listener has been started on the server. When I try to
> connect from NT, using Oracle Net8 Easy config, I get the ORA-12500
> error. I get the same error when I try to connect using Svrmgr on the
> Linux box.
> I would be grateful if someone can give me any help or pointers to where
> I can look for info.
> Thanks,
> Ian
>

I had a similar problem with the official release of the product. I think there is a problem in one of the installation scripts. When the installer copies the files for SQL*Net it does not set the proper owner for 'tnslsnr' and its log files. Got to your $ORACLE_HOME/bin directory and do 'ls -l tns*'. You should see that this file is owned by root. Shut down the listener (kill -9 if you have to) and chown the file to oracle:dba. Go to the log directories under $ORACLE_HOME/network and make sure Oracle owns the logs as well (the easiest way to do it is to log in as root and issue 'chown -r oracle:dba $ORACLE_HOME). Once Oracle owns all the files start the listener process and your connection problem should be resolved.

-b

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 15 1999 - 11:58:13 CST