Usage types for environments

A         =   St”A”ging B         =   Data Guard Test or lower level (“B”ackup) C         =   Crash & Burn or CIT, POC (alternatively) D         =   “D”evelopment this can be DIT as well E          =   Training F          =   Per”F”formance Test G         =   Data “G”uard Prod (alternate usage) H         =   Support I           =   iCert ? J          = K         = […]

Oracle Instance Naming

Over the years I have thought long and hard about an intelligent way of naming databases, this is only for Oracle environments. Naming of the database instances should identify immediately what database and instance number it is. I have seen many times where the instance number is not identified and makes it difficult when managing […]

Oracle Database Naming Standards

Naming of the database should include a descriptive identifier for the application usage of the database, if there is more than one application, a descriptive term should be applied to the collection of applications being used. Database naming is as follows: AAAAAXYY AAAAA          = This is a 5 char value for the application naming […]