¿Instalando EM12c? Warning: Limit of open file descriptors is found to be 1024

Posted by Paola Pullas | Posted in Administración, Base de Datos, Oracle | Posted on 01-07-2013

Tags: , , , ,

0

¿Está instalando EM12c y se encuentra con un warning que impide subir los servicios de la consola?. La solución es fácil.

Primero a continuación les pongo el error para que puedan compararlo con lo que están haciendo:

/bin/emctl start oms
Starting WebTier…
WebTier Successfully Started
Starting Oracle Management Server…
Oracle Management Server is not functioning because of the following reason:
Unexpected error occurred. Check error and log files.
WARNING: Limit of open file descriptors is found to be 1024.
For proper functioning of OMS, please set “ulimit -n” to be at least 4096.

El error mencionado puede presentarse durante la instalación o ya en operación. Para esto debe:

OMS_ORACLE_HOME>/bin/emctl stop oms -all -force

Luego buscamos si algún proceso STALE quedó corriendo y si es así los matamos (ojo solo los STALE y que tengan que ver con la consola):

ps -ef | grep EMGC_OMS1
ps -ef | grep EMGC_ADMINSERVER
ps -ef | grep java

Seteamos el valor correcto de ulimit:

ulimit -n 4096

Intentamos levantar nuevamente la consola:

OMS_ORACLE_HOME/bin/emctl start oms

¿Instalando EM12c? Asegúrese de descomprimir bien los archivos

Posted by Paola Pullas | Posted in Administración, Base de Datos, Tips, Unix/Linux | Posted on 01-07-2013

Tags: , ,

0

Si se encuentran con el siguiente error:

oracle.sysman.oii.oiii.OiiiInventoryDoesNotExistException: The inventory pointer location /etc/oraInst.loc is either not readable or does not exist
at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl
(OiiiInstallAreaControl.java:1858)
at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession
(OiicStandardInventorySession.java:292)
at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession
(OiicStandardInventorySession.java:231)
at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession
(OiicStandardInventorySession.java:180)
at oracle.sysman.install.oneclick.EMGCGetUpgradeableHomes.initInventorySession
(EMGCGetUpgradeableHomes.java:411)
at oracle.sysman.install.oneclick.EMGCGetUpgradeableHomes.getHomes
(EMGCGetUpgradeableHomes.java:117)
at oracle.sysman.install.oneclick.EMGCGetUpgradeableHomes.getInstance
(EMGCGetUpgradeableHomes.java:107)
at oracle.sysman.install.oneclick.EMGCInstallSettingsDlg.m_createupgradeTblSCrollPane
(EMGCInstallSettingsDlg.java:828)
at oracle.sysman.install.oneclick.EMGCInstallSettingsDlg.createMainPanel
(EMGCInstallSettingsDlg.java:252)
at oracle.sysman.install.oneclick.EMGCInstallSettingsDlg.
(EMGCInstallSettingsDlg.java:165)
………

Muy seguramente descomprimieron el instalador en carpetas separadas, o cuando hicieron la descompresión algo no fue bien. Siempre los instaladores deben descomprimirse en la misma carpeta y debes asegurarte que el proceso sea correcto, caso contrario, pasarás horas tratando se resolver un problema que se debe a un mal proceso de descompresión de archivos.

Paola Pullas

OTN LAD Tour 2013 – Expertos de Oracle en Quito

Posted by Paola Pullas | Posted in Noticias | Posted on 28-06-2013

Tags: , , , , , , , , , , , ,

2

Fecha: Lunes 15 de Julio de 2013
Lugar: Hotel Sheraton
Horario: 8h00 a 18h00
Inscripciones: Llamando al 6037651 / 6037652 o escribiendo a paola.pullas@ecuoug.org / mariajose.vela@ecuoug.org

Cuentos de un DBA: Backup de RMAN a un NFS

Posted by Paola Pullas | Posted in Base de Datos | Posted on 04-06-2013

