Sample configuration of Oracle pluggable database (PDB) resource in main.cf

Figure: Sample Oracle CDB-PDB configuration

Sample Oracle CDB-PDB configuration

Review the sample configuration with two PDB resources that are configured in the main.cf file.

   group CDB (
        SystemList = { sys1 = 1, sys2 = 1 }
        AutoStartList = { sys2 }
        )

        DiskGroup diskgrpres (
                DiskGroup = cdb_dg
                )

        Mount mntresora (
                MountPoint = "/db01"
                BlockDevice = "/dev/vx/dsk/cdb_dg/oravol"
                )

        IP IP_oraprod (
                Device = eth0
                Address = "192.168.1.22"
                NetMask = "255.255.240.0"
                )

        NIC NIC_oraprod (
                Device = eth0
                 NetworkHosts = {"192.168.1.1"}
                )

        Netlsnr lisner_res(
                Owner = oracle
                Home = "/u01/orahome"
                TnsAdmin = "/u01/orahome"
                Listener = LISTENER_PROD
                MonScript = "./bin/Netlsnr/LsnrTest.pl"
                LsnrPwd = cqfOdoOolOo
		              )

        Oracle orares_cdb (
                Critical = 0
                Sid = cdb
                Owner = oracle
                Home = "/u01/oraHome"
                StartUpOpt = STARTUP
                DBName = cdb
                User = "c##vcsuser"
                Pword = hvnTkvKvmVktMvj
                Table = vcs
                LevelTwoMonitorFreq = 5
                )
                                      
               
        Oracle pdb1 (
                Critical = 0
                Sid = cdb
                Owner = oracle
                Home = "/u01/oraHome"
                StartUpOpt = STARTUP
                PDBName = pdb1
                User = "c##vcsuser"
                Pword = hvnTkvKvmVktMvj
                Table = vcs
                LevelTwoMonitorFreq = 5
                )

        Oracle pdb2 (
                Critical = 1
                Sid = cdb
                Owner = oracle
                Home = "/u01/oraHome"
                PDBName = PDB2
                User = "c##vcsuser"
                Pword = hvnTkvKvmVktMvj
                Table = vcs
                LevelTwoMonitorFreq = 5
                )

        mntresora requires diskgrpres
        orares_cdb requires mntresora
        pdb1 requires orares_cdb
        pdb2 requires orares_cdb
        lisner_res requires orares_cdb
        IP_oraprod requires NIC_oraprod
        lisner_res requires IP_oraprod