HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle listener is down

 

Oracle listener is down

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??
Account Manager
Senior System Support Engineer
Eng Amjad R. Barqawi
8 REPLIES
labadie_1
Honored Contributor

Re: Oracle listener is down

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

Dear
It's not a time issue because it's stop maybe after one hour or maybe after two days or more.....?
Account Manager
Senior System Support Engineer
Eng Amjad R. Barqawi
Marc Van den Broeck
Trusted Contributor

Re: Oracle listener is down

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

Re: Oracle listener is down

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

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
Account Manager
Senior System Support Engineer
Eng Amjad R. Barqawi

Re: Oracle listener is down

dear ..
What does SHOW SYSTEM tell you ?

see attach file..
Account Manager
Senior System Support Engineer
Eng Amjad R. Barqawi
Hein van den Heuvel
Honored Contributor

Re: Oracle listener is down

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

Re: Oracle listener is down

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.