oracle 19c 创建新用户解决ORA-65096问题

最新推荐文章于 2024-08-04 10:36:33 发布

DB架构

最新推荐文章于 2024-08-04 10:36:33 发布

阅读量3.4k

点赞数 3

分类专栏： DBA 文章标签： oracle 数据库 sql

本文链接：https://blog.csdn.net/u011868279/article/details/127883150

版权

DBA 专栏收录该内容

183 篇文章 13 订阅

订阅专栏

报错： ORA-65096: invalid common user or role name

1.登录

[root@oracle-db-19c ~]# su - oracle
[oracle@oracle-db-19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 16 12:45:27 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show user;
USER is "SYS"
SQL>

2.核查当前环境所在的容器

SQL> select sys_context ('USERENV', 'CON_NAME') from dual; 

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT

SQL> set pagesize 200
SQL> set linesize 200
SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

    CON_ID       DBID NAME                                                                                                                             OPEN_MODE
---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------
         2 2760955567 PDB$SEED                                                                                                                         READ ONLY
         3 2714456025 PDB1                                                                                                                             READ WRITE

SQL> alter session set container=PDB1;

Session altered.

SQL> select sys_context ('USERENV', 'CON_NAME') from dual;

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PDB1

SQL> create user pstest identified by pstest;

User created.

SQL>