Livelink oracle database down. 1

[nieubee]

this has been a pain in the neck!
we have been experiencing it 3 times within this 1 week.
please need guidance from the expert, what could be possibly be the root cause?

 

[ggriffit]

can you provide some more detail as to what has happened.

 

[nieubee]

Well, basically we have 7 front end servers and 3 back end servers. In one server we have approx. 4 LL application 9.1 SP4 which connects to the Oracle 9i.
I don't know what has happened and can't really explained...it just went down affecting all the servers.
When check it stated
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

It went down and our db team have to restart the service.

 

[appnair]

Well that is typically an error that your ora dba should be able to explain then.Livelink is just reporting the error that comes from oracle

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[nieubee]

yep! dats rite, maybe I can have your thoughts on this probs, just to gather more infos.
thanks a lot! really appreciate it.

 

[appnair]

it is very rare that livelink will cause a database crash.Tyically Oracle can be set to auto extent and I have seen sometimes livelink servers crashing the db.Tyically it may run out of roll back segmnets or the undo table space.A user is trying to delete a million objects without knowing what Also the dba can see the locks contention that livelink causes..At this site Greg has a utility that prevents mass deletions

http://www.greggriffiths.org.The

debugging in your instance I would assume would be livelink logs and oracle logs.I hope these all helps

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[Syntergy]

The first place to look when you are seeing crashes in any of the components that make up the Livelink system is version compatibility. Double check the OS requirements and patches required for your version of Livelink. Also double check the same for Livelink. 9 times out of 10 version compatabitliy is the problem. The next issue is lack of or incorrect patches applied. The final reason is incorrect configuration of the offending software.

 

[nieubee]

Thank you all for the explaination.
I will ask my dba team to look at it.