Pular para o conteúdo principal

Setup Oracle 11gR2 on linux - Oracle Validated

First Configure public Yum Repository:
http://public-yum.oracle.com/

Run oracle-validated:
[root@localhost yum.repos.d]# yum install oracle-validated
Loading "security" plugin
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package oracle-validated.x86_64 0:1.1.0-14.el5 set to be updated
filelists.xml.gz          100% |=========================| 3.1 kB    00:00
filelists.xml.gz          100% |=========================| 2.9 MB    00:10
filelists.xml.gz          100% |=========================| 2.7 MB    00:15
filelists.xml.gz          100% |=========================| 3.2 MB    00:18
filelists.xml.gz          100% |=========================| 2.6 MB    00:14
filelists.xml.gz          100% |=========================| 3.2 MB    00:18
filelists.xml.gz          100% |=========================| 3.0 MB    00:14
filelists.xml.gz          100% |=========================| 2.9 MB    00:14
filelists.xml.gz          100% |=========================| 190 kB    00:00
filelists.xml.gz          100% |=========================|  33 kB    00:00
filelists.xml.gz          100% |=========================| 2.7 MB    00:10
--> Processing Dependency: util-linux >= 2.13-0.52.0.1.el5_4.1 for package: oracle-validated
--> Processing Dependency: libXp.so.6 for package: oracle-validated
--> Processing Dependency: /usr/lib/libodbccr.so for package: oracle-validated
--> Processing Dependency: /usr/lib64/libodbccr.so for package: oracle-validated
--> Processing Dependency: unixODBC-devel for package: oracle-validated
--> Processing Dependency: libaio-devel for package: oracle-validated
--> Processing Dependency: irqbalance >= 2:0.55-16 for package: oracle-validated
--> Processing Dependency: sysstat for package: oracle-validated
--> Processing Dependency: kernel-uek >= 2.6.32 for package: oracle-validated
--> Processing Dependency: /usr/lib64/libaio.so for package: oracle-validated
--> Processing Dependency: libdb-4.2.so()(64bit) for package: oracle-validated
--> Processing Dependency: /usr/lib/libodbc.so.1 for package: oracle-validated
--> Processing Dependency: /usr/lib/libaio.so for package: oracle-validated
--> Processing Dependency: libodbc.so.1()(64bit) for package: oracle-validated
--> Processing Dependency: compat-gcc-34-c++ for package: oracle-validated
--> Processing Dependency: compat-gcc-34 for package: oracle-validated
--> Processing Dependency: oraclelinux-release for package: oracle-validated
--> Running transaction check
---> Package unixODBC.x86_64 0:2.2.11-7.1 set to be updated
---> Package compat-db.x86_64 0:4.2.52-5.1 set to be updated
---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated
---> Package unixODBC-devel.x86_64 0:2.2.11-7.1 set to be updated
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
---> Package oraclelinux-release.x86_64 0:5-7.0.2 set to be updated
---> Package libaio-devel.x86_64 0:0.3.106-5 set to be updated
--> Processing Dependency: libaio = 0.3.106-5 for package: libaio-devel
---> Package util-linux.x86_64 0:2.13-0.56.0.2.el5 set to be updated
---> Package compat-gcc-34.x86_64 0:3.4.6-4.1 set to be updated
---> Package sysstat.x86_64 0:7.0.2-11.el5 set to be updated
---> Package irqbalance.x86_64 2:0.55-16.el5 set to be updated
---> Package kernel-uek.x86_64 0:2.6.32-200.13.1.el5uek set to be updated
--> Processing Dependency: kernel-firmware >= 2.6.32-200.13.1.el5uek for package: kernel-uek
--> Processing Dependency: mkinitrd >= 5.1.19.6-61.0.2 for package: kernel-uek
--> Processing Dependency: device-mapper-multipath >= 0.4.9-23.0.1.el5 for package: kernel-uek
--> Processing Dependency: ql2xxx-firmware for package: kernel-uek
--> Processing Dependency: kexec-tools >= 1.102pre-96.1.1.el5_5.2 for package: kernel-uek
---> Package compat-gcc-34-c++.x86_64 0:3.4.6-4.1 set to be updated
---> Package libaio-devel.i386 0:0.3.106-5 set to be updated
---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated
--> Running transaction check
---> Package kexec-tools.x86_64 0:1.102pre-126.0.1.el5_6.6 set to be updated
---> Package mkinitrd.x86_64 0:5.1.19.6-71.0.6.el5 set to be updated
--> Processing Dependency: kpartx >= 0.4.9 for package: mkinitrd
--> Processing Dependency: iscsi-initiator-utils for package: mkinitrd
--> Processing Dependency: hmaccalc for package: mkinitrd
--> Processing Dependency: nash = 5.1.19.6-71.0.6.el5 for package: mkinitrd
---> Package kernel-uek-firmware.noarch 0:2.6.32-200.13.1.el5uek set to be updated
---> Package mkinitrd.i386 0:5.1.19.6-71.0.6.el5 set to be updated
---> Package ql2xxx-firmware.noarch 0:1.01.01-0.2.el5 set to be updated
---> Package device-mapper-multipath.x86_64 0:0.4.9-23.0.9.el5 set to be updated
--> Processing Dependency: device-mapper >= 1.02.38 for package: device-mapper-multipath
--> Processing Dependency: device-mapper-multipath-libs = 0.4.9-23.0.9.el5 for package: device-mapper-multipath
--> Processing Dependency: libmultipath.so()(64bit) for package: device-mapper-multipath
---> Package libaio.i386 0:0.3.106-5 set to be updated
---> Package libaio.x86_64 0:0.3.106-5 set to be updated
--> Running transaction check
---> Package kpartx.x86_64 0:0.4.9-23.0.9.el5 set to be updated
--> Processing Dependency: device-mapper = 1.02.24-1.el5 for package: device-mapper-event
---> Package device-mapper-multipath-libs.x86_64 0:0.4.9-23.0.9.el5 set to be updated
---> Package device-mapper.i386 0:1.02.63-4.el5 set to be updated
---> Package device-mapper.x86_64 0:1.02.63-4.el5 set to be updated
---> Package iscsi-initiator-utils.x86_64 0:6.2.0.872-10.0.1.el5 set to be updated
---> Package hmaccalc.x86_64 0:0.9.6-3.el5 set to be updated
---> Package nash.x86_64 0:5.1.19.6-71.0.6.el5 set to be updated
--> Running transaction check
---> Package device-mapper-event.x86_64 0:1.02.63-4.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 oracle-validated        x86_64     1.1.0-14.el5     ol5_u7_base        24 k
Updating:
 device-mapper           i386       1.02.63-4.el5    ol5_u7_base       776 k
 device-mapper           x86_64     1.02.63-4.el5    ol5_u7_base       808 k
 device-mapper-multipath  x86_64     0.4.9-23.0.9.el5  ol5_u7_base        85 k
 irqbalance              x86_64     2:0.55-16.el5    ol5_u6_base        21 k
 kexec-tools             x86_64     1.102pre-126.0.1.el5_6.6  ol5_u7_base       593 k
 kpartx                  x86_64     0.4.9-23.0.9.el5  ol5_u7_base       449 k
 libaio                  i386       0.3.106-5        ol5_u6_base        19 k
 libaio                  x86_64     0.3.106-5        ol5_u6_base        19 k
 mkinitrd                x86_64     5.1.19.6-71.0.6.el5  ol5_u7_base       464 k
 mkinitrd                i386       5.1.19.6-71.0.6.el5  ol5_u7_base       475 k
 nash                    x86_64     5.1.19.6-71.0.6.el5  ol5_u7_base       1.4 M
 util-linux              x86_64     2.13-0.56.0.2.el5  ol5_u6_base       1.8 M
