//
you're reading...
Oracle Database Appliance

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 2

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.**

Oracle Database Appliance Deployment (Virtualized Platform) section 2

Before going futher, read this (From ODA Application Manager release note)

X5-2 does NOT support database versions 11.2.0.3.x (except 11.2.0.3.15 ACFS DB created from ODA 12.1.2.4 onwards) and 11.2.0.2.x. Only 11.2.0.3.15 (with ODA 12.1.2.4 onwards), 11.2.0.4.x and 12.1.0.2.x databases are supported must run on ACFS.

Reason: X5-2 contains 4TB disks which exceed the 11.2 ASM disk size limit of 2TB. Running 11.2 databases on ASM will lead to data corruption, regardless of the OAK version. While OAK 12.1.2.3 will prevent creation of unsupported databases, OAK 12.1.2.2 did not. If you have created any unsupported 11.2.0.2.x or 11.2.0.3.x ASM DBs on X5-2, you must immediately upgrade to 11.2.0.3.15, 11.2.0.4.x or 12.1.0.2.x and manually migrate from ASM to ACFS.

For X5-2, if the deployment started with 12.1.2.2, or running

asmcmd lsattr -lm | egrep "Name|compatible"

showing non “12.1.0.2” output, please immediately modify the compatible attribute to “12.1.0.2”. Please run the followings for all DATA, RECO, REDO and FLASH diskgroups.

alter diskgroup  set attribute 'compatible.asm'='12.1.0.2'; 
alter diskgroup  set attribute 'compatible.advm'='12.1.0.2';
alter diskgroup  set attribute 'compatible.rdbms'='12.1.0.2';

Check your ODA patch level

Check your ODA patch level, the latest patch released so far is 12.1.2.5.0.

[root@testodbanode01 12.1.0.2.5]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version
--------------  ---------------           ------------------        -----------------
12.1.2.5.0
                Controller_INT            4.230.40-3739             Up-to-date
                Controller_EXT            06.00.02.00               Up-to-date
                Expander                  0018                      Up-to-date
                SSD_SHARED {
                [ c1d20,c1d21,c1d22,      A29A                      Up-to-date
                c1d23 ]
                [ c1d16,c1d17,c1d18,      A29A                      Up-to-date
                c1d19 ]
                             }
                HDD_LOCAL                 A720                      Up-to-date
                HDD_SHARED                P554                      Up-to-date
                ILOM                      3.2.4.52 r101649          Up-to-date
                BIOS                      30050100                  Up-to-date
                IPMI                      1.8.12.0                  Up-to-date
                HMP                       2.3.2.4.1                 Up-to-date
                OAK                       12.1.2.5.0                Up-to-date
                OL                        5.11                      Up-to-date
                OVM                       3.2.9                     Up-to-date
                GI_HOME                   12.1.0.2.5(21359755,      Up-to-date
                                          21359758)
                DB_HOME {
                [ OraDb11204_home1 ]      11.2.0.4.8(21352635,      Up-to-date
                                          21352649)
                [ OraDb12102_home1 ]      12.1.0.2.5(21359755,      Up-to-date
                                          21359758)
                             }                            }
Component Name X5-2 Hardware
Controller_INT 4.230.40-3739
Controller_Ext 04.00.00.00
Expander 0018
SSD_SHARED A29A
HDD_LOCAL A720
HDD_SHARED A2D2
ILOM 3.2.4.52 r101649
BIOS 30050100
IPMI 1.8.12.0
HMP 2.3.2.4.1
OAK 12.1.2.5.0
ORACLE LINUX 5.11
Kernel 2.6.39-400.264.1.el5uek
OVS 3.2.9
Dom0 Kernel 2.6.39-400.264.1.el5uek
GI_HOME 12.1.0.2.5
DB_HOME 12.1.0.2.5
ASR 5.3.0

Create Oracle Database Home on oda_base

Oracle Database Appliance (12.1.2.5.0) Software image Linux X86 64bit (11.2.0.4.8 RDBMS PSU 8)

Download the software bundle for Oracle Database Appliance.

p17770873_121250_Linux-x86-64.zip

The p17770873_121250_Linux-x86-64.zip contains the Oracle Database software images for Oracle Database Appliance. Download this file and transfer these files to Oracle Database Appliance nodes, you must configure the public network interface on Oracle Database Appliance nodes.

This file is for creating a new database home running 11.2.0.4.8.

Unpack this patch bundle p17770873_121250_Linux-x86-64.zip using the following oakcli command on first node as root user.

cd /opt/oracle/oak/bin
./oakcli unpack -package   p17770873_121250_Linux-x86-64.zip;

