Instalação Oracle 12 por linha de comando - DBCA modo SILENT

[Calvetti 0]

Olá Pessoal!

Estou tentando instalar o Oracle 12.2.0 via linha de comando usando arquivo de response dbca.rsp da forma expressa abaixo, mas me deparo com um erro da qual não consegui identificar onde está o problema. Alguém poderia ajudar?

 

[prompt]$ /u01/app/oracle/product/12.2.0.1/db_1/bin/dbca -silent -createDatabase -responseFile /u01/app/oracle/product/12.2.0.1/db_1/inventory/response/dbca.rsp

 

Erro:

[WARNING] [DBT-00108] Incorrect value passed to a command line argument.
   CAUSE: Exception encountered : cvc-complex-type.2.4.a: Invalid content was found starting with element 'CREATEDATABASE'. One of '{silent, progressOnly, checkOnly, progress_only, executePrereqs, continueOnNonFatalErrors, customCreate, copySeed, deinstall, oui_internal, ouiInternal, logToStdOut, reTry, ignorePreReqs, skipPrereq, skipPrereqs, ignorePrereqFailure, skipUserTemplateCheck, internalSkipGIHomeCheck, skipPwdFileCreation, skipDBNameValidation, skipGIHomeCheck, skipDummyInstCreation, skipListenerRegistration, skipASMCompativilityCheck, skipSIDExistenceCheck, skipDBExistenceCheck, skipPDBExistenceCheck, skipPasswordlessSSHValidation, skipSYSDBAPasswordPrompt, forceArchiveLogDeletion, debug, skipHARegistration, exitWithWarningStatus, autoGeneratePasswords, emca_internal, passwordDialog, completionDialog, lockUsers, newflow, unlockDBUsers, createDatabase, unplugDatabase, createDuplicateDB, deletePluggableDatabase, configureDatabase, deleteDatabase, generateScripts, createTemplateFromDB, createCloneTemplate, createPluggableDatabase, configurePluggableDatabase, renameDatabase, addInstance, deleteInstance, createAsStandby, skipEMConfiguration, opsDemo, RACOneNode, policyManaged, enableArchive, adminManaged, createServerPool, force, noOratabEntry, networkConfOnly, MGMTDB, pdbSeed, configureWithOID, deRegisterEMCloudControl, forceInternalAlterCharacterSet, useCatcon, rdbmsini_internal, createNewPDBAdminUser, promptForWalletPassword, noSampleSchema, responseFile, responseFileVersion, jreLoc, primaryDBConnectionString, dbUniqueName, sourceSID, maxBackupSetSizeInMB, datafileDestination, nodelist, redoLogFileDestination, nodeName, nodeInfo, rmanParallelism, numberOfPDBs, templateName, sourceSeed, databaseType, databaseConfigType, databaseConfType, RACOneNodeServiceName, archiveLogMode, archiveLogDest, pqPoolName, serverPoolName, cardinality, pqCardinality, gdbName, scriptDest, scriptsWorkDir, logDir, oracleHostName, ORACLE_HOSTNAME, oratabLocation, backupControlFile, seedDBName, inventoryLoc, useRMAN, datafileJarLocation, templateLocation, sid, oldSID, instanceName, dvConfiguration, olsConfiguration, emConfiguration, runCVUChecks, maskPasswords, dvUserName, dvAccountManagerName, emUser, omsHost, omsPort, emExpressPort, serviceUserName, recoveryAreaDestination, recoveryAreaSize, listeners, createListener, variablesFile, variables, initParams, initParamsEscapeChar, excludeInitParams, memoryPercentage, customScripts, totalMemory, nationalCharacterSet, characterSet, redoLogFileSize, sourceDB, sysDBAUserName, connectionString, maintainFileLocations, obfuscatedPasswords, createAsContainerDatabase, enableDBConsolidation, pdbSeedConvert, sourceFileNameConvert, fileNameConvert, copyPDBFiles, pdbArchiveFile, archiveType, pdbMetadataFile, pdbBackUpfile, pdbSeedMetadataFile, pdbSeedBackUpfile, pdbName, newPDBNames, pdbStorageMAXSizeInMB, pdbStorageMAXTempSizeInMB, createPDBFrom, pdbDatafileDestination, useMetaDataFileLocation, pdbAdminUserName, createUserTableSpace, createAsClone, workArea, pdbUseMultipleBackup, registerWithDirService, unregisterWithDirService, updateDirService, regenerateDBPassword, databaseCN, dirServiceUserName, storageType, diskList, redundancy, diskGroupName, recoveryDiskList, recoveryGroupName, recoveryGroupRedundancy, diskString, sampleSchema, automaticMemoryManagement, memoryMgmtType, ldap_directory_access, useOMF, pdbCustomDatafileLocation, dbOptions, pdbOptions, skipPasswordComplexityCheck, dvAccountManagerPassword, dbsnmpPassword, emPassword, serviceUserPassword, sysDBAPassword, pdbAdminPassword, lbacsysPassword, dirServicePassword, walletPassword, asmsnmpPassword, asmSysPassword, asmPassword, sysPassword, systemPassword, dvUserPassword, addDBOption, showCompleteHelp, useLocalUndoForPDBs, oracleHomeUserName, oracleHomeUserPassword, moveDatabaseFiles, honorControlFileInitParam, dbCredentialsWalletLocation, useWalletForDBCredentials, dbCredentialsWalletPassword}' is expected.

 

Conteúdo do arquivo dbca.rsp:

[GENERAL]
RESPONSEFILE_VERSION = "12.2.0"
OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]
gdbName = "STIPTST"
templateName = "General_Purpose.dbc"
characterSet = "WE8ISO8859P15"
createAsContainerDatabase = "FALSE"
databaseConfigType = "SI"
databaseType = "MULTIPURPOSE"
datafileDestination = "/u01/app/oracle/oradata/"
emConfiguration = "NONE"
enableArchive = "FALSE"
memoryMgmtType = "AUTO"
totalMemory = "1024"
nationalCharacterSet = "AL16UTF16"
recoveryAreaDestination = "/u01/app/oracle/flash_recovery_area/"
recoveryAreaSize = "8192"
redoLogFileSize = "100"
sid = "STIPTST"
storageType = "FS"
sysPassword = "Fmf6qIp1"
systemPassword = "Fmf6qIp1"
useOMF = "TRUE"

 

[Dlms 4]

Boa tarde,

 

Pela sua mensagem de erro,  o mesmo se encontra nessa sessão  [CREATEDATABASE] ,  agora, você precisa descobrir se está faltando algum parâmetro ou se os que você passou não possui um valor correto, seja por valor, quantidade de string e etc,  pois ao final do arquivo tem a mensagem: is expected., o que garante que falta algo ou precisa corrigir algo ai para que ele aceite.

 

verifique o tamanho de strings , e aproveita verifica também se esse parâmetro totalMemory = "1024"  se você nao teria que passar uma unidade de medida pra ele tipo  Mb, Gb, e etc.

 

verifica também se o OPERATION_TYPE = "createDatabase"  está correto. se não seria "CreateDatabase"