TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
Symptoms
DBCA fails to create duplicate database with error "[FATAL] [DBT-10315] Specified SID Name cannot exceed (8) characters"
<DB_HOME>/bin/dbca -silent -createDuplicateDB -gdbName ORCLDBP0.<db_domain> -sid ORCLDBP0R -primaryDBConnectionString <string> -dbUniqueName ORCLDBP0R -adminManaged -datafileDestination +DATA01_EXTN -databaseConfigType RAC -nodelist Node01,Node02,Node03 -initParams db_create_file_dest=+DATA, db_create_online_log_dest_1=+RECO-sid ORCLDBP0R has 9 characters
$ORA_BASE/cfgtoollogs/dbca/<DB_NAME>/trace.log_2022-09-29_08-08-46AM
---------------------------------------------------------------------
[main] [ 2022-09-29 08:09:54.330 CEST ] [EntityOperations.isEntityRegisteredCRSD:367] entity: Generic, type: 3, registered: true
[main] [ 2022-09-29 08:09:54.330 CEST ] [CRSCache.getAttributesFromCRS:155] CRS: name: Free, type 3, node: null
[main] [ 2022-09-29 08:09:54.330 CEST ] [CRSCache.getAttributesFromCRS:156] attrs: [ACTIVE_SERVERS]
[main] [ 2022-09-29 08:09:54.333 CEST ] [CRSCache.getAttributesFromCRS:163] CRS: [<ACTIVE_SERVERS:>]
[main] [ 2022-09-29 08:09:54.333 CEST ] [ServerPoolImpl.serversHelper2:1010] attrValue=
[main] [ 2022-09-29 08:09:54.334 CEST ] [CRSCache.getAttributesFromCRS:155] CRS: name: Generic, type 3, node: null
[main] [ 2022-09-29 08:09:54.334 CEST ] [CRSCache.getAttributesFromCRS:156] attrs: [ACTIVE_SERVERS]
[main] [ 2022-09-29 08:09:54.336 CEST ] [CRSCache.getAttributesFromCRS:163] CRS: [<ACTIVE_SERVERS:Node01 Node02 Node03>]
[main] [ 2022-09-29 08:09:54.337 CEST ] [ServerPoolImpl.serversHelper2:1010] attrValue=Node01 Node02 Node03
WARNING: Sep 29, 2022 8:09:54 AM oracle.install.commons.util.exception.AbstractErrorAdvisor getDetailedMessage
WARNING: [WARNING] [DBT-10315] Specified SID Name cannot exceed (8) characters.
WARNING: Sep 29, 2022 8:09:54 AM oracle.assistants.common.base.util.AssistantAdvisor logMessage
WARNING: [ 2022-09-29 08:09:54.338 CEST ] [WARNING] [DBT-10315] Specified SID Name cannot exceed (8) characters.
Cause
Develoment worked on below bug and confirmed the issue is expected. Not a Bug.
Bug 32363746 - DBCA -DUPLICATEDB [FATAL] [DBT-10315] SPECIFIED SID NAME CANNOT EXCEED (8) CHARACTERS
Solution
The SID prefix has been limited to 8 characters to allow for underscore for policy-managed database and three digits for instance number.
This is the expected behavior from the DBCA
Choose SID name equal or less than 8 charachers.
|
|