Source Extractors - SQL PLSQL - Information - How to modify server name without generating added or deleted DB objects for the PL-SQL offline analyzer

With the PL/SQL offline analyzer (new), changing the server and/or instance from where the extraction is done leads to the change of all DB objects full name. As consequence, all DB objects will be seen as added/removed. To avoid this problem, please follow above steps before generating a new snapshot. If the new snapshot has been generated before doing these steps, you will need first to restore the KB, CB dumps corresponding to the first extraction

Steps to modify server and/or instance name without generating added/deleted DB objects

• For CAST versions 7.3.10 or greater, 8.0.3 or greater, 8.1.x, 8.2.x, and 8.3.x

  1. Use CAST-DatabaseExtractionRenamingTool.exe and CAST-DatabaseExtractionRenamingTool-CLI.exe available in the CAST Installation folder to assist in this task.

•  For CAST versions 7.2, 7.3.0-7.3.9 and 8.0.0-8.0.2

1. Edit the uax files of the 2nd extraction to keep the same Instance name:

1. In DatabaseExtraction.uaxdirectory
   ... < UAXFile path="<Prefix>.x.uax" name="X'Y'Z'" type="CAST_Oracle_Instance"> ...

2. In <Prefix>.x.uax
   < instance id="<Prefix>.x" instanceOf="CAST_Oracle_Instance">
       < CAST_SQL_Object version="x.y.z.t.u"/>
       < CAST_SQL_Area DBMSType="ORACLE"/>
       < CAST_Resolution_Identification resolutionName="X'Y'Z'"/>
       < CAST_Machine hostName="YXZ"/>
   < /instance> ... 

   where:

   <Prefix> may be p_Instance or I, depending of the exact release of the extractor

   x may be any valid integer (1, 2, ...)

   XYZ is the previous server name

   X'Y'Z'  is the previous instance name

2. Redo the pakage on the new extraction directory (the one modified) on the DMT. Deliver the version

3. Set the new version as the current one in CAST-MS

4. Generate the new snapshot (with analysis)

• For CAST Version 7.0.x Version

1. Edit the uax files of the 2nd extraction  to keep the same Server/Instance name:

   1. In DatabaseExtraction.uaxdirectory
      ... < UAXFile path="p_Server.x.uax" name="XYZ" type="CAST_SQL_Machine">
          < UAXFile path="p_Instance.x.uax" name="X'Y'Z'" type="CAST_SQL_Instance"> ...

   2. In p_Server.x.uax

      < instance id="p_Server.x" instanceOf="CAST_SQL_Machine">
          < CAST_Resolution_Identification resolutionName="YXZ"/>
      < /instance> ...

   3. In p_Instance.x.uax

      < instance id="p_Instance.x" instanceOf="CAST_SQL_Instance">
          < CAST_SQL_Object version="x.y.z.t.u"/>
          < CAST_SQL_Area DBMSType="ORACLE"/>
          < CAST_Resolution_Identification resolutionName="X'Y'Z'"/>
          < CAST_Symbol_WithParent parent="p_Server.x"/>
      < /instance> ...

      where:

      x may be any valid integer (1, 2, ...)

      XYZ is the previous server name

      X'Y'Z'  is the previous instance name

2.  Redo the discover on the new extraction directory (the one modified) 

3. Generate the new snapshot (with analysis)