ORACLE 설치 후 계정 생성 오류 해결

Enter user-name: system
Enter password:

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> create user ora1 identified by 1234;
create user oraname identified by 1234
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

 

db생성시 오류 65096 해결 방법

 

 

SQL> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

SQL> create user oraname identified by 1234;

User created.

SQL> grant connect, resource, dba to oraname;

-- restricted session  ORA-02248: invalid option for ALTER SESSION
grant restricted session to scott;



 SELECT logins FROM v$instance;
 
  ALTER SYSTEM DISABLE RESTRICTED SESSION;