oracle 20c enable dbnest

在这个cluster的所有的node的$GRID_HOME/network/admin/listener.ora里添加如下内容

dedicated_through_broker_listener=true
dedicated_through_broker_listener_scan1=true
dedicated_through_broker_listener_scan2=true
dedicated_through_broker_listener_scan3=true
dedicated_through_broker_asmnet1lsnr_asm=true

修改asm的参数并重启grid

SQL> alter system set use_dedicated_broker=true scope=spfile;
System altered.
SQL> alter system set "_bequeath_via_broker"=ipc scope=spfile;
System altered.

配置db启动dbnest
需要在cluster的所有的node上都编辑这个文件，里面可以包含你想include的path
$ORACLE_HOME/dbs/pdb_fs.conf

[crsusr@rwsaj13 dbs]$ pwd
/scratch/u01/app/crsusr/product/12.1.0/dbhome_1/dbs
[crsusr@rwsaj13 dbs]$ cat pdb_fs.conf
/bin
SQL> alter system set use_dedicated_broker=true scope=spfile;
System altered.
SQL> alter system set dbnest_enable='cdb_resource_pdb_all' scope=spfile;
System altered.
SQL> alter system set "_bequeath_via_broker"=ipc scope=spfile;
System altered.
SQL> alter system set dbnest_pdb_fs_conf='/scratch/u01/app/crsusr/product/12.1.0/dbhome_1/dbs/pdb_fs.conf' scope=spfile;
System altered.

如果设置"_bequeath_via_broker"为true,则./sqlplus “/as sysdba"会报错

SQL> alter system set "_bequeath_via_broker"=true scope=spfile;
System altered.

[crsusr@rwsaj13 bin]$ ./sqlplus "/as sysdba"
SQL*Plus: Release 21.0.0.0.0 - Development on Sun Jul 12 00:51:07 2020
Version 21.1.0.0.0
Copyright (c) 1982, 2020, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied

最后需要重启这个db

检查dbnest是不是enabled

[crsusr@rwsaj14 trace]$ cat alert* | grep -i nest
DB Nest is enabled, SGA file deletion disabled.
Instance running inside DB Nest (ORA_yudian_yudian3)
  dbnest_enable            = "cdb_resource_pdb_all"
  dbnest_pdb_fs_conf       = "/scratch/u01/app/crsusr/product/12.1.0/dbhome_1/dbs/pdb_fs.conf"
KSNS: Found Local ASM Home (/scratch/u01/app/12.1.0/grid). PDB Nests will be configured with ASM Home
PDB$SEED(2):Creating (PDB$SEED) Nest for PDB(2)
PDB$SEED(2):DB Nest (PDB00002, 368999580) open successful
YUDIANPDB10001(3):Creating (YUDIANPDB10001) Nest for PDB(3)
YUDIANPDB10001(3):DB Nest (PDB00003, 1135697056) open successful