Installing for dependencies:
 compat-db               x86_64     4.2.52-5.1       el5_u3_base       1.6 M
 compat-gcc-34           x86_64     3.4.6-4.1        ol5_u6_base       4.3 M
 compat-gcc-34-c++       x86_64     3.4.6-4.1        ol5_u6_base        13 M
 device-mapper-multipath-libs  x86_64     0.4.9-23.0.9.el5  ol5_u7_base       153 k
 hmaccalc                x86_64     0.9.6-3.el5      ol5_u7_base        21 k
 iscsi-initiator-utils   x86_64     6.2.0.872-10.0.1.el5  ol5_u7_base       1.0 M
 kernel-uek              x86_64     2.6.32-200.13.1.el5uek  ol5_u7_base        25 M
 kernel-uek-firmware     noarch     2.6.32-200.13.1.el5uek  ol5_u7_base       2.5 M
 libXp                   i386       1.0.0-8.1.el5    el5_u3_base        22 k
 libaio-devel            x86_64     0.3.106-5        ol5_u6_base        11 k
 libaio-devel            i386       0.3.106-5        ol5_u6_base        12 k
 oraclelinux-release     x86_64     5-7.0.2          ol5_u7_base       2.6 k
 ql2xxx-firmware         noarch     1.01.01-0.2.el5  ol5_u7_base       442 k
 sysstat                 x86_64     7.0.2-11.el5     ol5_u7_base       187 k
 unixODBC                x86_64     2.2.11-7.1       el5_u3_base       835 k
 unixODBC                i386       2.2.11-7.1       el5_u3_base       830 k
 unixODBC-devel          i386       2.2.11-7.1       el5_u3_base       743 k
 unixODBC-devel          x86_64     2.2.11-7.1       el5_u3_base       799 k
