hi all,
SQL> conn sys/oracle@xepdb1 as sysdba
Connected.
SQL>
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
created Win10 VM and I have installed 18c XE, after installation created a user "bob" and grant "dba" permission but can't login. my sqlplus session is here below for reference:
SQL> conn sys/oracle@xepdb1 as sysdba;
Connected.
SQL>
SQL> create user bob identified by bob;
User created.
SQL> grant connect, dba to bob;
Grant succeeded.
SQL> select username, account_status, EXPIRY_DATE from dba_users order by 1;
USERNAME ACCOUNT_STATUS EXPIRY_DA
------------------------------------------------------------ -------------------------------- ---------
ANONYMOUS EXPIRED 04-FEB-19
APEX_210100 LOCKED
APEX_LISTENER OPEN 24-MAR-22
APEX_PUBLIC_USER OPEN 24-MAR-22
APEX_REST_PUBLIC_USER OPEN 24-MAR-22
APPQOSSYS EXPIRED & LOCKED 04-FEB-19
AUDSYS LOCKED
BOB OPEN 27-MAR-22
CTXSYS EXPIRED & LOCKED 25-SEP-21
DBSFWUSER EXPIRED & LOCKED 04-FEB-19
DBSNMP EXPIRED & LOCKED 04-FEB-19
DIP EXPIRED & LOCKED 04-FEB-19
DVF LOCKED
DVSYS LOCKED
FLOWS_FILES LOCKED
GGSYS EXPIRED & LOCKED 04-FEB-19
GSMADMIN_INTERNAL EXPIRED & LOCKED 04-FEB-19
GSMCATUSER EXPIRED & LOCKED 04-FEB-19
GSMUSER EXPIRED & LOCKED 04-FEB-19
HR EXPIRED & LOCKED 25-SEP-21
LBACSYS LOCKED
MDDATA EXPIRED & LOCKED 04-FEB-19
MDSYS EXPIRED & LOCKED 04-FEB-19
OJVMSYS LOCKED
OLAPSYS EXPIRED & LOCKED 04-FEB-19
ORACLE_OCM EXPIRED & LOCKED 04-FEB-19
ORDDATA EXPIRED & LOCKED 04-FEB-19
ORDPLUGINS EXPIRED & LOCKED 04-FEB-19
ORDSYS EXPIRED & LOCKED 04-FEB-19
ORDS_METADATA OPEN
ORDS_PUBLIC_USER OPEN 24-MAR-22
OUTLN EXPIRED & LOCKED 04-FEB-19
PDBADMIN OPEN 24-MAR-22
REMOTE_SCHEDULER_AGENT EXPIRED & LOCKED 04-FEB-19
SI_INFORMTN_SCHEMA EXPIRED & LOCKED 04-FEB-19
SYS OPEN 03-AUG-19
SYS$UMF EXPIRED & LOCKED 04-FEB-19
SYSBACKUP EXPIRED & LOCKED 04-FEB-19
SYSDG EXPIRED & LOCKED 04-FEB-19
SYSKM EXPIRED & LOCKED 04-FEB-19
SYSRAC EXPIRED & LOCKED 04-FEB-19
SYSTEM OPEN 24-MAR-22
WMSYS EXPIRED & LOCKED 04-FEB-19
XDB EXPIRED & LOCKED 04-FEB-19
XS$NULL EXPIRED & LOCKED 04-FEB-19
46 rows selected.
SQL> disc
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL>
SQL> conn bob/bob@xepdb1;
ERROR:
ORA-01017: invalid username/password; logon denied
SQL>
please help, what i have missed or doing something wrong?
regards