SQL> create user rakesh identified by rakesh;
create user rakesh identified by rakesh
*
ERROR at line 1:
ORA-65096: invalid common user or role name
Fix;
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select PDB from V$services;
PDB
------------------------------
PDBORCL
CDB$ROOT
CDB$ROOT
CDB$ROOT
CDB$ROOT
SQL> alter session set container=PDBORCL;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDBORCL
SQL> create user rakesh identified by rakesh;
create user rakesh identified by rakesh
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open;
Database altered.
SQL> create user rakesh identified by rakesh;
User created.
SQL> GRANT CONNECT, RESOURCE, DBA TO rakesh;
Grant succeeded.
SQL>
create user rakesh identified by rakesh
*
ERROR at line 1:
ORA-65096: invalid common user or role name
Fix;
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select PDB from V$services;
PDB
------------------------------
PDBORCL
CDB$ROOT
CDB$ROOT
CDB$ROOT
CDB$ROOT
SQL> alter session set container=PDBORCL;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDBORCL
SQL> create user rakesh identified by rakesh;
create user rakesh identified by rakesh
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open;
Database altered.
SQL> create user rakesh identified by rakesh;
User created.
SQL> GRANT CONNECT, RESOURCE, DBA TO rakesh;
Grant succeeded.
SQL>
No comments:
Post a Comment