Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> ERROR=(BUF='32-bit Windows Error: 233: Unknown error', ERROR=(BUF='32-bit Windows Error: 233: Unknown error'
tulsidask@dcbl.c...
post Jan 19 2012, 09:41 AM
Post #1


Newbie
*

Group: Members
Posts: 8
Joined: 12-December 11
Member No.: 46,415



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
Go to the top of the page
 
+Quote Post
burleson
post Jan 19 2012, 10:32 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,097
Joined: 26-January 04
Member No.: 13



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




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
tulsidask@dcbl.c...
post Jan 20 2012, 11:35 PM
Post #3


Newbie
*

Group: Members
Posts: 8
Joined: 12-December 11
Member No.: 46,415



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

Go to the top of the page
 
+Quote Post
burleson
post Jan 21 2012, 06:56 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,097
Joined: 26-January 04
Member No.: 13



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!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
aussie_dba
post Jan 21 2012, 11:37 AM
Post #5


Advanced Member
***

Group: Members
Posts: 598
Joined: 28-August 04
Member No.: 495



"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
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd April 2014 - 03:26 AM