Tech Blogs on Oracle Database, Exadata, Oracle Database Appliance(ODA) Oracle Linux ,Solaris: June 2017

Tuesday 27 June 2017

Oracle Database Appliance (ODA X6-2 Small,Medium and Large) Cheat sheet

This document has all commands of Oracle Database Appliance (ODA X6-2 Small,Medium and Large)
For detailed information, pls refer to "Database Appliance X6-2S and X6-2M Deployment and User’s Guide"
https://docs.oracle.com/cd/E75549_01/doc.121/e76082/toc.htm

configure-firstnet
update-image --image-files file1,file2,file3
configure-cpucore -cores 4
configure-cpucore -cores ALL [-h]
odacli create-appliance -h
odacli describe-appliance
odacli list-databases
odacli describe-database -i dbid
odacli create-database -n test12 -m -cl OLTP -s odb1 -v 12.1.0.2
dacli delete-database -i my-database-ID
odacli list-dbhomes
odacli describe-dbhome -i dbhomeid
odacli create-dbhome -v 12.1.0.2
odacli list-networks
odacli describe-network -i id
odacli create-network -n sfpbond1 -p 192.0.2.15 -w Backup -s 255.255.255.0 -g 192.0.2.1
odacli list-jobs
odacli describe-job -i jobid
odaadmcli show disk
odaadmcli show disk pd_00
odaadmcli show diskgroup
odaadmcli show diskgroup DATA
odaadmcli show controller
odaadmcli show iraid
odaadmcli show raidsyncstatus
odaadmcli show storage
odaadmcli show storage -errors
odaadmcli stordiag pd_00
odaadmcli manage diagcollect --storage
odaadmcli power [on|off] n
odaadmcli show cooling
odaadmcli show env_hw
odaadmcli show fs
odaadmcli show memory
odaadmcli show network
odaadmcli show power
odaadmcli show processor
odaadmcli show server
odacli-adm set-credential --password --username oda-admin

Oracle Database Appliance Postinstallation Tasks ODA X6-2 Small,Medium and Large.

Following are the few things needs to consider after completing the initial deployment of ODA X6-2 Small,Medium and Large.

1.Changing the Oracle Installation Owner Passwords
the root, oracle, grid and database users SYS, SYSTEM and PDBADMIN are set to the master password. Change these passwords to comply with your enterprise user security protocols.

2.Changing the odacli-adm User Password
odacli-adm set-credential --password --username odacli-adm

3.Access Oracle Enterprise Manager Express
https://hostname:5500/em

Create database home on Oracle Database Appliance x6-2 Small,Medium and Large

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

Delete database on Oracle Database Appliance x6-2 Small,Medium and Large

This document describe step by step procedure to delete database in command line on Oracle Database Appliance x6-2 Small,Medium and Large .

1. list the databases to see the existing databases.

[root@oak ~]# odacli list-databases

ID DB Name DB Version CDB Class Shape Storage Status
---------------------------------------- ---------- -------------------- ---------- -------- -------- ---------- ----------
63079e59-9239-45ad-8eef-822179fa3ccc testdb 12.1.0.2 false OLTP odb1 ACFS Configured

2. Execute the delete database to delete the database. use ID from list databases output.

[root@oak ~]# odacli delete-database -i 63079e59-9239-45ad-8eef-822179fa3ccc
{
"jobId" : "985f1bb1-303d-47ae-b1c7-3802649f9e45",
"status" : "Running",
"message" : null,
"reports" : [ {
"taskId" : "TaskZJsonRpcExt_3600",
"taskName" : "Database Deletion",
"taskResult" : "Running",
"startTime" : "June 15, 2017 18:13:03 PM PHT",
"endTime" : "June 15, 2017 18:13:03 PM PHT",
"status" : "Running",
"taskDescription" : null,
"parentTaskId" : "TaskSequential_3595",
"jobId" : "985f1bb1-303d-47ae-b1c7-3802649f9e45",
"tags" : [ ],
"reportLevel" : "Info",
"updatedTime" : "June 15, 2017 18:13:03 PM PHT"
} ],
"createTimestamp" : "June 15, 2017 18:13:03 PM PHT",
"resourceList" : [ ],
"description" : "Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc",
"updatedTime" : "June 15, 2017 18:13:03 PM PHT"
}

