A Executing the SQL Server Upgrade Scripts

The Release 9.0.3 upgrade package includes command line scripts that will upgrade the SQL Server database and associated stored procedures for Oracle Identity Manager. These command line scripts execute a set of SQL Server scripts through the OSQL interface on the SQL Server database. The command line scripts support the following arguments:

Table A-1 Supported Arguments for the SQL Server Command Line Upgrade Scripts

Arguments	Description
<server-name[\instance-name]>	The name of the server under the ÒSQL Server GroupÓ in Enterprise Manager. \instance-name represents the instance running under the server.
<db-user>	The database user ID
<password>	The password of db-user
<db-name>	The name of the database
<script-location>	The absolute path to the command line script

For example:

• To upgrade the database, run <PATCH>\db\SQLServer\Scripts\upg_902_to_903.bat with the following command-line arguments:

  <PATCH>\db\SQLServer\Scripts\upg_902_to_903.bat <server-name[\instance-name]> <db-user> <password> db-name> <PATCH>\db\SQLServer\Scripts
  
  

• To compile the new stored procedures, run <PATCH>\db\SQLServer\StoredProcedures\compile_all_XL_SP.bat with the following command-line arguments:

  <PATCH>\db\SQLServer\StoredProcedures\compile_all_XL_SP.bat <server-name[\instance-name]> <db-user> <password> <db-name> <PATCH>\db\SQLServer\StoredProcedures
  
  

• To upgrade the Oracle Identity Manager Audit and Compliance module, run <PATCH>\db\SQLServer\Scripts\SQLServer_Enable_XACM.bat with the following command-line arguments:

  <PATCH>\db\SQLServer\Scripts\SQLServer_Enable_XACM.bat <server-name[\instance-name]> <db-user> <password> <db-name> <PATCH>\db\SQLServer\Scripts\