Server and Database Naming

As servers and databases are deployed for global applications, it becomes critical that server and database names are standardized globally. This document provides the guidelines that should be followed to name servers and databases for global applications. The naming conventions detailed in this document are provided as a formula. Certain components of the formula have been standardized so that they can be utilized very easily. However, there will be exceptions where the naming convention cannot be applied to a global application. It is then up to the GEOs to get together and agree on a naming convention that works for the specific application and that can be implemented on a global basis.

Server Naming Formula: application + function . domain

Database Naming Formula: application + function + geo specification

The following tables provide the recommended abbreviation standards to be used in naming servers and databases for global applications.

Examples :

FUNCTION ABBREVIATION
Disaster Recovery database DR
Disaster Recovery server DR or DBDR
Test database TST
Test server TST or TEST
Development DEV
Training TRN
Release REL
Test Reporting TRP
DBnet (off SWAN) DBX
Middle tier MT Middle tier (partner) MTP
Web server WS

GEO DOMAIN
APAC singapore; japan
EMEA holland; turkey
Americas central; east

Notes:

1. Oracle database names (SIDs) typically should be uppercase.

2. There is no hard limit to the length of a server name. It is recommended that server names no more than 8-14 characters, if possible.

3. Server names typically should be lower case.

4. Server names can include a hyphen to separate the application and function components of the server name. However, it has been discovered that a hyphen in the server name causes a problem when the Oracle database init.ora parameter global_names is set to TRUE and the db_domain parameter is set to the server name. To avoid this problem, do not use a hyphen in the server name.

5. The domain component of the server name will always be separated with a period ('.') from the application and function components.

In applications where there will be multiple servers of the same function, sequence numbers can be used. As an example, Radiance has 3 different servers hosting the middle tier. They are named rad-mt01.domain, rad-mt02.domain, rad-mt03.domain.


6. 
   

7. Oracle database names (SIDs) are limited to 8 charactersApplication component of Oracle database name can be up to 3 characters

1. Application component of Oracle database name can be up to 3 characters
2. Function component of Oracle database name can be up to 3 characters
3. GEO specification is limited to 2 characters