3. Describe the job to see the deletion job status.

[root@oak ~]# odacli describe-job -i 985f1bb1-303d-47ae-b1c7-3802649f9e45

Job details
----------------------------------------------------------------
ID: 985f1bb1-303d-47ae-b1c7-3802649f9e45
Description: Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc
Status: Running
Created: June 15, 2017 6:13:03 PM PHT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database Deletion June 15, 2017 6:13:03 PM PHT June 15, 2017 6:13:03 PM PHT Running

4. Describe the job to see the deletion job status,if conpleted successfully.

[root@oak ~]# odacli describe-job -i 985f1bb1-303d-47ae-b1c7-3802649f9e45

Job details
----------------------------------------------------------------
ID: 985f1bb1-303d-47ae-b1c7-3802649f9e45
Description: Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc
Status: Success
Created: June 15, 2017 6:13:03 PM PHT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database Deletion June 15, 2017 6:13:03 PM PHT June 15, 2017 6:13:54 PM PHT Success
Unregister Db From Cluster June 15, 2017 6:13:54 PM PHT June 15, 2017 6:13:54 PM PHT Success
Kill Pmon Process June 15, 2017 6:13:54 PM PHT June 15, 2017 6:13:54 PM PHT Success
Database Files Deletion June 15, 2017 6:13:54 PM PHT June 15, 2017 6:13:55 PM PHT Success
Deleting Volume June 15, 2017 6:14:07 PM PHT June 15, 2017 6:14:09 PM PHT Success

5. List the databases again to verify the existing databases.

[root@oak ~]# odacli list-databases

Create database on Oracle Database Appliance x6-2 Small,Medium and Large

This document describe step by step procedure to create database in command line on Oracle Database Appliance x6-2 Small,Medium and Large .

1. Execute create database command to create new database.

[root@oak ~]# odacli create-database -n testdb -m -cl OLTP -s odb1 -v 12.1.0.2
Password for SYS,SYSTEM and PDB Admin:
{
"jobId" : "3f81ab69-19be-46b4-b2ff-f14aaf1bc709",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "June 15, 2017 18:00:18 PM PHT",
"resourceList" : [ ],
"description" : "Database service creation with db name: testdb",
"updatedTime" : "June 15, 2017 18:00:18 PM PHT"
}

2. Describe the job to see the status.

[root@oak ~]# odacli describe-job -i 3f81ab69-19be-46b4-b2ff-f14aaf1bc709

Job details
----------------------------------------------------------------
ID: 3f81ab69-19be-46b4-b2ff-f14aaf1bc709
Description: Database service creation with db name: testdb
Status: Running
Created: June 15, 2017 6:00:18 PM PHT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:00:18 PM PHT June 15, 2017 6:00:18 PM PHT Success
Creating volume dattestdb June 15, 2017 6:00:18 PM PHT June 15, 2017 6:00:28 PM PHT Success
Creating ACFS filesystem for DATA June 15, 2017 6:00:28 PM PHT June 15, 2017 6:00:34 PM PHT Success
Creating DbHome Directory June 15, 2017 6:00:34 PM PHT June 15, 2017 6:00:34 PM PHT Success
Extract DB clones June 15, 2017 6:00:34 PM PHT June 15, 2017 6:01:42 PM PHT Success
Clone Db home June 15, 2017 6:01:42 PM PHT June 15, 2017 6:02:39 PM PHT Success
Enable DB options June 15, 2017 6:02:39 PM PHT June 15, 2017 6:02:47 PM PHT Success
Run Root DB scripts June 15, 2017 6:02:47 PM PHT June 15, 2017 6:02:47 PM PHT Success
configuring Net Security June 15, 2017 6:03:00 PM PHT June 15, 2017 6:03:00 PM PHT Success
Database Service creation June 15, 2017 6:03:00 PM PHT June 15, 2017 6:03:00 PM PHT Running
Database Creation June 15, 2017 6:03:00 PM PHT June 15, 2017 6:03:00 PM PHT Running

3. list the databases to see the creation job status.

[root@oak ~]# odacli list-databases

ID DB Name DB Version CDB Class Shape Storage Status
---------------------------------------- ---------- -------------------- ---------- -------- -------- ---------- ----------
63079e59-9239-45ad-8eef-822179fa3ccc testdb 12.1.0.2.170117 false OLTP odb1 ACFS Creating

