UNIX for Dummies Questions & Answers

HI all

I think i can get a perfect solution for our problem here.
we r using oracle 7i on hpux 11.0 as a billing server .The thing is it used to get hanged sometime and we need to unmount and need to mount the oracle DB then we need to start the oracle process.The process running in that server also used to struck sometimes we r restartng the server itself.
Our harddisk capacity is 9gb with 9gb mirroring and a memory of 1.5Gb .our processor is of 440Mhz Risca based.

thanks in advance for any solution to overcome this problem and need the reason why its behaving like this..

FrancisHI all

Hmm... We have had a few freak happeneings here at work with our HP-UX11/Oracle 8/9 servers. Some of them were related to a number of HP recommended patches we applied - one of the patches "broke" certain operations on our affected Oracle processes. Has anything changed, or been patched/unpatched before this started?

Also, we had a small flaw in one of our memory modules, this cause some wierd, wacky behavior at random times. Have you checked any hardware issues, or had any problems with other components of the server?

It's odd that unmounting/mounting disks and restarting Oracle helps. Is your disk local, or stored externally or over the network? Either way, have you checked the connectors? Is the server well-cooled?

And finally, does this happen all at once, or does performance degrade prior to downtime? If you can, have your DBA run a trace. He should be able to troubleshoot Oracle-specific problems, like exessive disk I/O or problems initializing shared memory.

Let me know how the progress goes - I'm very interested to see what it ends up being...

ALll this happen at once since its working as a billing server it stops to push(replicate) the data to the particular LDAP server which creates a lot of issue .The harddisks are external but not a NAS.As we are running the a lot of applications in other servers they doesnt create any issues like this.Is ther any major compatiblity probs or like that ?.We are able to communicate with the server on that time so i think it may not be a probs with the processor or other H/W ..cooling and all everything is ok .

if u need any info pls get back to me..

Thks for effort
Francis

Hmm, well, how are you moving this data to the LDAP server? I don't know you're specific situation, but I would personally use something like this:

1) shut down Oracle
2) copy the files to another name on the same
disk, if possible (it'll be faster this way)
3) Re-start Oracle
4) Transfer the copied files to the LDAP server
5) Remove the local copy of the files

This should leave you with only minutes of downtime, and make sure that a file copy / move doesn't disrupt operations. Would this be feasible? It could easily be scripted and set to run in the middle of the night...

This might not the best solution, but it might work...

we r using a process named Pin channel export to push those datas to Ldap from the billing.
due to the large capacity of data handled by oracle dbase we r struggling to shutdown it.Usually it hangs for hrs and then we opt to restart the server itself . This of course decrease the life of our server itself .since we r a isp here we need to have this setup of servers working without any interruption.

Regds
Francis

Hmmm, what is happening when Oracle is struggling to shut down? Is your disk going crazy? Next time you try to shut it down, try running the glance utility while it's shutting down - see how your machine is doing...

Also, are you using "shutdown immediate"? If it is just sitting there, it might be waiting for every process to stop using it before it will shut down.


You also might try searching otn.oracle.com for some information. I can't be sure that it's an Oracle problem or a server problem... It might be a combination of both.

Sorry I haven't been of too much help on this matter - I myself do not administer Oracle here, so I have no idea what troubleshooting measures would be best for your situation.

We r using shutdown immediate only but getting hanged at the same screen .if u type CTRL+c and come out of it after some hrs then u need to restart the oracle DB which is impossible since its not properly made down.

Anyway thanks for u r suggestions and efforts .


Francis