Installing the oracle 12c software is fairly straightforward *ahem*. But some small things did change..Of course when installed, one wants to dive in as soon as possible, like I do..but somehow I keep being sidetracked with searching on: “How does this work?” and “How was that again?”..
This post is a summary of steps where most of these issues are addressed, saving Googling until memorized.. 😉
After creating a user (“testUser”), and be able to actually DO something with the schema:
SQL> grant resource to testUser;
In order to prevent the pesky: ORA-01950: no privileges on tablespace 'XXXX'
SQL> ALTER USER testUser QUOTA UNLIMITED ON USERS;
Listing the plug-able databases in the container db, and see if they are ready to roll..
COLUMN pdb_name FORMAT A20 SELECT pdb_name, status FROM dba_pdbs ORDER BY pdb_name; SELECT name, open_mode FROM v$pdbs ORDER BY name;
— Starting all the PDB’s at once:
SQL> alter pluggable database all open;
– Switching from Container to Pluggable database (e.g.: pdb1):
SQL> alter session set container=pdb1;
SQL> sho con_name; CON_NAME ---------- PDB1
To ease the administraton/frustration: add this parameter to the listener.ora file:
This way , one can connect to a 12c database without configuring all the connectors to use a service name..