This chapter describes how to run the Oracle Fusion Middleware Upgrade Assistant from the command-line interface.
By default, the upgrade documentation describes how to use the graphical user interface to upgrade your Oracle Application Server 10g components to Oracle Fusion Middleware 11g. However, you can use the command-line interface, documented in this appendix, to automate the upgrade process with operating system scripts or to run the Upgrade Assistant remotely in a terminal window.
This chapter contains the following sections:
Using the Upgrade Assistant Command Line to Upgrade a Middle Tier
Using the Upgrade Assistant Command Line to Upgrade the Oracle SOA Suite Schemas
Using the Upgrade Assistant Command Line to Upgrade Oracle Identity Management
Using the Upgrade Assistant Command Line to Upgrade Oracle WebCenter Content
Using the Upgrade Assistant Command Line to Upgrade Oracle Data Integrator
Using the Upgrade Assistant Command Line to Upgrade Oracle Business Intelligence
Using the Upgrade Assistant Command Line to Verify an Upgraded Environment
The following arguments can be used when you launch the Upgrade Assistant graphical user interface:
On Windows systems:
ORACLE_HOME\bin\ua.bat [-logLevel log_level]
On UNIX systems:
ORACLE_HOME/bin/ua [-logLevel log_level] [-invPtrLoc inventory_location]
Refer to Table A-1 for a description of the command line arguments available when you are invoking the Upgrade Assistant graphical user interface (GUI).
Table A-1 Summary of the Upgrade Assistant Command-Line Arguments When Launching the Graphical User Interface
Argument | Description |
---|---|
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
At any time, you can use the following command to display a list of the options available from the Upgrade Assistant command line:
On Windows systems:
ORACLE_HOME\bin\ua.bat -help
On UNIX systems:
ORACLE_HOME/bin/ua -help
To use the Upgrade Assistant command line to upgrade a middle tier, enter the following command at the operating system prompt.
For example, you can use the arguments described here to upgrade an Oracle Portal, Forms, Reports, and Discoverer middle tier or a Web tier middle tier:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -sourceHome SOURCE_ORACLE_HOME -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]retainPorts] [-[no]stopComponents] [-[no]startComponents] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user]
On UNIX systems:
ORACLE_HOME/bin/ua MT -sourceHome SOURCE_ORACLE_HOME -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]retainPorts] [-[no]stopComponents] [-[no]startComponents] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user] [-invPtrLoc inventory_location]
Note:
The wls (Oracle WebLogic Server) options are not supported when you are running the Upgrade Assistant from a Web Tier Oracle home.Refer to Table A-2 for a description of the command line arguments available when you are upgrading a middle tier.
Table A-2 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading a Middle Tier
Argument | Description |
---|---|
-sourcehome |
Replace SOURCE_ORACLE_HOME with the full path to the Oracle Application Server 10g Oracle home that you want to upgrade. This is a required argument for middle-tier upgrades. |
-destInstanceHome |
Replace ORACLE_INSTANCE with the full path to the newly installed Oracle Fusion Middleware 11g Oracle instance. This is a required argument for middle-tier upgrades. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
-[no]silent |
Use this argument to turn off prompts and user confirmations during the upgrade. The default setting if you do not specify this argument is |
-[no]retainPorts |
Select this option to retain the port numbers used by the source middle tiers. The default setting is Note: Be sure to refer to "Important Notes When Using the Source Oracle Home Ports in the Destination Oracle Instance" in Oracle Fusion Middleware Upgrade Guide for Oracle Portal, Forms, Reports, and Discoverer. |
-[no]stopComponents |
Use this argument to stop all the components in the Source Oracle home before the upgrade process begins. The default setting is Stopping the source components is necessary to avoid any port conflicts when you select the Use source Oracle home ports in destination option in the GUI or the |
-[no]startComponents |
If you select this option, then Upgrade Assistant will attempt to start the 11g Oracle instance immediately after the upgrade. To start the components manually after the upgrade, use the The default setting is |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually These settings default to the values associated with the specified Oracle Fusion Middleware 11g Oracle instance. Note that these arguments are not required or supported when you are upgrading a Web tier Oracle home. |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
The following sections describe how to use the Upgrade Assistant command line to upgrade the Oracle SOA Suite schemas:
To use the Upgrade Assistant command line to upgrade the Oracle B2B schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat B2B -targetURL target_database_connect_string -targetUserName target_database_user -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
On UNIX systems:
ORACLE_HOME/bin/ua B2B -targetURL target_database_connect_string -targetUserName target_database_user -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
Table A-3 provides information about the Oracle B2B schema upgrade command-line upgrade options. Table A-4 provides a description of the command-line arguments common to all Oracle SOA Suite and Oracle Portal, Forms, Reports, and Discoverer schema upgrades.
Table A-3 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle B2B Schema
Argument | Description |
---|---|
-targetURL target_database_connect_string |
Enter the database connection string for the target database:
This is a required argument. |
-targetUserName target_database_user |
Enter the database user name that will be used to connect to the target database. For example, This is a required argument. |
Table A-4 Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades
Argument | Description |
---|---|
-[no]ErrorMode |
Use this argument to control whether or not the schema upgrade process stops on the first occurrence of any type of error condition. The default is |
-[no]CheckMode |
Use this argument to control whether or not the Upgrade Assistant performs the examination phase of the upgrade. The default is |
-[no]UpgradeMode |
Use this argument to control whether or not the Upgrade Assistant actually performs the upgrade after performing the examination phase. The default is |
To use the Upgrade Assistant command line to upgrade the Oracle BAM schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat BAM -targetURL target_db_connection_string -targetUserName target_db_user_name -dbHost source_db_host -dbPort source_db_port -dbServiceName source_db_service_name -bamUserName source_bam_schema_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
On UNIX systems:
ORACLE_HOME/bin/ua BAM -targetURL target_db_connection_string -targetUserName target_db_user_name -dbHost source_db_host -dbPort source_db_port -dbServiceName source_db_service_name -bamUserName source_bam_schema_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
Table A-5 describes the command-line arguments required when you are upgrading the Oracle BAM schema.
Table A-5 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle BAM Schema
Argument | Description |
---|---|
-targetURL target_db_connection_string |
Enter the database connection string for the target database:
This is a required argument. |
-targetUserName target_db_user_name |
Enter the database user name that will be used to connect to the target database. For example, This is a required argument. |
-dbHost source_db_host |
Enter the name of the host where the source database resides. This is the database that contains the Oracle BAM 10g schema. This is a required argument. |
-dbPort source_db_port |
Enter the listening port of the source database (for example, This is a required argument. |
-dbServiceName |
Enter the service name of the source database. For example: schemadb2.example.com This is the database that contains the Oracle BAM 10g schema. This is a required argument. |
-bamUserName |
Enter the database user associated with the Oracle BAM schema in the source database. This is a required argument. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
To use the Upgrade Assistant command line to upgrade the Oracle Portal and Oracle Business Intelligence Discoverer schemas in a Oracle Portal, Forms, Reports, and Discoverer installation, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MR -portal -discoverer -oidHost oid_host -oidSslPort oid_ssl_port -schemaName disco_schema_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
On UNIX systems:
ORACLE_HOME/bin/ua MR -portal -discoverer -oidHost oid_host -oidSslPort oid_ssl_port -schemaName disco_schema_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
Table A-6 describes the command-line arguments required when you are upgrading the Oracle Portal and Oracle Business Intelligence Discoverer schemas.
Table A-6 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle BAM Schema
Argument | Description |
---|---|
-portal |
Use this argument when you are upgrading the Oracle Portal schema. You can use it alone, or with the |
-discoverer |
Use this argument when you are upgrading the Oracle Business Intelligence Discoverer schema. You can use it alone, or with the |
-oidHost oid_host |
Enter the name of the host where the Oracle Internet Directory instance resides. This argument is required. |
-oidSslPort oid_ssl_port |
Enter the secure (SSL) listening port of the Oracle Internet Directory instance. This argument is required. |
-schemaName disco_schema_name |
Enter the name of the target Oracle Business Intelligence Discoverer 11g schema. This is the name of the schema that you entered when you created the Discoverer schema with the Repository Creation Utility. The 11g schema name usually includes a unique prefix that is used to identify the schema in the database. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
The following sections describe how to use the Upgrade Assistant command-line interface to upgrade your Oracle Identity Management components:
Oracle Access Manager Upgrade Assistant Command-Line Arguments
Oracle Adaptive Access Manager Middle-Tier Upgrade Assistant Command-Line Arguments
Oracle Adaptive Access Manager Schema Upgrade Assistant Command-Line Arguments
To use the Upgrade Assistant command line to upgrade Oracle Internet Directory and Oracle Directory Integration Platform, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat IM -sourceHome SOURCE_ORACLE_HOME -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]retainPorts] [-[no]startComponents] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user] [-dbHost db_host] [-dbPort db_port] [-dbServiceName db_service]
On UNIX systems:
ORACLE_HOME/bin/ua IM -sourceHome SOURCE_ORACLE_HOME -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]retainPorts] [-[no]startComponents] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user] [-dbHost oid_db_host] [-dbPort oid_db_port] [-dbServiceName oid_db_service] [-rac db_racspec] [-invPtrLoc inventory_location]
Refer to Table A-7 for a description of the command line arguments available when you are upgrading Oracle Internet Directory and Oracle Directory Integration Platform.
Table A-7 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading Oracle Internet Directory and Oracle Directory Integration Platform
Argument | Description |
---|---|
-sourcehome |
Replace SOURCE_ORACLE_HOME with the full path to the Oracle Application Server 10g Oracle home that you want to upgrade. This is a required argument. |
-destInstanceHome |
Replace ORACLE_INSTANCE with the full path to the newly installed Oracle Fusion Middleware 11g Oracle instance. This is a required argument. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
-[no]silent |
Use this argument to turn off prompts and user confirmations during the upgrade. The default setting if you do not specify this argument is |
-[no]retainPorts |
Select this option to retain the port numbers used by the 10g source Oracle home. The default setting is Note: Be sure to refer to "Important Notes When Using the Source Oracle Home Ports in the Destination Oracle Instance" in Oracle Fusion Middleware Upgrade Guide for Oracle Portal, Forms, Reports, and Discoverer. |
-[no]startComponents |
If you select this option, then Upgrade Assistant will attempt to start the 11g Oracle instance immediately after the upgrade. To start the components manually after the upgrade, use the The default setting is |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually |
-dbHost oid_db_host -dbPort oid_db_port -dbServiceName oid_db_service |
Use these arguments to enter the host, port, and service name of the database where the Oracle Internet Directory instance resides. For example: schemadb2.example.com These arguments are required for an Oracle Internet Directory or Oracle Identity Federation upgrade only. |
-rac db_racspec |
On UNIX systems, use this argument to enter the connection details to the nodes in a Real Application Clusters environment. Note this argument is necessary only if you are upgrading Oracle Directory Integration Platform in a Real Application Clusters environment. You must enter a list of the instances in the cluster, in the following format: host:port:instance^host:port:instance^...@service For more information, see "About Specifying Real Application Clusters (RAC) Database Details on the Specify Database Details Screen" in the Oracle Fusion Middleware Upgrade Guide for Oracle Identity Management. |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade Oracle Access Manager, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -OAM -propertyFile property_file_path -dbHost db_host -dbPort db_port -dbServiceName db_service -oidHost oid_host_name -oidSslPort oid_ssl_port -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponents] [-[no]oamAllowExternal]
On UNIX systems:
ORACLE_HOME/bin/ua MT -OAM -propertyFile property_file_path -dbHost db_host -dbPort db_port -dbServiceName db_service -oidHost oid_host_name -oidSslPort oid_ssl_port -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponents] [-[no]oamAllowExternal] [-invPtrLoc inventory_location]
Refer to Table A-8 for a description of the command line arguments available when you are upgrading Oracle Access Manager.
Table A-8 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading Oracle Access Manager
Argument | Description |
---|---|
-propertyFile property_file_path |
Replace property_file_path with the full path to the Oracle Single Sign-On 10g If your Oracle Access Manager 11g installation is on a separate host from the Oracle Single Sign-On 10g installation, then you must copy the 10g This is a required argument. |
-dbHost db_host |
Replace db_host with the full path to the host of the database where the Oracle Single Sign-On 10g schema is installed. This is a required argument. |
-dbPort db_port |
Replace db_port with port number of the database where the Oracle Single Sign-On 10g schema is installed. This is a required argument. |
-dbServiceName db_service |
Replace db_service with the service name of the database where the Oracle Single Sign-On 10g schema is installed. This is a required argument. |
-oidHost oid_host_name |
Replace oid_host_name with the name of the host where the Oracle Internet Directory server is running. This is a required argument. |
-oidSslPort oid_ssl_port |
Replace oid_ssl_port with the SSL port of the Oracle Internet Directory instance. This is a required argument. |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually |
[-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponent] |
For descriptions of these elements, see Table A-2, "Summary of the Upgrade Assistant Command-Line Arguments When Upgrading a Middle Tier". |
[-[no]oamAllowExternal] |
Upgrade Oracle Access Manager even if there are external Portal applications. The default is |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade an Oracle Adaptive Access Manager middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -OAAM -asaDir asa_directory -armDir arm_directory -dbType db_type -dbConnectString db_connect_string -oaamUserName oaam_user_name -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponents]
On UNIX systems:
ORACLE_HOME/bin/ua MT -OAAM -asaDir asa_directory -armDir arm_directory -dbType db_type -dbConnectString db_connect_string -oaamUserName oaam_user_name -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponents] [[-invPtrLoc <inventory_loc>] ...]
Refer to Table A-9 for a description of the command line arguments available when you are upgrading Oracle Adaptive Access Manager.
Table A-9 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading an Oracle Adaptive Access Manager Middle Tier
Argument | Description |
---|---|
-asaDir asa_directory |
Replace asa_directory with the directory location for Oracle Adaptive Access Manager Adaptive Strong Authenticator Web Application 10g (ASA) application. This is a required argument. |
-armDir arm_directory |
Replace arm_directory with the directory location for Oracle Adaptive Access Manager Adaptive Risk Manager Web Application 10g (ARM) application. This is a required argument. |
-dbType db_type |
Replace db_type with the type of database that contains the Oracle Adaptive Access Manager schema. Possible values are:
This is a required argument. |
-dbConnectString |
Replace db_connect_string with the database connect string.
This is a required argument. |
-oaam_UserName |
Replace oaam_schema_name with the name of the database user associated with the OAAM schema. |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually |
[-logLevel log_level] [-[no]verbose] [-[no]silent] [-[no]startComponent] |
For descriptions of these elements, see Table A-2, "Summary of the Upgrade Assistant Command-Line Arguments When Upgrading a Middle Tier". |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade the Oracle Adaptive Access Manager schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat OAAM -dbtype db_type -dbConnectString db_connect_string -dbaUserName dba_user_name -oaamUserName oaam_user_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode
On UNIX systems:
ORACLE_HOME/bin/ua OAAM -dbtype db_type -dbConnectString db_connect_string -dbaUserName dba_user_name -oaamUserName oaam_user_name -[no]ErrorMode -[no]CheckMode -[no]UpgradeMode [[-invPtrLoc <inventory_loc>] ...]
Refer to Table A-10 for a description of the command line arguments available when you are upgrading the Oracle Adaptive Access Manager schema.
Table A-10 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle Adaptive Access Manager Schema
Argument | Description |
---|---|
-dbType db_type |
Replace db_type with the type of database that contains the Oracle Adaptive Access Manager schema. Possible values are:
This is a required argument. |
-dbConnectString |
Replace database_connect_string with the database connect string.
This is a required argument. |
-oaam_UserName |
Replace oaam_schema_name with the name of the database user associated with the OAAM schema. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
The following sections describe how to upgrade the Oracle WebCenter Content components using the Upgrade Assistant command-line interface:
Oracle WebCenter Content Middle-Tier Upgrade Assistant Command-Line Arguments
Oracle WebCenter Content: Records Middle-Tier Upgrade Assistant Command-Line Arguments
WebCenter Content Schema Upgrade Assistant Command-Line Arguments
To use the Upgrade Assistant command line to upgrade an Oracle WebCenter Content (WebCenter Content) middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -UCM -binDir 10g_bindir_directory -intradocDir 11g_intradocDir_directory -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose]
On UNIX systems:
ORACLE_HOME/bin/ua MT -UCM -binDir 10g_bindir_directory -intradocDir 11g_intradocDir_directory -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-invPtrLoc inventory_location]
Refer to Table A-11 for a description of the command line arguments available when you are upgrading WebCenter Content.
Table A-11 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading an WebCenter Content Middle Tier
Argument | Description |
---|---|
-binDir |
Replace 10g_bindir_directory with the full path to the WebCenter Content 10g binDir directory. This is a required argument. |
-intradocDir |
Replace 11g_intradocDir_directory with the full path to the Oracle instance directory of the newly installed Oracle WebCenter Content 11g Oracle instance. The path to the Oracle instance directory is saved in the This variable refers to the root directory for configuration and data files specific to a Content Server instance deployed on an Oracle UCM domain. This directory can be located elsewhere, but the default location is This is a required argument. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually These are required arguments. |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade an Oracle WebCenter Content: Records (Records) middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -URM -binDir 10g_bindir_directory -intradocDir 11g_intradocDir_directory -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose]
On UNIX systems:
ORACLE_HOME/bin/ua MT -URM -binDir 10g_bindir_directory -intradocDir 11g_intradocDir_directory -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [-invPtrLoc inventory_location]
Refer to Table A-12 for a description of the command line arguments available when you are upgrading Records.
Table A-12 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading an Records Middle Tier
Argument | Description |
---|---|
-binDir |
Replace 10g_bindir_directory with the full path to the Records 10g binDir directory. This is a required argument. |
-intradocDir |
Replace 11g_instradocDir_directory with the full path to the Oracle instance directory of the newly installed Records 11g Oracle instance. The path to the Oracle instance directory is saved in the This variable refers to the root directory for configuration and data files specific to a Content Server instance deployed on an Oracle UCM domain. This directory can be located elsewhere, but the default location is This is a required argument. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade the WebCenter Content schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat UCM [-dbtype database_type] -dbConnectionString database_connect_string -dbaUserName database_admin_user -ucmUserName Oracle_UCM_user -sourceHome 10g_oracle_home [-[no]ErrorMode] [-[no]CheckMode] [-[no]UpgradeMode]
On UNIX systems:
ORACLE_HOME/bin/ua UCM [-dbtype database_type] -dbConnectionString database_connect_string -dbaUserName database_admin_user -ucmUserName Oracle_UCM_user -sourceHome 10g_oracle_home [-[no]ErrorMode] [-[no]CheckMode] [-[no]UpgradeMode]
Refer to Table A-13 for a description of the command line arguments available when you are upgrading Records.
Table A-13 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the WebCenter Content Schema
Argument | Description |
---|---|
-dbType |
Replace database_type with one of the following:
The default (if you do not enter a value) is Oracle. |
-dbConnectString |
Replace database_connect_string with the URL connect string for the database that contains the 10g schema. For example, the connect string for an Oracle database must be provided in one of the following formats:
The connect string for a Microsoft SQL Server database or an IBM DB2 database must be in the following format: //host:port:DatabaseName=database_name This is a required argument. |
-dbaUserName |
Replace database_admin_user with the database administrator user name of the 10g database:
This is a required argument. |
-ucmUserName |
Replace Oracle_UCM_user with the the name of the WebCenter Content database user. This is a required argument. |
-sourceHome 10g_oracle_home |
Replace 10g_oracle_home with the full path to the WebCenter Content 10g Oracle home. This is a required argument. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
To use the Upgrade Assistant command line to upgrade the Records schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat URM [-dbtype database_type] -dbConnectionString database_connect_string -dbaUserName database_admin_user -urmUserName Oracle_URM_user -sourceHome 10g_oracle_home [-[no]ErrorMode] [-[no]CheckMode] [-[no]UpgradeMode]
On UNIX systems:
ORACLE_HOME/bin/ua URM [-dbtype database_type] -dbConnectString <db_connect_string> -dbaUserName database_admin_user -ucmUserName Oracle_URM_user -sourceHome 10g_oracle_home [-[no]ErrorMode] [-[no]CheckMode] [-[no]UpgradeMode]
Refer to Table A-14 for a description of the command line arguments available when you are upgrading Records.
Table A-14 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Records Schema
Argument | Description |
---|---|
-dbType |
Replace database_type with one of the following:
The default (if you do not enter a value) is Oracle. |
-dbConnectString |
Replace database_connect_string with the URL connect string for the database that contains the 10g schema. For example, the connect string for an Oracle database must be provided in one of the following formats:
The connect string for a Microsoft SQL Server database or an IBM DB2 database must be in the following format: //host:port:DatabaseName=database_name This is a required argument. |
-dbaUserName |
Replace database_admin_user with the database administrator user name of the 10g database.
This is a required argument. |
-urmUserName |
Replace Oracle_URM_user with the the name of the Records database user. This is a required argument. |
-sourceHome |
Replace 10g_oracle_home with the full path to the Records 10g Oracle home. This is a required argument. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
The following sections describe how to upgrade the Oracle Data Integrator components using the Upgrade Assistant command-line interface:
Oracle Data Integrator Middle-Tier Upgrade Assistant Command-Line Arguments
Oracle Data Integrator Schema Upgrade Assistant Command-Line Arguments
To use the Upgrade Assistant command line to upgrade an Oracle Data Integrator middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat MT -sourceHome 10g_ODI_Oracle_home [-logLevel log_level] [-[no]verbose]
On UNIX systems:
ORACLE_HOME/bin/ua MT -sourceHome 10g_ODI_Oracle_home [-logLevel log_level] [-[no]verbose] [-invPtrLoc inventory_location]
Refer to Table A-15 for a description of the command line arguments available when you are upgrading an Oracle Data Integrator middle tier.
Table A-15 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading an Oracle Data Integrator Middle Tier
Argument | Description |
---|---|
-sourceHome |
Replace 10g_ODI_Oracle_home with the full path to Oracle Data Integrator 10g Oracle home. This is a required argument. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade the Oracle Data Integrator schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat ODI [-dbtype database_type] -dbConnectionString database_connect_string -dbaUserName <dba_user_name> -odiMasterUserName ODI_master_user_name -odiSupervisorName ODI_supervisor_name -odiWorkrep ODI_work_repository_list -odiWorkrepUserName ODI_work_repository_user_name_list [-cloneOption] [-noCloneOption] [-kmOption] [-noKmOption] [-topologyOption] [-noTopologyOption]
On UNIX systems:
ORACLE_HOME/bin/ua ODI [-dbtype database_type] -dbConnectionString database_connect_string -dbaUserName <dba_user_name> -odiMasterUserName ODI_master_user_name -odiSupervisorName ODI_supervisor_name -odiWorkrep ODI_work_repository_list -odiWorkrepUserName ODI_work_repository_user_name_list [-cloneOption] [-noCloneOption] [-kmOption] [-noKmOption] [-topologyOption] [-noTopologyOption]
Refer to Table A-16 for a description of the command line arguments available when you are upgrading the Oracle Data Integrator schema.
Table A-16 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle Data Integrator Schema
Argument | Description |
---|---|
-dbType |
Replace database_type with one of the following:
The default (if you do not enter a value) is Oracle. |
-dbConnectString |
Replace database_connect_string with the URL connect string for the database that contains the 10g schema. For a complete description of the connect string required for each database types, see the description of the Connect String field in the section, "Target Database," in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. This is a required argument. |
-dbaUserName |
Replace database_admin_user with the database administrator user name that will be used to connect to the database:
This is a required argument. |
-odiMasterUserName |
Replace ODI_master_user_name with the user name of the Oracle Data Integrator master repository owner. For example: DEV_ODI_REPO This is a required argument. |
-odiSupervisorName |
Replace ODI_supervisor_name with the user name of the Oracle Data Integrator User with Supervisor privileges. For example: SUPERVISOR This is a required argument. |
-odiWorkrep |
Replace ODI_work_repository_list with a comma-separated list of one or more ODI work repository names. |
-odiWorkrepUserName |
Replace ODI_work_repository_user_name_list with a comma-separated list of the user names associated with each work repository listed in the |
[-cloneOption | -noCloneOption] |
Corresponds to the Check That Upgrade Occurs Only on Cloned Repositories option on the Specify Operation screen in the Upgrade Assistant graphical user interface. For more information, see "Specify Operation" in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. The default setting is |
[-kmOption | -noKmOption] |
Corresponds to the Replace KMs with Mandatory Updates option on the Specify Operation screen in the Upgrade Assistant graphical user interface. For more information, see "Specify Operation" in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. The default setting is |
[-topologyOption | -noTopologyOption] |
Corresponds to the Update Topology and Security Metadata option on the Specify Operation screen in the Upgrade Assistant graphical user interface. For more information, see "Specify Operation" in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. The default setting is |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
The following sections describe how to use the Upgrade Assistant command-line interface to upgrade Oracle BI Enterprise Edition and Oracle Business Intelligence Publisher:
Oracle BI Enterprise Edition Middle Tier Upgrade Assistant Command-Line Arguments
Oracle Business Intelligence Publisher Middle Tier Upgrade Assistant Command-Line Arguments
Oracle Business Intelligence Scheduler Schema Upgrade Assistant Command-Line Arguments
To use the Upgrade Assistant command line to upgrade a Oracle BI Enterprise Edition middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat -BIEE -rpdFile rpd_file -rpdAdminUser rpd_admin_user -webCatDir webcat_directory -webCatDeliveriesDir webcatdeliveries_directory -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose]
On UNIX systems:
ORACLE_HOME/bin/ua MT -BIEE -rpdFile rpd_file -rpdAdminUser rpd_admin_user -webCatDir webcat_directory -webCatDeliveriesDir webcatdeliveries_directory -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [[-invPtrLoc inventory_loc]
Refer to Table A-17 for a description of the command line arguments available when you are upgrading a middle tier.
Many of the command-line options represent the options available in the Upgrade Assistant graphical user interface. For more information, see "Oracle Business Intelligence Upgrade Assistant Screens" in the Oracle Fusion Middleware Upgrade Guide for Oracle Business Intelligence.
Table A-17 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading a Oracle BI Enterprise Edition Middle Tier
Argument | Description |
---|---|
-rpdfile rpd_file -rpdAdminUser rpd_admin_user |
Replace rpd_file with the name of the Oracle Business Intelligence 10g repository file. Replace rpd_admin_user with the name of the Administrator user, which is usually "Administrator." These arguments are required for middle-tier upgrades if you are upgrading the Oracle Business Intelligence 10g repository file to 11g. |
-webCatDir webcat_directory -webCatDeliveriesDir |
Replace webcat_directory with the full path to the Oracle Business Intelligence 10g Web catalog directory. Replace webcatdeliveries_directory with the path to the Web catalog These arguments are required for middle-tier upgrades if you are upgrading the Oracle Business Intelligence 10g Web catalog to 11g. |
wls_port wls_port wls_userName wls_user |
Use these arguments to provide the Oracle WebLogic Server port and the user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually These settings default to the values associated with the specified Oracle Fusion Middleware 11g Oracle instance. Note that you cannot specify the Oracle WebLogic Server host. That value defaults to the localhost and cannot be modified. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade a Oracle Business Intelligence Publisher middle tier, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat -BIP [-sourceReposDir source_repos | -sourceTemplateDir source_template] -destReposDir dest_repos -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose]
On UNIX systems:
ORACLE_HOME/bin/ua MT -BIP [-sourceReposDir source_repos | -sourceTemplateDir source_template] -destReposDir dest_repos -wlsHost wls_host -wlsPort wls_port -wlsUserName wls_user [-logLevel log_level] [-[no]verbose] [[-invPtrLoc inventory_loc] ...]
Refer to Table A-18 for a description of the command line arguments available when you are upgrading a middle tier.
Many of the command-line options represent the options available in the Upgrade Assistant graphical user interface. For more information, see "Oracle Business Intelligence Upgrade Assistant Screens" in the Oracle Fusion Middleware Upgrade Guide for Oracle Business Intelligence.
Table A-18 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading a Oracle Business Intelligence Publisher Middle Tier
Argument | Description |
---|---|
-sourceReposDir source_repos |
Replace source_repos with the Oracle BI Publisher 10g repository directory path. You must use this argument or the |
-sourceTemplateDir source_template |
Replace source_template with the Oracle E-Business Suite data template directory path. You must use this argument or the |
-destReposDir dest_repos |
Replace dest_repos with one of the following:
This is a required argument for middle-tier upgrades. |
wls_host wls_host wls_port wls_port wls_userName wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually These settings default to the values associated with the specified Oracle Fusion Middleware 11g Oracle instance. Note that these arguments are not required or supported when you are upgrading a Web tier Oracle home. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
-[no]verbose |
Use this argument to output detailed information to the screen when you are running the Upgrade Assistant in command-line mode. Use The default setting if you do not include this argument is |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |
To use the Upgrade Assistant command line to upgrade the Oracle BI Enterprise Edition Scheduler, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat BISCHEDULER -targetURL target_url -targetUserName target_user_name -dbtype db_type -dbConnectString db_connect_string -biUserName bi_user_name -dbaUserName dba_user_name -sourceUserName source_user_name
On UNIX systems:
ORACLE_HOME/bin/ua BISCHEDULER -targetURL target_url -targetUserName target_user_name -dbtype db_type -dbConnectString db_connect_string -biUserName bi_user_name -dbaUserName dba_user_name -sourceUserName source_user_name
Refer to Table A-19 for a description of the command line arguments available when you are upgrading the Oracle BI Enterprise Edition BISCHEDULER schema.
Table A-19 Summary of the Upgrade Assistant Command-Line Arguments When Upgrading the Oracle BI EE and Oracle BI Publisher Schema
Argument | Description |
---|---|
-targetURL target_url |
Replace target_url with the URL connect string for the target database that contains the 11g schema. For a complete description of the connect string required for each database types, see the description of the Connect String field in the section, "Target Database," in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. This is a required argument. |
-targetUserName target_user_name |
Replace target_user_name with the name of the Oracle Business Intelligence 11g schema in the target database. This schema name will be in the following form:
RCUPREFIX_BIPLATFORM
For example: DEV_BIPLATFORM This is a required argument. |
-dbType database_type |
Replace database_type with the database type of the source database that contains the 10g schemas. The type must one of the following:
The default (if you do not enter a value) is Oracle. Note: The database type for the source database must be the same as the database type for the target database. As a result, you need to specify the database type for the source database only. |
-dbConnectString |
Replace database_connect_string with the URL connect string for the source database that contains the 10g schema. For a complete description of the connect string required for each database types, see the description of the Connect String field in the section, "Target Database," in the Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator. This is a required argument. |
-biUserName bi_user_name |
Replace bi_user_name with the name of the Oracle Business Intelligence 10g schema in the source database. This is a required argument. |
-dbaUserName dba_user_name |
Replace dba_user_name with the database administrator user name that will be used to connect to the target database where the 11g schema resides:
This is a required argument. |
-sourceUserName source_user_name |
Replace source_user_name with the database administrator user name that will be used to connect to the source database where the 10g schema resides:
This is a required argument. |
-[no]ErrorMode -[no]CheckMode -[no]UpgradeMode |
See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades". |
To use the Upgrade Assistant command line to upgrade the Oracle BI Publisher Scheduler schema, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat BIPUBLISHER -targetURL target_url -targetUserName target_user_name -dbtype db_type -dbConnectString db_connect_string -biUserName bi_user_name -dbaUserName dba_user_name -sourceUserName source_user_name
On UNIX systems:
ORACLE_HOME/bin/ua BIPUBLISHER -targetURL target_url -targetUserName target_user_name -dbtype db_type -dbConnectString db_connect_string -biUserName bi_user_name -dbaUserName dba_user_name -sourceUserName source_user_name
Refer to Table A-19 for a description of the command line arguments available when you are upgrading the Oracle Business Intelligence Publisher Scheduler schema.
To use the Upgrade Assistant command line to verify an Oracle Fusion Middleware environment, enter the following command at the operating system prompt:
On Windows systems:
ORACLE_HOME\bin\ua.bat VERIFY -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user]
On UNIX systems:
ORACLE_HOME/bin/ua VERIFY -destInstanceHome ORACLE_INSTANCE [-logLevel log_level] [-wlsHost wls_host] [-wlsPort wls_port] [-wlsUserName wls_user] [-invPtrLoc inventory_location]
Refer to Table A-20 for a description of the command line arguments available when you are verifying an upgrade.
Table A-20 Summary of the Upgrade Assistant Command-Line Arguments When Verifying an Upgrade
Argument | Description |
---|---|
-destInstanceHome |
Replace ORACLE_INSTANCE with the full path to the newly installed Oracle Fusion Middleware 11g Oracle instance. |
-logLevel log_level |
Replace log_level with one of the following values:
The default setting if you do not provide this argument is NOTIFICATION. |
wls_host wls_host wls_port wls_port wls_user wls_user |
Use these arguments to provide the host, port, and user name of the Administration Server in the destination Oracle WebLogic Server domain. For example, the port and user name are usually |
-invPtrLoc inventory_location |
On UNIX systems, you can use this argument if you have multiple Oracle inventory files on the host. For more information, see Section B.7, "Starting the Upgrade Assistant on UNIX Systems When Using Multiple Oracle Universal Installer Inventory Locations". |