Dear sirs,
I installed 2 nodes Oracle 19c on Oracle Linux 8, the setup finished successfully and both grid infrastructure and DB started automatically after reboot.
Still I can NOT access SQLPlus internally (from inside nodes) because of ORA-01017 error, even passwords are correct, disabled SEC_CASE_SENSITIVE_LOGON.
[oracle@HQ-Ora1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 23 12:52:54 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@HQ-Ora1 dbs]$ sqlplus sys/PA$$w0rd@oradb as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 23 12:53:16 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
I wonder why I can connect to database in this way:
[oracle@HQ-Ora1 dbs]$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 23 13:08:36 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> connect sys/PA$$w0rd@oradb as sysdba
Connected.
SQL>
Password file located on ASM, and both instances are up and running:
[oracle@HQ-Ora1 dbs]$ srvctl status database -d oradb
Instance oradb1 is running on node hq-ora1
Instance oradb2 is running on node hq-ora2
[oracle@HQ-Ora1 dbs]$ srvctl config all
Oracle Clusterware configuration details
========================================
Oracle Clusterware basic information
------------------------------------
Operating system Linux
Name HQ-Ora-cluster
Class STANDALONE
Cluster nodes hq-ora2, hq-ora1
Version 19.0.0.0.0
Groups SYSOPER:oinstall SYSASM:dba SYSRAC:dba SYSDBA:oinstall
OCR locations +CRS
Voting disk locations CRS
Voting disk file paths /dev/oracleasm/disks/CRS1
Cluster network configuration details
-------------------------------------
Interface name Type Subnet Classification
ens161 IPV4 172.23.23.0/28 PRIVATE, ASM
ens193 IPV4 10.10.10.0/24 PUBLIC
SCAN configuration details
--------------------------
SCAN "HQ-Ora-scan" details
++++++++++++++++++++++++++
Name HQ-Ora-scan
IPv4 subnet 10.10.10.0/24
DHCP server type static
End points TCP:1521
SCAN listeners
--------------
Name VIP address
LISTENER_SCAN1 10.10.10.20
LISTENER_SCAN2 10.10.10.21
LISTENER_SCAN3 10.10.10.22
ASM configuration details
-------------------------
Mode remote
Password file +CRS
SPFILE +CRS
ASM disk group details
++++++++++++++++++++++
Name Redundancy
CRS EXTERN
DATA EXTERN
FRA EXTERN
REDO1 EXTERN
REDO2 EXTERN
Database configuration details
==============================
Database "ora.oradb.db" details
-------------------------------
Name ora.oradb.db
Type RAC
Version 19.0.0.0.0
Role PRIMARY
Management AUTOMATIC
policy
SPFILE +DATA
Password file +DATA
Groups OSDBA:dba OSOPER:oper OSBACKUP:backupdba OSDG:dgdba OSKM:kmdba
OSRAC:racdba
Oracle home /u01/db_setup
Here's my environment variables:
[oracle@HQ-Ora1 dbs]$ cat ~/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/db_setup/
export GRID_HOME=/u01/grid_setup/
export DB_HOME=$ORACLE_BASE
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=oradb
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY=:0.0
And this listener and TNSNames config:
[oracle@HQ-Ora1 dbs]$ cat /u01/grid_setup/network/admin/listener.ora
MGMTLSNR=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MGMTLSNR=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_MGMTLSNR=SUBNET # line added by Agent
[oracle@HQ-Ora1 dbs]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-SEP-2022 12:54:53
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 23-SEP-2022 10:24:52
Uptime 0 days 2 hr. 30 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/grid_setup/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/HQ-Ora1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.15)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=HQ-Ora1)(PORT=5500))(Security=(my_wallet_directory=/u01/db_setup/admin/oradb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_FRA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_REDO1" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_REDO2" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "oradb" has 1 instance(s).
Instance "oradb1", status READY, has 1 handler(s) for this service...
Service "oradbXDB" has 1 instance(s).
Instance "oradb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@HQ-Ora1 dbs]$ cat /u01/db_setup/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/db_setup/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HQ-Ora-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradb)
)
)
ORADB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HQ-Ora1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradb1)
)
)
ORADB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HQ-Ora2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradb2)
)
)
Kindly advice and best regards