dbca静默建库报错:[DBT-06005] 'Datafile location' contains invalid characters.
dbca命令行方式建库报错
[FATAL] [DBT-06005] 'Datafile location' contains invalid characters.
ACTION: Choose a 'Datafile location' containing only alphanumeric characters and a few additional characters that are allowed for your platform.
查询mos
可能原因:bug:Apply generic patch 25353173
自己解决
使用响应文件的方式建库就可以了:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | -- D:\oracle19c\dbhome_1\bin\dbca -silent -deleteDatabase -sourceDB orcl19c D:\oracle19c\dbhome_1\bin\dbca -createdatabase -silent -J-Doracle.assistants.dbca.validate.ConfigurationParams=false -responseFile d:\dbca.rsp -- d:\dbca.rsp文件内容: responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 gdbName=orcl19c sid=orcl19c databaseConfigType=SI createAsContainerDatabase=true numberOfPDBs=1 pdbName=lhrpdb useLocalUndoForPDBs=true pdbAdminPassword=oracle templateName=D:\oracle19c\dbhome_1\assistants\dbca\templates\General_Purpose.dbc sysPassword=oracle systemPassword=oracle emConfiguration=none runCVUChecks=FALSE olsConfiguration=false datafileJarLocation={ORACLE_HOME}\assistants\dbca\templates\ datafileDestination={ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\ recoveryAreaDestination={ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME} storageType=FS characterSet=AL32UTF8 nationalCharacterSet=AL16UTF16 variables=ORACLE_BASE_HOME=D:\oracle19c\dbhome_1,DB_UNIQUE_NAME=orcl19c,ORACLE_BASE=D:\oracle19c,PDB_NAME=,DB_NAME=orcl19c,ORACLE_HOME=D:\oracle19c\dbhome_1,SID=orcl19c initParams=undo_tablespace=UNDOTBS1,sga_target=7371MB,db_block_size=8192BYTES,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orcl19cXDB),diagnostic_dest={ORACLE_BASE},control_files=("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME}\control02.ctl"),remote_login_passwordfile=EXCLUSIVE,audit_file_dest={ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump,processes=640,pga_aggregate_target=2458MB,nls_territory=AMERICA,local_listener=LISTENER_ORCL19C,db_recovery_file_dest_size=12732MB,open_cursors=300,compatible=19.0.0,db_name=orcl19c,db_recovery_file_dest={ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME},audit_trail=db sampleSchema=false databaseType=MULTIPURPOSE totalMemory=2048 |