Now that we have Oracle DB Express installed, let us create a new normal user.
The reason being that there are some hoops you have to jump over if you try to use the sys or sysdba system accounts.
There is a minimalist Client bundled with Oracle XE, it is called SQLPlus.
To launch on Windows access menu and underneath “Oracle Database 11g Express Edition” \ “Run SQL Command Line“.
Connect as SYS
SQL> connect SYS as SYSDBA
Output – Connecting …
Output – Connected
create user msftbids identified by mylittpwd; grant connect to msftbids;
Please launch another SQLPlus session and attempt to connect as the user you just created.