RE: ORA-12500 error

Responding to the few responses I got.

Maheshwara: My TNSNAMES.ora does have ORCL.WORLD.

Bill:  		My listener.log files rae not big, and I did delete them.
Vadim:		It's not working wth only 1 connection.

Still no success. I'm creating a new 8.1.6 instance and will import the data from the old 8.1.5 and blow it away. Not my first choice, but no alternatives.

Gary

-----Original Message-----
Sent: Wednesday, May 24, 2000 3:02 PM
To: Multiple recipients of list ORACLE-L

Hi,
Get ORA-12500 "TNS:listener failed to start a dedicated server process" trying to connect
I'm using 8.1.5 on NT
I can connect locally to my 8.1.5 database using svrmgrl and exp, but not with us/pw_at_orcl. Connect a/b works, connect a/b_at_orcl gives ORA-12500.

It was working fine the past year until I recently shutdown and started the database.

I checked possible problems found in Metalink notes, all with no success: I stopped all extra programs (Web Server, discoverer...) to clear up resources
I changed init.ora to have the instance use less memory I increased processes in init.ora
There are no warnings in NT Event Viewer Doesn't matter if I start the listener with either NT services or lsnrctl NT listener service is running as system - no change

Is this fixable through SQL*Net or the database? My next thought is to uninstall and reinstall SQL*Net. Might that help?

Gary Fox
Vertex Systems, Inc.
310-571-2222
garyf_at_vertexsystems.com
www.vertexsystems.com
Gary Fox
Vertex Systems, Inc.
310-571-2222
garyf_at_vertexsystems.com Received on Tue May 30 2000 - 11:33:58 CDT