How to Create a New User in Oracle Database

Are you having trouble creating a new user in Oracle, and getting either an "ORA-01017: invalid username/password; logon denied" error or an "invalid common user or role name" error?

In this video, I'll show you why these errors are happening, how to successfully create a new user in an Oracle database, connect as this new user, and a range of issues you might encounter.

⏱ TIMESTAMPS:
00:00 - Why it's hard
01:51 - Create a new user
03:04 - Connect to the database
03:52 - Issue - no create session
04:38 - Issue - connect as SYSDBA
05:34 - Issue - connect to CDB as a PDB user
06:21 - Issue - invalid common user or role name
08:03 - Overview and scenarios