| ORA-01034 [message #220211] |
Mon, 19 February 2007 08:32  |
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
|
Member |
|
|
Dear All,
I've two databases, having the same memory configuration. Both databases are up, problem is when i'm trying to connect to one of the db through cobol it throws the error ora-01034, but another programs are running fine in the same db, in other database that program which is giving error in first db is working fine. That program is calling a table having blob data. The difference between both the databases is that they are under different o/s, the db which is throwing error is in AIX and other one is LINUX.
As i'm new to AIX, i don't know the command to check shmmax and memory used by SGA and PGA. I mean to say i do not know how to configure/check the memory properly.
One more thing the server having the problemtic db have 5 databases and all 5 are up and working, while other server has only 3 db and all are up. If I shutdown one of the db from AIX server whether it works for me?
Can you assist me please on this issue that how can i move step by step to rectify this issue.
Thanx in Advance
Amit Pandey
|
|
|
|
| Re: ORA-01034 [message #220955 is a reply to message #220211] |
Thu, 22 February 2007 20:02  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Is it possible to use dblinks to connect the two databases? In smalltalk we have the concept of a 'session' and smalltalk could only have one at a time. Database links worked though. Both databases must know about eachother via listener.ora and have o/s access, try a ping.
Second question:
When you have multiple databases you need an Oracle Home for each one. Plus you need each database to be owned/installed by separate o/s users.
Also name each listener otherwise when you lsnrctl stop it kills all 5 listeners. Something like lsnrctl db1 stop.
|
|
|
|
| Re: ORA-01034 [message #221007 is a reply to message #220955] |
Fri, 23 February 2007 03:26 |
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
|
Member |
|
|
Dear nmacdannald,
Thanks for the reply, but sorry to say it is not clear to me or may be I'm unable to clear my problem. I'll explain it once more
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. Now as I told earlier both the Db having the same memory configuration. But only during one operation DB A throws error "SQL-1034 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
Thanx in Advance
Amit
|
|
|
|
| Re: ORA-01034 [message #221097 is a reply to message #221007] |
Fri, 23 February 2007 16:58 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
What o/s is having the memory problem? Do you mind posting you init.ora for that one. Are they dedicated servers? Just because you request SGA memory it does not mean your server has it, especially if there are other apps running. I like sga_target and sga_max instead of block_buffers.
It sounds like you need RAC or standby configurations. If A is not running then use B. Then when A becomes ready it copies everything B has been doing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
