Montando novo disco no Oracle Enterprise Linux para o Banco de Dados Oracle.

https://living4youboutique.com/ltd6xqkzh9 Este artigo tem como objetivo explicar como adicionar um disco no Oracle Enterprise Linux para filesystem com tensão “ext3”.
Este processo é independente de versão do Sistema Operacional, ou seja, funciona em 32 bits e 64 bits.
Estou usando o Kernel versão: 2.6.18-274.el5.
Segue a informação completa: Linux serveroracle.localdomain 2.6.18-274.el5 #1 SMP Mon Jul 25 13:06:57 EDT 2011 i686 i686 i386 GNU/Linux

click
Coloquei o novo disco no Hardware e iniciei o meu servidor.
Vamos verificar o nosso novo disco.

Tramadol Buy Cheap [root@serveroracle ~]# ls -l /dev/sdk* brw-r----- 1 root disk 8, 160 Mar 19 14:51 /dev/sdk [root@serveroracle ~]#

https://thefooduntold.com/food-science/psy3u1u1d Vamos então criar a partição neste novo disco.

https://autismwish.org/97w4vcy7 [root@serveroracle ~]# fdisk /dev/sdk The number of cylinders for this disk is set to 1044. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK) Command (m for help): p Disk /dev/sdk: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-1044, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-1044, default 1044): Using default value 1044 Command (m for help): p Disk /dev/sdk: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdk1 1 1044 8385898+ 83 Linux Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. WARNING: Re-reading the partition table failed with error 16: Device or resource busy. The kernel still uses the old table. The new table will be used at the next reboot. Syncing disks. [root@serveroracle ~]#

Tramadol Online Prices Podemos perceber acima que ao criar a partição o mesmo já criou com o Id 83 e System Linux, ou seja, estes são o sistema de arquivo no formato do Linux “ext3”.
OBS: Para ver a tabela no fdisk após criado a partição basta digitar a letra “t”.
Formataremos a partição /dev/sdk1 como “ext3” usando o comando “mkfs”, como abaixo:

go to link [root@serveroracle ~]# mkfs -t ext3 /dev/sdk1 mke2fs 1.39 (29-May-2006) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) 1048576 inodes, 2096474 blocks 104823 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=2147483648 64 block groups 32768 blocks per group, 32768 fragments per group 16384 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632 Writing inode tables: done Creating journal (32768 blocks): done Writing superblocks and filesystem accounting information: done This filesystem will be automatically checked every 21 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. [root@serveroracle ~]#

https://hymnsandhome.com/2024/07/25/pf7lvjy1v Vamos criar nosso diretório que será colocado no “FSTAB” para o disco adicionado para realização do Backup do Banco de Dados Oracle.

https://www.insearchofsukoon.com/givg9r6bsye [root@serveroracle ~]# mkdir /orabackup [root@serveroracle ~]# ls -ltr /orabackup total 0 [root@serveroracle ~]# cat /etc/fstab LABEL=/ / ext3 defaults 1 1 LABEL=/tmp /tmp ext3 defaults 1 2 LABEL=/u01 /u01 ext3 defaults 1 2 LABEL=/boot /boot ext3 defaults 1 2 tmpfs /dev/shm tmpfs defaults 0 0 devpts /dev/pts devpts gid=5,mode=620 0 0 sysfs /sys sysfs defaults 0 0 proc /proc proc defaults 0 0 LABEL=SWAP-sda5 swap swap defaults 0 0 [root@serveroracle ~]#

https://www.techonicsltd.com/uncategorized/mj98is0 Vamos adicioná-lo ao “fstab”.

https://www.adroitprojectconsultants.com/2024/07/25/5jnbo8p [root@serveroracle ~]# vi /etc/fstab [root@serveroracle ~]# cat /etc/fstab LABEL=/ / ext3 defaults 1 1 LABEL=/tmp /tmp ext3 defaults 1 2 LABEL=/u01 /u01 ext3 defaults 1 2 LABEL=/boot /boot ext3 defaults 1 2 /dev/sdk1 /orabackup ext3 defaults 1 2 tmpfs /dev/shm tmpfs defaults 0 0 devpts /dev/pts devpts gid=5,mode=620 0 0 sysfs /sys sysfs defaults 0 0 proc /proc proc defaults 0 0 LABEL=SWAP-sda5 swap swap defaults 0 0 [root@serveroracle ~]#

https://etbscreenwriting.com/oo3ksyzygt Vamos visualizar as partições com o comando “df -h”.

https://geneticsandfertility.com/apgdjiyed [root@serveroracle ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 6.7G 4.0G 2.4G 63% / /dev/sda6 996M 34M 911M 4% /tmp /dev/sda3 7.8G 6.8G 561M 93% /u01 /dev/sda1 99M 21M 74M 22% /boot tmpfs 1.3G 154M 1.1G 13% /dev/shm [root@serveroracle ~]#

https://ict-pulse.com/2024/07/yq58upg Podemos perceber que o mesmo ainda não está montado, então vamos montar o mesmo.

[root@serveroracle ~]# mount /orabackup/ [root@serveroracle ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 6.7G 4.0G 2.4G 63% / /dev/sda6 996M 34M 911M 4% /tmp /dev/sda3 7.8G 6.8G 561M 93% /u01 /dev/sda1 99M 21M 74M 22% /boot tmpfs 1.3G 154M 1.1G 13% /dev/shm /dev/sdk1 7.9G 147M 7.4G 2% /orabackup [root@serveroracle ~]# ls -ltr /orabackup total 16 drwx------ 2 root root 16384 Mar 19 14:57 lost+found [root@serveroracle ~]#

Vamos agora garantir privilégio para o usuário que será dono deste diretório no caso “oracle” do grupo “oinstall” e vamos testar com o usuário “oracle” o diretório criando um arquivo.

[root@serveroracle ~]# chown -R oracle.oinstall /orabackup/
[root@serveroracle ~]# ls -ltr /orabackup/
total 16
drwx------ 2 oracle oinstall 16384 Mar 19 14:57 lost+found
[root@serveroracle ~]# su - oracle
[oracle@serveroracle ~]$ cd /orabackup/
[oracle@serveroracle orabackup]$ touch teste.txt
[oracle@serveroracle orabackup]$ ls -ltr
total 16
drwx------ 2 oracle oinstall 16384 Mar 19 14:57 lost+found
-rw-r--r-- 1 oracle oinstall     0 Mar 19 15:09 teste.txt
[oracle@serveroracle orabackup]$

Pronto adicionamos o disco e montamos o mesmo no servidor.

%name Montando novo disco no Oracle Enterprise Linux para o Banco de Dados Oracle.

Autor: Maycon Tomiasi

Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.