Forum Stats

  • 3,855,574 Users
  • 2,264,523 Discussions
  • 7,906,071 Comments

Discussions

Naming convention for Application root and Application

martin75
martin75 Member Posts: 190 Bronze Badge
edited Apr 24, 2019 10:12PM in Multitenant

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

SandiM

Answers

  • Praveen Ch-Oracle
    Praveen Ch-Oracle Member Posts: 12 Employee
    edited Mar 27, 2019 10:30PM

    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

    SandiM
  • Praveen Ch-Oracle
    Praveen Ch-Oracle Member Posts: 12 Employee
    edited Apr 24, 2019 10:12PM

    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