ORA-12500: TNS:listener failed to start a dedicated server process
On Windows check if the service is started.
Oracle Services typically look like OracleService<SID>.
On Unix make sure you see the smon process running. When way to do this is using the ps command:
ps -ef | grep ora_smon
Another possibilty is that the system does not have enough resources available to start a new process or thread.
Have a look at the listener.log file, typically in your %ORACLE_HOME%\network\log directory on Windows or $ORACLE_HOME/network/log on Unix for more information or error messages.
On Windows you might see something like:
Winexec format error: 8
Contact your operating system vendor for more information regarding these error messages.
Welcome to our forum for Oracle error: ORA-12500 Add your own message
how can I solve this problem?
Database tips like a??ORA-12500: TNS: listener failed to start a dedicated server processa??. Also ORA-12500 is because of a PGA RAM shortage on the target database, based on the settings for pga_aggregate_target, sort_area_size and hash_area_size. But in fact that is a huge bullshit.
First of course check the free space size in your disk. If you think that free space in your base is enough then you must restart your listener else add some 1-2 GB (at least) and restart your listener.
After you restart your listener log back to your database. If the problem still exists (it usually goes after you restart you base) then get back into command line and run there sql+ (in my case) whatever you have got there.
Log in and startup the base. This will run your base and everything will go right.
For the future do not forget to stop by shut downing the base activity before you restart or turn off your server and to startup its activity after you server got power and gets back to normal.
Good luck.
But problem remain existing in every ~10 Minuts
Please tell me solution in urgent basis
before (before chaning the domain name )the connection establishing sucessfully
ofter changing the domain name Oracle TNS Listener is not starting properly
the error is desplaying in the java system like this :
Exception in thread "main" java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
so ply help me
If you did not change this, the listener won't start, and you will see some error messages in $ORACLE_HOME/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=unkownhost)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
18-JUL-2008 15:32:24 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\Data\ABSI\TOAD.exe)(HOST=LOCKPHMNL-FS01)(USER=Rcadaing_del))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.60.232)(PORT=1310)) * establish * orcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error
Can anybody help me with this? I need an urgent reply.. Thanks.
There is a problem with Oracle 9i and TrendMicro OficceScan 10
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-520092929 1073786111 9 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
“Trend Micro
Unauthorized Change Prevention Service” service.
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-520092929 1073786111 9 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
listener.log
07-JUL-2010 09:12:36 *
(CONNECT_DATA=(SID=appiq)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=x)) * establish * appiq * 12500
TNS-12500: TNS:listener failed to start a dedicated
server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5:
Input/output error
Stopping “Trend Micro
Unauthorized Change Prevention Service” service correct the issue.
i have used the dbca utilitis to create a new database.
when i try to connect to this databases with the session of the oracle owner it OK,but if i try to connect to the same database with an other linux user it tell me that listner failed to start dedicated server process.
cd $ORACLE_HOME/bin
ls -l oracle
The user who is trying to connect to the database probably has no access to it.
You also want to check access to the shared memory segment or semaphores using
ipcs
After you have rebooted, check the permissions again using ipcs
i tried : create tablespace SYSAUX size 150m;
but it tell me that option (it put the asterix * under the world size)invald;
i tried : create tablespace SYSAUX size 150m;
but it tell me that option (it put the asterix * under the world size)invald;
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
DATAFILE '/oradata/SID/sysaux_01.dbf
when i log into th oracle owner user and i type this command line (the first thing that i do)
ps -ef | grep ora_smon it shows something and i can connect to the database ,
but when i log into the other user (permission are granted for to execute oracle),th command shown above don't show any result.
we tried increasing the physical ram, and adjusting the appropriate pga ram parameters, increasing the sga disk space, but the problem keep comming back
The solution at the top of the string was excellent.
I got the error ora-12500
Restarted the listener and then restarted the database, Users were able to log in again.
Thanks.
tnsping servicename
Does it return the correct information? i.e servername and database id?
Either increase this parameter (and restart the database), of use Shared server connections
On Monday I was trying to apply a patch #7394394 and it failed. So I had to rollback the patch changes. Before I could apply the patch I had to stop the Oracle service (Obviously). Now after rollback I tried to open the SID service and it wont open. I deleted the old sid service "oradim -delete -sid servicename"
and it got deleted and then I created a new service with the same name using "oradim -new -sid "servicename" -intpwd password -startmode AUTO -pfile pfilepath\pfile\init.ora", the service gets created but it threw "DIM-00019: Create Service Error." error message. And now if try to manually start it the service it wont start.
The above was using command prompt, when I try to open it using the windows services i.e. services.msc, I get the following error message
"Could not start the OracleService service on the Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion"
I read through many forums and everywhere I saw that people said that its privilege issue. I'm the domain admin and the service is using the local admin account. I also tried using my username (I'm Domain Admin and in ORA_DBA group) but it wont work with that either. Please help!
I also checked the Listener.log file and the following are the entries:
"TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory"
-pfile pfilepath\pfile\init.ora"
Because you need to have the full path name, and you will need to include and open double quote
-pfile "c:\oracle\admin\MYDB\pfile\init.ora"
Thanks,
SN
Thanks,
SN
Is this a 32-bit version of Windows?
The maximum size for a proccess (oracle.exe in this case) is about 1,7Gb.
Every time you make a new connection, some extra space is assigned.
If a process is using a large amount of pga, you will reach the limit faster, hence the inconsistent behaviour (sometime 250, sometime 450, ...)
In order to get around this problem on a 32-bit Windows, you need to either use 4GT (by adding the /3G switch to your boot.ini) or AWE (Address Windowing Extension) by setting the use_indirect_data_buffers=true database parameter
total process in pfile =700 and the server memory=2GB. pls someone suggest me the solution.
regards
You probably reach the maximum size for the process, in order to avoid this, close your sessions, reduce the pga used, or use AWE/4GT (see post above of 27th of Feb)
I am working with 8.1.7 verson of oracle8i. Now i am facing error 12500 TNS:listener failed to start a dedicated server process. pl.. solve it.
You need to startup the database.
Logon to the database server, make sure your connection environment is ok, connect as SYSDBA and startup the database
I am working with 8.1.7 verson of oracle8i. Now i am facing error 12500 TNS:listener failed to start a dedicated server process. pl.. solve it.
Enter your message I am getting Output Session not Running when trying to connect using Oracle 9i client software.
Do you get this when connectin using sqlplus? Is there any Oracle number assiciated with this (12500 maybe?)
This is not a common Oracle error text message attached to ORA-12500, so extra info will be welcome
when I want to start Oracle Listener during the service start, suddenly appear this warning :
" teh oracle listener service on local computer started and then stopped. Some service stopped automatically if they have no work to do, for example, the performance Logs And AlertServices"
what I should do???
you will need to check your listener.log file.
It is typically in %ORACLE_HOME%/network/log
we have one schema and 600 sessions accesing that schema. Now a days whenever the number of sessions increases above 525 we are getting ora error 12500. Can anybody help us? we are now restrting the databse and managing it. But the error repeats once in two weeks or sometimes daily
Check your listener.log file, it will contain additional errors what happened.
If your are on Windows 32-bit you might have reached an internal limit.
If you do find an error in listener.log, please post it here and we'll work from there on
the listener log is as follows
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
31-AUG-2010 14:33:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(service_name=ekmnet)(SERVER=DEDICATED)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.44.98.1)(PORT=4172)) * establish * ekmnet * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
31-AUG-2010 14:33:24 * (CONNECT_DATA=(SERVICE_NAME=EKMNET)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=SSANETWEBSVR-2)(USER=IUSR_SSANETWEBSVR-2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.44.98.1)(PORT=4173)) * establish * EKMNET * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
31-AUG-2010 14:33:28 * (CONNECT_DATA=(SERVICE_NAME=EKMNET)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=SSANETWEBSVR-2)(USER=IUSR_SSANETWEBSVR-2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.44.98.1)(PORT=4174)) * establish * EKMNET * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
You reached the internal limit of Windows on a 32-bit system.
You either have following choices:
1) Make sure connections are closed when they are no longer needed
2) Implement connection pooling on the app server level or Multi-threaded server (MTS/Shared Server) on Oracle
3) Enable AWE on Windows level, this will buy you a little bit more time
Check our post of 27 feb 2009:
In order to get around this problem on a 32-bit Windows, you need to either use 4GT (by adding the /3G switch to your boot.ini) or AWE (Address Windowing Extension) by setting the use_indirect_data_buffers=true database parameter
we have one schema and 600 sessions accesing that schema. Now a days whenever the number of sessions increases above 525 we are getting ora error 12500. Can anybody help us? we are now restarting the databse and managing it. But the error repeats once in two weeks or sometimes daily. Databse is ora9i over windows 2003.
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.