White Paper

Oracle Database Migration to Dell PowerEdge 12
th
Generation Servers and Dell Compellent Storage
Systems
18
FRA2
FRA3
FRA4
FRA5
FRA6
FRA7
FRA8
FRA9
Starting Up Database on the Target System
The preparation steps described in the previous two sections Preparing the target system and
Presenting Dell|EMC volumes to the target database servers do not impact the source database
availability. All steps are performed while the source database is up and running. At this point, the
target database is ready to be brought up.
1. Shut down the source database instances and ASM instances.
2. Start up the ASM instances on the target database servers. The ASM disk groups from the source
database should be automatically mounted upon the ASM instance startup.
SQL> select name, state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
FRA MOUNTED
3. Start up the database instances on both target database servers using SQL Plus. For example,
SQL> startup;
Quick Application Switch Over to the Target Database
Database applications connect to databases by specifying a database connection string in the
tnsnames.ora file of the Oracle client. After the database is brought up on the target servers, one
can manually update the connection string in the tnsnames.ora file to reflect the target system
information. For example, the connect string to the source database is:
MIGRTST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w21-2950-m-top-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = w21-2950-m-bot-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = migrtst)
)
)
After database is brought on the target servers, the connect string should be updated to: