¿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: , , , ,

1

¿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

OEM 12c: Compatibilidad

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

Tags: , ,

30

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)

Day 4: How to submit SQL commands to Oracle database

Posted by Paola Pullas | Posted in Administración, Base de Datos, Oracle | Posted on 05-09-2010

Tags: , , , , , , ,

4

There are different tools to access Oracle database in order to submit SQL commands. In this section I will show you 3 Oracle tools that you have with no extra cost. Before to review this tutorial review this links:

SQL*Plus

The firs tool is SQL*Plus, this is a command-line interface tool to access to Oracle database. You use SQL*Plus to execute many administrative tasks for example: start up and shut down the database, set database initialization parameters, create and manage users, create and alter database objects (such as tables and indexes), and more. In addition SQL*Plus can be used to insert and update data and run SQL queries.

The format to establish a connection using SQL*Plus is:

  • CONN[ECT] [logon] [AS {SYSOPER | SYSDBA}]
  • {username | /}[@connect_identifier]

In the next screen I will show you some examples in order to gain access to database from SQL*Plus.

  • sqlplus /nolog

  • connect sys/oracle as sysdba

  • conn sys/oracle@eva as sysdba

  • conn system/oracle

  • connect system/oracle@eva

  • connect system/oracle as sysdba

  • conn system/oracle as sysoper

  • conn hr/hr

  • conn hr/hr@eva

Enterprise Manager Dbconsole

Oracle Enterprise Manager Dbconsole is an intuitive graphical interface to administer the database.

In order to gain access to Enterprise Manager you should be a user defined like administrator in the application dbconsole. In the next screen I will show you the users that can login in the Oracle Enterprise Manager Dbconsole. In order to acess this screen you should login in Enterprise Manager Dbconsole like sys user and then go to Setup link in the right upper corner of the application:

In the next screens I will show you some examples in order to login in Enterprise Manager Dbconsole. The url to access have the format https://server_ip:em_port/em. If you don’t know the port to access the application you can find this in the file portlist.ini located in $ORACLE_HOME/install:

SQL Developer

Start the application with sqldeveloper command from a operating system terminal, and next create a connection in the graphical interface like I show you in the next screens:

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.