Forum Stats

  • 3,851,510 Users
  • 2,263,992 Discussions
  • 7,904,755 Comments

Discussions

ORA-01017 invalid username/password After install RAC 19c

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.

[[email protected] 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

[[email protected] dbs]$ sqlplus sys/[email protected] 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:

[[email protected] 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/[email protected] as sysdba
Connected.
SQL>

Password file located on ASM, and both instances are up and running:

[[email protected] dbs]$ srvctl status database -d oradb
Instance oradb1 is running on node hq-ora1
Instance oradb2 is running on node hq-ora2

[[email protected] 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:

[[email protected] 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:

[[email protected] 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



[[email protected] 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
[[email protected] 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

Tagged:

Best Answer

Answers