Help - Search - Members - Calendar
Full Version: ERROR=(BUF='32-bit Windows Error: 233: Unknown error'
Oracle DBA Forums > Oracle > Oracle Forum
tulsidask@dcbl.com
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
burleson
Hi Tulashidas,

>> =(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.


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


tulsidask@dcbl.com
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


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

burleson
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.

QUOTE
- Add more RAM for PGA
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!
aussie_dba
"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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.