Límite máximo de procesos para el usuario ORACLE

Posted by josefabre | Posted in Noticias | Posted on 13-05-2014

1

Te has preguntado por que tienes que agregar las lineas siguientes en la instalación de Oracle

Valida los limites actuales con:

[host@localhost ~]$ su – oracle

[host@localhost ~]$ ulimit -u
Archivo de limites del Sistema Operativo.

[host@localhost ~]$vim /etc/security/limits.conf

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              hard    stack   10240

Estos valores son para una instalación correcta . El usuario "oracle " es, básicamente, automatizado, y por lo tanto no aumenta automáticamente el límite suave hasta el valor límite estricto cuando se alcanza el límite blando (que es todo el propósito de su límite suave ) . Si tiene varias instancias en un servidor , ejecutar Java, Weblogic , OBIEE , etc, entonces usted va a golpear ese 2047 límite real rápido, y si ese es su límite.

Quiere decir que cada acceso al servidor tiene su límite de procesamiento y estos límites,  mejoran el rendimiento de su servidor

 

OTN LAD Tour 2013 – Expertos de Oracle en Quito

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

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

3

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

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 (2215) 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: , , , , , , , , , , ,

10

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

12

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;

Charles Philips Resigns as President of Oracle

Posted by Paola Pullas | Posted in Noticias | Posted on 06-09-2010

Tags: , ,

27

According to a communicate published in http://www.marketwire.com/press-release/Charles-Phillips-Resigns-as-President-of-Oracle-NASDAQ-ORCL-1314228.htm Charles Philips resigns as President of Oracle Corporation.

Oracle (NASDAQ: ORCL) today announced that Charles Phillips has resigned his position as President and as a member of the board of directors.

“Charles has evolved our field culture toward a more customer-centric organization and improved our top line consistency through a period of tremendous change and growth,” said Oracle CEO Larry Ellison. “When Charles approached me last December and expressed his desire to transition out of the company, I asked him to stay on through the Sun integration which has gone well. We will miss his talent and leadership, but I respect his decision.”

“I want to thank Larry Ellison and the Oracle Board of Directors for the tremendous opportunity to be a part of an important and winning team for the last 29 quarters,” said Phillips. “It has been an honor to work with them, Safra Catz, and the thousands of Oracle employees around the world who are committed to delivering high quality products and services to customers, and to be a part of one of the most innovative companies on the planet.”

Paola Pullas’s Oracle Magazine Interview

Posted by Paola Pullas | Posted in Noticias, Opinión, Oracle | Posted on 24-08-2010

Tags: , , , , , , ,

1

Oracle Magazine Interview published at: http://www.oracle.com/technetwork/oramag/2010/10-sep/o50upclose-165467.html

COMMUNITY: Up Close

As Published In
Oracle Magazine
September/October 2010

Stronger Together
By Jeff Erickson

A growing Ecuadorian user group builds ties with its Latin American neighbors.

Paola Pullas knows how to do a lot with a little. With the nearest Oracle corporate office in neighboring Colombia and user group members spread across a geographically diverse nation, Pullas, president of the Ecuador Oracle Users Group (ECUOUG), is helping to forge a single Oracle user group that can attract top speakers and make its voice heard.

ECUOUG represents more than 200 corporate members in the country’s major industries, including mining, construction, and telecommunications, as well as agricultural production of crops such as bananas, cocoa, and flowers. “We have three main telecommunications companies in Ecuador, and all of them are members of our group,” says Pullas. “But there are many smaller businesses, such as in our flower industry, that are coming to us.”

Across the Stack

The group holds as many as 12 meetings a year, mostly in Quito, Ecuador’s capital city, and mostly on subjects such as Oracle Database, Oracle WebLogic Server, and Oracle JDeveloper. But the group is expanding to support other parts of the technology stack. “We’ve found that lots of midsize companies in Ecuador use [Oracle’s] JD Edwards, and many of our members use [Oracle’s] PeopleSoft and Siebel,” says Pullas. “We are in the process of launching an applications user group within ECUOUG.”

With Oracle’s acquisition of Sun, ECUOUG is also reaching out to Sun users through a new Sun special interest group and is working with an existing Java user group to fold it into ECUOUG. “As a small country, we want to bring all Oracle users, Sun, applications, Java, and tech under one roof,” says Pullas.

With members dotted across Ecuador, the ECUOUG community has become adept at using social media to communicate. The group is easy to find and follow on Facebook, Twitter, and Oracle Mix. Its blog, at ecuoug.org, was the online foundation from which the current user group was formed, and it is still a great place to keep up with Oracle technologists in Ecuador. “We organize our live event each month to share experiences and network because we want to cover all the subjects and we want this community to stay together,” says Pullas. “In between events, we go online to share tutorials, tips, and news.”

Banding Together

On the heels of a successful Oracle OpenWorld conference in São Paulo, Brazil, in 2009, the Latin American user group community began working together to keep the momentum going. User group leaders organized a Latin American user group council, with each member country providing a board member. Pullas is the board member from Ecuador. Current member countries include Argentina, Brazil, Chile, Colombia, Costa Rica, Mexico, Peru, Uruguay, and Ecuador.

