Migrate the internal database to Oracle database using migration tool. Define two new Oracle database users before using the migration tool to migrate. The resulting user names and passwords are required to complete the process. Both users should have the permissions: resource and connect. Only the first user is used by the Database Security server; the second user is used for backup during upgrade scenarios.
Make sure that you have administrator rights to run the migration tool.
The Database Security server must be stopped before you try to set up the external database.
Start the migration tool in one of these ways:
On a Windows system, open a command prompt, then go to the bin directory under the root install directory.
For example,
C:\Program Files\McAfee\Trellix Database Security\binThen, run the bat file, migration_tool.bat.
On a Linux system, run:
/etc/init.d/mfe-dbs-server db-migrate
Select an action, type
migrate.Select the database type, type
oracle.Type the user name and password for the first Oracle user.
Type the user name and password for the second Oracle user.
Type the IP address or host name of the server where the database is located.
Type the number of the Oracle listening port, for example, 1521.
Type the database instance SID.
After the process is completed, a message is displayed indicating the duration of the process and whether the process is completed successfully.
When the process completes successfully, the server-custom.properties file is changed to contain properties for enabling Database Security to connect to the external database.
The server-custom.properties file is located in the following location:
<installation directory>/conf
Note
If the process fails, examine and verify that the properties listed on the screen are correct. For further assistance, contact support with the process output.