30. April 2008 by mstaub.

Francisco mi consulta es por un problema que tuve que abordar hace algunos días. Me llegó una alarma por espacio crítico en un filesystem de Oracle, por lo que revisé donde podía quitar archivos y liberar espacio. Mi sorpresa fue que aproximadamente 73 GB de espacio lo ocupaba un directorio de errores del dbconsole donde habían más de 180.000 archivos xml.

Revisando el alert e investigando me di cuenta que los errores almacenados ahi correspondían a un problema de un segmento de memoria que no podía ser cargado. Los archivos se generaban rápidamente y sólo cuando el dbconsole estaba arriba, además los logs y los alert daban problemas con un package como te muestro al final, además de un error en java.

En el dbconsole (web) mostraba un error de TNS desconocido, luego decía “conexión de agente a instancia no disponible”, pero todas las funciones estaban disponibles.

Intenté ejecutar el comando emctl clearstate agent, con lo que el error desaparecía por un momento, pero aparecía un error java.lang y al cabo de cierto tiempo volvía al mismo error de conexión.

La única recomendación que encontré aparte de esa, fue que en metalink recomendaba reinstalar el dbconsole. Me gustaría pedir tu opinión acerca del problema y ver si hay alguna otra alternativa para resolverlo que no involucre reinstalar o simplemente comprender por qué sucede.

 Muchos Saludos Francisco y que estes muy bien.

