Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After GI upgrade to 19c ASMNET1LSNR_ASM has one node in INTERMEDIATE state

Hello
I have upgraded our 2 node Exadata X6 Gi from 12.1 to 19.
During upgrade while running rootupgrade.sh on Node 1, there was error about ASMNET1LSNR_ASM missing on Node 2.
So I have manually enabled ASMNET1LSNR_ASM on node 2, after this action upgrade process continued well.

Now I see that ASMNET1LSNR_ASM.lsnr has INTERMEDIATE state on node 1 , but ONLINE on node 2.
Currently services are working, but I'm afraid to leave this like that.
When I check parameters , listener_networks:
node 1 - LOCAL_LISTENER local address & REMOTE_LISTENER address of node1 ONLY
node 2 - LOCAL_LISTENER local address & REMOTE_LISTENER address of node1 & node2
local_listener seems to be ok.
When I try to restart listener on node 1 there is error in log:
TNS-01195: Listener rejected registration of endpoint "(ADDRESS=(PROTOCOL=TCP)(HOST=10.253.253.1)(PORT=1526))"
TNS-01195: Listener rejected registration of endpoint "(ADDRESS=(PROTOCOL=TCP)(HOST=10.253.253.2)(PORT=1526))"

10.253.253.1 & 10.253.253.2 are addresses on Node 1

I think of setting REMOTE_LISTENER address of node1 & node2 on node 1 listener_networks paremeters and restart listener on both nodes, but as far as this is production I'm afraid to stay without service. Currently node 2 ASMNET1LSNR_ASM os OK.

Can you please suggest any steps?

Best Regards

Erekle

Comments
Post Details
Added on May 18 2021
0 comments
1,128 views