After that, you can

[root@testodanode01 ~]# cd /opt/oracle/oak/bin
[root@testodanode01 ~]# oakcli create dbhome -version 11.2.0.4.8
INFO: 2016-04-12 14:23:44: Please check the logfile ‘/opt/oracle/oak/log/testodanode01/tools/12.1.2.5.0/createdbhome_16332.log’ for more details

Please enter the 'SYSASM'  password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
INFO: 2016-04-12 14:23:56: Installing a new home: OraDb11204_home2 at /u01/app/oracle/product/11.2.0.4/dbhome_2
INFO   : Logging all actions in /opt/oracle/oak/log/testodanode01/patch/12.1.2.5.0/testodanode01-20160412142401.log and traces in /opt/oracle/oak/log/testodanode01/patch/12.1.2.5.0/testodanode01-20160412142401.trc
INFO   : Loading configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO   : Creating nodelist files...
INFO   : Setting up ssh for root...
INFO   : Setting up ssh across the private network...
...INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.27 /root/DoAllcmds.sh
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
INFO   : Background process 19226 (node: 192.168.16.27) gets done with the exit code 0
INFO   : Background process 19247 (node: 192.168.16.28) gets done with the exit code 0
INFO   : Done setting up ssh
INFO   : Running /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory on node 
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
...INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /root/DoAllcmds.sh
INFO   : Background process 20717 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /root/DoAllcmds.sh
INFO   : Background process 20740 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142443.sh
INFO   : Background process 20791 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142443.sh
INFO   : Background process 20814 (node: testodanode02) gets done with the exit code 0
INFO   : setting up ssh for user oracle...
...INFO   : checking nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO   : checking SSH setup for user (oracle) on nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
INFO   : did not do scp for node: testodanode01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142502.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142502.sh
INFO   : Background process 21984 (node: testodanode01) gets done with the exit code 0
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142502.sh
INFO   : Background process 22008 (node: testodanode02) gets done with the exit code 0
INFO   : Creating DB homes on nodes testodanode01 testodanode02....
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142503.sh
INFO   : Background process 22043 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142503.sh
INFO   : Background process 22067 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142503.sh
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142503.sh
INFO   : Background process 22121 (node: testodanode01) gets done with the exit code 0
INFO   : Background process 22142 (node: testodanode02) gets done with the exit code 0
INFO   : Running /usr/bin/scp /opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.8/Base/db112.tar.gz root@192.168.16.28:/opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.8/Base/db112.tar.gz to copy DB clone to the other node...
SUCCESS: Ran /usr/bin/scp /opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.8/Base/db112.tar.gz root@192.168.16.28:/opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.8/Base/db112.tar.gz and it returned: RC=0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142536.sh
INFO   : Background process 24459 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142536.sh
INFO   : Background process 24480 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142536.sh
INFO   : Background process 24531 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142536.sh
INFO   : Background process 24554 (node: testodanode02) gets done with the exit code 0
INFO   : Restoring the copy of DB home on all nodes...
INFO   : did not do scp for node: testodanode01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142537.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142537.sh
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142537.sh
INFO   : Background process 24612 (node: testodanode01) gets done with the exit code 0
INFO   : Background process 24645 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142627.sh
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412142627.sh
INFO   : Background process 27899 (node: testodanode01) gets done with the exit code 0
INFO   : Background process 27925 (node: testodanode02) gets done with the exit code 0
INFO   : Cloning and relinking RAC home
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/fuser_mv.sh
INFO   : Background process 27987 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/fuser_mv.sh
INFO   : Background process 28011 (node: testodanode02) gets done with the exit code 0
INFO   : Running clone.pl on RAC home. Look at /opt/oracle/oak/onecmd/tmp/racclonepl.sh-20160412142401-log for more details
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/racclonepl.sh
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/racclonepl.sh

Create Oracle RAC Database

1) Create the db configuration file

[root@testodanode01 11.2.0.4]# oakcli create db_config_params -conf testdb.ora
Please select one of the following for Database Block Size  [1 .. 4] :
1    => 4096
2    => 8192
3    => 16384
4    => 32768
2
The selected value is : 8192

Specify the  Database Language (1. AMERICAN 2. Others) [1] : 2
Please select one of the following for Database Language [0 .. 10] :
0    => Others
1    => ALBANIAN
2    => AMERICAN
3    => VIETNAMESE
4    => ARABIC
5    => ASSAMESE
6    => AZERBAIJANI
7    => BANGLA
8    => BELARUSIAN
9    => BRAZILIAN PORTUGUESE
10   => BULGARIAN
0

