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