Note:
For a standby database, open the standby database in
READ ONLY
mode
before executing the
odacli register-database
command.
Follow these steps to register a database:
1.
If you have Oracle Database version 12.1 with SQL patches, ensure that the
sqlpatches
are in the Oracle Database Appliance environment. If the patches are
not in the environment, copy the
$OH/sqlpatch
directories from the source
database home to the
$OH
in Oracle Database Appliance before executing the
odacli register-database
command
The
odacli register-database
command invokes the
datapatch
utility for
applying the post patch SQLs. If the source database has any
sqlpatches
applied
that are not present in the Oracle Database Appliance environment, then the
datapatch
will fail.
2.
If you have Oracle Database version 11.2 with SQL patches, you must roll back
any patches applied to the source database that are not part of the installed
Oracle Database Bundle patch (BP).
3.
Register the database with Oracle Database Appliance.
odacli register-database -c OLTP -s odb1 -sn proddb.example.com -p
Password for SYS:
{
"jobId" : "317b430f-ad5f-42ae-bb07-13f053d266e2",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "August 08, 2018 05:55:49 AM EDT",
"description" : "Database service registration with
db service name: proddb.example.com",
"updatedTime" : "August 08, 2018 05:55:49 AM EDT"
}
rpandrap: ]# odacli describe-job -i "317b430f-ad5f-42ae-
bb07-13f053d266e2"
Job details
----------------------------------------------------------------
ID: 317b430f-ad5f-42ae-bb07-13f053d266e2
Description: Database service registration with
db service name: proddb.example.com
Status: Success
Created: November 23, 2018 5:55:49 AM EDT
Message:
Task Name Start Time
----------------------------- ------------------------------
restore control file November 23, 2018 5:55:49 AM EDT
move spfile to right location November 23, 2018 5:56:08 AM EDT
register DB with clusterware November 23, 2018 5:56:13 AM EDT
reset db parameters November 23, 2018 5:57:05 AM EDT
Chapter 9
Migrating Databases
9-17
Summary of Contents for Database Appliance X6-2-HA
Page 15: ...Index xv...
