Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-12500 error
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
Received on Wed May 24 2000 - 12:59:06 CDT
![]() |
![]() |