Upgrading Oracle User Databases Manually

Use hds_oracle_upgradedb.sql to upgrade an Oracle user database manually or if the database upgrade with sysadmin upgrade failed.

1. Use the maintenance user login ID to connect to the user database.
   See the SAP Replication Server Options documentation to configure a connection to a non-SAP ASE database.
2. Locate the hds_oracle_upgradedb.sql in the scripts subdirectory of your SAP Replication Server installation directory.
3. Run the script to upgrade the user database.
4. Check the status of the upgrade with admin who.
   If you see "Awaiting Upgr", you must reset the connection to the database.
5. To reset the connection, log in to the RSSD and execute:

   set replication off
   go 
   set triggers off
   go 
   update rs_databases set dist_status = dist_status & ~hextoint("0x400") 
     where ltype=’P’ 
     and connid=xxxx 
   go 
   set replication on 
   go 
   set triggers on
   go

6. Restart SAP Replication Server.