| ORA-12500: TNS:listener failed to start a dedicated server process [message #85855] |
Wed, 04 August 2004 07:37  |
Stupid
Messages: 8
Registered: November 2001
|
Junior Member |
|
|
My Oracle database sits on Windows 2000 Server with 3GB memory.
It works fine, but once a while some users will get this "ORA-12500: TNS:listener failed to start a dedicated server process" when they try to access the database via our ASP.NET IIS server.
Of course, if they wait a bit and come back in, everything works fine. I did select count(*) from v$process, it shows 139 and my process is set at 500.
This really starts to bother me as it interrupt our service to our customers.
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12500: TNS:listener failed to start a dedicated server process [message #86180 is a reply to message #86146] |
Tue, 07 September 2004 05:14  |
Greg
Messages: 35
Registered: July 2000
|
Member |
|
|
of course:
It's a Win2K machine (sp4) w/ 2.8G Xeon and 2.8G RAM. We're running Oracle 9i (9.2.0.1.0) in NOARCHIVELOG mode.
Veritas Backup Exec has it's little agent running on this machine as well (beserver.exe and bengine.exe), otherwise, nothing of note. I started to think that maybe my S/P GA's were underallocated, but the "advice" in EM indicates otherwise. What say you?
spfile:
-----------------------------------
*.aq_tm_processes=1
*.background_dump_dest='D:oracleadmindealbdump'
*.compatible='9.2.0.0.0'
*.control_files='d:oracleoradatadealcontrol01.ctl','d:oracleoradatadealcontrol02.ctl','d:oracleoradatadealcontrol03.ctl'
*.core_dump_dest='D:oracleadmindealcdump'
*.db_block_size=8192
*.db_cache_size=50331648
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='deal'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='deal'
*.java_pool_size=16777216
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=600
*.pga_aggregate_target=25165824
*.processes=700
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=100663296
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:oracleadmindealudump'
*.utl_file_dir='D:oracleadmindealutl_file'
Thanks,
Greg Johnson
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
