Pessoal, olá.
Hoje venho aqui para dividir com vocês uma satisfação muito grande. Verdade que está um pouco atrasada, mas nunca é tarde.
Esse é o meu primeiro post publicado no OTN: Guia de Instalação Oracle Enterprise Manager Cloud Control 13c
Para quem não sabe, a Comunidade Oracle Technology Network America Latina é uma espaço mantido pela Oracle para que artigos técnicos escritos pelos profissionais da área sejam compartilhados.
Esses artigos passam por uma revisão da equipe técnica do produto na própria Oracle antes de ser publicado, garantindo assim a qualidade e aderência da publicação com as regras de uso e licenciamento do produto que está sendo usado no artigo.
Espero que gostem.
Logo mais estarei publicando mais um artigo no OTN e também retomando aqui com pelo menos um artigo por semana.
Abraço
Mario
segunda-feira, 10 de outubro de 2016
quinta-feira, 2 de junho de 2016
Conhecendo o mundo do tal do ODA - Criando um database
Olá jovens.
Vamos direto ao ponto hoje, vamos criar uma nova base de dados no ODA X5. Assim, simples e rápido...
Vamos lá.
Então começamos preparando nosso script de criação da base:
CREATE DATABASE TESTE...
Opa!!! Para!!! Para!!! Para!!! Para!!!
Tipo João Kleber manja ahahahhaha... O que é isso pequeno gafanhoto, não precisamos de nada disso não.
Mais uma vez nosso amigo OAKCLI vai nos ajudar. Vamos lá, agora é sério...
Primeiro vamos gerar um arquivo com algumas configurações. Esse não é um passo obrigatório, mas pode ser que o template do ODA não sirva para o que você quer então acho legal fazer isso.
1) Conecta como root
su -
2) Manda o comando abaixo:
[root@odax51 ~]# oakcli create db_config_params -conf rsfile
Agora é só responder as perguntas. Eu vou colocar todo o log aqui para vocês verem. Vai ficar um pouco grande mas acho que vale a pena.
Please select one of the following for Database Block Size [1 .. 4]:
1 => 4096
2 => 8192
3 => 16384
4 => 32768
2
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
2
Selected value is: AMERICAN
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
0
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
0
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
0
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
0
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
0
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
0
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
0
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
92
Selected value is: WE8ISO8859P1
Specify the Database Territory (1. AMERICA 2. Others) [1]:
2
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
3
Selected value is: AMERICA
Specify the Component Language (1. en 2. Others) [1]:
2
Please select one of the following for Component Language [0 .. 10] :
0 => Others
1 => en : Engilish
2 => fr : French
3 => ar : Arabic
4 => bn : Bengali
5 => pt_BR : Brazilian Portuguese
6 => bg : Bulgarian
7 => fr_CA : Canadian French
8 => ca : Catalan
9 => hr : Croatian
10 => cs : Czech
1
Selected value is: en
Please select one of the following for NLS Characterset [1 .. 2]:
1 => AL16UTF16
2 => UTF8
1
Selected value is : AL16UTF16
Successfully generated the Database parameter file 'rsfile'
3) Vamos verificar o que acabamos de gerar
oakcli show db_config_params
Available DB configuration files are:
default ==> Olha aqui o default do ODA
rsfile ==> O que acabamos de criar
oakcli show db_config_params -conf rsfile -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => WE8ISO8859P1
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
NLS_NCHAR_CHARACTERSET => AL16UTF16
4) Veja os ORACLE_HOMES disponíveis. Você vai precisar.
[root@odax51 ~]# oakcli show dbhomes
5) Então pequeno amigo, agora é só ter o trabalho de olhar o ODA trabalhar
oakcli create database -db teste -oh OraDb11204_home1 -params rsfile
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
Selected value is : OLTP
Please select one of the following for Database Deployment [1 .. 3]:
1 => EE : Enterprise Edition
2 => RACONE
3 => RAC
3
Selected value is : RAC
Please select one of the following for Database Class [1 .. 5]:
1 => odb-01s ( 1 cores , 4 GB memory)
2 => odb-01 ( 1 cores , 8 GB memory)
3 => odb-02 ( 2 cores , 16 GB memory)
4 => odb-04 ( 4 cores , 32 GB memory)
5 => odb-06 ( 6 cores , 48 GB memory)
2
Selected value is : odb-01 ( 1 cores , 8 GB memory)
Do you want to setup the EM DB Console for this database [ Y | N ] ? : N
Agora basta seguirmos o log
INFO : Logging all actions in the file /opt/oracle/oak/log/hscodax41/patch/12.1.2.6.0/hscodax41-20160517105858.log and traces in the file /opt/oracle/oak/log/hscodax41/patch/12.1.2.6.0/hscodax41-20160517105858.trc
INFO : Loading the configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO : Creating the node list 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.24 /root/DoAllcmds.sh
INFO : Running as root: /usr/bin/ssh -l root 192.168.16.25 /root/DoAllcmds.sh
INFO : Background process 76404 (node: 192.168.16.24) gets done with the exit code 0
INFO : Background process 76430 (node: 192.168.16.25) gets done with the exit code 0
INFO : Setting up SSH completed successfully
INFO : Running the command /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory
on node <192 .168.16.25="">
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/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 : hscodax41
INFO : Running as root: /usr/bin/ssh -l root hscodax41 /root/DoAllcmds.sh
INFO : Background process 77099 (node: hscodax41) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root hscodax42 /root/DoAllcmds.sh
INFO : Background process 77126 (node: hscodax42) gets done with the exit code 0
INFO : Did not do scp for node : hscodax41
INFO : Running as root: /usr/bin/ssh -l root hscodax41 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517105939.sh
INFO : Running as root: /usr/bin/ssh -l root hscodax42 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517105939.sh
INFO : Background process 77181 (node: hscodax41) gets done with the exit code 0
INFO : Background process 77207 (node: hscodax42) 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 : hscodax41
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle hscodax41 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517105958.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517105958.sh
INFO : Background process 77766 (node: hscodax41) 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 hscodax42 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517105958.sh
INFO : Background process 77792 (node: hscodax42) gets done with the exit code 0
INFO : Setting up ACFS storage
INFO : Did not do scp for node : hscodax41
INFO : Running as root: /usr/bin/ssh -l root hscodax41 /opt/oracle/oak/onecmd/tmp/acfsm_72134.sh
INFO : Running as root: /usr/bin/ssh -l root hscodax42 /opt/oracle/oak/onecmd/tmp/acfsm_72134.sh
INFO : Background process 77986 (node: hscodax41) gets done with the exit code 0
INFO : Background process 78012 (node: hscodax42) gets done with the exit code 0
INFO: 2016-05-17 11:00:14: Creating the volume datastore on the diskgroup REDO of size 52 G
INFO: 2016-05-17 11:00:24: Creating acfs on volume datastore
INFO: 2016-05-17 11:00:25: Registering datastore with clusterware
INFO: 2016-05-17 11:00:38: Creating the volume datastore on the diskgroup DATA of size 1625 G
INFO: 2016-05-17 11:00:53: Creating accelerator volume acldatstore
INFO: 2016-05-17 11:00:59: Creating acfs on volume datastore
INFO: 2016-05-17 11:01:44: Registering datastore with clusterware
INFO: 2016-05-17 11:02:09: Creating the volume datastore on the diskgroup RECO of size 374 G
INFO: 2016-05-17 11:02:21: Creating acfs on volume datastore
INFO: 2016-05-17 11:02:37: Registering datastore with clusterware
INFO: 2016-05-17 11:02:50: Successfully setup the storage structure for the database 'teste'
SUCCESS: Successfully setup ACFS storage for the database teste
INFO : Creating Database using DBCA...
INFO : Did not do scp for node : hscodax41
INFO : Running as root: /usr/bin/ssh -l root hscodax41 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517110250.sh
INFO : Running as root: /usr/bin/ssh -l root hscodax42 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160517110250.sh
INFO : Background process 91175 (node: hscodax41) gets done with the exit code 0
INFO : Background process 91201 (node: hscodax42) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-teste.sh on hscodax41 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-teste-20160517105858.log on hscodax41
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle hscodax41 /opt/oracle/oak/onecmd/tmp/dbca-teste.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-teste.sh
Instance teste1 is running on node hscodax41
Instance teste2 is running on node hscodax42
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 teste -t 'TZ=America/Sao_Paulo' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.teste.db -p
.INFO : Did not do scp for node : hscodax41
..
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle hscodax41 /opt/oracle/oak/onecmd/tmp/dbupdates-teste.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-teste.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 teste
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 teste
INFO: 2016-05-17 11:12:25: Successfully set the RMAN SNAPSHOT control file
E se tudo correu bem, acabamos assim:
SUCCESS: 2016-05-17 11:12:26: Successfully created the Database : teste
Olha só que legal, ele já fez tudo, até registrar a nova base no RAC. É ou não é nosso amigo esse tal de OAKCLI ahahahha.
Ai claro, dá uma conferida lá né o preguiça:
Bom pessoal, espero que ajude. Dica simples mas bastante útil.
Abraço
Mario
Conhecendo o mundo do tal do ODA - OAKCLI I
Olá jovens!!
Como estão? Espero que estejam bem.
A algum tempo comecei a administrar um ambiente ODA (X4-2). Ambiente bacana de se trabalhar.
Com o tempo, fui anotando algumas verificações feitas no ODA através do OAKCLI.
Seguindo o que eu acho (e se eu acho, é um achismo meu.. então pode estar errado ahahahahah) o Oracle cada vez mais quer fornecer ferramentas para facilitar o dia a dia de quem gosta de uma linha de comando.
Assim como o ADRCI, essa é uma ferramenta de linha de comando que auxilia na realização de várias tarefas no ODA.
Hoje vou passar aqui algumas opções de verificação e validações de componentes.
Vocês verão no help que ainda podemos fazer deploy, upgrade, update, etc. Mas esse não é o foco.
Então, chega de embromation e vamos lá ao que interessa.
O OAKCLI deve ser executado como usuário root.
su -
cd /opt/oracle/oak/bin/
Claro, vamos dar uma olhada no Help primeiro:
[root@zema02 bin]# ./oakcli -h
Usage: oakcli show - show disk, diskgroup, expander, controller,
server, processor, memory, power, cooling,
network, enclosure, storage, version,
dbhomes, databases, db_config_params,
core_config_key, env_hw, asr
oakcli apply - applies the core_config_key
oakcli locate - locates a disk
oakcli deploy - deploys the Database Appliance
oakcli update - updates the Database Appliance
oakcli validate - validates the Database Appliance
oakcli manage - manages the oak repository, diagcollect e.t.c
oakcli unpack - unpack the given package to oak repository
oakcli copy - copies the deployment config file
oakcli upgrade - upgrades database
oakcli stordiag - run storage diagnostic tool on both node
oakcli test - test asr
oakcli orachk - performs configuration settings check on ODA
oakcli configure - configures the network or asr
oakcli create - creates database,dbhome,db_config_params file
oakcli delete - deletes database,dbhome,db_config_params file
Podemos também verificar o help por hierarquia.
[root@zema02 bin]# oakcli show -h
Usage:
oakcli show {disk|diskgroup|expander|controller|server|processor|
memory|power|cooling|network|enclosure|storage|
core_config_key|version|dbhomes|databases|
db_config_params|asr|env_hw} []
where:
disk - About the disk
diskgroup - Asm disk group
expander - Expander
controller - Controller
storage - All storage components
version - Running software version
dbhomes - Installed oracle database homes
databases - Database names
db_config_params - db_config_params file
asr - Asr configuration
env_hw - Environment and Hardware
information
server - Details of server sub-system
processor - Details of processor sub-system
memory - Details of memory sub-system
power - Details of power supply
sub-system
cooling - Details of cooling sub-system
network - Details of network sub-system
enclosure - Details of enclosure sub-system
core_config_key - Core configuration
Agora é só brincar com as opções. Aqui uma lista dos discos disponíveis
- Informações dos discos
[root@zema02 bin]# oakcli show disk
NAME PATH TYPE STATE STATE_DETAILS
e0_pd_00 /dev/sda HDD ONLINE Good
e0_pd_01 /dev/sdb HDD ONLINE Good
e0_pd_02 /dev/sdaa HDD ONLINE Good
e0_pd_03 /dev/sdab HDD ONLINE Good
e0_pd_04 /dev/sdac HDD ONLINE Good
e0_pd_05 /dev/sdad HDD ONLINE Good
e0_pd_06 /dev/sdae HDD ONLINE Good
e0_pd_07 /dev/sdaf HDD ONLINE Good
e0_pd_08 /dev/sdag HDD ONLINE Good
e0_pd_09 /dev/sdah HDD ONLINE Good
e0_pd_10 /dev/sdai HDD ONLINE Good
e0_pd_11 /dev/sdaj HDD ONLINE Good
e0_pd_12 /dev/sdak HDD ONLINE Good
e0_pd_13 /dev/sdal HDD ONLINE Good
e0_pd_14 /dev/sdam HDD ONLINE Good
e0_pd_15 /dev/sdan HDD ONLINE Good
e0_pd_16 /dev/sdao HDD ONLINE Good
e0_pd_17 /dev/sdap HDD ONLINE Good
e0_pd_18 /dev/sdaq HDD ONLINE Good
e0_pd_19 /dev/sdar HDD ONLINE Good
e0_pd_20 /dev/sdas SSD ONLINE Good
e0_pd_21 /dev/sdat SSD ONLINE Good
e0_pd_22 /dev/sdau SSD ONLINE Good
e0_pd_23 /dev/sdav SSD ONLINE Good
- Informações dos diskgroups criados
[root@zema02 bin]# oakcli show diskgroup
DiskGroups
----------
DATA
RECO
REDO
- Informações dos servidores
[root@zema02 bin]# ./oakcli show server
Power State : On
Open Problems : 0
Model : ODA X4-2
Type : Rack Mount
Part Number : 33144597+1+1
Serial Number : 1446NMP00E
Primary OS : Not Available
ILOM Address : XXX.XX.XX.XX
ILOM MAC Address : 00:00:X0:00:X0:X0
Description : Oracle Database Appliance X4-2 1446NMP00E
Locator Light : Off
Actual Power Consumption : 244 watts
Ambient Temperature : 20.000 degree C
Open Problems Report : System is healthy
- Informações da versão
[root@zema02 bin]# oakcli show version
Version
-------
2.10.0.0.0
- Informações dos processadores e quantidade de core's habilitados
[root@zema02 bin]# oakcli show processor
NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES
CPU_0 OK - 060E P0 (CPU 0) Intel(R) Xeon(R) CPU E5-2697 2.700 GHZ 12 12
CPU_1 OK - 060E P1 (CPU 1) Intel(R) Xeon(R) CPU E5-2697 2.700 GHZ 12 12
- Informações de energia, temperatura, etc
[root@zema02 bin]# oakcli show power
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP
Power_Supply_0 OK - 7079395 000000X+0000XX00X0 PS0 Present 110 watts 30.500 degree C 35.312 degree C
Power_Supply_1 OK - 7079395 000000X+0000XX00X0 PS1 Present 108 watts 35.750 degree C 39.375 degree C
- Se está com a core_config_key implantada.
[root@zema02 bin]# oakcli show core_config_key
Optional core_config_key is not applied on this machine yet !
Importante: Se houvesse uma chave, seria mais ou menos isso:
Host's serialnumber = 00000XX00X7
Configured Cores = 16
- Informações das bases que lá estão:
[root@zema02 bin]# oakcli show databases
Database Name Database Type Database HomeName
Database HomeLocation Database Version
---------------- ------------- ----------------
----------------------------------------- ---------------------
orcl RAC OraDb11204_home1
/u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.2(18031668,18031740)
tttt RAC OraDb11204_home1
/u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.2(18031668,18031740)
xxxx RAC OraDb11204_home1
/u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.2(18031668,18031740)
É isso. É tranquilo. Só olhar o help e mandar bala.
O validate segue o mesmo ponto...
Vamos ver o help.
[root@zema02 ~]# oakcli validate -h
Usage:
oakcli validate [-V | -l | -h]
oakcli validate [-v] [-f absolute output_file_name]
[-a | -d | -c check1[,check2]]
ARGUMENTS:
-v verbose output
-f output_file_name.The output is sent to the file
instead of standard output
-a run all checks
-d run only default checks.
-c check1[,check2] run specific checks
-l list the checks and description
-V Print the Version
-h print help
EXAMPLES:
oakcli validate -l
oakcli validate -a
oakcli validate -c DiskCalibration
oakcli validate -c SystemComponents,NetworkComponents,asr
Uma lista com descrição do que é validado em cada teste também está lá.
[root@zema02 ~]# oakcli validate -l
Checkname -- Description
========= ===========
*SystemComponents -- Validate system components based on ilom sensor
data readings
*OSDiskStorage -- Validate OS disks and filesystem information
*SharedStorage -- Validate Shared storage and multipathing
information
DiskCalibration -- Check disk performance with orion
*NetworkComponents -- Validate public and private network components
*StorageTopology -- Validate external JBOD connectivity
asr -- Validate asr components based on asr config
file and ilom sensor data readings
* -- These checks are also performed as part of default checks
- Podemos, por exemplo, validar a topologia do Storage
[root@zema02 ~]# oakcli validate -c StorageTopology
It may take a while. Please wait...
INFO : ODA Topology Verification
INFO : Running on Node1
INFO : Check hardware type
SUCCESS : Type of hardware found : X4-2
INFO : Check for Environment(Bare Metal or Virtual Machine)
SUCCESS : Type of environment found : Bare Metal
INFO : Check number of Controllers
SUCCESS : Number of Internal LSI SAS controller found : 1
SUCCESS : Number of External LSI SAS controller found : 2
INFO : Check for Controllers correct PCIe slot address
SUCCESS : Internal LSI SAS controller : 50:00.0
SUCCESS : External LSI SAS controller 0 : 30:00.0
SUCCESS : External LSI SAS controller 1 : 40:00.0
INFO : Check if JBOD powered on
SUCCESS : 1JBOD : Powered-on
INFO : Check for correct number of EBODS(2 or 4)
SUCCESS : EBOD found : 2
INFO : Check for External Controller 0
SUCCESS : Controller connected to correct ebod number
SUCCESS : Controller port connected to correct ebod port
SUCCESS : Overall Cable check for controller 0
INFO : Check for External Controller 1
SUCCESS : Controller connected to correct ebod number
SUCCESS : Controller port connected to correct ebod port
SUCCESS : Overall Cable check for controller 1
INFO : Check for overall status of cable validation on Node1
SUCCESS : Overall Cable Validation on Node1
INFO : Check Node Identification status
SUCCESS : Node Identification
SUCCESS : Node name based on cable configuration found : NODE1
INFO : Check JBOD Nickname
SUCCESS : JBOD Nickname set correctly : Oracle Database Appliance - E0
INFO : The details for Storage Topology Validation can also
be found in log
file=/opt/oracle/oak/log/zema02/storagetopology/StorageTopology-2015-05-14-11:13:59_59781_137.log
- Ou as informações de network
[root@zema02 ~]# oakcli validate -c NetworkComponents
INFO: Doing oak network checks
RESULT: Detected active link for interface eth0 with link speed
10000Mb/s and cable type as Twinax
RESULT: Detected active link for interface eth1 with link speed
10000Mb/s and cable type as Twinax
RESULT: Detected active link for interface eth2 with link speed
1000Mb/s and cable type as Twisted Pair
RESULT: Detected active link for interface eth3 with link speed
1000Mb/s and cable type as Twisted Pair
WARNING: No Link detected for interface eth4 with cable type
as Twisted Pair
WARNING: No Link detected for interface eth5 with cable type as
Twisted Pair
INFO: Checking bonding interface status
RESULT: Bond interface bond0 is up configured in mode:load
balancing (round-robin) with current active interface as
Slave1 interface is eth2 with status:up Link fail count=0
Maccaddr:00:10:e0:62:a5:c2
Slave2 interface is eth3 with status:up Link fail count=0
Maccaddr:00:10:e0:62:a5:c3
WARNING: Bond interface bond1 has the following current status:down
RESULT: Bond interface bond1 is down configured in mode:
fault-tolerance (active-backup) with current active
interface as None
Slave1 interface is eth4 with status:down Link fail count=0
Maccaddr:00:10:e0:62:a5:c4
Slave2 interface is eth5 with status:down Link fail count=0
Maccaddr:00:10:e0:62:a5:c5
SUCCESS: eth0 is running 192.168.16.25
SUCCESS: eth1 is running 192.168.17.25
E assim podemos validar várias informações.
É isso jovens. Espero ter ajudado quem, como eu, está começando com o ODA.
That's it my friends...
Mario
Assinar:
Postagens (Atom)
Postagem em destaque
[Oracle] GoldenGate for Distributed Applications and Analytics (GG for DAA) & Iceberg replication
Hello everyone. How are you doing? I was talking to Alex Lima, Oracle GoldenGate Product Manager, today and he suggested I take a look a...
