DBCA Duplication In A Multibyte Environment Causes ORA-01078
(Doc ID 2915528.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
DBCA database duplication with the following command fails with error ORA-01078 as shown below:
$ env | grep LANG
NLS_LANG=American_Japan.JA16EUC
LANG=ja_JP.UTF-8
$ dbca -silent -createDuplicateDB -createAsStandby -gdbName <Primary DBName> -sysPassword <SYS Password> -primaryDBConnectionString <Hostname>:<Port>/<Instance Name> -dbUniqueName <Standby DB Unique Name> -sid <SID> -storageType FS -useOMF false -datafileDestination <Datafile Path>
Prepare for db operation
22% complete
Listener config step
44% complete
Auxiliary instance creation
67% complete
RMAN duplicate
89% complete
Post duplicate database operations
100% complete
[FATAL] ORA-01078: failure in processing system parameters
NLS_LANG=American_Japan.JA16EUC
LANG=ja_JP.UTF-8
$ dbca -silent -createDuplicateDB -createAsStandby -gdbName <Primary DBName> -sysPassword <SYS Password> -primaryDBConnectionString <Hostname>:<Port>/<Instance Name> -dbUniqueName <Standby DB Unique Name> -sid <SID> -storageType FS -useOMF false -datafileDestination <Datafile Path>
Prepare for db operation
22% complete
Listener config step
44% complete
Auxiliary instance creation
67% complete
RMAN duplicate
89% complete
Post duplicate database operations
100% complete
[FATAL] ORA-01078: failure in processing system parameters
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |