Hi,
I'm installing a fresh 12cR2 single instance database with ASM on RHEL7.
I have installed Oracle Grid Infrastructure and also created the 12cR2 database using DBCA.
While creating the database with DBCA, i have created a new listener named "LISTENER_MBISTST" on port 1522 in ORACLE HOME.
But i already have the default listener "LISTENER" ON port 1521 created while installing Grid Infrastructure on GRID home.
Now when i try to connect to Database using Toad or SqlPlus tool im getting the error ORA-28040: No matching authentication protocol.
Can anyone tell me is the error because of the 2 listeners running on the same server.
I want to know if i can remove the new listener which i created on port 1522 and use only the default listener on port 1521 from GRID Home.
If i can remove the new listener what are the steps i need to follow.
Please help me on this.
========================================================================================
[oracle@TSTORA01 ~]$ lsnrctl status LISTENER_MBISTST
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 04-DEC-2018 13:05:15
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.19.83.75)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_MBISTST
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 04-DEC-2018 12:44:57
Uptime 0 days 0 hr. 20 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/TSTORA01/listener_mbistst/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.19.83.75)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "mbistst" has 2 instance(s).
Instance "mbistst", status UNKNOWN, has 1 handler(s) for this service...
Instance "mbistst", status READY, has 1 handler(s) for this service...
Service "mbiststXDB" has 1 instance(s).
Instance "mbistst", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@TSTORA01 ~]$
============================================================================================
[oracle@TSTORA01 ~]$ lsnrctl status LISTENER
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 04-DEC-2018 13:05:03
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 04-DEC-2018 12:33:59
Uptime 0 days 0 hr. 31 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/TSTORA01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TSTORA01.local)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA1" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_FRA" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@TSTORA01 ~]$
=========================================================================================================================
Thanks in advance,