Tags: , , ,

0

Ayer estaba intentando enviar un backup de RMAN a un NFS y RMAN me arrojaba como error que el directorio NFS no había sido montado con las opciones correctas. El error exacto es: ORA-27054: NFS file system where the file is created or resides is not mounted with correct options.

Este error se puede presentar cuando están trabajando con RMAN o expdp e intentan trabajar con un NFS que no tiene la opción “noac” seteada.

La solución en este caso es guardar los respaldos de RMAN o del utilitario expdp en otra ubicación o setear el evento que detallo a continuación a nivel de la base de datos:

ALTER SYSTEM SET EVENTS ’10298 trace name context forever, level 32′;

Oracle, parches y más…

Posted by Paola Pullas | Posted in Base de Datos, Oracle | Posted on 17-02-2013

Tags: , , , , , , , ,

1

A continuación una práctica lista de los parches asociados a las versiones de base de datos Oracle desde 8i hasta 11g:

Información para Oracle 11g:

11.2.0.3.5 14727310 DATABASE PATCH SET UPDATE 11.2.0.3.5 (INCLUDES CPUJAN2013)
11.2.0.3.4 14275605 DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPUOCT2012)
11.2.0.3.3 13923374 DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES CPU JUL2012)
11.2.0.3.2 13696216 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)
11.2.0.3.1 13343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
11.2.0.3 10404530 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
11.2.0.2.9 14727315 DATABASE PATCH SET UPDATE 11.2.0.2.9 (INCLUDES CPUJAN2013)
11.2.0.2.8 14275621 DATABASE PATCH SET UPDATE 11.2.0.2.8 (INCLUDES CPUOCT2012)
11.2.0.2.7 13923804 DATABASE PATCH SET UPDATE 11.2.0.2.7 (INCLUDES CPU JUL2012)
11.2.0.2.6 13696224 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)
11.2.0.2.5 13343424 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)
11.2.0.2.4 12827726 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
11.2.0.2.3 12419331 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
11.2.0.2.2 11724916 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
11.2.0.2.1 10248523 DATABASE PSU 11.2.0.2.1
11.2.0.2 10098816 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER
11.2.0.1.6 12419378 DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
11.2.0.1.5 11724930 DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)
11.2.0.1.4 10248516 DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)
11.2.0.1.3 9952216 DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)
11.2.0.1.2 9654983 DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
11.2.0.1.1 9352237 DATABASE PSU 11.2.0.1.1
11.1.0.7.14 14739378 [*] DATABASE PATCH SET UPDATE 11.1.0.7.14 (INCLUDES CPUJAN2013)
11.1.0.7.13 14275623 [*] DATABASE PATCH SET UPDATE 11.1.0.7.13 (INCLUDES CPUOCT2012)
11.1.0.7.12 13923474 DATABASE PATCH SET UPDATE 11.1.0.7.12 (INCLUDES CPU JUL2012)
11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
11.1.0.7.10 13343461 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)
11.1.0.7.9 12827740 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
11.1.0.7.8 12419384 DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
11.1.0.7.7 11724936 DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
11.1.0.7.6 10248531 DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11.1.0.7.5 9952228 DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
11.1.0.7.4 9654987 DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
11.1.0.7.3 9352179 DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
11.1.0.7.2 9209238 DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
11.1.0.7.1 8833297 DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
11.1.0.7 6890831 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER

Información para Oracle 10g:

10.2.0.5.10 14727319 [*] DATABASE PATCH SET UPDATE 10.2.0.5.10 (INCLUDES CPUJAN2013)
10.2.0.5.9 14275629 [*] DATABASE PATCH SET UPDATE 10.2.0.5.9 (INCLUDES CPUOCT2012)
10.2.0.5.8 13923855 [*] DATABASE PATCH SET UPDATE 10.2.0.5.8 (INCLUDES CPU JUL2012)
10.2.0.5.7 13632743 [*] DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)
10.2.0.5.6 13343471 [*] DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)
10.2.0.5.5 12827745 [*] DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
10.2.0.5.4 12419392 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
10.2.0.5.3 11724962 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
10.2.0.5.2 10248542 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10.2.0.5.1 9952230 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10.2.0.5 8202632 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.4.15 14736542 [*] DATABASE PSU 10.2.0.4.15 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJAN2013)
10.2.0.4.14 14275630 [**] DATABASE PSU 10.2.0.4.14 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2012)
10.2.0.4.13 13923851 [*] DATABASE PSU 10.2.0.4.13 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2012)
10.2.0.4.12 12879933 [*] DATABASE PSU 10.2.0.4.12 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUAPR2012)
10.2.0.4.11 12879929 [*] DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
10.2.0.4.10 12827778 DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2011)
10.2.0.4.9 12419397 DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2011)
10.2.0.4.8 11724977 DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUAPR2011)
10.2.0.4.7 10248636 DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJAN2011)
10.2.0.4.6 9952234 DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2010)
10.2.0.4.5 9654991 DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2010) [overlay PSU]
10.2.0.4.4 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
10.2.0.4.3 9119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
10.2.0.4.2 8833280 DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
10.2.0.4.1 8576156 DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
10.2.0.4 6810189 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.3 5337014 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.2 4547817 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
10.1.0.5 4505133 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER
10.1.0.4 4163362 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER
10.1.0.3 3761843 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER

Información para Oracle 9i:

9.2.0.8 4547809 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.7 4163445 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.6 3948480 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.5 3501955 ORACLE 9I DATABASE SERVER RELEASE 2 – PATCH SET 4 VERSION 9.2.0.5.0
9.2.0.4 3095277 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.3 2761332 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.2 2632931 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
9.0.1.5 3301544 9.0.1.5 PATCHSET
9.0.1.4 2517300 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER
9.0.1.3 2271678 9.0.1.3. PATCH SET FOR ORACLE DATA SERVER

Información para Oracle 8i:

8.1.7.4 2376472 8.1.7.4 PATCH SET FOR ORACLE DATA SERVER
8.1.7.3 2189751 8.1.7.3 PATCH SET FOR ORACLE DATA SERVER
8.1.7.2 1909158 8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER

[*] 10.2.0.4 and 10.2.0.5 are now in extended support mode and PSU’s released after Aug 01,2011 will need ES License to download them.
[**] Available only in limited platforms

Fuente: Oracle Support

OEM 12c: Compatibilidad

Posted by Paola Pullas | Posted in Administración, Oracle | Posted on 31-10-2012

Tags: , ,

9

Al momento me encuentro dictando un taller de Oracle Enterprise Manager 12c para Oracle University y una de las preguntas clave con las que deberíamos empezar hace referencia a la compatibilidad del producto. En este post voy a colocar un listado de compatibilidad del producto a diferentes niveles. Para quienes están comenzando con la herramienta les será muy útil pues el listado que coloco a continuación es un overview para empezar a trabajar con el producto:

Enterprise Applications (4 Items)

  • Enterprise Manager Ops Center Plug-in
  • 1 Release(12.1.0.1.0)

  • JD Edwards EnterpriseOne Tools (Managed Target)
  • 1 Release(8.97+)

  • Oracle Fusion Applications (Managed Target)
  • 1 Release(11.1.1.5.1)

  • Siebel Enterprise (Managed Target)
  • 3 Releases(8.1.1,8.0.0,7.8.2)

