Skip to main content

DB - To Prepare Linux OS for Oracle DB



PT : Preparar Linux para Base de Dados Oracle  
EN : To prepare Linux  for Oracle DB
OS INFO

 [root@host ~]# uname -a
Linux host.mydomain.net 4.1.12-61.1.18.el7uek.x86_64 #2 SMP Fri Nov 4 15:48:30 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux
[root@host ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.3 (Maipo)
[root@host ~]# cat /etc/oracle-release 
Oracle Linux Server release 7.3

 OS KERNEL PARAMETERS

 cp /etc/sysctl.conf /etc/sysctl.conf.bakp

 echo "fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144

net.core.wmem_max = 1048576" >> /etc/sysctl.conf 

 [root@host ~]#  /sbin/sysctl -p

[root@host ~]#  /sbin/chkconfig boot.sysctl on
[root@host ~]#  reboot
ADD SWAP

 root@host ~]#  dd if=/dev/zero of=/swapfile bs=1024 count=262144
262144+0 records in
262144+0 records out
268435456 bytes (268 MB) copied, 0.61773 s, 435 MB/s

[root@host ~]# mkswap /swapfile
Setting up swapspace version 1, size = 262140 KiB
no label, UUID=185a9ca6-730d-4952-a5f4-50c2879a95be

[root@host ~]# swapon /swapfile
swapon: /swapfile: insecure permissions 0644, 0600 suggested.

[root@host ~]# chmod 0600 /swapfile

[root@host ~]# # echo "/swapfile               swap                    swap    defaults        0 0" >> /etc/fstab
root@host ~]# vi /etc/fstab


 FS INFO

 [root@host u01]# df
Filesystem          1K-blocks    Used Available Use% Mounted on
devtmpfs              1867416       0   1867416   0% /dev
tmpfs                 1891012     156   1890856   1% /dev/shm
tmpfs                 1891012    8964   1882048   1% /run
tmpfs                 1891012       0   1891012   0% /sys/fs/cgroup
/dev/mapper/ol-root  10258432 4938200   5320232  49% /
/dev/sda1             1038336  214244    824092  21% /boot
tmpfs                  378204      12    378192   1% /run/user/1000
/dev/sr0                57088   57088         0 100% /run/media/oracle/VBOXADDITIONS_5.0.30_112061
tmpfs                  378204       0    378204   0% /run/user/0

ADD A NEW DISK

 [root@host ~]# fdisk -l 

 Disk /dev/sda: 12.9 GB, 12884901888 bytes, 25165824 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x0005b7ac

    Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *        2048     2099199     1048576   83  Linux
/dev/sda2         2099200    25165823    11533312   8e  Linux LVM

 Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/mapper/ol-root: 10.5 GB, 10515120128 bytes, 20537344 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

 Disk /dev/mapper/ol-swap: 1287 MB, 1287651328 bytes, 2514944 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

 [root@host ~]# fdisk -l /dev/sdb

 Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

 [root@host ~]# fdisk -l /dev/sdb

 Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
[root@host ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).

 Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

 Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xeda68212.

 Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   g   create a new empty GPT partition table
   G   create an IRIX (SGI) partition table
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)

 Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 
First sector (2048-104857599, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-104857599, default 104857599): 
Using default value 104857599
Partition 1 of type Linux and of size 50 GiB is set

 Command (m for help): w
The partition table has been altered!

 Calling ioctl() to re-read partition table.
Syncing disks.

 [root@host ~]# fdisk -l /dev/sdb*

 Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0xeda68212

    Device Boot      Start         End      Blocks   Id  System
/dev/sdb1            2048   104857599    52427776   83  Linux

 Disk /dev/sdb1: 53.7 GB, 53686042624 bytes, 104855552 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

 [root@host ~]#  mkfs.xfs -L fs4oracle /dev/sdb1
meta-data=/dev/sdb1              isize=256    agcount=4, agsize=3276736 blks
         =                       sectsz=512   attr=2, projid32bit=1
         =                       crc=0        finobt=0, sparse=0
data     =                       bsize=4096   blocks=13106944, imaxpct=25
         =                       sunit=0      swidth=0 blks
naming   =version 2              bsize=4096   ascii-ci=0 ftype=0
log      =internal log           bsize=4096   blocks=6399, version=2
         =                       sectsz=512   sunit=0 blks, lazy-count=1
realtime =none                   extsz=4096   blocks=0, rtextents=0
MOUNT FILESYSTEM

 [root@host ~]# mkdir /u01 
[root@host ~]# mount /dev/sdb1 /u01
[root@host ~]# df -h | grep -i u01
/dev/sdb1             50G   33M   50G   1% /u01

 [root@host ~]# mount | grep -i u01
/dev/sdb1 on /u01 type xfs (rw,relatime,seclabel,attr2,inode64,noquota)

 [root@host ~]# vi  /etc/fstab 