Please select one of the following for Database Language  [0 .. 21] :
11    => CANADIAN FRENCH
12    => CATALAN
13    => CROATIAN
14    => CYRILLIC KAZAKH
15    => CYRILLIC SERBIAN
16    => CYRILLIC UZBEK
17    => CZECH
18    => DANISH
19    => DUTCH
20    => EGYPTIAN
21    => ENGLISH
21
The selected value is : ENGLISH

Specify the  Database Characterset (1. AL32UTF8 2. Others) [1] : 2

Please select one of the following for Database Characterset [0 .. 10] :
0    => Others
1    => AL32UTF8
2    => AR8ADOS710
3    => AR8ADOS720
4    => AR8APTEC715
5    => AR8APTEC715T
6    => AR8ARABICMACS
7    => AR8ASMO8X
8    => AR8HPARABIC8T
9    => AR8ISO8859P6
10   => AR8MSWIN1256
0

Please select one of the following for Database Characterset  [0 .. 21] :
11    => AR8MUSSAD768
12    => AR8MUSSAD768T
13    => AR8NAFITHA711
14    => AR8NAFITHA711T
15    => AR8NAFITHA721
16    => AR8NAFITHA721T
17    => AR8SAKHR706
18    => AR8SAKHR707
19    => AR8SAKHR707T
20    => AZ8ISO8859P9E
21    => BG8MSWIN


Please select one of the following for Database Characterset  [0 .. 32] :
22    => BG8PC437S
23    => BLT8CP921
24    => BLT8ISO8859P13
25    => BLT8MSWIN1257
26    => BLT8PC775
27    => BN8BSCII
28    => CDN8PC863
29    => CEL8ISO8859P14
30    => CL8ISO8859P5
31    => CL8ISOIR111
32    => CL8KOI8R


Please select one of the following for Database Characterset  [0 .. 43] :
33    => CL8KOI8U
34    => CL8MACCYRILLICS
35    => CL8MSWIN1251
36    => EE8ISO8859P2
37    => EE8MACCES
38    => EE8MACCROATIANS
39    => EE8MSWIN1250
40    => EE8PC852
41    => EL8DEC
42    => EL8ISO8859P7
43    => EL8MACGREEKS


Please select one of the following for Database Characterset  [0 .. 54] :
44    => EL8MSWIN1253
45    => EL8PC437S
46    => EL8PC851
47    => EL8PC869
48    => ET8MSWIN923
49    => HU8ABMOD
50    => HU8CWI2
51    => IN8ISCII
52    => IS8PC861
53    => IW8ISO8859P8
54    => IW8MACHEBREWS


Please select one of the following for Database Characterset  [0 .. 65] :
55    => IW8MSWIN1255
56    => IW8PC1507
57    => JA16EUC
58    => JA16EUCTILDE
59    => JA16SJIS
60    => JA16SJISTILDE
61    => JA16VMS
62    => KO16KSC5601
63    => KO16KSCCS
64    => KO16MSWIN949
65    => LA8ISO6937


Please select one of the following for Database Characterset  [0 .. 76] :
66    => LA8PASSPORT
67    => LT8MSWIN921
68    => LT8PC772
69    => LT8PC774
70    => LV8PC1117
71    => LV8PC8LR
72    => LV8RST104090
73    => N8PC865
74    => NE8ISO8859P10
75    => NEE8ISO8859P4
76    => RU8BESTA


Please select one of the following for Database Characterset  [0 .. 87] :
77    => RU8PC855
78    => RU8PC866
79    => SE8ISO8859P3
80    => TH8MACTHAIS
81    => TH8TISASCII
82    => TR8DEC
83    => TR8MACTURKISHS
84    => TR8MSWIN1254
85    => TR8PC857
86    => US8PC437
87    => UTF8

Please select one of the following for Database Characterset  [0 .. 87] :
77    => RU8PC855
78    => RU8PC866
79    => SE8ISO8859P3
80    => TH8MACTHAIS
81    => TH8TISASCII
82    => TR8DEC
83    => TR8MACTURKISHS
84    => TR8MSWIN1254
85    => TR8PC857
86    => US8PC437
87    => UTF8


Please select one of the following for Database Characterset  [0 .. 98] :
88    => VN8MSWIN1258
89    => VN8VN3
90    => WE8DEC
91    => WE8DG
92    => WE8ISO8859P1
93    => WE8ISO8859P15
94    => WE8ISO8859P9
95    => WE8MACROMAN8S
96    => WE8MSWIN1252
97    => WE8NCR4970
98    => WE8NEXTSTEP


