topic Re: Oracle listener is down in Operating System - OpenVMS

Oracle listener is down

Amjad. R. Barqawi — Tue, 28 Oct 2008 08:24:24 GMT

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??

Re: Oracle listener is down

labadie_1 — Tue, 28 Oct 2008 08:43:10 GMT

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

Re: Oracle listener is down

Amjad. R. Barqawi — Tue, 28 Oct 2008 08:59:50 GMT

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

Re: Oracle listener is down

Marc Van den Broeck — Tue, 28 Oct 2008 09:59:07 GMT

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

Re: Oracle listener is down

Hein van den Heuvel — Tue, 28 Oct 2008 10:17:35 GMT

>> 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

Re: Oracle listener is down

Amjad. R. Barqawi — Thu, 30 Oct 2008 05:08:03 GMT

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

Re: Oracle listener is down

Amjad. R. Barqawi — Thu, 30 Oct 2008 05:10:18 GMT

dear ..
What does SHOW SYSTEM tell you ?

see attach file..

Re: Oracle listener is down

Hein van den Heuvel — Thu, 30 Oct 2008 11:31:27 GMT

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

Re: Oracle listener is down

Hein van den Heuvel — Thu, 30 Oct 2008 15:38:22 GMT

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.