For 2010 the group has organized what Pullas calls a Latin American Oracle Technology Network tour. The plan, says Pullas, is for smaller countries to hold their annual meetings in quick succession so that top speakers can make a swing through Latin America and visit several user groups along the way. Top Oracle ACEs from the U.S. and Europe and speakers from Oracle Consulting are expected to make the trip—even Oracle architect and Oracle Magazine columnist Tom Kyte is on the bill in some countries. Ecuador’s event is scheduled for October. “We are now working like one big integrated community,” says Pullas. “We know that Latin American technologists are a big presence in the Oracle world, and this community will be a voice for sharing our experiences with members in neighboring countries and with Oracle.”

Project Oracle Open World

Posted by Paola Pullas | Posted in Noticias | Posted on 20-08-2010

Tags: , , , , ,

0

In one month we are going to attend at Moscone Center in San Francisco to the Oracle Open World 2010 from September 19 to 23.

In order to collaborate with Oracle Community around the world we are going to post one technical article per day until Oracle Open World starts.

Autor: Paola Pullas

JDeveloper 11g on MAC OS X

Posted by Paola Pullas | Posted in Noticias | Posted on 12-02-2010

Tags:

0

This days I had a issue while I tried to work with JDeveloper 11g (11.1.1.2.0) Studio Edition on a MAC OS X, when I tried to lunch the installer I got this error:

java.lang.OutOfMemoryError

this bug look like a problem since version 1.4 and 1.5 from Sun/Oracle Java version’s.

To fix this problem you have to update the jave version, in my case I had 3 java’s versions 1.4, 1.5 and 1.6, but by default my system was working with 1.5.

To change the default java version you have to go to:

Applications -> Utilities -> Java Preferences

Here you have to drag and drop in the java aplications the Java SE 6 at the begin.

Mac OS X Java Versions

Mac OS X Java Versions

That’s all then just open a terminal a type:

java -jar jdevstudio11112install.jar

then you should get this:

jdeveloper-macosx-11g

Note: Please review this to choose the Java Home

http://www.oracle.com/technology/products/jdev/htdocs/11/knownissues.html#install4

Welcome My Oracle Support

Posted by Paola Pullas | Posted in Noticias, Oracle | Posted on 05-11-2009

Tags: , ,

1

A continuación transcribimos algunos puntos a tomar en cuenta durante el período de transición hacia My Oracle Support:

Oracle Global Customer Support is pleased to announce that My Oracle Support—Oracle’s next-generation support platform—will be upgraded beginning this weekend, November 6-8, 2009, to become the single online support platform for all Oracle products. At that time, Classic MetaLink will retire.

Summary of Changes

During the upgrade period, My Oracle Support will be temporarily unavailable; however, Global Customer Support will be accessible via telephone for your Service Request needs. Please be advised that the upgrade will impact your current login credentials, Service Request (SR) history, and assigned SR numbers as follows:

  • Simplified Login: The authentication process for My Oracle Support will be simplified. Now only one login—your Oracle Single Sign-On (SSO)—will be required, enabling access to multiple Oracle Web sites. If you have not yet established an SSO login, please refer to the “Use Your Single Sign On” section below.

  • Service Request History: SRs which are currently “open” and those “closed” within the last six months will migrate to My Oracle Support in their entirety. Those SRs closed more than six months ago and within the last two years will migrate also, displaying header information only.

  • Assigned Service Request Numbers: A new tracking number with a prefix of 2 (i.e. 2-xxxxxxx) will be assigned to each “open” and “closed” migrated SR. Those SRs created in My Oracle Support after the upgrade will be assigned a prefix of 3 (3-xxxxxxx). The original SR number will be listed in the “Legacy SR” field within the Service Request.

During System Downtime

  • Beginning at approximately 2:00 p.m. Pacific time on Friday, November 6, 2009, My Oracle Support will be unavailable throughout the weekend and until the upgrade is complete. Also, we anticipate that Classic MetaLink will be unavailable beginning Friday, November 6, at approximately 2:00 p.m. Pacific time; however, we expect this outage to be limited. Once Classic MetaLink is back in service, it will be available in read only mode until it is retired at the end of the upgrade period.

  • Classic MetaLink functions such as SR Query, Knowledge Base, Patches & Updates, and Certify will be available during this read-only period. You will need to use your existing Classic MetaLink username and password to access the customer portal.

  • Should you need assistance with any Service Requests during the downtime associated with the upgrade, Global Customer Support will be available via telephone.

Use Your Single Sign-On (SSO) to Log In to My Oracle Support

  • Upon completion of the upgrade, https://metalink.oracle.com will redirect you automatically to the new My Oracle Support site at https://support.oracle.com, which you may begin using at that time. Please note that you must log in with your SSO account to access My Oracle Support. Classic MetaLink will no longer be available.

  • If you have not yet created an Oracle Single Sign-On account, we recommend that you log in to https://metalink.oracle.com prior to November 6, where you will be automatically prompted to create a new SSO login using your email address.

Esperamos tomen en cuenta estas recomendaciones del equipo de soporte de Oracle Corporation.

Autor: Paola Pullas
Vía: Oracle