12c Create user
Create User C # #lyoo2 identified by Oracle;
12c User Authorization
Sql> Grant Resource,connect to C # #abiao12c;
Sql> Show Parameter Db_create
Create PDB
Sql> Create pluggable Database PDB_SONGCC Admin user SONGCC identified by Oracle;
Toggle PDB
sql> Alter pluggable database PDB_SONGCC open;
Sql> alter session set CONTAINER=PDB_SONGCC;
View current PDB
Sql> Show Con_name
View current Instance
Sql> select instance_name from V$instance;
Sqlplus/as SYSDBA Administrator to connect to the database
Sqlplus/as SYSDBA
This is in Cdb$root mode.
Show Con_name;
See all PDBs under Cdb$root
Select Name, Open_mode from V$pdbs;
Open the PDB database
Alter pluggable database Pdbepps Open
Go to the PDB database
Alter session set CONTAINER=ORCLPDB;
Turn off PDB
Alter pluggable database orclpdb close;
Switch back to Cdb$root
Alter session set Container=cdb$root;
Conn as Sysdba
6.14 12c Create user, authorize, create PDB