4. Again, Describe the job to see the successful status of all the steps.

[root@oak ~]# odacli describe-job -i 3f81ab69-19be-46b4-b2ff-f14aaf1bc709

Job details
----------------------------------------------------------------
ID: 3f81ab69-19be-46b4-b2ff-f14aaf1bc709
Description: Database service creation with db name: testdb
Status: Success
Created: June 15, 2017 6:00:18 PM PHT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance June 15, 2017 6:00:18 PM PHT June 15, 2017 6:00:18 PM PHT Success
Creating volume dattestdb June 15, 2017 6:00:18 PM PHT June 15, 2017 6:00:28 PM PHT Success
Creating ACFS filesystem for DATA June 15, 2017 6:00:28 PM PHT June 15, 2017 6:00:34 PM PHT Success
Creating DbHome Directory June 15, 2017 6:00:34 PM PHT June 15, 2017 6:00:34 PM PHT Success
Extract DB clones June 15, 2017 6:00:34 PM PHT June 15, 2017 6:01:42 PM PHT Success
Clone Db home June 15, 2017 6:01:42 PM PHT June 15, 2017 6:02:39 PM PHT Success
Enable DB options June 15, 2017 6:02:39 PM PHT June 15, 2017 6:02:47 PM PHT Success
Run Root DB scripts June 15, 2017 6:02:47 PM PHT June 15, 2017 6:02:47 PM PHT Success
configuring Net Security June 15, 2017 6:03:00 PM PHT June 15, 2017 6:03:00 PM PHT Success
Database Service creation June 15, 2017 6:03:00 PM PHT June 15, 2017 6:08:48 PM PHT Success
Database Creation June 15, 2017 6:03:00 PM PHT June 15, 2017 6:07:33 PM PHT Success
Running DataPatch June 15, 2017 6:08:27 PM PHT June 15, 2017 6:08:48 PM PHT Success
updating the Database version June 15, 2017 6:08:48 PM PHT June 15, 2017 6:08:48 PM PHT Success
create Users tablespace June 15, 2017 6:08:48 PM PHT June 15, 2017 6:08:50 PM PHT Success

5. List the database to verfiy the creation status.

[root@oak ~]# odacli list-databases

ID DB Name DB Version CDB Class Shape Storage Status
---------------------------------------- ---------- -------------------- ---------- -------- -------- ---------- ----------
63079e59-9239-45ad-8eef-822179fa3ccc testdb 12.1.0.2 false OLTP odb1 ACFS Configured

6. check the databbase process as Oracle user.

[oracle@oak dbvagent]$ ps -ef | grep pmon
grid 7127 1 0 09:49 ? 00:00:01 asm_pmon_+ASM1
oracle 46054 1 0 10:20 ? 00:00:00 ora_pmon_orcl12c
oracle 55026 1 0 18:08 ? 00:00:00 ora_pmon_testdb
oracle 60386 30420 0 18:09 pts/1 00:00:00 grep pmon
oracle 87635 1 0 10:29 ? 00:00:01 ora_pmon_orcl11g

7. Connect to the database.

[oracle@oak dbvagent]$ . oraenv
ORACLE_SID = [orcl12c] ? testdb
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oak dbvagent]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jun 15 18:09:48 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
TESTDB READ WRITE PRIMARY

Deploy the Oracle Database Appliance (ODA X6-2S,M,L) Small,Medium and Large (Part 2)

For complete procedure pls check the Deploy the Oracle Database Appliance (ODA X6-2S,M,L) Small,Medium and Large (Part 1)

In this part 2, we will continue the ODA deployment with web browser.

1. Goto web browser and enter IP-Address and port number and accept security certificate warning to proceed to login.

2. Login with username oda-admin and password.

3. Click on Create appliance to start the deployment.

4. Fill-up the System Information.

5. Fill-up the Network Information.

6. Select the User and Group and choose OS Role separation.

7. Fill-up Database Information to create the database during deployment.

8. Fill-up Information for ASR, to configure the ASR during deployment. then click on Submit.

9. Will prompt for confirmation after clicking on Submit. click on yes.

10 New window will popup with Job Status, click on provided link to see the progress.

11. below screen shots will show the progress of the deployment steps.keep monitoring till job is completed successfully.

12. Once deployment is completed, Click on Appliance to see the configuration info.

13. Click on Network tab, to see the network information.

14. Click on ASR tab, to see the ASR configuration info or to configure the ASR if not done yet.

15. Click on Database tab to see the installed database. Click on Specific database to see the detailed information of the database.
There is also create database tab to create new database.

16. Click on Database homes to see or to create the Database homes.

Deploy the Oracle Database Appliance (ODA X6-2S,M,L) Small,Medium and Large (Part 1)

This document describe step by step procedure to Deploy the Oracle Database Appliance (ODA X6-2S,M,L) Small,Medium and Large.

1. Log in to Oracle Database Appliance.
as root, using the password welcome1.

2. Download the Grid and RDBMS patches from MOS
Download the patch from Doc ID 2144642.1

3.Transfer the downloaded files to Oracle Database Appliance machine.
scp or winscp

4.Unzip the GRID Patches.

[root@oak u01]# unzip p23494985_1212100_Linux-x86-64_1of2.zip
Archive: p23494985_1212100_Linux-x86-64_1of2.zip
inflating: oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_1of2.zippart
[root@oak u01]# unzip p23494985_1212100_Linux-x86-64_2of2.zip
Archive: p23494985_1212100_Linux-x86-64_2of2.zip
inflating: oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_2of2.zippart

[root@oak u01]# ls -l
-rw-r--r-- 1 root root 2200000000 Feb 20 01:52 oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_1of2.zippart
-rw-r--r-- 1 root root 2190538165 Feb 20 02:17 oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_2of2.zippart

5. Concatenate GRID Files

[root@oak u01]# cat oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_1of2.zippart oda-sm-12.1.2.10.0-170205-GI-12.1.0.2_2of2.zippart> oda-sm-12.1.2.10.0-170205-GI-12.1.0.2.zip

[root@oak u01]# ls -l
-rw-r--r-- 1 root root 4390538165 Jun 18 19:11 oda-sm-12.1.2.10.0-170205-GI-12.1.0.2.zip

6. Unzip the RDBMS patch.

[root@oak u01]# unzip p23494992_1212100_Linux-x86-64.zip
Archive: p23494992_1212100_Linux-x86-64.zip
extracting: oda-sm-12.1.2.10.0-170205-DB-12.1.0.2.zip
inflating: README.txt
[root@oak u01]# ls -l
-rw-r--r-- 1 root root 3632802505 Feb 20 02:05 oda-sm-12.1.2.10.0-170205-DB-12.1.0.2.zip

7. Update Repository with GRID and RDBMS patches.

[root@oak bin]# ./odacli update-repository -f /u01/oda-sm-12.1.2.10.0-170205-GI-12.1.0.2.zip,/u01/oda-sm-12.1.2.10.0-170205-DB-12.1.0.2.zip
{
"jobId" : "82d0652e-efb9-423b-967d-05f7948947d5",
"status" : "Created",
"message" : "/u01/oda-sm-12.1.2.10.0-170205-GI-12.1.0.2.zip,/u01/oda-sm-12.1.2.10.0-170205-DB-12.1.0.2.zip",
"reports" : [ ],
"createTimestamp" : "June 18, 2017 19:13:38 PM PDT",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "June 18, 2017 19:13:38 PM PDT"
}

8. describe the job to check the status.

[root@oak bin]# ./odacli describe-job -i 82d0652e-efb9-423b-967d-05f7948947d5

Job details
----------------------------------------------------------------
ID: 82d0652e-efb9-423b-967d-05f7948947d5
Description: Repository Update
Status: Running
Created: June 18, 2017 7:13:38 PM PDT
Message: /u01/oda-sm-12.1.2.10.0-170205-GI-12.1.0.2.zip,/u01/oda-sm-12.1.2.10.0-170205-DB-12.1.0.2.zip

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip patch bundle June 18, 2017 7:13:38 PM PDT June 18, 2017 7:13:38 PM PDT Running

9. List the jobs to verify the status.

[root@oak bin]# ./odacli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
82d0652e-efb9-423b-967d-05f7948947d5 Repository Update June 18, 2017 7:13:38 PM PDT Success