z2008-04-19 05:48:45,623 [MetadataLoad http://cluster-bd2:3938/emd/main:A0000007151.xml] ERROR eml.XMLLoader markFileAsError.780 - Failed to load A0000007151.xml because of errors; moving to errors directory2008-04-19 05:48:45,629 [HttpRequestHandler-1143098068] ERROR eml.FxferRecv doPost.828 - Upload repsonse header :-ERROR-400|ORA-04063: package body “SYSMAN.EM_CHECK” has errorsORA-06508: PL/SQL: could not find program unit being called: “SYSMAN.EM_CHECK”ORA-06512: at “SYSMAN.EMD_LOADER”, line 1802

ORA-06512: at line 1

Posted in Consultas | Print | 4 Comments »

28. April 2008 by fmunoz.

Uno de los grandes problemas que entrentan muchos DBAs en el mercado actual, es que no saben o no entienden el funcionamento del soporte Oracle, como utilizar las mejores funcionalidades del metalink, etc.

 Ahora podran entender mejor el funcionamento de este utilizando este seminario online de “Trabajando Efectivamente con Soporte Oracle”.

Para acceder a este utilziar el siguiente link: http://oukc.oracle.com/static05/opn/25688/082505_25688/index.htm

Muchos saludos a todos,

Francisco Munoz Alvarez.

 Nota: Mis agradecimientos a Juan Puga por informarme de este material.

Posted in Principal | Print | 1 Comment »

16. April 2008 by fmunoz.

Estimados,

En este momento me encuentro trabajando en notas tecnicas referentes los siguientes temas:

• Parsing (Hard Parse y Soft Parse cual es la diferencia y como funcional realmente) 
• Licencias Oracle
• Como funciona el Oracle (La Instancia)
• Entender NoLogging y Logging Metodologia
• Database Tuning
  • Redologs
  • Datafiles
  • I/O
  • Estadisticas
  • Particionamento
  • Locks

Tambien me encuentro trabajando en un libro que explica facilmente y claramente lo que es y como funciona una BD Oracle y introducion al Lenguage SQL y PL/SQL, en un formato que hasta un TAM (Technical Account Manager) lo entienda.

Tanto en Chile, como en NZ me e dado cuenta que no existem muchos DBAs con experiencia en Tuning y con un real entendimiento de como funciona el Oracle internamente. Mi idea es cambiar eso un poco y darles las herramientas y la informacion necesaria para que todos los DBAs que quieran evolucionar entiendan estas tecnicas y las puedan aplicar en sus respectivos ambientes de trabajo. 

Cada semana estare publicando 1 o mas notas tecnicas para ponerlos al tanto de mis experiencias.

Saludos a todos,

Francisco Munoz Alvarez

Posted in Principal | Print | No Comments »

15. April 2008 by admin.

Estimados,

A partir de ahora hay una seccion de fotos, la podran ver en la esquina superior derecha, “Fotos”. Tengo publicadas algunas fotos del Oracle Open World de Brasil y de Auckland, NZ.

Todos los que deseen publicar una foto, favor enviarla a fmunoz@oracleenespanol.com

Tambien los que desen tener un email de este blog deben enviar un requerimiento al mismo email ariba con el nombre requerido. Ejemplo minombre@oracleenespanol.com.

Muchos Saludos,

Francisco Munoz Alvarez

Posted in Principal | Print | No Comments »

15. April 2008 by jpuga.

Tengo una BD Oracle 9.2.0.4 como puedo saber que parches estan aplicados?

Posted in Consultas | Print | 2 Comments »

14. April 2008 by fmunoz.

Salio la nueva lista de Productos afectados por el nuevo patch de actualizacion de seguridad de Oracle.

Este nuevo patch solo actualiza Server side no Client side y afecta los siguientes productos:

Para mas informacion favor ir al siguiente link:

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuapr2008.html

Tambien les recuerdo que el patch set para 10.2.0.4 ya se encuentra disponible para ser bajado, esta version permitira la integracion para pruebas y grabar cargas de esta version a la 11g.

Saludos,
Francisco Munoz Alvarez

Posted in News | Print | 1 Comment »

12. April 2008 by ecepeda.

email: edgardocepeda@hotmail.com 

ANTECEDENTES ACADEMICOS 

1989-1991 Universidad Austral de Chile.                                             

Técnico Universitario en Mantención de Equipos Industriales 

1994 – 1998 Universidad de Los Lagos 

Ingeniería En Informática Y Multimedia.  

1996   Curso de Fast-Track SQL-Transactions Sybase Ase 

1998   Curso de Herramienta Case DAG-Tools     

2002   Curso de Tuxedo 

2006   Oracle 9i Database Administracion and Recovery Fundamental II R2  ORACLE UNIVERSITY 

2006    Oracle 9i Database Performance and Tuning  R2      ORACLE UNIVERSITY  

2007    Oracle 10g Database Real Aplication Cluster       ORACLE UNIVERSITY  

2006   Profesor curso “Análisis de Algoritmos y Grafos” en Universidad Tecnológica 

Posted in Curriculum | Print | 1 Comment »

11. April 2008 by jpuga.

Como se si mi BD esta usando Pfile o SPfile?

Posted in Consultas | Print | 3 Comments »

11. April 2008 by fmunoz.

Francisco Javier Munoz Alvarez
email: mbatec@hotmail.com 

OVERVIEW:

• Around 16 years of experience in consulting, analysis, support, Implementation, and Migration of Oracle Databases
• Excellent Implementation Methodologies
• Expertise in most phases of Database life cycle: Development, Stabilization, Security, Backup and Recovery, Tuning, Installations, and Data warehouse (“ETL”).
• Extensive experience with SQL and PL/SQL.
• Strong analytical, communication and leadership skills. Strong team player
• Worked as Associate Technology at Oracle Brazil and Chile
• Oracle Instructor for New Horizons Center, Chile.  (www.newhorizons.com)
• OCE Oracle Certified Expert (Oracle RAC 10g)
• OCP Oracle 10g DBA Certified
• OCP Oracle E-Business Suite 11i
• OCA Oracle Application Server 10g Administrator
• OCA - PL/SQL DEVELOPER
• OCM Database Administrator Oracle 7
• OCA Oracle 9i DBA Certified
• ITIL Fundamentals Certified

TECHNICAL SUMMARY:

Oracle 7, Oracle 8i, Oracle 9i , 10g , SQL Server Administration , SQL*Plus, SQL, PL/SQL(cursors, sub-queries, triggers, procedures, packages, etc.), SQL Navigator, Toad, Insider, MySQL, PHP, ASP, HTML, Microsoft Access, SQL Server 2000, SQL Load, ETL, Oracle Replication, RAC, ODBC, Oracle Data Warehouse, Datagard, Oracle Grid, OEM, MAA (Oracle Maximum Availability Architecture), Listener, SQL NET, Data Pump, HP/UX, SUN/SOLARIS, NT, AIX, LINUX, DG/UX, Windows 2003, RS/9000,VMS, UNIX, Windows ,Macromedia Flash, Fireworks, FrontPage, Adobe Photoshop, Paintshop Pro ,Microsoft Office suite, Microsoft Project
EXPERIENCE: 

DATACOM SYSTEMS –Auckland, New Zealand

DATACOM -  New Zealand’s largest locally owned IT services company

02/08 – Present, Senior Oracle Consultant

• DBA Service Management for a wide DBA services (Oracle/SQL Server/OSS Databases)
  • This role will cover process/operational/functional management across the DBA functions and working with line managers to develop synergies across the different DBA teams (virtual team of 9)
• Assisting account managers with presales activities (RFP’s, prospects etc.)
• Oracle Consultancy 

SONDA S.A. - Santiago, Chile,
South America 

SONDA is one of the main systems integrators and IT service providers in Latin America. Its mission is to add value to its clients by providing world class IT services and solutions, helping them to achieve a better competitive position. Employing more than 4.500 people, and with annual sales of more than US$ 350 millions, it has an extensive reach in the region, with operations in Argentina, Brazil, Chile, Colombia, Costa Rica, Ecuador, Mexico, Peru and Uruguay.

12/06-02/08, Manager of DBA and Applications Department, Senior DBA

Responsible for Database Administration of 112 productions instances, manage a team of 23 DBA’S, responsible for reducing down time and increase all compliance of SLAs, introduced the MOF (Microsoft Operation Frameworks) ITIL based methodology to the department, increased applications performance, Database performance, new security checklists, preventive monitoring checklists and tools (Insider, Application Manager, and Tivoli), and introduce the Oracle Maximum Availability Architecture.  Provided technical support for critical databases, Data Warehouse databases, user problems, and developers. Monitored error logs, tablespaces, indexes, PL/SQL, data analysis, Triggers, Backup & Recovery Techniques, performance tuning, data migrations, software installations, database creations/configurations and upgrading the Oracle systems. Maintained Oracle systems in both Development and Production environments, 24 * 7 . Accomplishments:

• SLA - Order of Service Attention (20 minutes) : 64% to 96% at 3 months.
• SLA - Order of Service Finish (4 Hours): 52% to 95% at 3 months.
• SLA - Uptime Instances: 92.9% to 99.9% at 3 months.
• SLA - Customer Satisfaction: 68% to 98% at 3 months
• Obtain ISO 9001-2000 Certification to department.
• Percent of DBA’s certifications: 8% to 90% at 6 months (Coach all DBA’s , and provided internal training)
• Generated several new business opportunities

Environments: Oracle 7.x, 8.i, 9.i , 10g ,SQL Server, ETL, MAA, OEM, MYSQL, E-Commerce, SQL*Plus, SQL, PL/SQL, ACCESS, SQL*Load, Rac, Oracle Replication, Datagard, HP/UX, SUN/SOLARIS, NT, AIX, LINUX, Windows, Tru64, Toad, Insider, Data pump, ODBC, Listener.
EXPRESS TRAVEL GROUP –
Charlotte, NC

12/01-12/06 Senior Oracle DBA

Responsible for Internet Development and Database Administration.Responsible for reducing down time, increase applications performance, Database performance, security , and projects success. Provided technical support for databases, user problems, and developers. Monitored error logs, tablespaces, indices, PL/SQL, data analysis, Triggers, Backup & Recovery Techniques, performance tuning, data migrations, software installations, database creations/configurations and upgrading the Oracle systems, Maintained Oracle systems in both Development and Production environments, 24 * 7, loads, and security.

Environments: Oracle 7.x, 8.i, 9.i , Flash, PHP, MYSQL, FrontPage , Fireworks, PhotoShop, ASP, E-Commerce, SQL*Plus, SQL, PL/SQL, ACCESS, SQL*Load, Rac, Oracle Replication, HP/UX, SUN/SOLARIS, NT, LINUX, Import, Export, ODBC, Listener. 

PLANET MEDIA INT’L, INC –
Miami, FL

03/97-12/01 Senior Oracle DBA and Web Administrator

Responsible for the Internet Development and Oracle Administration Area. Provided technical support for databases, user problems, and developers. Monitored error logs, tablespaces, indices, PL/SQL, data analysis, Triggers, Backup & Recovery Techniques, performance tuning, data migrations, software installations, database creations/configurations and upgrading the Oracle systems.

Environments: Oracle 7, 8i, 9i , Flash, PHP, MYSQL, FrontPage
MBA & TECHNOLOGY LTDA. –
Santiago, Chile

01/92-03/97 Database Manager
Responsible for the department of Database Administration (Installation and configuration, backup & recovery strategies, system architecture planning and mentoring, performance tuning of Database and applications, SQL*Plus, PL/SQL, SQL*Net, SQL*Loader, Oracle Replication Manager), distribution of products Quest Corp. for Chile, controlling complete net sales and supporting on-line the products Quest. (Quest Corp. is a software manufacture for DBA, established in California, USA)

Environments: SUN, DG/UX, RS/9000, HP/UX, NT, SOLARIS, VMS, UNIX, ORACLE7, ORACLE8 and ORACLE REPLICATION MANAGER
FAST AIR CARRIER S.A (LAN CHILE HOLDING).
Santiago, Chile

05/90-05/93 Oracle DBA
DEFENSE INFORMATICA LTDA
Curitiba, Brazil

01/87-04/90 Developer/Consultant/DBA
EDUCATION:

UNIVERSIDAD DE SANTIAGO DE CHILE – USACH

Bachelor of Computer Science degree, May 1997
ORACLE EDUCATION,CALIFORNIA

Master Oracle DBA degree in Oracle7, 1997

Data Processing Courses, 1988 – Present

Took or Passed more than 30 courses, like Administration Oracle8i , Administration and Tuning Oracle 9i, and SQL & PL/SQL Advanced for Oracle 9i, Oracle 10g DBA I, DBA II, Tuning and 10g RACMost recent course: Oracle 10g DBA I, DBA II, Tuning and 10g RAC, Administration and Tuning Oracle 9i, and SQL & PL/SQL Advanced for Oracle 9i)
SKILLS & INTERESTS:
Trilingual: Proficient in English, Spanish and Portuguese. Strong analytical, communication and leadership skills.. Strong team player, and Paramedic (Volunteer Rescue Squad Team).

Posted in Curriculum | Print | No Comments »

11. April 2008 by fmunoz.

PROMPT
PROMPT ******************************************** LIBRARY CACHE ***********************************************************
PROMPT

COLUMN y new_value sid NOPRINT
SELECT name||’_'||TO_CHAR(sysdate, ‘ddmonyy_hh24miss’) y FROM v$database;

SPOOL library_cache_&sid..txt

BREAK ON HASH_VALUE

SELECT hash_value, sql_text
FROM gv$sqltext
WHERE command_type = 3
ORDER BY 1, piece;

CLEAR BREAKS

SPOOL OFF

Posted in Memoria, Scripts | Print | No Comments »