ORADICAS: junho 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

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

Selected value is: AMERICAN

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

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

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 .. 98] :

88 => VN8MSWIN1258

89 => VN8VN3

90 => WE8DEC

91 => WE8DG

92 => WE8ISO8859P1

93 => WE8ISO8859P15

94 => WE8ISO8859P9

95 => WE8MACROMAN8S

96 => WE8MSWIN1252

97 => WE8NCR4970

98 => WE8NEXTSTEP

Selected value is: WE8ISO8859P1

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

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

Selected value is: AMERICA

Specify the Component Language (1. en 2. Others) [1]:

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

Selected value is: en

Please select one of the following for NLS Characterset [1 .. 2]:

1 => AL16UTF16

2 => UTF8

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

Selected value is : OLTP

Please select one of the following for Database Deployment [1 .. 3]:

1 => EE : Enterprise Edition

2 => RACONE

3 => RAC

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)

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|

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

quinta-feira, 2 de junho de 2016

Conhecendo o mundo do tal do ODA - Criando um database

Conhecendo o mundo do tal do ODA - OAKCLI I

Postagem em destaque

[ORACLE] Embedding ONNX model for Vector Search tests with Oracle Database 23ai

Pesquisar este blog

Sites que acompanho