Hi I have no experience with Oracle. I have built an Oracle 12c 12.1.0 database server on Centos 6 with the idea of creating tables, populating them using sqlldr and running select, alter, delete -- basic Oracle tasks.
I am Logged in like this:
[oracle@new-host bin]$ ./sqlplus / as sysdba;
Created a new user like this, using instructions from "Oracle Database 12c The Complete Reference":
CREATE USER newuser IDENTIFIED BY hokie1999 TEMPORARY TABLESPACE temp DEFAULT TABLESPACE users;
SQL> CREATE USER newuser IDENTIFIED BY hokie1999 TEMPORARY TABLESPACE temp DEFAULT TABLESPACE users;
CREATE USER newuser IDENTIFIED BY hokie1999 TEMPORARY TABLESPACE temp DEFAULT TABLESPACE users
*
ERROR at line 1:
ORA-65096: invalid common user or role name <<<<<<<<<<< HERE
Someone tell me what I am doing wrong, thanks.
--------------------------------------------------------------------------------------------------------------------------------------------
ORACLE_SID=DEV
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
When server was built the "Create and Configure a Database" option was selected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT