wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes ORA-12500: TNS:listener failed to start a dedicated server process Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-12500: TNS:listener failed to start a dedicated server process " Watch "ORA-12500: TNS:listener failed to start a dedicated server process " New topic
Author

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

Arun raghvan
Ranch Hand

Joined: Aug 22, 2010
Posts: 75
ORA-12500: TNS:listener failed to start a dedicated server process ...i'm getting this error ,not able to open my database,can someone guide me step by step process to do things.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30146
    
150

http://ora-12500.ora-code.com/


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Arun raghvan
Ranch Hand

Joined: Aug 22, 2010
Posts: 75
Please,Move the thread to Oracle/OAS.
Arun raghvan
Ranch Hand

Joined: Aug 22, 2010
Posts: 75
When I increase value of parameter SORT_AREA_SIZE in init.ora file by some magnitide, it gets successfully connected even without restart of database service. How come?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30146
    
150

Moved as requested.

I imagine some parameters take effect immediately and others require a restart.
 
Consider Paul's rocket mass heater.
 
subject: ORA-12500: TNS:listener failed to start a dedicated server process
 
Similar Threads
Problem to run Oracle9i after installed in Windows2000 professional?
Oracle Error
Need to delete the configured DataSource manually without using console
Oracle database connection problem
Problem in connecting Oracle thru Java