Creating the domainUpgradeResponse.txt File

16.2.2 Creating the domainUpgradeResponse.txt File

Run the following steps to create the domainUpgradeResponse.txt file:

Create a working directory for the upgrade scripts and navigate to it:

mkdir <workdir>/upgradescripts

cd <workdir>/upgradescripts

For example:

mkdir /OIG12CUPG/upgradescripts

cd /OIG12CUPG/upgradescripts

Create a domainUpgradeResponse.txt file and replace the environment variables listed with the corresponding values collected in Upgrade Prerequisite Steps:

[GENERAL]
 
fileFormatVersion = 3
 
#==================================================================
[UAWLSINTERNAL.UAWLS]
pluginInstance = 1
 
# Specifies the WebLogic Server domain directory:
UASVR.path = %DOMAIN_HOME%
 
#==================================================================
[MDS.SCHEMA_UPGRADE]
pluginInstance = 2
MDS.databaseConnectionString = %CONNECTION_STRING%
MDS.schemaConnectionString = %CONNECTION_STRING%
MDS.schemaUserName = %RCUPREFIX%_MDS
MDS.cleartextSchemaPassword = %SCHEMA_PASSWORD%
MDS.dbaUserName = %SYS_USERNAME% as sysdba
MDS.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[SOA.SOA1]
pluginInstance = 3
dependsOnPluginInstance = 2
SOAINFRA.databaseConnectionString = %CONNECTION_STRING%
SOAINFRA.schemaUserName = %RCUPREFIX%_SOAINFRA
SOAINFRA.cleartextSchemaPassword = %SCHEMA_PASSWORD%
SOAINFRA.dbaUserName = %SYS_USERNAME% as sysdba
SOAINFRA.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[OPSS.OPSS_SCHEMA_PLUGIN]
pluginInstance = 4
OPSS.databaseConnectionString = %CONNECTION_STRING%
OPSS.schemaUserName = %RCUPREFIX%_OPSS
OPSS.cleartextSchemaPassword = %SCHEMA_PASSWORD%
OPSS.dbaUserName = %SYS_USERNAME% as sysdba
OPSS.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[IAU.AUDIT_SCHEMA_PLUGIN]
pluginInstance = 5
IAU.databaseConnectionString = %CONNECTION_STRING%
IAU.schemaConnectionString = %CONNECTION_STRING%
IAU.schemaUserName = %RCUPREFIX%_IAU
IAU.cleartextSchemaPassword = %SCHEMA_PASSWORD%
IAU.dbaUserName = %SYS_USERNAME% as sysdba
IAU.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[FMWCONFIG.CIE_SCHEMA_PLUGIN]
pluginInstance = 6
STB.databaseConnectionString = %CONNECTION_STRING%
STB.schemaConnectionString = %CONNECTION_STRING%
STB.schemaUserName = %RCUPREFIX%_STB
STB.cleartextSchemaPassword = %SCHEMA_PASSWORD%
STB.dbaUserName = %SYS_USERNAME% as sysdba
STB.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[WLS.WLS]
pluginInstance = 7
WLS.databaseConnectionString = %CONNECTION_STRING%
WLS.schemaConnectionString = %CONNECTION_STRING%
WLS.schemaUserName = %RCUPREFIX%_WLS
WLS.cleartextSchemaPassword = %SCHEMA_PASSWORD%
WLS.dbaUserName = %SYS_USERNAME% as sysdba
WLS.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
# WLS_RUNTIME entries
WLS_RUNTIME.databaseConnectionString = %CONNECTION_STRING%
WLS_RUNTIME.schemaUserName = %RCUPREFIX%_WLS_RUNTIME
WLS_RUNTIME.cleartextSchemaPassword = %SCHEMA_PASSWORD%
WLS_RUNTIME.dbaUserName = %SYS_USERNAME% as sysdba
WLS_RUNTIME.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[UCSUMS.UCSUMS_SCHEMA_PLUGIN]
pluginInstance = 8
UMS.databaseConnectionString = %CONNECTION_STRING%
UMS.schemaUserName = %RCUPREFIX%_UMS
UMS.cleartextSchemaPassword = %SCHEMA_PASSWORD%
UMS.dbaUserName = %SYS_USERNAME% as sysdba
UMS.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%
 
