2 Replies Latest reply on Apr 25, 2019 2:12 AM by Praveen Ch-Oracle

    Naming convention for Application root and Application

    martin75

      DB version : 12.2/18C

      OS : Oracle Linux/RHEL 7.6

       

       

      In the below article about application containers, the application root container is named :sales_app_root

      and the application is named sales_app using the below commands.

       

       

      I know they both can have the same name (say, sales_app). I want to know the best practice in it.

      ie Whether it is good to have a separate name for root container and the application name.

       

       

      CDB$ROOT>CREATE PLUGGABLE DATABASE sales_app_root AS APPLICATION CONTAINER

               ADMIN USER appadmin IDENTIFIED BY oracle

               CREATE_FILE_DEST='/u01/app/oracle/oradata/orclcdb/sales_app_root';

      .

      .

      .

      SALES_APP_ROOT>ALTER PLUGGABLE DATABASE APPLICATION sales_app BEGIN INSTALL '1.0';

       

       

      https://blog.toadworld.com/2017/07/10/oracle-multi-tenant-application-containers-part-ii-create-application-container

        • 1. Re: Naming convention for Application root and Application
          Praveen Ch-Oracle

          Hi Martin75,

          Some aspects of administering an application container are similar to administering the CDB root and the CDB as a whole, while other aspects are similar to administering a PDB.

          Administering an application container is similar to administering a CDB because you can manage both the application root and the application PDBs that are plugged into the application root. However, administering an application container is also similar to managing a PDB because changes to the application container do not affect other application containers or PDBs in the CDB.

          Its good to have different name for Application root and Application PDBs. This will make maintenance operations easy. like install, upgrade, and patch an application in an application root.

           

          Thanks

          Praveen

          • 2. Re: Naming convention for Application root and Application
            Praveen Ch-Oracle

            Hi Martin75,

             

            Please mark your question as answered or helpful if you find the above solution useful / correct, so that other community members can find the information easily. See Did Your Question Get Answered in My Oracle Support Community Note 1180503.1 document on how to do this.

             

            Thanks

            Praveen