Home » RDBMS Server » Server Administration » ORA-01034
ORA-01034 [message #220211] Mon, 19 February 2007 08:32 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: MAXIMUM NUMBER OF SESSION
Next Topic: chkconfig
Goto Forum:
  


Current Time: Sat Dec 10 14:32:20 CST 2016

Total time taken to generate the page: 0.08779 seconds