10. Deploy the Oracle Database Appliance

After the images have been successfully updated, you are ready to deploy the Oracle Database Appliance.
Using the Chrome browser, type the following URL:

https://<ipaddress or hostname>:7093/mgmt/index.html
Username: oda-admin
Password (default): welcome1

Continue to part 2 ...

Patching/Upgrading Oracle Database Appliance (ODA) X6-2S,M,L (Small,Medium and Large)

This document describe the step by step procedure to Patching or Upgrading Oracle Database Appliance (ODA) X6-2S,M,L (Small,Medium and Large).

1. Log in to Oracle Database Appliance.
as root, using the password welcome1.

2. Plumb the Network (if this is fresh ODA installation)
configure-firstnet

3. Check Dsc-agent version.
[root@oak ~]# rpm -qa |grep dcs-agent
dcs-agent-12.1.2.8.0_LINUX.X64_160817.2-1.x86_64

3. Download latest patches from MOS
Download the patch from Doc ID 2144642.1

4.Transfer the downloaded files to Oracle Database Appliance machine.
scp or winscp

5. Unzip the Patch in a temporary location (/u01) in the Oracle Database Appliance X6-2. The unzipped file will have a name oda-sm-12.1.2.10.0-170213-server.zip

6.Update metadata repository

[root@oak bin]# ./odacli update-repository -f /u01/oda-sm-12.1.2.10.0-170213-server.zip
{
"jobId" : "d3dcf3b1-c333-4f16-a9bf-dd3492a717b8",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "June 16, 2017 02:17:15 AM PDT",
"description" : "Repository Update",
"updatedTime" : "June 16, 2017 02:17:15 AM PDT"
}

7. Check the job completion status.

[root@oak bin]# ./odacli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
d3dcf3b1-c333-4f16-a9bf-dd3492a717b8 Repository Update June 16, 2017 2:17:15 AM PDT Success

8. Update the dcs agent

[root@oak bin]# ./odacli update-dcsagent -v 12.1.2.10.0 ; sleep 120
{
"jobId" : "14326f0b-3828-493b-b476-0511a2d86624",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "June 16, 2017 02:18:44 AM PDT",
"description" : "DcsAgent patching",
"updatedTime" : "June 16, 2017 02:18:44 AM PDT"
}

9.Verifying the dcs-agent patch
[root@oak bin]# ./odacli describe-job -i 14326f0b-3828-493b-b476-0511a2d86624

Job details
----------------------------------------------------------------
ID: 14326f0b-3828-493b-b476-0511a2d86624
Description: DcsAgent patching
Status: Success
Created: June 16, 2017 2:18:44 AM PDT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
location validation June 16, 2017 2:18:44 AM PDT June 16, 2017 2:18:44 AM PDT Success
Apply patch June 16, 2017 2:18:44 AM PDT June 16, 2017 2:18:45 AM PDT Success

10.Check the job completion status.

[root@oak bin]# ./odacli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
d3dcf3b1-c333-4f16-a9bf-dd3492a717b8 Repository Update June 16, 2017 2:17:15 AM PDT Success
14326f0b-3828-493b-b476-0511a2d86624 DcsAgent patching June 16, 2017 2:18:44 AM PDT Success

11. Verify the DCS-Agent version.
[root@oak bin]# rpm -qa | grep dcs-agent
dcs-agent-12.1.2.10.0_LINUX.X64_170213-1.x86_64

12. Upgrade the Server.This steps will upgrade the various OS, Firmware, oda-hw-mgmt rpm and the Grid Infrastructure(GI).
The 12.1.2.10 patch bundle contains GI patch, dcs–agent and oda-hw-mgmt stack, ilom/Bios and os patches.
[root@oak bin]# ./odacli update-server -v 12.1.2.10.0
{
"jobId" : "876b78dc-2adb-4bd1-b997-e701eb678a29",
"status" : "Created",
"message" : "Success of Server Update may trigger reboot of node after 4-5 minutes. Please wait till node restart",
"reports" : [ ],
"createTimestamp" : "June 16, 2017 02:22:33 AM PDT",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "June 16, 2017 02:22:33 AM PDT"
}

13. Verifying the patching process.
[root@oak bin]# ./odacli describe-job -i 876b78dc-2adb-4bd1-b997-e701eb678a29

