Oracle listener is down

[Amjad. R. Barqawi]

Dear All.
i have this problem in cluster integrity server with OS Openvms 8.3 have Oracle 10g r2,
the problem that the listener of oracle in cluster node is down suddenly and i update the Openvms ECO700 but the problem still to now what i can do??

[labadie_1]

Hello

You should have a log file, with more details about the reason.

You should check the final status code in accounting

$ account/fu/since=10:00
if your process stopped working after 10 o'clock

[Amjad. R. Barqawi]

Dear
It's not a time issue because it's stop maybe after one hour or maybe after two days or more.....?

[Marc Van den Broeck]

Can you look in tns_admin:listener.log? May be some error is written there.

Also check in your trace directory if anything is written in the alert file or a trace file is created.

If nothing is found here, you have to find out why the listener process stopped using 'vms-tools'. Starting with accounting to find the final exit status is a good start.

Rgds
Marc

[Hein van den Heuvel]

>> Oracle listener is down

How do you know?

Was it ever up? Fresh install?
What changed? (time, reboot)
Which listener (BEQ or TCP?)

You mention cluster. Is this a RAC Oracle install? Are you using the crs tools?
What does crs status show for resource ora..LISTENER_.lsn

What does SHOW SYSTEM tell you ?

What is the (last) message in the log?

A device with dump/log directories would no be full would they now?

>> now what i can do??

Call Oracle mid-range support !?

Hope this helps some,
Hein van den Heuvel

[Amjad. R. Barqawi]

Dear all.

Was it ever up? yes
Fresh install? yes
What changed? (time, reboot)nothing.
You mention cluster. Is this a RAC Oracle install? Are you using the crs tools? yes

[Amjad. R. Barqawi]

dear ..
What does SHOW SYSTEM tell you ?

see attach file..

[Hein van den Heuvel]

So it appears the the listener process is running fine, it might just not be listening to _you_ :-), or not listening in the room where yo call it (IP, port)

I repeat one of my qeustion:

>>>> Oracle listener is down
>>How do you know?

What does LSNRCTL STATUS shows?
Is the ora_root:[NETWORK.ADMIN]LISTENER.ORA set up fine?

Did you use VIPCA and NETCA (and in that order).


What does a 'TAIL' of LISTENER.LOG show?

Hope this helps some more,
Hein

[Hein van den Heuvel]

Oops, I just noticed the earlier attachment with LSNRCTL output. Sorry for missing that earlier.

I do not recognize this right away, but I'm pretty sure is is not an OpenVMS quota/priv problem.

I would double check that all oracle files are owned by the oracle user, or are at least in the dba uic group. And make sure the the listener.ora and tnsnames and such are stream_lf as required since Oracle 10.

And check the CRS reports/monitors.

fwiw,
Hein.