Strange processes behavior

[Nuwan Wijesundera]

Hi all,
I encounted one strange behavior in one of our HP-9000 customer with N-Class. The system is running Oracle 8i and once the oracle processes closed from the front-end,even after this the system (ps -ef) outputs the closed processes. So the system comes to its max userprocesses and not allow any process to folk.
Any idea for this strange situation and any procedure to track the fault,whether this is an oracle issue or HP-UX problem.

[malay boy]

Hi,
This is don't understand:

The system is running Oracle 8i and once the oracle processes closed from the front-end,even after this the system (ps -ef) outputs the closed processes. .

what do you mean by front-end ?.

even after this the system (ps -ef) outputs the closed processes.

what do you mean??..

some detail please...

regards
mB

[Steven E. Protter]

The usual cause of Oracle proceses being closes like that are:

1) Improper installatoin of oracle ias/orcle server.
2) Corruption of the executables, sometimes caused by disk issues.
3) Resource Issues.

The first step is to try and relink oracle and/or the application server.

It is possible that you'll pick up an erorr with one of the "make" files in the relink. Then, if you have another server you can pull the file across and fix the relink.

Oracle is a heavy user of shared memory resources such as ipcs, message queues and the like.

shmmax should be set to approximately a quarter of available memory including swap to optimize oracle.

That can be set dynamically.

We have just finished tuning and set shmseg to 250 on L Class servers with good results.

A good first step is running the command ipcs and checking the output against a working machine.

SEP

[Massimo Bianchi]

Hi,
also are you sure you are not trying to start and stop the same oracle instance with different users ?

In this case you may have many process left running, doing nothing and keepeing your procs occupied.

HTH,
Massimo

[Nuwan Wijesundera]

I think my explaination is not clear enough to understand for you.
Let me explain the issue.
(Oracle 8.1.7.0.0)
In the system there are 2 instances running and normally users connects through tns,but this particular issue occurs only when one particular application uses JDBC to connect to the DB.(use web browser to clients)
I identified for one connection there are two connections open in oracle and even I close the connection and web browser from clients the connection stays in oracle processes (list in the DBA studio output).
When I disconnect the particular proceceses from oracle still the OS process in the list for particular PIDs.(ps -ef).

I doubt is this a oracle/JDBC bug or OS problem.

Hope I have explained it well this time.Thanks for you interest on this

[Steven E. Protter]

If there is a resource problem, this kind of behavior can happen. Processes don't get shut down quickly when the machine is stressed or poorly tuned.

You say ....

----
I identified for one connection there are two connections open in oracle and even I close the connection and web browser from clients the connection stays in oracle processes (list in the DBA studio output).
When I disconnect the particular proceceses from oracle still the OS process in the list for particular PIDs.(ps -ef).
----

By saying its not the OS or an Oracle bug or java, you are eliminating three pretty good suspects.

I'd reconsider that conclusion.

http://www.hp.com/go/java

Make sure all java patches are installed based on your java version. A reboot will be required. Patches can be obtained via http://itrc.hp.com patches/hpux, search by patch number.

This kind of behavior can be caused by performance problems.

Here is a good doc on Oracle performance, written by one of HP's best Oracle performance men.

http://www1.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&mode=id&admit=-682735245+1053636168960+28353475&searchCrit=allwords&printable=true

SEP