1、进入sqlplus :sqlplus / as sysdba;
2、重启数据库使用upgrade方式:startup upgrade;
3、切换到orclpdb模式下:alter session set container=orclpdb;
startup upgrade;
3、查看数据库max_string_size的参数:show parameter max_string_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_string_size string LEGACY
4、修改参数为extended mode =both
alter system set max_string_size='extended' scope=both;
5、查看修改是否成功:show parameter max_string_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_string_size string EXTENDED
6、执行rdbms/admin/utl32k.sql脚本:
@$ORACLE_HOME/rdbms/admin/utl32k.sql
7、执行rdbms/admin/utlrp.sql 脚本 :
@$ORACLE_HOME/rdbms/admin/utlrp.sql
8、show pdbs--显示所有的PDB
9、新建pdb库,并赋权限
create pluggable database pdb2 admin user pdbadmin identified by Learning file_name_convert= ('/u01/app/oracle/oradata/orcl/pdbseed', '/u01/app/oracle/oradata/orcl/orclpdb/system02.dbf');
10、alter session set container=pdb2; --切换成PDB pdbadmin
11、切换数据库后可以创建没有c##前缀的用户
create user oracle IDENTIFIED BY 123456;--创建用户名为oracle密码为123456的用户
12、grant dba to oracle;--为该用户赋予dba角色
13、alter pluggable database pdb2 open ;
14、编辑oracle home目录下/product/12.2.0.1/db_1/network/admin/tnsnames.ora 增加如下文件:
pdb2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb2)
)
)