如何对pdb$seed做修改

首先设置参数_oracle_script为true，然后对pdb$seed 做修改，然后再将_oracle_script这个参数设置位false

00:02:26 SQL> alter session set "_oracle_script"=true;

Session altered.

Elapsed: 00:00:00.01
00:04:36 SQL> alter pluggable database pdb$seed close immediate instances=all;

Pluggable database altered.

Elapsed: 00:00:01.11
00:04:54 SQL> alter pluggable database pdb$seed open read write instances=all;

Pluggable database altered.

Elapsed: 00:00:02.71
00:05:11 SQL> select inst_id,open_mode,name from gv$pdbs where name='PDB$SEED';

   INST_ID OPEN_MODE  NAME
---------- ---------- --------------------
	 1 READ WRITE PDB$SEED
	 2 READ WRITE PDB$SEED

Elapsed: 00:00:00.01
00:05:30 SQL> alter session set container=pdb$seed;

Session altered.

Elapsed: 00:00:00.04


00:10:22 SQL> create user pdbadmin identified by vault1;

User created.

Elapsed: 00:00:00.09

00:13:14 SQL> alter pluggable database close immediate instances=all;

Pluggable database altered.

Elapsed: 00:00:01.22
00:13:27 SQL> alter pluggable database open read only instances=all;

Pluggable database altered.

Elapsed: 00:00:01.60

00:13:47 SQL> alter session set "_oracle_script"=false ;

Session altered.

Elapsed: 00:00:00.01