{"id":2398,"date":"2020-01-17T10:45:56","date_gmt":"2020-01-17T13:45:56","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=2398"},"modified":"2020-01-17T10:45:56","modified_gmt":"2020-01-17T13:45:56","slug":"instalando-o-oracle-19c","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/instalando-o-oracle-19c\/","title":{"rendered":"Instalando o Oracle 19c"},"content":{"rendered":"

Nesse Artigo, Vamos instalar o Oracle 19c no virtual Box<\/p>\n

Vamos iniciar criando a maquina Virtual.<\/p>\n\n

\n
\nVirtualBox\n<\/div>\n
\n<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\n

[collapse]<\/div>\n<\/div>\n<\/div>\n\n

Agora Vamos iniciar a instala\u00e7\u00e3o do SO<\/p>\n\n

\n
\nOracle Linux 7.7\n<\/div>\n
\n<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\n

[collapse]<\/div>\n<\/div>\n<\/div>\n\n

Vamos instalar os pacotes:<\/p>\n

yum -y update \r\nyum -y install oracle-database-preinstall-19c.x86_64 \r\nyum -y install unzip wget screen gcc #\r\nyum -y install https:\/\/dl.fedoraproject.org\/pub\/epel\/epel-release-latest-7.noarch.rpm # \r\nyum -y install oracleasm-support gcc gcc-c++ make\r\nyum -y update # yum -y install rlwrap\r\nyum install tigervnc-server\r\nyum install -y bc \r\nyum install -y binutils\r\nyum install -y compat-libcap1\r\nyum install -y compat-libstdc++-33\r\nyum install -y dtrace-modules\r\nyum install -y dtrace-modules-headers\r\nyum install -y dtrace-modules-provider-headers\r\nyum install -y dtrace-utils\r\nyum install -y elfutils-libelf\r\nyum install -y elfutils-libelf-devel\r\nyum install -y fontconfig-devel\r\nyum install -y glibc\r\nyum install -y glibc-devel\r\nyum install -y ksh\r\nyum install -y libaio\r\nyum install -y libaio-devel\r\nyum install -y libdtrace-ctf-devel\r\nyum install -y libXrender\r\nyum install -y libXrender-devel\r\nyum install -y libX11\r\nyum install -y libXau\r\nyum install -y libXi\r\nyum install -y libXtst\r\nyum install -y libgcc\r\nyum install -y librdmacm-devel\r\nyum install -y libstdc++\r\nyum install -y libstdc++-devel\r\nyum install -y libxcb\r\nyum install -y make\r\nyum install -y net-tools # Clusterware\r\nyum install -y nfs-utils # ACFS\r\nyum install -y python # ACFS\r\nyum install -y python-configshell # ACFS\r\nyum install -y python-rtslib # ACFS\r\nyum install -y python-six # ACFS\r\nyum install -y targetcli # ACFS\r\nyum install -y smartmontools\r\nyum install -y sysstat\r\nyum install -y unixODBC\r\n\r\nwget http:\/\/download.oracle.com\/otn_software\/asmlib\/oracleasmlib-2.0.12-1.el7.x86_64.rpm\r\nrpm -Uvh oracleasmlib-2.0.12-1.el7.x86_64.rpm<\/pre>\n
 <\/p>\n
Configure o arquivo\u00a0\/etc\/hosts:<\/p>\n
127.0.0.1 localhost localhost.localdomain\r\n\r\n192.168.56.79\u00a0 zmol7.localdomain zmol7<\/pre>\n
Configure o Usuario Oracle<\/p>\n
groupadd asmadmin\u00a0\r\n\r\ngroupadd asmdba\r\n\r\ngroupadd asmoper\r\n\r\nusermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle<\/pre>\n
Criei os diretorios<\/p>\n
mkdir -p \/u01\/app\/oracle\r\n\r\nmkdir -p \/u01\/app\/oracle\/product\/19.3.0.0\/grid\r\n\r\nchown -R\u00a0 oracle:oinstall \/u01\/app\/\r\n\r\nchmod -R 775 \/u01\/\r\n\r\nmkdir -p \/u01\/app\/oracle\/product\/19.3.0.0\/db_1\r\n\r\nchown oracle:oinstall \/u01\/app\/oracle\/product\/19.3.0.0\/db_1\r\n\r\nchmod -R 775 \/u01\/<\/pre>\n
desabilite o firewall, o avahi e o chronyd. #<\/p>\n
systemctl disable firewalld\r\n\r\nsystemctl disable avahi-daemon\r\n\r\nsystemctl enable chronyd<\/pre>\n
altere o SELinux para o modo permissive.<\/p>\n
vi \/etc\/selinux\/config ...\r\n\r\nSELINUX=permissive<\/pre>\n
adicione um novo disco<\/p>\n\n
\n
\nNovo Disco\n<\/div>\n
\n<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\n
[collapse]<\/div>\n<\/div>\n<\/div>\n\n
Acesse o terminal e execute os comando abaixo:<\/p>\n
fdisk -l\r\n\r\nDisk \/dev\/sdb: 24.8 GB, 24843845632 bytes, 48523136 sectors\r\nUnits = sectors of 1 * 512 = 512 bytes\r\nSector size (logical\/physical): 512 bytes \/ 512 bytes\r\nI\/O size (minimum\/optimal): 512 bytes \/ 512 bytes\r\n\r\nCommand (m for help): n\r\nPartition type:\r\np primary (0 primary, 0 extended, 4 free)\r\ne extended\r\nSelect (default p): p\r\nPartition number (1-4, default 1): 1\r\nFirst sector (2048-48523135, default 2048):\r\nUsing default value 2048\r\nLast sector, +sectors or +size{K,M,G} (2048-48523135, default 48523135):\r\nUsing default value 48523135\r\nPartition 1 of type Linux and of size 23.1 GiB is set\r\n\r\nCommand (m for help): w\r\nThe partition table has been altered!\r\n\r\nCalling ioctl() to re-read partition table.\r\nSyncing disks.\r\n[root@zmol7 ~]#<\/pre>\n
Configurando 0 ASM<\/p>\n
\/etc\/init.d\/oracleasm configure\r\n\r\n[root@zmol7 ~]# oracleasm configure -i\r\n\r\nConfiguring the Oracle ASM library driver.\r\n\r\n\r\n\r\nThis will configure the on-boot properties of the Oracle ASM library\r\n\r\ndriver.\u00a0 The following questions will determine whether the driver is\r\n\r\nloaded on boot and what permissions it will have.\u00a0 The current values\r\n\r\nwill be shown in brackets ('[]').\u00a0 Hitting <ENTER> without typing an\r\n\r\nanswer will keep that current value.\u00a0 Ctrl-C will abort.\r\n\r\n\r\n\r\nDefault user to own the driver interface []:\r\n\r\nDefault user to own the driver interface []: oracle\r\n\r\nDefault group to own the driver interface []: asmadmin\r\n\r\nStart Oracle ASM library driver on boot (y\/n) [n]: y\r\n\r\nScan for Oracle ASM disks on boot (y\/n) [y]: y\r\n\r\nWriting Oracle ASM library driver configuration: done\r\n\r\n\r\n\r\n[root@zmol7 ~]# oracleasm init\r\n\r\nCreating \/dev\/oracleasm mount point: \/dev\/oracleasm\r\n\r\nLoading module \"oracleasm\": oracleasm\r\n\r\nConfiguring \"oracleasm\" to use device physical block size\r\n\r\nMounting ASMlib driver filesystem: \/dev\/oracleasm\r\n\r\n\r\n\r\n[root@zmol7 ~]# oracleasm status\r\n\r\nChecking if ASM is loaded: yes\r\n\r\nChecking if \/dev\/oracleasm is mounted: yes\r\n\r\n[root@zmol7 ~]#<\/pre>\n
Criando o disco ASM<\/strong><\/p>\n
[root@zmol7 ~]# oracleasm createdisk DISK01 \/dev\/sdb1\r\n\r\nWriting disk header: done\r\n\r\nInstantiating disk: done\r\n\r\n\r\n\r\n[root@zmol7 ~]# oracleasm scandisks\r\n\r\nReloading disk partitions: done\r\n\r\nCleaning any stale ASM disks...\r\n\r\nScanning system for ASM disks...\r\n\r\n[root@zmol7 ~]# oracleasm listdisks\r\n\r\nDISK01\r\n\r\n[root@zmol7 ~]#<\/pre>\n
Instalando o Grid<\/p>\n\n
\n
\nInstalando o Grid\n<\/div>\n
\n<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\n
[collapse]<\/div>\n<\/div>\n<\/div>\n\n
Instalando o RDBMS<\/p>\n
Entre com o Usu\u00e1rio Oracle<\/b><\/p>\n\n
\n
\nInstalando o RDBMS\n<\/div>\n
\n<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
 <\/p>\n
\n
[collapse]<\/div>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"
Nesse Artigo, Vamos instalar o Oracle 19c no virtual Box Vamos iniciar criando a maquina Virtual. Agora Vamos iniciar a instala\u00e7\u00e3o do SO Vamos instalar os pacotes: yum -y update yum -y install oracle-database-preinstall-19c.x86_64 yum -y install unzip wget screen gcc # yum -y install https:\/\/dl.fedoraproject.org\/pub\/epel\/epel-release-latest-7.noarch.rpm # yum -y install oracleasm-support gcc gcc-c++ make yum -y update # yum -y install rlwrap yum install tigervnc-server yum install -y bc yum install -y binutils yum install[…]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2398"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=2398"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2398\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=2398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=2398"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=2398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}