Create a new user on PDB on Oracle XE

user1045523

Good afternoon.   I'm having some trouble to create a user in XE pdb. 

  After I log in to sqlplus using sysdba I type :

  alter session set containner = xepdb1 ;

  CREATE USER Tarlensus IDENTIFIED BY ****** DEFAULT TABLESPACE tbs_Tarlensus TEMPORARY TABLESPACE temp QUOTA 15M ON tbs_Tarlensus; 

  Done this I give a grant to thi user :

  GRANT CREATE SESSION to Tarlensus ; 

  But when I will login using sqlplus :

[email protected] the Oracle DB returns that user or password are invalid. 

  Where am I going wrong? 

  I am using environment  Oracle Linux Environment and Oracle XE 21.c

cormaco

The User Tarlensus exists in xepdb1, not XE. So try this:

sqlplus [email protected]/xepdb1 

This uses the EZConnect method, if you wish to use just the PDB name xepdb1, you have to create an entry in the tnsnames.ora for that.

cormaco

The User Tarlensus exists in xepdb1, not XE. So try this:

sqlplus [email protected]/xepdb1 

This uses the EZConnect method, if you wish to use just the PDB name xepdb1, you have to create an entry in the tnsnames.ora for that.

user1045523

Its work :)

Thank you