Skip to Content
0
Jul 04, 2022 at 01:32 AM

Oracle database naming convention

180 Views


We are in processing of having below setup for ECC, with two physical standby databases. This is part of migration effort.

Database Name (DB_NAME) A

Primary Database Instance (ORACLE_SID) B
Primary Database Unique Name (db_unique_name) B

First Standby Instance (ORACLE_SID) C
First Standby Database Unique Name (db_unique_name) C

Second Standby Instance (ORACLE_SID) D
Second Standby Database Unique Name (db_unique_name) D


A service will be created with name A, which can handle Data Guard connection as below:

A=
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = on)
(CONNECT_TIMEOUT = 5)
(TRANSPORT_CONNECT_TIMEOUT = 3)
(RETRY_COUNT = 3)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = A)
)
)


Questions:
==================

1. Does SAP application support this naming convention?
2. Do we have any restrictions/limitations on naming? Our Basis/application team pointed few SAP notes about three character limitations on ORACLE_SID/DB_NAME/Instance Name?
3. Update us with SAP Notes on naming convention if anything as pointed in #2


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.