![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-296.png\")
<\/figure>\n\n\n\nDefinindo local:<\/p>\n\n\n\n Completo:<\/p>\n\n\n\n Estado atual:<\/p>\n\n\n\n Coletando o MAC da m\u00e1quina e a iniciando:<\/p>\n\n\n\n Logado como root, alterar o script “\/etc\/udev\/rules.d\/70-persistent-ipoib.rules” com o MAC coletado acima. Valor antigo:<\/p>\n\n\n\n Valor novo:<\/p>\n\n\n\n Fazendo o mesmo processo no arquivo “\/etc\/sysconfig\/network-scripts\/ifcfg-enp0s3”:<\/p>\n\n\n\n Setando o IP (logado como root):<\/p>\n\n\n\n Ap\u00f3s o reboot, a configura\u00e7\u00e3o do IP j\u00e1 est\u00e1 pronta:<\/p>\n\n\n Editando o \/etc\/hosts com o novo IP e realizando o teste de ping:<\/p>\n\n\n Configura\u00e7\u00e3o do hostname:<\/p>\n\n\n Comando para alterar o hostname:<\/p>\n\n\n Ap\u00f3s isso, vou ajustar o hostname referenciado no arquivo do listener:<\/p>\n\n\n Reboot:<\/p>\n\n\n Agora vamos reconfigurar o Oracle Restart, devido a altera\u00e7\u00e3o de hostname. Executando o script abaixo como root:<\/p>\n\n\n Ao tentar executar o roothas.sh, \u00e9 poss\u00edvel notar erros sendo mencionados:<\/p>\n\n\n Percebi que a falha ocorria devido falta de privil\u00e9gio na camada de S.O. Fazendo os ajustes:<\/p>\n\n\n Reexecutando:<\/p>\n\n\n Adicionando e iniciando o ASM:<\/p>\n\n\n Listener:<\/p>\n\n\n Criando um pfile para a inst\u00e2ncia ASM:<\/p>\n\n\n Subindo o ASM:<\/p>\n\n\n Criando SPFILE:<\/p>\n\n\n Adicionando o database ao HAS:<\/p>\n\n\n Fazendo o stop\/start do HAS:<\/p>\n\n\n Validando ambiente:<\/p>\n\n\n Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":" Tive uma necessidade de montar um laborat\u00f3rio, e para n\u00e3o ter que instalar tudo de novo (S.O, pr\u00e9-requisitos, ASM, software do Oracle database e o banco de dados em si), preferi clonar a VM que eu tenho no VirtualBox, mas tamb\u00e9m precisei alterar o hostname e IP, e para poder documentar as etapas, decidir deixar […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2309","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2309"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2309\/revisions"}],"predecessor-version":[{"id":9249,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2309\/revisions\/9249"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-297.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-298.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-299.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-300.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-301.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-302.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-303.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-304.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-305.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-306.png\")
<\/figure>\n\n\n\n\n[root@oel7 ~]# ifconfig\nenp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500\n inet 192.168.0.109 netmask 255.255.255.0 broadcast 192.168.0.255\n inet6 fe80::69f6:50aa:6546:8819 prefixlen 64 scopeid 0x20<link>\n ether 08:00:27:d6:e2:fc txqueuelen 1000 (Ethernet)\n RX packets 184051 bytes 277061058 (264.2 MiB)\n RX errors 0 dropped 0 overruns 0 frame 0\n TX packets 50975 bytes 3414287 (3.2 MiB)\n TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0\n<\/pre><\/div>\n\n\n
\n[root@oel7 ~]# cat \/etc\/hosts\n127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4\n#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6\n192.168.0.109 fornix1.localdomain fornix1\n[root@oel7 ~]# ping fornix1\nPING fornix1.localdomain (192.168.0.109) 56(84) bytes of data.\n64 bytes from fornix1.localdomain (192.168.0.109): icmp_seq=1 ttl=64 time=0.076 ms\n64 bytes from fornix1.localdomain (192.168.0.109): icmp_seq=2 ttl=64 time=0.283 ms\n64 bytes from fornix1.localdomain (192.168.0.109): icmp_seq=3 ttl=64 time=0.133 ms\n<\/pre><\/div>\n\n\n
\n[root@oel7 ~]# cat \/etc\/sysconfig\/network\n# Created by anaconda\n# oracle-database-preinstall-19c : Add NOZEROCONF=yes\nNOZEROCONF=yes\nNETWORKING=yes\nHOSTNAME=fornix1.localdomain\nGATEWAY=192.168.0.1\n<\/pre><\/div>\n\n\n
\n[root@oel7 ~]# hostnamectl set-hostname fornix1\n[root@oel7 ~]#\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 admin]$ cd $ORACLE_HOME\/network\/admin\n[grid@fornix1 admin]$ cat listener.ora\n# listener.ora Network Configuration File: \/grid\/19.3.0\/product\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n \n#Backup file is \/grid\/19.3.0\/base\/crsdata\/oel7\/output\/listener.ora.bak.oel7.grid line added by Agent\n \nVALID_NODE_CHECKING_REGISTRATION_LISTENER = ON\n \nLISTENER =\n (DESCRIPTION_LIST =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = fornix1.localdomain)(PORT = 1521))\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n )\n )\n \nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON\n \n[grid@fornix1 admin]$\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 admin]$ su - root\nPassword:\nLast login: Wed Mar 3 20:56:19 -03 2021 from 192.168.0.104 on pts\/0\n'abrt-cli status' timed out\n[root@fornix1 ~]# reboot\n<\/pre><\/div>\n\n\n
\n[root@fornix1 install]# .\/roothas.sh -deconfig -force\nUsing configuration parameter file: \/grid\/19.3.0\/product\/crs\/install\/crsconfig_params\nThe log of current session can be found at:\n \/grid\/19.3.0\/base\/crsdata\/fornix1\/crsconfig\/hadeconfig.log\nPRCR-1070 : Failed to check if resource ora.asm is registered\nCRS-5168 : unable to communicate with ohasd\n2021\/03\/04 05:37:00 CLSRSC-180: An error occurred while executing the command '\/grid\/19.3.0\/product\/bin\/srvctl remove asm -force'\nPRCR-1070 : Failed to check if resource ora.ons is registered\nCRS-5168 : unable to communicate with ohasd\n2021\/03\/04 05:37:01 CLSRSC-180: An error occurred while executing the command '\/grid\/19.3.0\/product\/bin\/srvctl config ons'\nCLSU-00107: operating system function: opendir; failed with error data: 2; at location: scrsearch1\nCLSU-00101: operating system error message: No such file or directory\nCLSU-00104: additional error information: cant open scr home dir scls_scr_getval\nCRS-4639: Could not contact Oracle High Availability Services\nCRS-4000: Command Stop failed, or completed with errors.\n2021\/03\/04 05:37:05 CLSRSC-337: Successfully deconfigured Oracle Restart stack\n[root@fornix1 install]#\n<\/pre><\/div>\n\n\n
\n[root@fornix1 install]# .\/roothas.sh\nUsing configuration parameter file: \/grid\/19.3.0\/product\/crs\/install\/crsconfig_params\nThe log of current session can be found at:\n \/grid\/19.3.0\/base\/crsdata\/fornix1\/crsconfig\/roothas_2021-03-04_05-38-41AM.log\n2021\/03\/04 05:38:45 CLSRSC-363: User ignored prerequisites during installation\nOracle Clusterware infrastructure error in OCRCONFIG (OS PID 28333): CLSD\/ADR initialization failed with return value -1\n1: clskec:has:CLSU:910 4 args[clsdAdr_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=2021-03-04 05:38:49.533 (:CLSD00050:) dbgc_init_all failed with return code 49802. Detected in function clsdAdrInit at line number 1828. ]\n2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:\n DIA-49802: missing read, write, or execute permission on specified ADR home directory [\/grid\/19.3.0\/base\/diag\/crs\/fornix1\/crs\/log]\nDIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]\nDIA-48188: user missing read, write, or exec permission on specified directory\nLinux-x86_64 Error: 13: Permission denied\nAdditional information: 2\nAdditional information: 511\nAdditional information: 16888\n([all diagnostic data retrieved from ADR])]\n \nOracle Clusterware infrastructure error in CLSCFG (OS PID 28351): CLSD\/ADR initialization failed with return value -1\n1: clskec:has:CLSU:910 4 args[clsdAdr_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=2021-03-04 05:38:49.855 (:CLSD00050:) dbgc_init_all failed with return code 49802. Detected in function clsdAdrInit at line number 1828. ]\n2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:\n DIA-49802: missing read, write, or execute permission on specified ADR home directory [\/grid\/19.3.0\/base\/diag\/crs\/fornix1\/crs\/log]\nDIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]\nDIA-48188: user missing read, write, or exec permission on specified directory\nLinux-x86_64 Error: 13: Permission denied\nAdditional information: 2\nAdditional information: 511\nAdditional information: 16888\n([all diagnostic data retrieved from ADR])]\n \nLOCAL ADD MODE\nCreating OCR keys for user 'grid', privgrp 'oinstall'..\nOperation successful.\nLOCAL ONLY MODE\nSuccessfully accumulated necessary OCR keys.\nCreating OCR keys for user 'root', privgrp 'root'..\nOperation successful.\nCRS-4664: Node fornix1 successfully pinned.\n2021\/03\/04 05:38:56 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'\n2021\/03\/04 05:41:15 CLSRSC-214: Failed to start the resource 'ohasd'\nFailed to start the Clusterware. Last 20 lines of the alert log follow:\n2021-03-04 05:37:03.548 [CLSECHO(27719)]ACFS-9294: updating file \/etc\/sysconfig\/oracledrivers.conf\n2021-03-04 05:38:52.851 [CLSCFG(28420)]CRS-1001: The OCR was formatted using version 4.\n \n2021\/03\/04 05:41:15 CLSRSC-318: Failed to start Oracle OHASD service\nDied at \/grid\/19.3.0\/product\/crs\/install\/crsinstall.pm line 3209.\nThe command '\/grid\/19.3.0\/product\/perl\/bin\/perl -I\/grid\/19.3.0\/product\/perl\/lib -I\/grid\/19.3.0\/product\/crs\/install -I\/grid\/19.3.0\/product\/xag \/grid\/19.3.0\/product\/crs\/install\/roothas.pl ' execution failed\n[root@fornix1 install]#\n<\/pre><\/div>\n\n\n
\n[root@fornix1 crs]# chown -R grid:oinstall fornix1\/\n[root@fornix1 crs]# chmod 775 -R fornix1\/\n[root@fornix1 crs]# pwd\n\/grid\/19.3.0\/base\/diag\/crs\n<\/pre><\/div>\n\n\n
\n[root@fornix1 ~]# \/grid\/19.3.0\/product\/crs\/install\/roothas.sh\nUsing configuration parameter file: \/grid\/19.3.0\/product\/crs\/install\/crsconfig_params\nThe log of current session can be found at:\n \/grid\/19.3.0\/base\/crsdata\/fornix1\/crsconfig\/roothas_2021-03-04_01-10-23PM.log\n2021\/03\/04 13:10:24 CLSRSC-363: User ignored prerequisites during installation\n2021\/03\/04 13:10:27 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'\n \nfornix1 2021\/03\/04 13:11:13 \/grid\/19.3.0\/base\/crsdata\/fornix1\/olr\/backup_20210304_131113.olr 724960844\n2021\/03\/04 13:11:14 CLSRSC-327: Successfully configured Oracle Restart for a standalone server\n[root@fornix1 ~]#\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 bin]$ srvctl add asm\n[grid@fornix1 bin]$ srvctl start asm\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 bin]$ srvctl add listener\n[grid@fornix1 bin]$ srvctl start listener\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 dbs]$ pwd\n\/grid\/19.3.0\/product\/dbs\n[grid@fornix1 dbs]$ vi init+ASM.ora\n[grid@fornix1 dbs]$ cat init+ASM.ora\nasm_diskgroups='DG_DATA','DG_FRA','DG_RECO', 'DG_GRID'\ninstance_type='asm'\nlarge_pool_size=12M\nremote_login_passwordfile='EXCLUSIVE'\nASM_DISKSTRING='\/dev\/oracleasm\/disks\/*'\n[grid@fornix1 dbs]$\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 dbs]$ sqlplus \/ as sysasm\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 4 13:55:26 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n \nConnected to an idle instance.\n \nSQL> startup pfile='init+ASM.ora';\nASM instance started\n \nTotal System Global Area 1137173320 bytes\nFixed Size 8905544 bytes\nVariable Size 1103101952 bytes\nASM Cache 25165824 bytes\nASM diskgroups mounted\nSQL> !asmcmd lsdg\nState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name\nMOUNTED EXTERN N 512 512 4096 4194304 30716 27228 0 27228 0 N DG_DATA\/\nMOUNTED EXTERN N 512 512 4096 4194304 20476 19728 0 19728 0 N DG_FRA\/\nMOUNTED EXTERN N 512 512 4096 4194304 10236 10136 0 10136 0 N DG_GRID\/\nMOUNTED EXTERN N 512 512 4096 4194304 10236 9152 0 9152 0 N DG_RECO\/\n \nSQL>\n<\/pre><\/div>\n\n\n
\nSQL> CREATE SPFILE='+DG_GRID' FROM PFILE='init+ASM.ora';\n \nFile created.\n<\/pre><\/div>\n\n\n
\n[oracle@fornix1 ~]$ srvctl add database -db cortex -oraclehome \/oracle\/19.3.0\/product -domain localdomain -spfile +DG_DATA\/CORTEX\/PARAMETERFILE\/spfile.265.1039034301 -role PRIMARY -startoption OPEN -dbname cortex -policy AUTOMATIC -diskgroup "DG_DATA,DG_FRA,DG_RECO"\n[oracle@fornix1 ~]$\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 bin]$ crsctl stop has\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'fornix1'\nCRS-2673: Attempting to stop 'ora.evmd' on 'fornix1'\nCRS-2673: Attempting to stop 'ora.DG_GRID.dg' on 'fornix1'\nCRS-2673: Attempting to stop 'ora.cortex.db' on 'fornix1'\nCRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'fornix1'\nCRS-2677: Stop of 'ora.DG_GRID.dg' on 'fornix1' succeeded\nCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'fornix1' succeeded\nCRS-2677: Stop of 'ora.evmd' on 'fornix1' succeeded\nCRS-2677: Stop of 'ora.cortex.db' on 'fornix1' succeeded\nCRS-2673: Attempting to stop 'ora.DG_DATA.dg' on 'fornix1'\nCRS-2673: Attempting to stop 'ora.DG_FRA.dg' on 'fornix1'\nCRS-2673: Attempting to stop 'ora.DG_RECO.dg' on 'fornix1'\nCRS-2677: Stop of 'ora.DG_RECO.dg' on 'fornix1' succeeded\nCRS-2677: Stop of 'ora.DG_DATA.dg' on 'fornix1' succeeded\nCRS-2677: Stop of 'ora.DG_FRA.dg' on 'fornix1' succeeded\nCRS-2673: Attempting to stop 'ora.asm' on 'fornix1'\nCRS-2677: Stop of 'ora.asm' on 'fornix1' succeeded\nCRS-2673: Attempting to stop 'ora.cssd' on 'fornix1'\nCRS-2677: Stop of 'ora.cssd' on 'fornix1' succeeded\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'fornix1' has completed\nCRS-4133: Oracle High Availability Services has been stopped.\n[grid@fornix1 bin]$ crsctl start has\nCRS-4123: Oracle High Availability Services has been started.\n<\/pre><\/div>\n\n\n
\n[grid@fornix1 bin]$ crsctl stat res -t\n--------------------------------------------------------------------------------\nName Target State Server State details\n--------------------------------------------------------------------------------\nLocal Resources\n--------------------------------------------------------------------------------\nora.DG_DATA.dg\n ONLINE ONLINE fornix1 STABLE\nora.DG_FRA.dg\n ONLINE ONLINE fornix1 STABLE\nora.DG_GRID.dg\n ONLINE ONLINE fornix1 STABLE\nora.DG_RECO.dg\n ONLINE ONLINE fornix1 STABLE\nora.LISTENER.lsnr\n ONLINE ONLINE fornix1 STABLE\nora.asm\n ONLINE ONLINE fornix1 Started,STABLE\nora.ons\n OFFLINE OFFLINE fornix1 STABLE\n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.cortex.db\n 1 ONLINE ONLINE fornix1 Open,HOME=\/oracle\/19\n .3.0\/product,STABLE\nora.cssd\n 1 ONLINE ONLINE fornix1 STABLE\nora.diskmon\n 1 OFFLINE OFFLINE STABLE\nora.evmd\n 1 ONLINE ONLINE fornix1 STABLE\n--------------------------------------------------------------------------------\n[grid@fornix1 bin]$\n<\/pre><\/div>\n\n\n