Please select one of the following for Database Characterset  [0 .. 109] :
99    => WE8PC850
100    => WE8PC858
101    => WE8PC860
102    => WE8ROMAN8
103    => ZHS16CGB231280
104    => ZHS16GBK
105    => ZHT16BIG5
106    => ZHT16CCDC
107    => ZHT16DBT
108    => ZHT16HKSCS
109    => ZHT16MSWIN950


Please select one of the following for Database Characterset  [1 .. 113] :
110    => ZHT32EUC
111    => ZHT32SOPS
112    => ZHT32TRIS
113    => US7ASCII
113
The selected value is : US7ASCII

Specify the  Database Territory (1. AMERICA 2. Others) [1] : 0

Please select one of the following for Database Territory [0 .. 10] :
0    => Others
1    => ALBANIA
2    => ALGERIA
3    => AMERICA
4    => ARGENTINA
5    => AUSTRALIA
6    => AUSTRIA
7    => AZERBAIJAN
8    => BAHRAIN
9    => BANGLADESH
10    => BELARUS


Please select one of the following for Database Territory  [0 .. 21] :
11    => BELGIUM
12    => BRAZIL
13    => BULGARIA
14    => CANADA
15    => CATALONIA
16    => CHILE
17    => CHINA
18    => COLOMBIA
19    => COSTA RICA
20    => CROATIA
21    => CYPRUS


Please select one of the following for Database Territory  [0 .. 32] :
22    => CZECH REPUBLIC
23    => DENMARK
24    => DJIBOUTI
25    => ECUADOR
26    => EGYPT
27    => EL SALVADOR
28    => ESTONIA
29    => FINLAND
30    => FRANCE
31    => FYR MACEDONIA
32    => GERMANY


Please select one of the following for Database Territory  [0 .. 43] :
33    => GREECE
34    => GUATEMALA
35    => HONG KONG
36    => HUNGARY
37    => ICELAND
38    => INDIA
39    => INDONESIA
40    => IRAQ
41    => IRELAND
42    => ISRAEL
43    => ITALY


Please select one of the following for Database Territory  [0 .. 54] :
44    => JAPAN
45    => JORDAN
46    => KAZAKHSTAN
47    => KOREA
48    => KUWAIT
49    => LATVIA
50    => LEBANON
51    => LIBYA
52    => LITHUANIA
53    => LUXEMBOURG
54    => MALAYSIA


Please select one of the following for Database Territory  [0 .. 65] :
55    => MAURITANIA
56    => MEXICO
57    => MONTENEGRO
58    => MOROCCO
59    => NEW ZEALAND
60    => NICARAGUA
61    => NORWAY
62    => OMAN
63    => PANAMA
64    => PERU
65    => PHILIPPINES
59
The selected value is : NEW ZEALAND

Specify the  Component Language (1. en 2. Others) [1] : 1
The selected value is : en
Please select one of the following for NLS Characterset  [1 .. 2] :
1    => AL16UTF16
2    => UTF8
2
The selected value is : UTF8

Successfully generated the Database parameter file 'testdb.ora'

[root@testodanode01 11.2.0.4]# oakcli show db_config_params
Available DB configuration files are:
default
testdb.ora

Create Oracle RAC database

[root@testodanode01 ~]# oakcli show db_config_params
Available DB configuration files are:
default
testdb.ora
[root@testodanode01 ~]# oakcli show dbhomes

Oracle Home Name      Oracle Home version                  Home Location
----------------      -------------------                  ------------
OraDb11204_home1      11.2.0.4.8(21352635,21352649)       /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1      12.1.0.2.5(21359755,21359758)       /u01/app/oracle/product/12.1.0.2/dbhome_1
[root@testodanode01 ~]# oakcli create database -h
Usage:
      oakcli create database  -db  [[[-oh ] | [-version ]]  [-params ] [-cdb]]
      where:
         db_name      - Name of the database to be created.
         home         - Existing oracle home for creating the database. By default we create a new database home.
         version      - Database Version information for creating the database home. [ex. 11.2.0.2.7] If not provided create the database home from latest available bits.
         params_file  - Name of the db_config_parameter file [This file can be created using using 'oakcli create db_config_params'].
                        If not provided, create the database using  default configuration file
         cdb          - Creates this database as a container database
[root@testodanode01 ~]# oakcli create database -db testdb -oh OraDb11204_home1 -params testdb.ora
INFO: 2016-04-12 10:16:37: Please check the logfile  '/opt/oracle/oak/log/testodanode01/tools/12.1.2.5.0/createdb_testdb_10844.log' for more details

Please enter the 'SYSASM'  password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
Please select one of the following for Database type  [1 .. 2] :
1   => OLTP
2   => DSS
1
The selected value is : OLTP
Please select one of the following for Database Deployment  [1 .. 3] :
1   => EE : Enterprise Edition
2   => RACONE
3   => RAC
3
The selected value is : RAC


