Oracle-00001
1. 访问https://localhost:5500/em弹窗
解决方案:
确保Oracle相关服务均启动,清除container Name即可正常登录
2. 初始化设置Oracle
C:\Users\...>sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 4月 14 22:10:07 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> create tablespace learning datafile 'D:\Oracle\tablespace\learning\learning.dbf' size 200M;
-- 创建表空间:
-- 基本语法:create tablespace 表空间名 datafile '路径' size 空间大小
SQL> create user student identified by student default tablespace learning;
create user student identified by student default tablespace learning
*
第 1 行出现错误:
ORA-65096: 公用用户名或角色名无效
# 创建用户时需要加 c##username
SQL> create user c##student identified by student default tablespace learning;
...
# 为用户分配权限:
SQL> grant connect,resource to student;