Database Administration (MOSC)

MOSC Banner

DBCA create database with DB_NAME != DB_UNIQUE_NAME?

edited May 20, 2020 5:02AM in Database Administration (MOSC) 8 commentsAnswered

Using 18c DBCA in GUI mode to create a new RAC database that will eventually be the primary in a Data Guard configuration.  The DB_NAME is TSTP in both databases and the DB_UNIQUE_NAME would be TSTP1 for the primary database and TSTP2 for the standby database.  This is not as simple to create as I thought it would be.

In DBCA GUI, creating a database from a template, set the Global DB Name = TSTP, SID Prefix = TSTP1 and then edited DB_UNIQUE_NAME in the Advanced Parameters to TSTP1.  The resultant database had two RAC nodes of TSTP11 and TSTP12 as expected, but a query on v$database showed that both the name and db_unique_name were TSTP.  DBCA ignored the DB_UNIQUE_NAME setting.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center