This document describe step by step procedure to create database home in command line on Oracle Database Appliance x6-2 Small,Medium and Large .
1. List database homes.
[root@oak ~]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
df735368-8dfb-4a06-bdf0-f233e18891c7 OraDB12102_home2 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_2 Configured
c7cc94c2-6a10-429c-9ac8-71906bf3cf61 OraDB11204_home2 11.2.0.4.161018 (23054319, 24006111) /u01/app/oracle/product/11.2.0.4/dbhome_2 Configured
2. Execute create-dbhome with version
[root@oak ~]# odacli create-dbhome -v 12.1.0.2
{
"jobId" : "0fd43705-2b44-4cb5-8583-f66d8c15ef43",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "June 15, 2017 18:20:07 PM PHT",
"resourceList" : [ ],
"description" : "Database Home OraDB12102_home5 creation with version :12.1.0.2",
"updatedTime" : "June 15, 2017 18:20:07 PM PHT"
}
3. Describe the job to see the creation status.
[root@oak ~]# odacli describe-job -i 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Job details
----------------------------------------------------------------
ID: 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Description: Database Home OraDB12102_home5 creation with version :12.1.0.2
Status: Running
Created: June 15, 2017 6:20:07 PM PHT
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Creating DbHome Directory June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Extract DB clones June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Running
4. Describe the status to see the job compeletion.
[root@oak ~]# odacli describe-job -i 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Job details
----------------------------------------------------------------
ID: 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Description: Database Home OraDB12102_home5 creation with version :12.1.0.2
Status: Running
Created: June 15, 2017 6:20:07 PM PHT
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Creating DbHome Directory June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Extract DB clones June 15, 2017 6:20:07 PM PHT June 15, 2017 6:21:14 PM PHT Success
Clone Db home June 15, 2017 6:21:14 PM PHT June 15, 2017 6:22:11 PM PHT Success
Enable DB options June 15, 2017 6:22:11 PM PHT June 15, 2017 6:22:19 PM PHT Success
Run Root DB scripts June 15, 2017 6:22:19 PM PHT June 15, 2017 6:22:19 PM PHT Success
5. List the database homes again to see the newly created dbhome.
[root@oak ~]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
df735368-8dfb-4a06-bdf0-f233e18891c7 OraDB12102_home2 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_2 Configured
c7cc94c2-6a10-429c-9ac8-71906bf3cf61 OraDB11204_home2 11.2.0.4.161018 (23054319, 24006111) /u01/app/oracle/product/11.2.0.4/dbhome_2 Configured
0c7561f0-1131-46bf-9ac6-39eee4dac9d9 OraDB12102_home5 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_5 Configured
1. List database homes.
[root@oak ~]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
df735368-8dfb-4a06-bdf0-f233e18891c7 OraDB12102_home2 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_2 Configured
c7cc94c2-6a10-429c-9ac8-71906bf3cf61 OraDB11204_home2 11.2.0.4.161018 (23054319, 24006111) /u01/app/oracle/product/11.2.0.4/dbhome_2 Configured
2. Execute create-dbhome with version
[root@oak ~]# odacli create-dbhome -v 12.1.0.2
{
"jobId" : "0fd43705-2b44-4cb5-8583-f66d8c15ef43",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "June 15, 2017 18:20:07 PM PHT",
"resourceList" : [ ],
"description" : "Database Home OraDB12102_home5 creation with version :12.1.0.2",
"updatedTime" : "June 15, 2017 18:20:07 PM PHT"
}
3. Describe the job to see the creation status.
[root@oak ~]# odacli describe-job -i 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Job details
----------------------------------------------------------------
ID: 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Description: Database Home OraDB12102_home5 creation with version :12.1.0.2
Status: Running
Created: June 15, 2017 6:20:07 PM PHT
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Creating DbHome Directory June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Extract DB clones June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Running
4. Describe the status to see the job compeletion.
[root@oak ~]# odacli describe-job -i 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Job details
----------------------------------------------------------------
ID: 0fd43705-2b44-4cb5-8583-f66d8c15ef43
Description: Database Home OraDB12102_home5 creation with version :12.1.0.2
Status: Running
Created: June 15, 2017 6:20:07 PM PHT
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Creating DbHome Directory June 15, 2017 6:20:07 PM PHT June 15, 2017 6:20:07 PM PHT Success
Extract DB clones June 15, 2017 6:20:07 PM PHT June 15, 2017 6:21:14 PM PHT Success
Clone Db home June 15, 2017 6:21:14 PM PHT June 15, 2017 6:22:11 PM PHT Success
Enable DB options June 15, 2017 6:22:11 PM PHT June 15, 2017 6:22:19 PM PHT Success
Run Root DB scripts June 15, 2017 6:22:19 PM PHT June 15, 2017 6:22:19 PM PHT Success
5. List the database homes again to see the newly created dbhome.
[root@oak ~]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
df735368-8dfb-4a06-bdf0-f233e18891c7 OraDB12102_home2 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_2 Configured
c7cc94c2-6a10-429c-9ac8-71906bf3cf61 OraDB11204_home2 11.2.0.4.161018 (23054319, 24006111) /u01/app/oracle/product/11.2.0.4/dbhome_2 Configured
0c7561f0-1131-46bf-9ac6-39eee4dac9d9 OraDB12102_home5 12.1.0.2.170117 (25462196, 24732088) /u01/app/oracle/product/12.1.0.2/dbhome_5 Configured
No comments:
Post a Comment