p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   ORA-0134 (http://p2p.wrox.com/showthread.php?t=54480)

db009 February 23rd, 2007 06:04 AM

I've 2 databases suppose A and B both on different server. My application architect is like that my application will try to connect db A through cobol and do the operation, if db A is not available at any point of time then it connects to B and do the operation. Both the Db having the same memory configuration. But only during one operation DB A throws error "SQL-1034 Oracle Not Available possible cause The SGA requires more space than was allocated for it" when he is trying to fetch some blob data, but DB B is fetching that same data easily. What are the possibilties of error, is it related to memory, some buffer, some initialization of blob or some other .. I'll also like to bring this in your kind notice that cobol program is same to fetch the data and data in the DB is also same. If you want then i can post my init file of both the db. Please suggest


All times are GMT -4. The time now is 09:16 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.