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

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

OHS 12c noprompt password when stop/start component

cd $OHS_DOMAIN/bin $ ./stopComponent.sh ohs1 Stopping System Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Reading domain from /u01/oracle/domains/ohs_domain Please enter your password : password Connecting to Node Manager ... Successfully Connected to Node Manager. Killing server ohs1 ... Successfully killed server ohs1 Successfully disconnected from Node Manager. Exiting WebLogic Scripting Tool. Done $ OHS_HOME/oracle_common/common/bin $ wlst.sh readDomain('/u01/oracle/domains/ohs_domain') ohs_domain>cd('/SecurityConfiguration/ohs_domain') set('NodeManagerUsername','weblogic') set('NodeManagerPasswordEncrypted','password') updateDomain() closeDomain() exit() $ ./startComponent.sh ohs1  Starting system Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welco...
Postar um comentário
Leia mais