Updating for dependencies:
 device-mapper-event     x86_64     1.02.63-4.el5    ol5_u7_base        23 k

Transaction Summary
=============================================================================
Install     19 Package(s)
Update      13 Package(s)
Remove       0 Package(s)

Total download size: 58 M
Is this ok [y/N]:

Are automatically installed all the necessary packages, setup the sysctl.conf and limits.conf files.

Comentários

Postagens mais visitadas deste blog

Webcenter Content - Cache Configuration for JdbcFileStore configuration

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...

Assign Backup Policy for Boot and Block Volumes - OCI

To get Availability Domain oci iam availability-domain list  #!/bin/bash OCI_AD="hQsi:SA-SAOPAULO-1-AD-1" OCI_COMPARTMENT="ocid1.compartment.oc1..aaaaaaaavgyjpoffz5qliieawamjaksfb6juxejurtduclqjkvv66ookcxja" #Get Silver policy ocid funct_get_policy(){ OCI_POL_OCID=$(oci bv volume-backup-policy list | jq -r '.data[] | select(."display-name"|contains("silver"))' | jq -r '.id') } funct_boot_vol (){ #Create a file with all boot volume ocid oci bv boot-volume list --availability-domain ${OCI_AD} -c  ${OCI_COMPARTMENT} | jq -r '.data[].id' > boot-vol.txt while IFS="" read -r p || [ -n "$p" ] do   printf 'Seeting backup policy for %s\n' "$p"   oci bv volume-backup-policy-assignment create  --asset-id  $p  --policy-id ${OCI_POL_OCID} done < boot-vol.txt } funct_block_vol (){ #Create a file with all block volume ocid oci bv volume list  -c ${OCI_COMPARTMENT} | jq -r '.data[].id' ...

Configurar Tamanho de UNDO e tempo de RETENÇÃO (UNDO_RETENTION)

-- Tamanho Undo Atual SELECT SUM(a.bytes) "UNDO_SIZE" FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO' AND c.status = 'ONLINE' AND b.name = c.tablespace_name AND a.ts# = b.ts#; -- Blocos de UNDO por Seg. SELECT MAX(undoblks/((end_time-begin_time)*3600*24)) "UNDO_BLOCK_PER_SEC" FROM v$undostat; --Tamanho do Bloco SELECT TO_NUMBER(value) "DB_BLOCK_SIZE [KByte]" FROM v$parameter WHERE name = 'db_block_size'; -- Select calcula UNDO RETENTION SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]", SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]", ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]" FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO' ...