Databases (8 Items)

  • Audit Vault 10.3.0.0.0 (Managed Target)
  • 1 Release(10.3.0.0.0)

  • IBM DB2 (Managed Target)
  • 1 Release(9.1)

  • Microsoft SQL Server (Managed Target)
  • 2 Releases(2008 R2,2005)

  • Oracle Audit Vault (Managed Target)
  • 1 Release(10.2.3.2)

  • Oracle Database (Managed Target)
  • 8 Releases(11.2.0.3.0,11.2.0.2.0,11.2.0.1.0,11.1.0.7.0,10.2.0.5.0,10.2.0.4.0,10.1.0.5.0,9.2.0.8.0)

  • Oracle Database (Repository)
  • 5 Releases(11.2.0.3.0,11.2.0.2.0,11.2.0.1.0,11.1.0.7.0,10.2.0.5.0)

  • Oracle Exadata Storage Server (Managed Target)
  • 3 Releases(11.2.3.1.0,11.2.2.4.0,11.2.2.3.0)

  • Sybase Adaptive Server Enterprise (Managed Target)
  • 1 Release(12.5.4)

Virtualization Software (1 Item)

  • Oracle VM Server for x86
  • 3 Releases(3.1.1.0.0,3.0.3.0.0,3.0.2.0.0)

Desktop Applications, Browsers and Clients (5 Items)

  • Adobe Flash Player
  • 2 Releases(10.3+,10)

  • Firefox
  • 3 Releases(5+,4,3.6)

  • Google Chrome
  • 1 Release(17)

  • Internet Explorer
  • 4 Releases(9.x,9,8,7)

  • Safari
  • 2 Releases(5,4)

