What is the difference between the database template files included with the oracle installation tools.
search cancel

What is the difference between the database template files included with the oracle installation tools.

book

Article ID: 403556

calendar_today

Updated On:

Products

Data Loss Prevention Endpoint Prevent

Issue/Introduction

Within the <DB_version>_64_bit_Installation_Tools.zip file there are several database template files(dbt) what are each of them for?

/multitenant/Oracle_19.3.0.0_Template_for_64_bit_PDB_<WIN/LIN>.dbt
/rac/Oracle_19.3.0.0_Template_for_64_bit_PDB_<WIN/LIN>dbt
/rac/Oracle_19.3.0.0_Template_for_64_bit_<WIN/LIN>.dbt
/singleinstance/Oracle_19.3.0.0_Template_for_64_bit_<WIN/LIN>.dbt

Cause

Relevant terms:
RAC: Oracle Real Application Clusters (RAC) is a database architecture that enables multiple servers to run a single Oracle database concurrently, providing high availability and scalability. It allows for increased performance and fault tolerance by distributing the database workload across multiple instances. Rac may or may not be part of a multitenant database. 

Multitenant: A database architecture that enables multiple servers to run a single Oracle database concurrently, providing high availability and scalability. It allows for increased performance and fault tolerance by distributing the database workload across multiple instances. 

Singleinstance: A standalone database that is not part of a multitenant database or oracle RAC. 
If you are running Oracle Enterprise, your DBA should know which type of database you have. 

Pluggable Database(PDB)



Resolution

For the purpose of choosing a dbt file, choose the appropriate architecture,  RAC/Multitenant/singleinstance. 

If the database is multitenant then you'd use the only option available /multitenant/Oracle_19.3.0.0_Template_for_64_bit_PDB_<WIN/LIN>.dbt
If the database is a RAC database then it may be multitenant or singleinstance. If it is single instance use the /rac/Oracle_19.3.0.0_Template_for_64_bit_<WIN/LIN>.dbt 
If the RAC database is multitenant then use the /rac/Oracle_19.3.0.0_Template_for_64_bit_PDB_<WIN/LIN>dbt
If the database is neither RAC nor Multitenant, then use the /singleinstance/Oracle_19.3.0.0_Template_for_64_bit_<WIN/LIN>.dbt