A Using the Upgrade Assistant Command-Line Interface

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:

A.1 Invoking the Graphical User Interface

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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".


A.2 Getting Help on the Upgrade Assistant Command-Line Options

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
    

A.3 Using the Upgrade Assistant Command Line to Upgrade a Middle Tier

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
SOURCE_ORACLE_HOME

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
ORACLE_INSTANCE

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

-[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 -nosilent. The Upgrade Assistant will prompt only for passwords.

-[no]retainPorts

Select this option to retain the port numbers used by the source middle tiers.

The default setting is -retainPorts.

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 -stopComponents.

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 -retainPorts command-line argument.

-[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 -nostartComponents argument.

The default setting is -startComponents.

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 7001 and weblogic, respectively.

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".


A.4 Using the Upgrade Assistant Command Line to Upgrade the Oracle SOA Suite Schemas

The following sections describe how to use the Upgrade Assistant command line to upgrade the Oracle SOA Suite schemas:

A.4.1 Using the Command Line to Upgrade the Oracle B2B Schema

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:

  • The target database is the database base where the Oracle B2B 11g schema resides.

  • The connection string identifes the host, port, and system identifier (SID) of the target database:

    host:port:SID
    

    For example:

    dbhost2:1521:schemaDB2
    

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, SYS.

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 noErrorMode.

-[no]CheckMode

Use this argument to control whether or not the Upgrade Assistant performs the examination phase of the upgrade.

The default is CheckMode.

-[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 UpgradeMode.


A.4.2 Using the Command Line to Upgrade the Oracle Business Activity Monitoring Schema

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:

  • The target database is the database base where the Oracle B2B 11g schema resides.

  • The connection string identifes the host, port, and system identifier (SID) of the target database:

    host:port:SID
    

    For example:

    dbhost2:1521:schemaDB2
    

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, SYS.

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, 1521). This is the database that contains the Oracle BAM 10g schema.

This is a required argument.

-dbServiceName
source_db_service_name

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
source_bam_schema_name

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".


A.5 Using the Upgrade Assistant Command Line to Upgrade the Oracle Portal and Oracle BI Discoverer Schemas

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 argument if you are upgrading both the Oracle Portal and Oracle Business Intelligence Discoverer schema at the same time.

-discoverer

Use this argument when you are upgrading the Oracle Business Intelligence Discoverer schema.

You can use it alone, or with the -portal argument, if you are upgrading both the Oracle Portal and Oracle Business Intelligence Discoverer schema at the same time.

-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".


A.6 Using the Upgrade Assistant Command Line to Upgrade Oracle Identity Management

The following sections describe how to use the Upgrade Assistant command-line interface to upgrade your Oracle Identity Management components:

A.6.1 Oracle Internet Directory and Oracle Directory Integration Platform Upgrade Assistant Commmand-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
SOURCE_ORACLE_HOME

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
ORACLE_INSTANCE

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

-[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 -nosilent.

-[no]retainPorts

Select this option to retain the port numbers used by the 10g source Oracle home.

The default setting is -retainPorts.

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 -nostartComponents argument.

The default setting is -startComponents.

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 7001 and weblogic, respectively.

-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".


A.6.2 Oracle Access Manager Upgrade Assistant Command-Line Arguments

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 policy.properties file.

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 policy.properties file to a temporary directory on the Oracle Access Manager 11g host. Then specify the path of the policy.properties file located in your temporary folder.

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 7001 and weblogic, respectively.

[-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 -noOamAllowExternal.

-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".


A.6.3 Oracle Adaptive Access Manager Middle-Tier Upgrade Assistant Command-Line Arguments

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:

  • Microsoft

  • Oracle

This is a required argument.

-dbConnectString
db_connect_string

Replace db_connect_string with the database connect string.

  • For an Oracle database, use the host:port:SID connection string format.

  • For a Microsoft database, use the following:

    //host:port:DatabaseName=database_name
    

This is a required argument.

-oaam_UserName
oaam_schema_user_name

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 7001 and weblogic, respectively.

[-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".


A.6.4 Oracle Adaptive Access Manager Schema Upgrade Assistant Command-Line Arguments

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:

  • Microsoft

  • Oracle

This is a required argument.

-dbConnectString
database_connect_string

Replace database_connect_string with the database connect string.

  • For an Oracle database, use the host:port:SID connection string format.

  • For a Microsoft database, use the following:

    //host:port:DatabaseName=database_name
    

This is a required argument.

-oaam_UserName
oaam_schema_user_name

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".


A.7 Using the Upgrade Assistant Command Line to Upgrade Oracle WebCenter Content

The following sections describe how to upgrade the Oracle WebCenter Content components using the Upgrade Assistant command-line interface:

A.7.1 Oracle WebCenter Content Middle-Tier 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
10g_bindir_directory

Replace 10g_bindir_directory with the full path to the WebCenter Content 10g binDir directory.

This is a required argument.

-intradocDir
11g_intradocDir_directory

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 IntradocDir variable in the Oracle Content Server instance.

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 DomainHome/ucm/short-product-id.

This is a required argument.

-logLevel log_level

Replace log_level with one of the following values:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

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 7001 and weblogic, respectively.

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".


A.7.2 Oracle WebCenter Content: Records Middle-Tier Upgrade Assistant Command-Line Arguments

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
10g_bindir_directory

Replace 10g_bindir_directory with the full path to the Records 10g binDir directory.

This is a required argument.

-intradocDir
11g_intradocDir_directory

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 IntradocDir variable in the Oracle Content Server instance.

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 DomainHome/ucm/short-product-id.

This is a required argument.

-logLevel log_level

Replace log_level with one of the following values:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

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 7001 and weblogic, respectively.

-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".


A.7.3 WebCenter Content Schema Upgrade Assistant Command-Line Arguments

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
database_type

Replace database_type with one of the following:

  • Oracle

  • Microsoft

  • IBM

The default (if you do not enter a value) is Oracle.

-dbConnectString
database_connect_string

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:

  • host:port:sid
    

    OR

  • //host:port/service_name
    

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
database_admin_user

Replace database_admin_user with the database administrator user name of the 10g database:

  • For Oracle databases, use the SYS user or a user with the DBA role.

  • For Microsoft SQL Server, enter sa or a user with db_owner role.

  • For IBM DB2, enter db2admin.

This is a required argument.

-ucmUserName
Oracle_UCM_user

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".


A.7.4 Records Schema Upgrade Assistant Command-Line Arguments

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
database_type

Replace database_type with one of the following:

  • Oracle

  • Microsoft

  • IBM

The default (if you do not enter a value) is Oracle.

-dbConnectString
database_connect_string

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:

  • host:port:sid
    

    OR

  • //host:port/service_name
    

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
database_admin_user

Replace database_admin_user with the database administrator user name of the 10g database.

  • For Oracle databases, use the SYS user or a user with the DBA role.

  • For Microsoft SQL Server, enter sa or a user with db_owner role.

  • For IBM DB2, enter db2admin.

This is a required argument.

-urmUserName
Oracle_URM_user

Replace Oracle_URM_user with the the name of the Records database user.

This is a required argument.

-sourceHome
10g_oracle_home

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".


A.8 Using the Upgrade Assistant Command Line to Upgrade Oracle Data Integrator

The following sections describe how to upgrade the Oracle Data Integrator components using the Upgrade Assistant command-line interface:

A.8.1 Oracle Data Integrator Middle-Tier 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
10g_ODI_Oracle_home

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

-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".


A.8.2 Oracle Data Integrator Schema Upgrade Assistant Command-Line Arguments

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
database_type

Replace database_type with one of the following:

  • Oracle

  • Microsoft

  • IBM

  • Postgres

  • Sybase

  • Hypersonic

The default (if you do not enter a value) is Oracle.

-dbConnectString
database_connect_string

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
database_admin_user

Replace database_admin_user with the database administrator user name that will be used to connect to the database:

  • For Oracle databases, use the SYS user or a user with the DBA role.

  • For Microsoft SQL Server, enter sa or a user with db_owner role.

  • For IBM DB2, enter db2admin.

This is a required argument.

-odiMasterUserName
ODI_master_user_name

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
ODI_supervisor_name

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
ODI_work_repository_list

Replace ODI_work_repository_list with a comma-separated list of one or more ODI work repository names.

-odiWorkrepUserName
ODI_work_repository_user_name_list

Replace ODI_work_repository_user_name_list with a comma-separated list of the user names associated with each work repository listed in the -odiWorkrep argument.

[-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 -cloneOption.

[-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 -kmOption.

[-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 -topologyOption.

-[no]ErrorMode

-[no]CheckMode

-[no]UpgradeMode

See Table A-4, "Upgrade Assistant Command-Line Arguments Common to All Schema Upgrades".


A.9 Using the Upgrade Assistant Command Line to Upgrade Oracle Business Intelligence

The following sections describe how to use the Upgrade Assistant command-line interface to upgrade Oracle BI Enterprise Edition and Oracle Business Intelligence Publisher:

A.9.1 Oracle BI Enterprise Edition Middle Tier 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
webcatdeliveries_directory

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 deliveries directory.

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 7001 and weblogic, respectively.

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

-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".


A.9.2 Oracle Business Intelligence Publisher Middle Tier Upgrade Assistant Command-Line Arguments

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 argument, but you cannot provide both.

-sourceTemplateDir source_template

Replace source_template with the Oracle E-Business Suite data template directory path.

You must use this argument or the -sourceReposDir argument, but you cannot provide both.

-destReposDir dest_repos

Replace dest_repos with one of the following:

  • If you are upgrading the templates in an Oracle BI Publisher repository directory, then enter the full path to the Oracle BI Publisher 11g repository directory.

  • If you are upgrading the templates in an Oracle E-Business Suite data template directory, then enter the path to the Oracle BI Publisher 11g data model directory.

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 7001 and weblogic, respectively.

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 -noverbose to limit the amount of detail displayed on the screen.

The default setting if you do not include this argument is -noverbose.

-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".


A.9.3 Oracle Business Intelligence Scheduler Schema Upgrade Assistant Command-Line Arguments

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:

  • Oracle

  • Microsoft

  • IBM

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
database_connect_string

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:

  • For Oracle databases, use the SYS user or a user with the DBA role.

  • For Microsoft SQL Server, enter sa or a user with db_owner role.

  • For IBM DB2, enter db2admin.

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:

  • For Oracle databases, use the SYS user or a user with the DBA role.

  • For Microsoft SQL Server, enter sa or a user with db_owner role.

  • For IBM DB2, enter db2admin.

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".


A.9.4 Oracle BI Publisher Scheduler Schema Upgrade Assistant Command-Line Arguments

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.

A.10 Using the Upgrade Assistant Command Line to Verify an Upgraded Environment

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
ORACLE_INSTANCE

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:

  • NOTIFICATION

  • WARNING

  • ERROR

  • INCIDENT_ERROR

  • TRACE

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 7001 and weblogic, respectively.

-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".