Middleware / Application Servers (35 Items)

  • Apache Tomcat (Managed Target)
  • 5 Releases(7.*,6.0.*,5.5.*,5.0.30,5.0.3+)

  • Directory Integration Platform (Managed Target)
  • 1 Release(11.1.1.2.0)

  • IBM WebSphere Application Server (Managed Target)
  • 3 Releases(7.*,6.1,6.0)

  • IBM WebSphere MQ (Managed Target)
  • 2 Releases(7.0.*,6.0.*)

  • IBM WebSphere Portal Server (Managed Target)
  • 3 Releases(7.0.0.0,6.1.0.2+,6.0.1+)

  • JBoss Application Server (Managed Target)
  • 4 Releases(6.*,5.0.1,4.2.*,4.0.*)

  • Microsoft .NET Framework (Managed Target)
  • 3 Releases(3.0.*,2.0.*,1.1.*)

  • Microsoft Active Directory (Managed Target)
  • 2 Releases(2008,2003)

  • Microsoft BizTalk Server (Managed Target)
  • 1 Release(2004)

  • Microsoft Internet Information Server (Managed Target)
  • 3 Releases(7.0,6.0,5.0+)

  • Oracle Access Manager (Managed Target)
  • 4 Releases(11.1.1.5.0,11.1.1.3.0,10.1.4.3.0,10.1.4.2.0)

  • Oracle Adaptive Access Manager (Managed Target)
  • 2 Releases(11.1.1.5.0,11.1.1.3.0)

  • Oracle Application Server (Managed Target)
  • 3 Releases(10.1.3.5.0,10.1.3.4.0,10.1.2.3.0)

  • Oracle BPEL Process Manager (Managed Target)
  • 4 Releases(10.1.3.5.0,10.1.3.4.0,10.1.3.3.0,10.1.3.1.0)

  • Oracle Business Intelligence Enterprise Edition (Managed Target)
  • 4 Releases(11.1.1.6.0,11.1.1.5.0,10.1.3.4.1,10.1.3.4.0)

  • Oracle Business Intelligence Publisher (Infrastructure)
  • 1 Release(11.1.1.6.0)

  • Oracle Coherence (Managed Target)
  • 6 Releases(3.7.1.0.0,3.7.0.0.0,3.6.1.0.0,3.6.0.0.0,3.5.0.0.0,3.4.0.0.0)

  • Oracle Directory Integration Platform (Managed Target)
  • 2 Releases(10.1.4.3.0,10.1.4.2.0)

  • Oracle Directory Server Enterprise Edition (Managed Target)
  • 1 Release(11.1.1.5.0)

  • Oracle Enterprise Content Management (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle Forms (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle Fusion Middleware (Infrastructure)
  • 1 Release(11.1.1.6.0)

  • Oracle HTTP Server (Managed Target)
  • 7 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0,10.1.2.0.0)

  • Oracle Identity Federation (Managed Target)
  • 3 Releases(11.1.1.2.0,10.1.4.3.0,10.1.4.2.0)

  • Oracle Identity Management (Managed Target)
  • 2 Releases(10.1.4.3.0,10.1.4.2.0)

  • Oracle Identity Manager (Managed Target)
  • 3 Releases(11.1.1.3.0,9.1.0.2.0,9.1.0.1.0)

  • Oracle Reports (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle SOA Suite (Managed Target)
  • 6 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle Service Bus (Managed Target)
  • 9 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,10.3.1.0.0,10.3.0.0.0,3.0.0.0.0,2.6.1.0.0,2.6.0.0.0)

  • Oracle Virtual Directory (Managed Target)
  • 4 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle WebCenter (Managed Target)
  • 4 Releases(11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle WebLogic Portal (Managed Target)
  • 4 Releases(10.3.3.0.0,10.3.2.0.0,10.3.1.0.0,10.3.0.0.0)

  • Oracle WebLogic Server (Infrastructure)
  • 1 Release(10.3.5.0.0)

  • Oracle WebLogic Server (Managed Target)
  • 7 Releases(12.1.1.0.0,10.3.6.0.0,10.3.5.0.0,10.3.4.0.0,10.3.3.0.0,10.3.2.0.0,9.2)

  • WebLogic Server (Managed Target)
  • 4 Releases(9.2,9.1,9.0,8.1)

Operating Systems (7 Items)

  • IBM AIX on POWER Systems (64-bit)
  • 3 Versions(7.1,6.1,5.3)

  • Linux x86
  • 7 Versions(SLES 11,SLES 10,Red Hat Enterprise Linux 5,Red Hat Enterprise Linux 4,Oracle Linux 5,Oracle Linux 4,Asianux 3)

  • Linux x86-64
  • 8 Versions(SLES 11,Red Hat Enterprise Linux 6,Red Hat Enterprise Linux 5,Red Hat Enterprise Linux 4,Oracle Linux 6,Oracle Linux 5,Oracle Linux 4,Asianux 3)

  • Microsoft Windows x64 (64-bit)
  • 4 Versions(7,2008 R2,2008,2003)

  • Oracle Exalogic Infrastructure (Managed Target)
  • 3 Releases(2.0.0.0.0,1.0.0.2.1,1.0.0.1.0)

  • Oracle Solaris on SPARC (64-bit)
  • 3 Versions(9,11,10u9)

  • Oracle Solaris on x86-64 (64-bit)
  • 2 Versions(11,10u9)

OTN Tour 2012 llegó el momento de la inscripción a nuestro evento

Posted by Paola Pullas | Posted in Administración, Aplicaciones, Base de Datos, JDeveloper, Noticias, Oracle, Oracle XE | Posted on 19-06-2012

Tags: , , , , , , , , , , ,

9

Estimados Amigos,

Se acerca el evento de tecnología Oracle más importante del año a Ecuador. Este año contaremos con la participación de 8 expositores internacionales y hasta 5 tracks de capacitación en tecnología de los cuales podrán elegir.

A continuación los detalles y costos del evento:

Fecha: 6 de Julio de 2012
Lugar: Universidad de las Américas, Campus Av. de los Granados y Colimes esq, Quito – Ecuador, Auditorio 1 y 2.
Costo del Evento: 150USD o 100USD por día. Estudiantes cuentan con el 50% de descuento si presentan el carnet de su universidad.
Pago del Evento: El pago del evento podrá hacerse mediante depósito en la cuenta corriente #02054016475 del Banco Produbanco a nombre de Refundation o realizar el pago en efectivo en nuestras oficinas ubicadas en la Checoslovaquia y Av. Eloy Alfaro, Edf. Cuarzo, Piso 5, Of. 2. Una vez que haya realizado el pago deberá enviar un correo electrónico a inscripcion@ecuoug.org con la papeleta de depósito escaneada e indicando el track de capacitación en el cual desea reservar su cupo.
Retiro de credenciales: El retiro de credenciales de acceso al evento deberá hacerse entre el día Viernes 29 de Junio y Martes 3 de Julio en las oficinas de Refundation ubicadas en la Checoslovaquia y Av. Eloy Alfaro, Edf. Cuarzo, Piso 5, Of. 2.
Acceso a tracks de capacitación por el pago de 150USD: Por el pago de 150USD tendrá acceso a:

  • Evento del 6 de Julio de 2012
  • Accceso a un track de capacitación los cuales se dictarán el 4 y 5 de Julio. Usted podrá elegir entre: Oracle DBA en 2 días, High Availability con Oracle Real Application Clusters, Disaster Recovery con Oracle Data Guard u Oracle Security.
  • Acceso al Track de CIO’s en donde se tratará temas como ITIL, Cobit, Licenciamiento de Productos Oracle y demás..
  • Acceso a almuerzo, servicio de coffe break a media mañana y media tarde y cocktail.

Agenda del Evento: Descargar de Agenda del Evento OTN LAD Tour 2012 (1225) la agenda del evento para el día 6 de Julio.

Las personas que se inscriban y realicen el pago hasta el día Lunes 25 de Junio automáticamente participarán por el sorteo de una Notebook. En su credencial de acceso constará el número para participar en el sorteo.

OTN Tour 2012 – 4,5,6 de Julio de 2012 Quito Ecuador

Posted by Paola Pullas | Posted in Entrenamiento, Noticias, Oracle | Posted on 31-05-2012

Tags: , , , , , , , , , , ,

7

En 30 días Ecuador tendrá al evento de tecnología más grande e importante realizado durante el año. Tendremos 3 días de conocimiento distribuídos entre el 4 y 6 de Julio en la Universidad de las Américas en la sede ubicada en la Av. de los Granados y Colimes esq, Quito – Ecuador.

Lo invitamos a inscribirse en nuestra página web http://www.ecuoug.org/otn12.

Post 1 – 2011: How to Install Oracle Apex 4.0

Posted by Paola Pullas | Posted in Noticias | Posted on 13-03-2011

3

Preinstallation Requirements

Review and satisfy all Oracle Application Express installation requirements:

  • Oracle Application Express version 4.0 requires an Oracle database (Enterprise Edition, Standard Edition or Standard Edition One) that is release 10.2.0.3 or higher. Application Express 4.0 can also be used with Oracle Database 10g Express. I will show you how to verify your database version:

  • SELECT * FROM V$VERSION;

  • Oracle Application Express requires the SHARED_POOL_SIZE of the target database to be at least 100 MB. Ignore this requirement if your configuration uses non-null values for the database initialization parameters SGA_TARGET (in Oracle Database 10g and 11g) or MEMORY_TARGET (in Oracle Database 11g). In my case I am using MEMORY_TARGET, but I will show you how to verify and modify the SHARED_POOL_SIZE parameter:

  • SHOW PARAMETER SHARED_POOL_SIZE
    ALTER SYSTEM SET SHARED_POOL_SIZE=’100M’ SCOPE=spfile;
    SHUTDOWN
    STARTUP

    I will show you the configuration of my database. I have MEMORY_TARGET parameter so I don’t need to follow the steps above:

  • To view or develop Oracle Application Express applications, Web browsers must support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers are required to develop applications in Oracle Application Express:

  • Microsoft Internet Explorer 7.0 or later version
    Mozilla Firefox 3.5 or later version
    Google Chrome 4.0 or later version
    Apple Safari 4.0 or later version

  • In order to run, Oracle Application Express you must have access to one of the following:

  • Oracle Application Express Listener
    Embedded PL/SQL gateway
    Oracle HTTP Server and mod_plsql

  • Oracle Application Express disk space requirements are as follows:

  • Free space for Oracle Application Express software files on the file system: 450 MB if using English only download (apex_4_0_en.zip) and 1 GB if using full download (apex_4_0.zip). You can use operating system commands to verify if you have free space to install the product:

    df -h

    Free space in Oracle Application Express tablespace: 185 MB

    Free space in SYSTEM tablespace: 100 MB

    Free space in Oracle Application Express tablespace for each additional language (other than English) installed: 75 MB

  • Oracle XML DB must be installed in the Oracle database that you want to use. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

Download and Install Oracle Application Express

  • Download the product from:

  • http://www.oracle.com/technology/products/database/application_express/download.html

  • Unzip downloaded zip file:

  • unzip apex_4.0.2.zip

  • Change your working directory to apex. For example:

  • cd apex

  • Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

  • sqlplus / as sysdba

  • Select the appropriate installation option. In my case I will install the full development environment that provides complete access to the Application Builder environment to develop applications. A runtime environment that is the other option enables users to run applications that cannot be modified. In order to install the full development environment you should run apexins.sql passing the following four arguments in the order shown:

  • @apexins tablespace_apex tablespace_files tablespace_temp images

    Where:

    tablespace_apex is the name of the tablespace for the Oracle Application Express application user.

    tablespace_files is the name of the tablespace for the Oracle Application Express files user.

    tablespace_temp is the name of the temporary tablespace.

    images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.

    When Oracle Application Express installs it creates three new database accounts:

    APEX_040000 – The account that owns the Oracle Application Express schema and metadata.

    FLOWS_FILES – The account that owns the Oracle Application Express uploaded files.

    APEX_PUBLIC_USER – The minimally privileged account used for Oracle Application Express configuration with Oracle HTTP Server and mod_plsql or Oracle Application Express Listener.

  • In a new installation of Oracle Application Express, or if you are converting a runtime environment to a development environment, you must change the password of the internal ADMIN account. Change your working directory to the apex directory where you unzipped the installation software and run apxchpwd.sql script:

  • The embedded PL/SQL gateway installs with the Oracle Database 11g. However, you must configure it before you can use it with Oracle Application Express. To accomplish this, you run a configuration file and unlock the ANONYMOUS account:

  • The embedded PL/SQL gateway runs in the Oracle XML DB HTTP server in the Oracle database. You can determine if the Oracle XML DB HTTP server is enabled by verifying the associated port number. To verify the port number where the Oracle XML DB HTTP Server is running:

  • select dbms_xdb.gethttpport from dual;

Day 6: Tip Log_Archive_Dest_1 Set To Default in Oracle Database 11.1

Posted by Paola Pullas | Posted in Base de Datos, Oracle, Tips | Posted on 03-10-2010

Tags: , , , ,

6

In this post I want to share with you the information about the Bug 6373164 present in Oracle Database 11.1. This bug was fixed in release 11.1.0.7.0.

Symptoms

I configured Archivelog Mode in my database and set the flash recovery area like the default location to store achivelog files. I configured the next parameters in order to set the flash recovery area:

  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE

Other parameters related to Archivelog Mode aren’t configured in my linux box, for example:

  • LOG_ARCHIVE_DEST is not set
  • LOG_ARCHIVE_DEST_n is not set

In the next screen I show you my actual configuration:

When the database starts to generate archivelog files, these was send to flash recovery area location but additionally to $ORACLE_HOME/dbs causing higher disk space utilization in my server, like I show you in the next screen:

How to solve the problem

In order to solve this problem you should change the configuration of LOG_ARCHIVE_DEST_1 parameter with the next command:

  • alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;

Author: Paola Pullas
Do you need to buy support?: Contact me at pp@refundation.com

If you think that this tutorial helped you. Make a donation to this initiative. We appreciate your support. Also your donation can help me to buy more coffee or Red Bull.