[root@host ~]# umount /u01
[root@host ~]# mount | grep -i u01
[root@host ~]# mount -a
[root@host ~]# mount | grep -i u01
/dev/sdb1 on /u01 type xfs (rw,relatime,seclabel,attr2,inode64,noquota)
FS INFO

 [root@host u01]# df

 Filesystem          1K-blocks    Used Available Use% Mounted on
....
/dev/sdb1            52402180   32960  52369220   1% /u01
ADD GROUPS AND USERS AND DIRECTORIES 
*minimal

 [root@host u01]# groupadd -g 54321 oinstall
[root@host u01]# groupadd -g 54322 dba
[root@host u01]# useradd -u 54321 -g oinstall -G dba oracle
[root@host u01]# useradd -u 54322 -g oinstall -G dba grid

[root@host u01]# mkdir -p /u01/app/grid
[root@host u01]# mkdir -p /u01/app/oracle
[root@host u01]# chown -R grid:oinstall /u01
[root@host u01]# chown oracle:oinstall /u01/app/oracle
[root@host u01]# chmod -R 775 /u01

INSTALL RPMSs

 [root@host u01]#  yum install binutils \
compat-libcap1 compat-libstdc++ gcc gcc-c++ \
glibc glibc-devel ksh \
libaio libaio-devel libgcc libstdc++ libstdc++-devel \
libXi libXtst make sysstat \
unixODBC unixODBC-devel

 RELATED READING

 http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm
http://docs.oracle.com/database/121/LADBI/toc.htm
http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
-----
Obrigado pela leitura, espero que este post o tenha ajudado :)
Thank you for reading, hope this post was helpful  :) 
Labels:

Comments

Post a Comment

Popular posts from this blog

DB - How to monitor Oracle datapump jobs

These days there is lot of work around database migrations not only but mainly to cloud providers. One of the ways to migrate Oracle databases is using data pump (expdp/impdp). In general works fine, it allows an easy way to bring the database even different OS. It is always good to monitor the progress, to know where we are and estimate how long we are from the end. In this post, I am sharing some queries to help with database monitoring progress. The queries can be easily tailed to various scenarios. Starting with a simple one - the track the number of objects loaded during an import operation. When there is a massive amount of errors during the import. Drop and run the import again. The bellow query can be useful also to monitor the number of objects if we are dropping the users. Here, I’m making the assumption there were no other database activity in progress on the last 24 hours. select owner, count(0) from dba_objects where owner in ( select username from dba_users where created...
Post a Comment
Read more

VM - Partilhar Pastas Windows - Linux

Neste post escrevo como partilhar pastas entre Windows (Host) e uma VM Guest, neste caso Linux. Ha algumas formas de fazer isto, esta parece me a mais facil. Seleccionar a Pasta Windows Na consola Virtual Box > Devices > Shared Folder Seleccionar a pasta windows para partilhar no Linux   O   Montar a pasta Windows na VM Ha duas opcoes : 1) Reiniciar a VM (Auto-mount) 2) Linha de comando [root@host ~]# mkdir -p /u01/stage/win_ebs_sw [root@host ~]# chmod 777 /u01/stage/win_ebs_sw [root@host ~]# mount -t vboxsf Oracle_EBS /u01/stage/win_ebs_sw/ [root@host ~]# ls /u01/stage/win_ebs_sw ebs_weblogic_webtier [root@host ~]# df -h /u01/stage/win_ebs_sw Filesystem Size Used Avail Use% Mounted on Oracle_EBS 895G 494G 401G 56% /u01/stage/win_ebs_sw Guardar a Configuracao no /etc/fstab para tornar as alteracoes permanentes. [root@host ~]# echo "Oracle_EBS /u01/stage/win_ebs_sw vboxsf defaults 0 0" >> /etc/fstab [root@host ~]# cat /etc/fstab # /etc/...
Post a Comment
Read more

DB – How to monitor Oracle database long ops ?

As DBAs, some questions we are often asked and to be fair we ask ourselfs when we are doing massive operations, are : Is the database doing something? How long the database takes to complete the task? There a data dictionary view, GV$SESSION_LONGOPS whom is really usefull for monitoring and to provide estimated time to get the task done. Starting with a first example, a query for general propose . set lines 240 col message form a100 col opname form a50 select * from ( select round(l.sofar/l.totalwork*100,2) as complete, --l.* l.sid, --l.opname, l.message, l.start_time, l.time_remaining/60 "minuts remaining", l.elapsed_seconds from gv$session_longops l where totalwork !=0 ) where complete < 100; The view is also usefull on specific operations such as Oracle Recovery Manager (RMAN) jobs monitoring, this query returns information about backup,restore and recovery. select sid, serial#,opname, context, sofar, totalwork, round(sofar/totalwork*100,2) "%_complet...
Post a Comment
Read more