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

Joined: May 26, 2003
Posts: 29246
    
139

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: 29246
    
139

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
 
Similar Threads
Need to delete the configured DataSource manually without using console
Oracle Error
Problem to run Oracle9i after installed in Windows2000 professional?
Problem in connecting Oracle thru Java
Oracle database connection problem