Further Adventures in RAC - Cannot Add Instance

From: David Barbour <david.barbour1_at_gmail.com>
Date: Sun, 7 Jun 2020 19:51:19 -0500
Message-ID: <CAFH+ifcPn47_59+m0PgVtRrE9kit37MR0Fp-vA1BsnHfgUENRA_at_mail.gmail.com>

I figured after I was able to identify the disk on the new node, the rest would be easy. Ran add.node.sh, cloned the ORACLE_HOME and went to add an instance. Nope. dbca isn't listing the new node. There are a couple of Oracle notes on this but I've tried those suggestions and had no success.

This is RHEL 7.6 running oracle 12.2.0.1 - patched through Jan 2020.

+ASM3_at_1103477-db7:/u01/app/12.2.0/grid/network/admin $ olsnodes
685921-db5
685925-db6
1103477-db7

[root_at_1103477-db7 bin]# ./crsctl query crs softwareversion Oracle Clusterware version on node [1103477-db7] is [12.2.0.1.0]

+ASM3_at_1103477-db7:/home/grid $ srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node 1103477-db7
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node 685925-db6
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node 685921-db5

[root_at_1103477-db7 bin]# ./crsctl status res -t

ora.LISTENER.lsnr ONLINE OFFLINE 1103477-db7 STABLE

                   ONLINE  ONLINE     685921-db5  STABLE
                   ONLINE  ONLINE     685925-db6  STABLE

I cannot get this listener online. Here's what happens:

+ASM3_at_1103477-db7:/u01/app/12.2.0/grid/network/admin $ lsnrctl start listener

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-JUN-2020 19:49:54

Copyright (c) 1991, 2016, Oracle. All rights reserved.

TNS-01106: Listener using listener name LISTENER_SCAN1 has already been started
+ASM3_at_1103477-db7:/u01/app/12.2.0/grid/network/admin $ lsnrctl stop listener

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-JUN-2020 19:50:24

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=scan01-dfw.istation.com)(PORT=1521))) TNS-01189: The listener could not authenticate the user

Any ideas here?

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 08 2020 - 02:51:19 CEST