Actions on Oracle Linux

To migrate from the CentOS Virtual Appliance, follow the below preparatory steps in Oracle Linux Virtual Appliance:

1. Create admin migration user using the below commands:

    GRANT ALL PRIVILEGES ON *.* TO 'mig_admin'@'%' IDENTIFIED BY 'MIG_ADMIN' WITH GRANT OPTION;
    FLUSH PRIVILEGES;

2. Add the below entries in /etc/my.cnf to [mysqld] section and restart MariaDB server to apply the new settings:

    net_read_timeout=1000
    connect_timeout=1000
    On terminal: systemctl restart mariadb.service

3. Using the below command, try connecting to CentOS VA using mig_admin user from the new Oracle Linux VA:

    mysql –umig_admin –pMIG_ADMIN  -h<Centos VA IP> 

4. Using the below command, try connecting toOracle Linux from CentOS VA:

    mysql –umig_admin –pMIG_ADMIN  -h<Oraclelinex VA IP> 

   note

   Make sure both the servers can connect each other, if any issue found in MySQL connection then check /etc/mysql/my.cnf file and comment # bind-address 127.0.0.0 (or) change the bind address to 0.0.0.0.

5. Stop the services, using the below commands:

    systemctl stop sgdaemon.service 
    systemctl stop scandaemon.service
    systemctl stop haproxy.service

6. Drop the common and private databases (Oracle Linux VA) using the below commands:

    DROP DATABASE ca; 
    DROP DATABASE ca_; (Private database starts with ca_)

7. Drop the private db mysql users (which starts with customer id) using the below commands:

    DROP USER '<cust_id*>'@'localhost'
    FLUSH PRIVILEGES;