aspose file tools*
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31074
    
232

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31074
    
232

Moved as requested.

I imagine some parameters take effect immediately and others require a restart.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-12500: TNS:listener failed to start a dedicated server process