Oracle 12c 创建 PDB 用户
参考：oracle19c sql developer创建本地用户(PDB用户)及配置连接
参考：Oracle12c 连接 pdb 并创建用户
SQL>
show con_name pdbs;
CON_NAME
------------------------------
CDB$ROOT
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 MOUNTED
create tablespace JEECGBOOT
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/JEECGBOOT.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;
CREATE USER "JEECGBOOT" IDENTIFIED BY "JEECGBOOT"
DEFAULT TABLESPACE "JEECGBOOT"
TEMPORARY TABLESPACE "TEMP";
GRANT "DBA" TO "JEECGBOOT";
GRANT "CONNECT" TO "JEECGBOOT" ;
ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";
create tablespace NXSERVICE
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXSERVICE.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;
CREATE USER "NXSERVICE" IDENTIFIED BY "NXSERVICE"
DEFAULT TABLESPACE "NXSERVICE"
TEMPORARY TABLESPACE "TEMP";
GRANT "DBA" TO "NXSERVICE";
GRANT "CONNECT" TO "NXSERVICE" ;
ALTER USER "NXSERVICE" DEFAULT ROLE "DBA","CONNECT";
create tablespace NXNOW
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXNOW.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;
CREATE USER "NXNOW" IDENTIFIED BY "NXNOW"
DEFAULT TABLESPACE "NXNOW"
TEMPORARY TABLESPACE "TEMP";
GRANT "DBA" TO "NXNOW";
GRANT "CONNECT" TO "NXNOW" ;
ALTER USER "NXNOW" DEFAULT ROLE "DBA","CONNECT";
create tablespace NXHISTORY
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXHISTORY.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;
CREATE USER "NXHISTORY" IDENTIFIED BY "NXHISTORY"
DEFAULT TABLESPACE "NXHISTORY"
TEMPORARY TABLESPACE "TEMP";
GRANT "DBA" TO "NXHISTORY";
GRANT "CONNECT" TO "NXHISTORY" ;
ALTER USER "NXHISTORY" DEFAULT ROLE "DBA","CONNECT";
详细记录
[oracle@iZ2zedfer0bdc3u8g9o1xfZ ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 30 10:32:51 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 con_name pdbs;
CON_NAME
------------------------------
CDB$ROOT
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 MOUNTED
SQL> alter session set container = ORCLPDB1
2 ;
Session altered.
SQL> startup;
Pluggable Database opened.
SQL> show con_name pdbs;
CON_NAME
------------------------------
ORCLPDB1
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ORCLPDB1 READ WRITE NO
SQL> select CDB from v$database;
CDB
---------
YES
SQL> create tablespace JEECGBOOT
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/JEECGBOOT.dbf'
size 100m
autoextend on
next 100m maxsize 51200m
extent management local; 2 3 4 5 6 7
create tablespace JEECGBOOT
*
ERROR at line 1:
ORA-03206: maximum file size of (6553600) blocks in AUTOEXTEND clause is out of
range
SQL> create tablespace JEECGBOOT
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/JEECGBOOT.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local; 2 3 4 5 6 7
Tablespace created.
SQL> CREATE USER "JEECGBOOT" IDENTIFIED BY "JEECGBOOT"
DEFAULT TABLESPACE "JEECGBOOT"
TEMPORARY TABLESPACE "TEMP"; 2 3
User created.
SQL> SQL>
GRANT "DBA" TO "JEECGBOOT" ;
GRANT "CONNECT" TO "JEECGBOOT" ;
ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";SP2-0042: unknown command "SQL>" - rest of line ignored.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> GRANT "DBA" TO "JEECGBOOT" ;
GRANT "CONNECT" TO "JEECGBOOT" ;
ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";GRANT "DBA" TO "JEECGBOOT"
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL>
Grant succeeded.
SQL> GRANT "DBA" TO "JEECGBOOT" ;
ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";GRANT "DBA" TO "JEECGBOOT"
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> GRANT "CONNECT" TO "JEECGBOOT" ;
Grant succeeded.
SQL> GRANT "DBA" TO "JEECGBOOT";
Grant succeeded.
SQL> ALTER USER "JEECGBOOT" DEFAULT ROLE "DBA","CONNECT";
User altered.
SQL> create tablespace NXSERVICE
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXSERVICE.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local; 2 3 4 5 6 7
Tablespace created.
SQL> CREATE USER "NXSERVICE" IDENTIFIED BY "NXSERVICE"
DEFAULT TABLESPACE "NXSERVICE"
TEMPORARY TABLESPACE "TEMP"; 2 3
User created.
SQL> GRANT "DBA" TO "NXSERVICE";
Grant succeeded.
SQL> GRANT "CONNECT" TO "NXSERVICE" ;
Grant succeeded.
SQL> ALTER USER "NXSERVICE" DEFAULT ROLE "DBA","CONNECT";
User altered.
SQL> create tablespace NXNOW
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXNOW.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local; 2 3 4 5 6 7
Tablespace created.
SQL> CREATE USER "NXNOW" IDENTIFIED BY "NXNOW"
DEFAULT TABLESPACE "NXNOW"
TEMPORARY TABLESPACE "TEMP"; 2 3
User created.
SQL> GRANT "DBA" TO "NXNOW";
Grant succeeded.
SQL> GRANT "CONNECT" TO "NXNOW" ;
Grant succeeded.
SQL> ALTER USER "NXNOW" DEFAULT ROLE "DBA","CONNECT";
User altered.
SQL> create tablespace NXHISTORY
logging
datafile '/opt/oracle/product/19c/dbhome_1/dbs/NXHISTORY.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local; 2 3 4 5 6 7
Tablespace created.
SQL> CREATE USER "NXHISTORY" IDENTIFIED BY "NXHISTORY"
DEFAULT TABLESPACE "NXHISTORY"
TEMPORARY TABLESPACE "TEMP"; 2 3
User created.
SQL> GRANT "DBA" TO "NXHISTORY";
Grant succeeded.
SQL> GRANT "CONNECT" TO "NXHISTORY" ;
Grant succeeded.
SQL> ALTER USER "NXHISTORY" DEFAULT ROLE "DBA","CONNECT";
User altered.
SQL>
```
浙公网安备 33010602011771号