Instalando Banco de Dados Oracle 11gR2 em Oracle Enterprise Linux 5.6

Este artigo tem como objetivo explicar como instalar o banco de dados Oracle 11g R2 no Oracle Enterprise Linux 5.6.
Para preparar o Linux para Instalação do banco de dados Oracle veja o artigo Preparando o Oracle Enterprise Linux 5.6 para Instalação do Banco de Dados Oracle 11gR2.

Preparando o Oracle Enterprise Linux 5.6 para Instalação do Banco de Dados Oracle 11gR2

Após fazer o download do Software Oracle 11g R2 e descompactado com o UNZIP no Linux no diretório raiz “/u01/app/oracle/database” vamos iniciar nossa instalação do Software Oracle 11g R2.

[oracle@srvoracle11g oracle]$ ls -ltr
total 8
drwxr-xr-x 8 oracle oinstall 4096 Aug 18  2009 database
drwxrwxr-x 3 oracle oinstall 4096 Dec  2 14:18 product
[oracle@srvoracle11g oracle]$ cd database/
[oracle@srvoracle11g database]$ pwd
/u01/app/oracle/database
[oracle@srvoracle11g database]$ ls -ltr
total 40
-rwxr-xr-x  1 oracle oinstall 4352 Aug 14  2009 runInstaller
drwxr-xr-x  4 oracle oinstall 4096 Aug 14  2009 install
drwxr-xr-x  2 oracle oinstall 4096 Aug 14  2009 rpm
drwxr-xr-x 14 oracle oinstall 4096 Aug 14  2009 stage
drwxrwxr-x  2 oracle oinstall 4096 Aug 14  2009 sshsetup
drwxrwxr-x  2 oracle oinstall 4096 Aug 14  2009 response
drwxr-xr-x 12 oracle oinstall 4096 Aug 17  2009 doc
-rw-r--r--  1 oracle oinstall 5400 Aug 17  2009 welcome.html
[oracle@srvoracle11g database]$

Vamos iniciar nosso instalação executando o “./runInstaller”.

[oracle@srvoracle11g database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 80 MB.   Actual 1619 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] y


>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-29_03-05-43PM. Please wait ...

>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-29_03-05-43PM. Please wait ...[oracle@srvoracle11g database]$ Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified

Exception in thread "main" java.lang.NoClassDefFoundError
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at java.awt.Toolkit$2.run(Toolkit.java:821)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
        at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source)
        at com.jgoodies.looks.LookUtils.<clinit>(Unknown Source)
        at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:122)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:242)
        at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783)
        at javax.swing.UIManager.setLookAndFeel(UIManager.java:480)
        at oracle.install.commons.util.Application.startup(Application.java:758)
        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
        at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
        at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
        at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

[oracle@srvoracle11g database]$ 

O erro acima ocorrido ocasionado pela falta da exportação do DISPLAY.

DISPLAY

Quando você executa “startx” no sistema local, ele define a variável DISPLAY para algo como: DISPLAY =: 0.0 programas X cliente ver este valor sob Linux ou UNIX irá tentar se conectar ao servidor X através de um soquete de domínio UNIX locais (um dos nós do sistema de arquivos uma cujas permissões / tipo começa com um “s” na saída de um “longo” ‘ls’). Que trabalha para os processos locais de falar com o servidor X local.
No entanto, para iniciar um processo remoto que precisa falar com o seu servidor X local, você deve configurar a variável DISPLAY para um número de hostname e mostrar. O que você precisa é algo como DISPLAY = 192.168.56.110:0.0 (IP) ou DISPLAY = srvoracle11g.localdomain:0.0 (Hostname).

[oracle@srvoracle11g database]$ hostname
srvoracle11g.localdomain
[oracle@srvoracle11g database]$ DISPLAY=srvoracle11g.localdomain:0.0; export DISPLAY
[oracle@srvoracle11g database]$ 

Vamos executar novamente o “./runInstaller”.

[oracle@srvoracle11g oracle]$ database/./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 80 MB.   Actual 1024 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-29_03-17-26PM. Please wait ...[oracle@srvoracle11g oracle]$ 

[oracle@srvoracle11g database]$

Vamos executar os Scripts na Instalação do Software dando permissão para o usuário “root”.
Segue os Scripts.
“/u01/app/oraInventory/orainstRoot.sh”
“/u01/app/oracle/product/11.2.0/db_1/root.sh”

Este scripts está na Imagem no final da Instalação do Software Oracle 11g R2.

[oracle@srvoracle11g database]$ su -
Password: 
[root@srvoracle11g ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@srvoracle11g ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@srvoracle11g ~]# 

Usando o DBCA para Instalação do Banco de Dados Oracle.

[oracle@srvoracle11g database]$ dbca
[oracle@srvoracle11g database]$
[oracle@srvoracle11g database]$ netca
[oracle@srvoracle11g database]$

Após a criação do Listener vamos configurar o mesmo.

[oracle@srvoracle11g admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2012 11:43:30

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.110)(PORT=1521)))
The command completed successfully
[oracle@srvoracle11g admin]$

Use esta configuração abaixo para configurar o Listener.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.110)(PORT = 1521))
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
)
)

[oracle@srvoracle11g admin]$ vi $ORACLE_HOME/network/admin/listener.ora
[oracle@srvoracle11g admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.110)(PORT = 1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=orcl)
         (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@srvoracle11g admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2012 11:44:30

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srvoracle11g/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.110)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.110)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                06-JAN-2012 11:44:31
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/srvoracle11g/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.110)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@srvoracle11g admin]$

Pronto instalamos o software Oracle e criamos o Banco de Dados Oracle 11g R2.
Mais informações acessar o documento Oracle. Oracle Documentation.

%name Instalando Banco de Dados Oracle 11gR2 em Oracle Enterprise Linux 5.6

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.