I was finally able to start with 12C!! So once I finish the installation, I tried to connect to the DB and create a user. That is when I discover that you need to connect to a special Database in order to perform that.
I got an error message creating a user. Well, I figured out how to create a new user and a few other things. I’m working with the DB12C database that comes with the install and all the parameters, etc. that come with it.
Evidently the default install comes with a PDB called PDBORCL. So, I have two tns entries one for the parent CBD and one for the child PDB and they look like this:
DB12C = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB12C) ) ) PDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) )
So, if I connect as SYSTEM/password@DB12C I’m connected to the CDB and if I connect to SYSTEM/password@pdb I’m connected to the PDB. When I connected to the PDB I could create a new user without getting an error.
But, when I first tried connecting to the PDB I got this error, even though the database was up: