L
lopamudra mahapatra Posted on 12/03/2020


SQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 12 17:26:55 2020
Version 18.4.0.0.0

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

Enter user-name: system
Enter password:
Last Successful login time: Thu Mar 12 2020 17:19:39 +05:30

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

SQL> select username from dba_users;

USERNAME
--------------------------------------------------------------------------------
SYS
SYSTEM
XS$NULL
OJVMSYS
LBACSYS
OUTLN
SYS$UMF
DBSNMP
APPQOSSYS
DBSFWUSER
GGSYS

USERNAME
--------------------------------------------------------------------------------
ANONYMOUS
CTXSYS
DVSYS
SI_INFORMTN_SCHEMA
DVF
GSMADMIN_INTERNAL
ORDPLUGINS
MDSYS
OLAPSYS
ORDDATA
XDB

USERNAME
--------------------------------------------------------------------------------
WMSYS
ORDSYS
GSMCATUSER
MDDATA
SYSBACKUP
REMOTE_SCHEDULER_AGENT
GSMUSER
SYSRAC
AUDSYS
DIP
SYSKM

USERNAME
--------------------------------------------------------------------------------
ORACLE_OCM
SYSDG

35 rows selected.

SQL> create user john identified by root
2 123
3
SQL> create user john identified by root
2
SQL>


P
Priyanka Replied on 12/03/2020

You need to create user identified by the system's password through which you got connected with oracle. Have you used root as your password to get connected with oracle?


L
lopamudra mahapatra Replied on 12/03/2020

Hi Priyanka i tried with the password i gave for system.

Its not working.

Its better if i can share my desktop with with through skype.

Please let me know.


P
Priyanka Replied on 13/03/2020

Kindly refer your mail_id so that i can connect with you through any other medium


L
lopamudra mahapatra Replied on 13/03/2020

lopamudra.mohapatra90@gmail.com


P
Priyanka Replied on 14/03/2020

I will take a webex Meeting at 11 o'clock on Monday to solve this issue. I will send you the WebEx link on your mail ID