when I am going to start my database it gives the error 12500
how can I solve this problem? |
If like me to tell you trust, then it took whole my day just to understand the 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.
|
| Thank you for your valuable feedback Fuad |
I had tried as stated.
But problem remain existing in every ~10 Minuts
Please tell me solution in urgent basis |
Do you see errors in the listener.log file?
|
| TNS Listener is not starting in my system if i try to start it. it will automatically stoping ofter some time |
data base is not connecting using java code(data base system(node7) ,java system(node8) are connected in a domain ) and my domain name was changed resently.
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
|
Did you change the listener.ora to reflect the new hostname (domainname)?
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)))
|
Home