Do you want to keep the data files on FLASH storage? : : [ Y | N ]?
Please enter either Y or N : n

Specify the  Database Class (1. odb-01 '1 core, 8 GB memory'   2. Others) [1] : 1
The selected value is : odb-01 '1 core, 8 GB memory'
 
Do you want to setup the EM DBconsole for this database [ Y | N ] ? : n
INFO   : Logging all actions in /opt/oracle/oak/log/testodanode01/patch/12.1.2.5.0/testodanode01-20160412101912.log and traces in /opt/oracle/oak/log/testodanode01/patch/12.1.2.5.0/testodanode01-20160412101912.trc
INFO   : Loading configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO   : Creating nodelist files...
INFO   : Setting up ssh for root...
INFO   : Setting up ssh across the private network...
...INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.27 /root/DoAllcmds.sh
INFO   : Background process 28891 (node: 192.168.16.27) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
INFO   : Background process 28914 (node: 192.168.16.28) gets done with the exit code 0
INFO   : Done setting up ssh
INFO   : Running /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on node <192.168.16.28>
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
 
...INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /root/DoAllcmds.sh
INFO   : Background process 30249 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /root/DoAllcmds.sh
INFO   : Background process 30272 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412101954.sh
INFO   : Background process 30321 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412101954.sh
INFO   : Background process 30344 (node: testodanode02) gets done with the exit code 0
INFO   : setting up ssh for user oracle...
...INFO   : checking nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO   : checking SSH setup for user (oracle) on nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
INFO   : did not do scp for node: testodanode01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102013.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102013.sh
INFO   : Background process 31626 (node: testodanode01) gets done with the exit code 0
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102013.sh
INFO   : Background process 31650 (node: testodanode02) gets done with the exit code 0
INFO   : Setting up ACFS storage
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/acfsm_10844.sh
INFO   : Background process 31754 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/acfsm_10844.sh
INFO   : Background process 31777 (node: testodanode02) gets done with the exit code 0
INFO: 2016-04-12 10:20:32: Successfully setup the storage structure for the database 'testdb'
SUCCESS: Successfully setup ACFS storage for the database testdb
INFO   : Creating database using dbca...
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102032.sh
INFO   : Background process 33630 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102032.sh
INFO   : Background process 33653 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102033.sh
INFO   : Background process 33701 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102033.sh
INFO   : Background process 33724 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102034.sh
INFO   : Background process 33778 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102034.sh
INFO   : Background process 33801 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102035.sh
INFO   : Background process 33849 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102035.sh
INFO   : Background process 33872 (node: testodanode02) gets done with the exit code 0
INFO   : Running dbca using /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh on testodanode01 as oracle...
INFO   : Check output in /opt/oracle/oak/onecmd/tmp/dbca-testdb-20160412101912.log on testodanode01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh
INFO   : Creating database using dbca...
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102032.sh
INFO   : Background process 33630 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102032.sh
INFO   : Background process 33653 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102033.sh
INFO   : Background process 33701 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102033.sh
INFO   : Background process 33724 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102034.sh
INFO   : Background process 33778 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102034.sh
INFO   : Background process 33801 (node: testodanode02) gets done with the exit code 0
INFO   : did not do scp for node: testodanode01
INFO   : Running as root: /usr/bin/ssh -l root testodanode01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102035.sh
INFO   : Background process 33849 (node: testodanode01) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root testodanode02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160412102035.sh
INFO   : Background process 33872 (node: testodanode02) gets done with the exit code 0
INFO   : Running dbca using /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh on testodanode01 as oracle...
INFO   : Check output in /opt/oracle/oak/onecmd/tmp/dbca-testdb-20160412101912.log on testodanode01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-testdb.sh
         Instance testdb1 is running on node testodanode01
         Instance testdb2 is running on node testodanode02
INFO   : One or more instances running on the cluster nodes.
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/srvctl setenv database -d testdb -t 'TZ=Pacific/Auckland' to set DB timezone
INFO   : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.testdb.db -p
.INFO   : did not do scp for node: testodanode01
..
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle testodanode01 /opt/oracle/oak/onecmd/tmp/dbupdates-testdb.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-testdb.sh
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/srvctl stop database -d testdb
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/srvctl start database -d testdb
INFO: 2016-04-12 10:29:09: Successfully set the rman snapshot controlfile
SUCCESS: 2016-04-12 10:29:10: Successfully created the database : testdb
Advertisements

About daviewning

I am an Oracle DBA

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: