Home » RDBMS Server » Enterprise Manager » ora-12500
ora-12500 [message #268112] Mon, 17 September 2007 10:07 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Hi

My oracle was working fine before 2 hrs but now it showing me error when i m trying to connect it gives ORA-12500 : TNS-listener failed to start a dedicated server. pls help me its urgent

waiting for ur reply.

thank you in advance

samit
Re: ora-12500 [message #268113 is a reply to message #268112] Mon, 17 September 2007 10:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Whats your oracle version.???
Quote:
Common syntax issues in the listener.ora file can cause numerous listener connection problems, most notably this:

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

Sometimes this 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.

You can have a single listener, pointing to multiple Oracle instances, each on a different version.

In Windows, especially Oracle8 and Oracle8i, you may need to re-start the listener service using the Windows task manager.


http://www.dba-oracle.com/t_ora_12500_listener_process.htm

[Updated on: Mon, 17 September 2007 10:18]

Report message to a moderator

Re: ora-12500 [message #268114 is a reply to message #268112] Mon, 17 September 2007 10:23 Go to previous messageGo to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

hi,

thanks for the reply.

i m using windows server 2003 as my server and the oracle 9i as the database. i m attaching herewith my init.ora file pls suggest me what to do

samit
Re: ora-12500 [message #268185 is a reply to message #268112] Mon, 17 September 2007 22:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORA-12500: TNS:listener failed to start a dedicated server process
Cause: The process of starting up a dedicated server process
failed. The executable could not be found or the environment may
be set up incorrectly.
Action: Turn on tracing at the ADMIN level and reexecute the
operation. Verify that the ORACLE Server executable is present
and has execute permissions enabled. Ensure that the ORACLE
environment is specified correctly in LISTENER.ORA. The Oracle
Protocol Adapter that is being called may not be installed on the
local hard drive. Please check that the correct Protocol Adapter
are successfully linked. If error persists, contact Oracle Customer
Support.
Re: ora-12500 [message #268891 is a reply to message #268114] Thu, 20 September 2007 00:56 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-12500: TNS:listener failed to start a dedicated server process

For Above error there is couple of reason check below point.



1.Oracle Services is start.
Windows > c:\>net start OracleService
Unix > $ps -ef | grep ora_smon

2.Listener Services is start.

3.Take a look on LISTENER.LOG file {%ORACLE_HOME%/network/log}

4.if you received WINEXEC FORMAT ERROR 8

C:\>net helpmsg 8

Not enough storage is available to process this command.
Contact OS vendor for more information.

5.Sometimes it is happen due to PGA RAM shortage on database.
You have to set below parameters.
pga_aggregate_target, sort_area_size and hash_area_size.

6.TNS-00517: Lost contact
32-bit Windows Error: 54: Unknown error
If your received above error
C:\>net helpmsg 54

The network is busy.

7.TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error

C:\>net helpmsg 109

The pipe has been ended.

8.Recreate OracleService service through ORADIM utility

ORADIM -DELETE -SID
ORADIM -NEW -SID


http://dbataj.blogspot.com/2007/03/ora-12500.html
Previous Topic: oracle moves to shutdown and automaticaly up
Next Topic: How to connect to the another SID by 10g E.M?
Goto Forum:
  


Current Time: Fri Mar 29 02:33:14 CDT 2024