Connected to Oracle Database 18c Express Edition Release 18.0.0.0.0 
Connected as system@DBOFFICEXE

SQL> create user u identified by "u";

User created


SQL> grant resource to u;

Grant succeeded


SQL> grant unlimited tablespace to u;

Grant succeeded


SQL> grant connect to u;

Grant succeeded


SQL> connect u/u;
Connected to Oracle Database 18c Express Edition Release 18.0.0.0.0 
Connected as u@DBOFFICEXE

SQL> create table t1 as select * from all_tables;

Table created


SQL> select * from t1 fetch first 10 rows only;

OWNER                                                                            TABLE_NAME                                                                       TABLESPACE_NAME                CLUSTER_NAME                                                                     IOT_NAME                                                                         STATUS     PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS FREELIST_GROUPS LOGGING BACKED_UP   NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE                                   INSTANCES                                CACHE                TABLE_LOCK SAMPLE_SIZE LAST_ANALYZED PARTITIONED IOT_TYPE     TEMPORARY SECONDARY NESTED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE ROW_MOVEMENT GLOBAL_STATS USER_STATS DURATION        SKIP_CORRUPT MONITORING CLUSTER_OWNER                                                                    DEPENDENCIES COMPRESSION COMPRESS_FOR                   DROPPED READ_ONLY SEGMENT_CREATED RESULT_CACHE CLUSTERING ACTIVITY_TRACKING       DML_TIMESTAMP             HAS_IDENTITY CONTAINER_DATA INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE DEFAULT_COLLATION                                                                DUPLICATED SHARDED EXTERNAL CELLMEMORY               CONTAINERS_DEFAULT CONTAINER_MAP EXTENDED_DATA_LINK EXTENDED_DATA_LINK_MAP INMEMORY_SERVICE INMEMORY_SERVICE_NAME                                                            CONTAINER_MAP_OBJECT MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE HAS_SENSITIVE_COLUMN
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------- ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------- --------- ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- ---------------------------------------- ---------------------------------------- -------------------- ---------- ----------- ------------- ----------- ------------ --------- --------- ------ ----------- ----------- ---------------- ------------ ------------ ---------- --------------- ------------ ---------- -------------------------------------------------------------------------------- ------------ ----------- ------------------------------ ------- --------- --------------- ------------ ---------- ----------------------- ------------------------- ------------ -------------- -------- ----------------- ------------------- -------------------- ------------------ -------------------------------------------------------------------------------- ---------- ------- -------- ------------------------ ------------------ ------------- ------------------ ---------------------- ---------------- -------------------------------------------------------------------------------- -------------------- ---------------- ----------------- --------------------
SYS                                                                              DUAL                                                                             SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          16384     1048576           1  2147483645                       1               1 YES     N                  1          1            0          0          0           2                         0                   0          1                                        1                                   N                ENABLED              1 25.02.2019 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              SYSTEM_PRIVILEGE_MAP                                                             SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                257          2            0          0          0          27                         0                   0          1                                        1                                   N                ENABLED            257 25.02.2019 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              TABLE_PRIVILEGE_MAP                                                              SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                 26          1            0          0          0          11                         0                   0          1                                        1                                   N                ENABLED             26 25.02.2019 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              USER_PRIVILEGE_MAP                                                               SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                  4          1            0          0          0          21                         0                   0          1                                        1                                   N                ENABLED              4 25.02.2019 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              STMT_AUDIT_OPTION_MAP                                                            SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                337          2            0          0          0          25                         0                   0          1                                        1                                   N                ENABLED            337 26.07.2019 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              FINALHIST$                                                                                                                                                                                                                                                                        VALID            10         40          1        255                                                                          1               1 NO      N                                                                                                                                     1                                        1                                   N                ENABLED                              NO                       Y         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     NO           NO         SYS$TRANSACTION DISABLED     NO                                                                                          DISABLED     DISABLED    BASIC                          NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              MODELGTTRAW$                                                                                                                                                                                                                                                                      VALID            10         40          1        255                                                                          1               1 NO      N                                                                                                                                     1                                        1                                   N                ENABLED                              NO                       Y         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     NO           NO         SYS$SESSION     DISABLED     NO                                                                                          DISABLED     DISABLED    BASIC                          NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              AV_DUAL                                                                          SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                  1          1            0          0          0           0                         0                   0          1                                        1                                   N                ENABLED              1 04.02.2019 5: NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              AUDIT_ACTIONS                                                                    SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                239          1            0          0          0          20                         0                   0          1                                        1                                   N                ENABLED            239 18.08.2020 22 NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO
SYS                                                                              ALL_UNIFIED_AUDIT_ACTIONS                                                        SYSTEM                                                                                                                                                                                           VALID            10         40          1        255          65536     1048576           1  2147483645                       1               1 YES     N                452          3            0          0          0          33                         0                   0          1                                        1                                   N                ENABLED            452 04.02.2019 5: NO                       N         N         NO     DEFAULT     DEFAULT     DEFAULT          DISABLED     YES          NO                         DISABLED     YES                                                                                         DISABLED     DISABLED                                   NO      NO        YES             DEFAULT      NO                                                           NO           NO             DISABLED                                                                               USING_NLS_COMP                                                                   N          N       NO                                NO                 NO            NO                 NO                                                                                                                       NO                   DISABLED         DISABLED          NO

10 rows selected


SQL> 

C:\ora11cli\orahome\network\admin>tnsping TEST

TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 15-JAN-2022 12:43:16

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
c:\ora11cli\orahome\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.174)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (0 msec)

C:\ora11cli\orahome\network\admin>sqlplus system/qqq@TEST

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 15 12:43:28 2022

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-28040: No matching authentication protocol


[oracle@localhost admin]$ cat ./sqlnet.ora 
# sqlnet.ora Network Configuration File: /opt/oracle/product/18c/dbhomeXE/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION = 8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8                                                                                                                                                                                                      
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8   

[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 15-JAN-2022 04:52:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                15-JAN-2022 04:49:49
Uptime                    0 days 0 hr. 2 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /opt/oracle/product/18c/dbhomeXE/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=localhost)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "d59bffaee4f22c0ee055000000000001" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "xepdb1" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\ora11cli\orahome\network\admin>sqlplus system/qqq@TEST

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 15 12:54:21 2022

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production