#==================================================================
[OIM.OIM1]
pluginInstance = 9
dependsOnPluginInstance = 3
OIM.databaseConnectionString = %CONNECTION_STRING%
OIM.schemaUserName = %RCUPREFIX%_OIM
OIM.cleartextSchemaPassword = %SCHEMA_PASSWORD%
OIM.dbaUserName = %SYS_USERNAME% as sysdba
OIM.cleartextDbaPassword = %SYS_SCHEMA_PASSWORD%

For example:

[GENERAL]
 
fileFormatVersion = 3
 
#==================================================================
[UAWLSINTERNAL.UAWLS]
pluginInstance = 1
 
# Specifies the WebLogic Server domain directory:
UASVR.path = /u01/oracle/user_projects/domains/governancedomain
 
#==================================================================
[MDS.SCHEMA_UPGRADE]
pluginInstance = 2
MDS.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
MDS.schemaConnectionString = mydatabasehost.example.com:1521/orcl.example.com
MDS.schemaUserName = OIGK8S_MDS
MDS.cleartextSchemaPassword = <password>
MDS.dbaUserName = sys as sysdba
MDS.cleartextDbaPassword = <password>
 
#==================================================================
[SOA.SOA1]
pluginInstance = 3
dependsOnPluginInstance = 2
SOAINFRA.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
SOAINFRA.schemaUserName = OIGK8S_SOAINFRA
SOAINFRA.cleartextSchemaPassword = <password>
SOAINFRA.dbaUserName = sys as sysdba
SOAINFRA.cleartextDbaPassword = <password>
 
#==================================================================
[OPSS.OPSS_SCHEMA_PLUGIN]
pluginInstance = 4
OPSS.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
OPSS.schemaUserName = OIGK8S_OPSS
OPSS.cleartextSchemaPassword = <password>
OPSS.dbaUserName = sys as sysdba
OPSS.cleartextDbaPassword = <password>
 
#==================================================================
[IAU.AUDIT_SCHEMA_PLUGIN]
pluginInstance = 5
IAU.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
IAU.schemaConnectionString = mydatabasehost.example.com:1521/orcl.example.com
IAU.schemaUserName = OIGK8S_IAU
IAU.cleartextSchemaPassword = <password>
IAU.dbaUserName = sys as sysdba
IAU.cleartextDbaPassword = <password>
 
#==================================================================
[FMWCONFIG.CIE_SCHEMA_PLUGIN]
pluginInstance = 6
STB.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
STB.schemaConnectionString = mydatabasehost.example.com:1521/orcl.example.com
STB.schemaUserName = OIGK8S_STB
STB.cleartextSchemaPassword = <password>
STB.dbaUserName = sys as sysdba
STB.cleartextDbaPassword = <password>
 
#==================================================================
[WLS.WLS]
pluginInstance = 7
WLS.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
WLS.schemaConnectionString = mydatabasehost.example.com:1521/orcl.example.com
WLS.schemaUserName = OIGK8S_WLS
WLS.cleartextSchemaPassword = <password>
WLS.dbaUserName = sys as sysdba
WLS.cleartextDbaPassword = <password>
 
# WLS_RUNTIME entries
WLS_RUNTIME.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
WLS_RUNTIME.schemaUserName = OIGK8S_WLS_RUNTIME
WLS_RUNTIME.cleartextSchemaPassword = <password>
WLS_RUNTIME.dbaUserName = sys as sysdba
WLS_RUNTIME.cleartextDbaPassword = <password>
 
#==================================================================
[UCSUMS.UCSUMS_SCHEMA_PLUGIN]
pluginInstance = 8
UMS.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
UMS.schemaUserName = OIGK8S_UMS
UMS.cleartextSchemaPassword = <password>
UMS.dbaUserName = sys as sysdba
UMS.cleartextDbaPassword = <password>
 
#==================================================================
[OIM.OIM1]
pluginInstance = 9
dependsOnPluginInstance = 3
OIM.databaseConnectionString = mydatabasehost.example.com:1521/orcl.example.com
OIM.schemaUserName = OIGK8S_OIM
OIM.cleartextSchemaPassword = <password>
OIM.dbaUserName = sys as sysdba
OIM.cleartextDbaPassword = <password>