1

Good afternoon, I am working with docker and an oracle 12c database, the official image found in the docker hub, the question is that I am testing creating a user from the SQL Plus, and when I am going to verify in the SQL developer, Note that the changes executed with the SQL Plus are not displayed in the SQL Developer, even having made the respective console commit (as shown in the image)

Creation of the user, commit and the current user of the session:

enter image description here

Then checking in the SQL Developer:

enter image description here

The configuration of the SQL Developer, with the port and ip of the host (not of the container) and the user of the session:

enter image description here

What can I need to configure? I've been looking for a solution for hours and nothing

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
Cesar Justo
  • 707
  • 2
  • 11
  • 35

1 Answers1

1

container should be set before creating a user for a pluggable DB :

SQL> ALTER SESSION SET CONTAINER = orclpdb1;

and display whether connected to that container : 

SQL> SHOW CON_NAME

CON_NAME
------------------------------
ORCLPDB1

and finally create concerned user :

SQL> CREATE USER cesar IDENTIFIED BY prueba123 [CONTAINER=CURRENT];

square bracketed part is optional

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
  • 1
    I will test it as soon as I can connect remotely – Cesar Justo Dec 28 '19 at 16:32
  • It worked, thank very much. Could you send me a link or information about why is it necessary to do this? – Cesar Justo Dec 30 '19 at 13:36
  • you're welcome @CesarJusto . [Pluggable DBs](https://logicalread.com/2015/05/29/oracle-pluggable-databases-mc05/#.XgoV7kczZPY) can be plugged into and unplugged from a Container DB. They're individual DBs held together by CDBs. – Barbaros Özhan Dec 30 '19 at 15:25