Dear Sir,
I am getting the below error.
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153094144)(ERR=12500)(ERROR_STACK=(ERROR=(CODE
=12500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BUF
='32-bit Windows Error: 233: Unknown error'))))
Please guide us
Regards,
Tulashidas
Full Version: ERROR=(BUF='32-bit Windows Error: 233: Unknown error'
Hi Tulashidas,
>> =(CODE=12560)(
From the OS prompt, do an "oerr ora 12560
Please read:
http://www.dba-oracle.com/t_ora_12500_listener_process.htm
You need to:
- Add more RAM for PGA
- Make PGA regions smaller
- Implement stared servers
>> =(CODE=12560)(
From the OS prompt, do an "oerr ora 12560
QUOTE
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.
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.
Please read:
http://www.dba-oracle.com/t_ora_12500_listener_process.htm
You need to:
- Add more RAM for PGA
- Make PGA regions smaller
- Implement stared servers
Dear Sir,
We get the above error in between woking.
After restart the DB its working fine.
Our Existing OS configuration is
OS 2003 Server Eterprise Edition SP2
16 GB RAM
2 CPU Dual Core
Database Oracle 9.2.0.8
Please guide us
Regarding,
Tulashidas
mb:9870707670
We get the above error in between woking.
After restart the DB its working fine.
Our Existing OS configuration is
OS 2003 Server Eterprise Edition SP2
16 GB RAM
2 CPU Dual Core
Database Oracle 9.2.0.8
Please guide us
Regarding,
Tulashidas
mb:9870707670
QUOTE (burleson @ Jan 19 2012, 10:32 AM) 
Hi Tulashidas,
>> =(CODE=12560)(
From the OS prompt, do an "oerr ora 12560
Please read:
http://www.dba-oracle.com/t_ora_12500_listener_process.htm
You need to:
- Add more RAM for PGA
- Make PGA regions smaller
- Implement stared servers
>> =(CODE=12560)(
From the OS prompt, do an "oerr ora 12560
Please read:
http://www.dba-oracle.com/t_ora_12500_listener_process.htm
You need to:
- Add more RAM for PGA
- Make PGA regions smaller
- Implement stared servers
Hi Tulashidas,
>> We get the above error in between woking
Woking? You cook Chinee food?
Keep the Wok away from the PC, the hot grease might damage it.
*********************************
>> Please guide us
I already told you your options to fix this.
If you want mentoring, call 800-766-1885 or open an SR on MOSC:
http://support.oracle.com.
Good Luck!
>> We get the above error in between woking
Woking? You cook Chinee food?
Keep the Wok away from the PC, the hot grease might damage it.
*********************************
>> Please guide us
I already told you your options to fix this.
QUOTE
- Add more RAM for PGA
or
- Make PGA regions smaller
or
- Implement shared servers
or
- Make PGA regions smaller
or
- Implement shared servers
If you want mentoring, call 800-766-1885 or open an SR on MOSC:
http://support.oracle.com.
Good Luck!
"We get the above error in between "
Yes, thgsat because you periodically run out of PGA RAM.
Make your pga_aggregate_target larger:
Read this:
http://www.dba-oracle.com/oracle_tips_pga_size.htm
Yes, thgsat because you periodically run out of PGA RAM.
Make your pga_aggregate_target larger:
Read this:
http://www.dba-oracle.com/oracle_tips_pga_size.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.