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.
Marcadores:

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Index SKIP SCAN???

Index Skip Scan nada mais é que o "split" logico de um indice composto, ou seja, se sua clausula WHERE não tiver todos os campos do indice composto, ele é dividido em menores sub-indices Exemplo: -------- SQL> create table teste(a number,b number); Table created. SQL> begin 2 for i in 1..1000 3 loop 4 insert into teste values(i, 56); 5 end loop; 6 end; 7 / PL/SQL procedure successfully completed. SQL> create index idx_teste on teste(a,b); Index created. SQL> analyze table teste compute statistics; Table analyzed. SQL> explain plan for select /*+ index_ss(teste idx_teste) */ * from teste where b=56; Explained. SQL> start ?\rdbms\admin\utlxpls.sql -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | SELECT STATEMENT | | 1
Postar um comentário
Leia mais

Webcenter Content - Jython to Checkin Content with Attachments (CHECKIN_NEW_WITH_RENDITIONS)

In the last few days, i had to load a content that, by its requirements, needs to attach files to the content. My first alternative would be Batch Loading, however for the bacth loder file it was not possible because it does not actually support the rendition service. With the next option, i tried to use the IdcCommand, but still had many problems, such as errors below: sample hda file: [oracle @ hostname bin] $ cat idctst.txt @Properties LocalData IdcService = EDIT_RENDITIONS dID = 37020 renditionKeys = addRendition0 addRendition0.name = test543 addRendition0.action = edit addRendition0.file = test.txt addRendition0.file: path = / u01 / oracle / domains / content_domain / ucm / cs / vault / ~ temp / test.txt @end << EOD >> Executing: [oracle @ hostname bin] $ ./IdcCommand -f idctst.txt -u sysadmin -l log.log -c server Error: Java HotSpot (TM) 64-Bit Server VM warning: Using the ParNew young collector with the Serial old collector is deprecated and w
Postar um comentário
Leia mais

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'
2 comentários
Leia mais