Job details
----------------------------------------------------------------
ID: 876b78dc-2adb-4bd1-b997-e701eb678a29
Description: Server Patching
Status: Success
Created: June 16, 2017 2:22:33 AM PDT
Message:

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcscontroller rpm verification June 16, 2017 2:22:33 AM PDT June 16, 2017 2:22:33 AM PDT Success
Patch location validation June 16, 2017 2:22:33 AM PDT June 16, 2017 2:22:33 AM PDT Success
dcs-controller upgrade June 16, 2017 2:22:34 AM PDT June 16, 2017 2:22:35 AM PDT Success
dcscli rpm verification June 16, 2017 2:22:35 AM PDT June 16, 2017 2:22:35 AM PDT Success
Patch location validation June 16, 2017 2:22:35 AM PDT June 16, 2017 2:22:35 AM PDT Success
dcs-cli upgrade June 16, 2017 2:22:35 AM PDT June 16, 2017 2:22:35 AM PDT Success
oak rpm verification June 16, 2017 2:22:35 AM PDT June 16, 2017 2:22:36 AM PDT Success
Patch location validation June 16, 2017 2:22:36 AM PDT June 16, 2017 2:22:36 AM PDT Success
oda-hw-mgmt upgrade June 16, 2017 2:22:36 AM PDT June 16, 2017 2:22:57 AM PDT Success
Creating repositories using yum June 16, 2017 2:22:57 AM PDT June 16, 2017 2:23:01 AM PDT Success
Applying OS Patches June 16, 2017 2:23:01 AM PDT June 16, 2017 2:26:47 AM PDT Success
Checking Ilom patch Version June 16, 2017 2:26:48 AM PDT June 16, 2017 2:26:50 AM PDT Success
Patch location validation June 16, 2017 2:26:50 AM PDT June 16, 2017 2:26:51 AM PDT Success
Apply Ilom patch June 16, 2017 2:26:53 AM PDT June 16, 2017 2:36:06 AM PDT Success
Copying Flash Bios to Temp location June 16, 2017 2:36:06 AM PDT June 16, 2017 2:36:06 AM PDT Success
Reboot Ilom June 16, 2017 2:36:06 AM PDT June 16, 2017 2:36:06 AM PDT Success

14. Check the job completion status.

[root@oak bin]# ./odacli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
d3dcf3b1-c333-4f16-a9bf-dd3492a717b8 Repository Update June 16, 2017 2:17:15 AM PDT Success
14326f0b-3828-493b-b476-0511a2d86624 DcsAgent patching June 16, 2017 2:18:44 AM PDT Success
876b78dc-2adb-4bd1-b997-e701eb678a29 Server Patching June 16, 2017 2:22:33 AM PDT Success

15.check status of all the components.

[root@oak~]# odacli describe-component
System Version
---------------
12.1.2.10.0

Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 12.1.2.10.0 up-to-date
GI 12.1.0.2.170117 up-to-date
DB 12.1.0.2.170117 up-to-date
ILOM 3.2.8.24.r114611 up-to-date
BIOS 38070000 up-to-date
OS 6.8 up-to-date

16.Log Files.All the patching related information is logged in the dcs-agent log file
/opt/oracle/dcs/log/dcs-agent.log.

Reference MOS notes:- 888888.1 , 2144642.1

Tuesday 6 June 2017

Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied. Oracle GoldenGate

I used credentialstore for credential encryption in GoldenGate, when i tried to login it thrown below error message.
The error message is self explanatory, there is issue with username and password.

Simply update the password for the GoldenGate user in Database.

Issue:-
GGSCI (abc) 4> dblogin useridalias ogg_user
ERROR: Unable to connect to database using user ogg_user@test. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.

Solution:-

1.Connect to the Database and update the password for the GoldenGate user.

[oracle@abc ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 7 13:30:36 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
SQL>
SQL> alter user ogg_user identified by oracle;

User altered.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

2. Connect to the GoldenGate and Update the Credentialstore with updated password and try login, it worked.

[oracle@abc ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (abc) 2> alter credentialstore add user ogg_user password oracle alias ogg

Credential store in ./dircrd/ altered.

GGSCI (abc) 3> dblogin useridalias ogg
Successfully logged into database.