viernes, 3 de julio de 2015

Oracle ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS

Te habrás preguntado una y otra vez, como se genera el famoso error ORA-32004?

En que consiste el mismo y como se resuelve.?

Bueno vamos a reproducirlo y a solucionarlo.

En una instancia de base de datos ya creada,  vamos a crear un archivo PFILE con el contenido del archivo SPFILE.

A la hora de examinar el contenido del archivo PFILE, podríamos ver algo como esto:

[oracle@db02 dbs]$ more initdemo1.ora
*.audit_file_dest='/opt/oracle/admin/demo1/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/opt/oracle/oradata/demo1/control01.ctl','/opt/oracle/fast_recovery_area/demo1/control02.ctl'
*.db_block_size=8192
demo1.db_cache_size=100M
*.db_domain=''
*.db_name='demo1'
*.db_recovery_file_dest='/opt/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8589934592
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=demo1XDB)'
demo1.java_pool_size=16777216
demo1.large_pool_size=30M
*.log_archive_format='arc_demo1_%t_%s_%r.arc'
*.open_cursors=300
demo1.pga_aggregate_target=90M
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
demo1.sga_target=500M
demo1.shared_pool_size=150994944
*.undo_tablespace='UNDOTBS1'

Borramos el archivo SPFILE o lo re-nombramos.
[oracle@db02 dbs]$ rm spfiledemo1.ora

Nos conectamos a la base de datos e iniciamos la instancia con el archivo PFILE.
[oracle@db02 dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 3 10:31:27 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.

SQL> startup pfile='initdemo1.ora'
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             201328664 bytes
Database Buffers          310378496 bytes
Redo Buffers                7974912 bytes
Database mounted.
Database opened.

Si revisamos el contenido del parámetro SPFILE veremos que esta vacío, lo que nos indica que estamos iniciando la base de datos desde un archivo PFILE.

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------
spfile                               string
SQL>


Ahora vamos a crear el archivo SPFILE con el contenido del archivo PFILE.

SQL> create spfile from pfile='initdemo1.ora';

File created.

Creando el archivo de parámetros SPFILE a partir del contenido del archivo PFILE y levantar la instancia de la base de datos con el mismo, no tenemos problema.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             201328664 bytes
Database Buffers          310378496 bytes
Redo Buffers                7974912 bytes
Database mounted.
Database opened.

Pero que pasa si lo hacemos a partir de un archivo con el contenido de los parámetros configurados en memoria.?

Primero vamos a borrar el archivo de parámetros SPFILE.

SQL> host rm spfiledemo1.ora

Ahora creamos el archivo de parámetros con los parámetros de memoria.

SQL> create spfile from memory;

File created.

Reiniciamos la base de datos y vemos que pasa.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             205522968 bytes
Database Buffers          306184192 bytes
Redo Buffers                7974912 bytes
Database mounted.
Database opened.
SQL>

Sorpresa, aquí nos aparece el ORA-32004
La otra sorpresa, es que si consultas directamente en el diccionario de la base de datos, aparentemente no existe ningún parámetro configurado que sea obsoleto.

SQL> select name from v$obsolete_parameter where isspecified='TRUE';
no rows selected

Si revisamos el contenido del archivo alert de la base de datos, que para efectos de nuestra demo debemos hacerlo a través de la utilidad ADRCI, por ser versión 11gR2 Patch Set 3, nos podemos enterar que efectivamente, hay dos parámetros seteados que sí son obsoletos en esta versión.

SQL> host
[oracle@db02 dbs]$ adrci

ADRCI: Release 11.2.0.4.0 - Production on Fri Jul 3 10:35:42 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/opt/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/demo1/demo1
diag/tnslsnr/dbvisit01/listener
diag/tnslsnr/db02/listener
adrci> set home diag/rdbms/demo1/demo1

adrci> show alert

ADR Home = /opt/oracle/diag/rdbms/demo1/demo1:
*************************************************************************
Output the results to file: /tmp/alert_2928_14068_demo1_1.ado
2015-03-07 11:45:13.439000 -06:00
Adjusting the default value of parameter parallel_max_servers
from 160 to 120 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
************************ Large Pages Information *******************


ADR Home = /opt/oracle/diag/rdbms/demo1/demo1:
*************************************************************************
Output the results to file: /tmp/alert_2928_14068_demo1_1.ado
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options.
ORACLE_HOME = /opt/oracle/product/11g
System name:Linux
Node name:db02.demo.com
Release:3.8.13-16.2.1.el6uek.x86_64
Version:#1 SMP Thu Nov 7 17:01:44 PST 2013
Machine:x86_64
VM name:VMWare Version: 6
Using parameter settings in server-side spfile /opt/oracle/product/11g/dbs/spfiledemo1.ora
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 144M
  large_pool_size          = 32M
  ...
    _sqltune_category_parsed = "DEFAULT"
    diagnostic_dest          = "/opt/oracle"
  Deprecated system parameters with specified values:
    background_dump_dest
    user_dump_dest
  End of deprecated system parameter listing
  PMON started with pid=2, OS id=2843
PSP0 started with pid=3, OS id=2845

ADR Home = /opt/oracle/diag/rdbms/demo1/demo1:
*************************************************************************
Output the results to file: /tmp/alert_2928_14068_demo1_1.ado
adrci> exit

Para solucionar el problema, debemos reiniciar los parámetros afectados.

SQL> alter system reset background_dump_dest scope=spfile;

System altered.

SQL> alter system reset user_dump_dest scope=spfile;

System altered.

Reiniciamos la base de datos y asunto resuelto.

SQL> startup force
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             205522968 bytes
Database Buffers          306184192 bytes
Redo Buffers                7974912 bytes
Database mounted.
Database opened.
SQL>

Fin de error ORA-32004


miércoles, 1 de julio de 2015

Webinar: Leading Retailers METRO and Fresh & Easy Share Their Approach to Private Label Growth and Brand Compliance

Logo
Leading Retailers METRO and Fresh & Easy Share Their Approach to Private Label Growth and Brand Compliance

Speakers: John Carter, METRO| Denise Webster, Fresh & Easy | Susan Reda, STORES Media
Date & Time: Wednesday, July 1, 2015 | 11 am ET

The retail industry, and particularly the food sector, has become a highly sensitive market with consumers demanding full transparency, accurate labeling, quality ownership and a rapid response to incidents. The growth in private label has only heightened this need for brand owners to collaborate with their supply chain in the sourcing, development, labeling and quality control of their products. To ensure continued brand loyalty, brand owners must demonstrate due diligence in their collection, capture and validation of supplier and product data.

In this session, two of the world’s leading grocers will share their approach to protecting their brand, maintaining consumer trust and navigating the mounting legislative and regulatory requirements for private label products.

Attendees will specifically hear unique perspectives from Europe and North America including:
  • METRO’s strategy and tactical approach to growing private label whilst maintaining brand quality and satisfaction
  • Fresh & Easy’s perspective on the challenges NA grocers face and the opportunity to successfully increase revenue and profit from private label
  • The role of technology in the successful execution of a strong brand compliance program

If you are looking to leverage industry best practices, don’t miss this session.

Learn More. Register now.


About the Speakers

John Carter, Global Director Quality Assurance and Vice President, METRO
Denise Webster, Director Brand Development & Protection – Product Development, Food Safety, Quality & Regulatory, Fresh & Easy
Susan Reda, Editor, STORES Media


About Metro
With more than 750 stores in 28 countries serving more than 21 million customers, METRO Cash & Carry is the leading international player in wholesale trade and is the largest sales lines of METRO GROUP: customer-focused, international and innovative. For over 50 years, the distinctive business concept has oriented itself towards helping professional customers to successfully run their own businesses.


About Fresh & Easy
Since transitioning to new ownership over a year ago, Fresh & Easy has reinvigorated its brand and its stores with the aim of fulfilling a new mission – saving customers time by making fresh and natural food more available and affordable. The new Fresh & Easy is a company built on fresh ideas. With innovation at its core, Fresh & Easy is delivering its promise to be a destination for value and products that don’t exist anywhere else.


About STORES Media
STORES Media is the publishing arm of NRF, the world’s largest retail trade association, representing discount and department stores, home goods and specialty stores, Main Street merchants, grocers, wholesalers, chain restaurants and Internet retailers from the United States and more than 45 countries.

Cisco to Buy OpenDNS Company for $635 Million


Source: http://thehackernews.com

Cisco, a networking giant that offers traditional network edge protection, has announced that the company is buying cloud-based security company OpenDNS for $635 Million.

Yes, OpenDNS, whose Domain Name Services (DNS) you might have used to avoid regional restrictions or to improve your Internet connection.

However, Cisco is not making the acquisition of OpenDNS for any of the above reasons. Instead, the networking giant says it will boost its own cloud security, adding "broad visibility and threat intelligence from the OpenDNS cloud-delivered platform."

The aim is to offer you the protection against cyber attacks on your corporate network from any device, anywhere, anytime, and to predict threats before they strike.

Hilton Romanski, who leads business development at Cisco, wrote in his blog post:
"The acquisition will extend our ability to provide customers enhanced visibility and threat protection for unmonitored and potentially unsecure entry points into the network, and to quickly and efficiently deploy and integrate these capabilities as part of their defense architecture."
Since OpenDNS is easy to deploy at large scale, it is expected to fulfil the increased need for security with the fast-growing Internet of Things (IoT) believed to be more than 50 Billion Internet-connected devices by 2020.

The OpenDNS team will join the Cisco Security Business Group after finalizing the deal, which is expected to be in the first quarter of fiscal 2016.

According to Cisco, the company will pay $635 Million in cash and assumed equity awards, as well as retention-based incentives for OpenDNS.

If you are wondering about the OpenDNS' existing services, then relax. As David Ulevitch, founder and CEO of OpenDNS says, OpenDNS' services aren't going away and will continue to run as-it-is under the deal, so you will not have to search around for any alternative.

martes, 30 de junio de 2015

Oracle Hot Topics: Database hang or may fail to OPEN in 12c IBM AIX - ORA-742, DEADLOCK or ORA-600

Alerts

Alert
Product Area
Last Updated
Oracle Database - Enterprise Edition
Fri, 26 Jun 2015 08:08 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database - Enterprise Edition
Mon, 29 Jun 2015 06:21 GMT-06:00


"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support

viernes, 26 de junio de 2015

El programa Insider no tiene fecha de caducidad, nos lo confirma Microsoft

Por Pedro Algar
http://windowsphoneapps.es/
insider windows 10
Si nos seguís en nuestra cuenta de Twitter, habréis visto que esta mañana hemos estado en un evento de Microsoft España con motivo de la presentación de Windows 10, por supuesto teníamos muchas dudas que hemos tratado de resolver para comunicároslas. Una de esas dudas estaba relacionada con el programa Insider que permite a cualquier usuario usar Windows 10 en versiones previas antes de su lanzamiento y que ya cuenta con más de cuatro millones de miembros.

w7-w8 a windows 10
Como sabéis ha habido una gran confusión sobre si los Insider tendrían o no una licencia valida solo por estar en él, la respuesta ya se confirmó es que no, si no tienes una licencia valida de Windows 7 o Windows 8.1, no podrás actualizar gratis a Windows 10, pero si podrás continuar en el programa Insider y mantener vuestro Windows 10 Insider Preview activo y plenamente funcional.

A esto se nos presentaba una pregunta ¿Qué pasaría si se finalizaba el programa?, recordemos que inicialmente este tenía fecha de caducidad aunque más tarde Microsoft confirmó que continuaría tras el lanzamiento de Windows 10 publicamente el 29 de Julio. Nuestra preocupación era conocer si había planes de una finalización futura o no, ya que ello influiría en miles de usuarios que están en el programa. Por este motivo le planteamos la pregunta a Fernando Calvo de Microsoft, su respuesta fue clara, Windows 10 ahora es un servicio y como tal continuará en el tiempo, no habrá un Windows 11 sino que se planea perpetuar el servicio con actualizaciones periódicas, como tal el sistema necesitará continuamente que se siga probando las futuras novedades antes de su lanzamiento publico, Microsoft planea seguir contando con los Insider para seguir probando estas novedades en versiones previas al lanzamiento público y de momento se prevé mantener el programa Insider indefinidamente.

Yahoo! se apoya en Oracle para su buscador

Por Eduardo Quintana 26/06/2015
Yahoo! Oracle
Yahoo! y Oracle alcanzan un acuerdo para aumentar las visitas del buscador de la compañía californiana.

Según indica The Wall Street Journal, Yahoo! aumentará la cuota de mercado de su buscador web gracias a Oracle, aunque no ha trascendido el beneficio que obtiene la compañía de software con el trato.

De esta forma, la CEO de Yahoo!, Marissa Mayer informó en la junta de accionistas de la compañía de las condiciones del acuerdo, por el cual Yahoo! ganará visitas gracias a que los usuarios que actualicen Java se les ofrecerá por defecto la opción de configurar Yahoo! como principal motor de búsqueda web.

Junto a esto, salvo que el usuario lo rechace expresamente, Yahoo! pasará a ser la página web de inicio del ordenador. El acuerdo resulta muy beneficioso si se tiene en cuenta que 9 de cada 10 ordenadores de Estados Unidos tienen instalado Java, gestionado por Oracle.

Así las cosas, Yahoo! pretende ganar porcentaje de visitas a Google y Bing, puesto que actualmente se encuentra en tercera posición con el 12,7% de cuota de mercado. Mientras tanto, Google acumula el 64,2% y Bing de Microsoft el 20,2%.

jueves, 25 de junio de 2015

Houston tenemos un problema: Migrando a Oracle Database 12c con cursor_sharing='SIMILAR' => cambiar a FORCE o EXACT



APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

BUG:5177766 - ENCOUNTER ORA-600 [17059] WITH CURSOR_SHARING=SIMILAR

DETAILS

We recommend that customers discontinue setting cursor_sharing = SIMILAR due to the many problematic situations customers have experienced using it. The ability to set this will be removed in version 12C of the Oracle Database (the settings of EXACT and FORCE will remain available). Instead, we recommend the use of Adaptive Cursor Sharing in 11g:

Document 740052.1 Adaptive Cursor Sharing: Overview
A number of customers have seen an increase in the number of child cursors since migrating to Oracle Database 11g Release 2. This can lead to many problems including complete CPU saturation of a machine requiring a database instance bounce or general database performance issues in the form of waits on mutexes and 'library cache lock'.

From Oracle versions 9.0 through 11.1, an oracle instance would limit the number child cursors in the shared pool associated with a single parent to 1024 before it would mark the parent OBSOLETE effectively invalidating it and all the children. Then a new parent with one child would be created and used going forward. But this would only limit the degradation of performance for some environments rather than fix something that could be addressed more effectively through improved application coding. (The attempt to address this from the database side also introduced other issues like bug 5177766). The child limit was removed by Oracle development because it was only masking an application problem at the expense of database performance for better designed applications. In addition, the obsolete code would not work in cases when SQL was wrapped within PL/SQL. The fundamental problem that obsolete code was masking is application code that was written incorrectly with regards to the ability to be shared. For example,  it is not written with user binds or the literal characteristics differ to a high degree.

Therefore, setting cursor_sharing = SIMILAR is highly discouraged in Oracle Database 11g Release 2 (and generally has not been recommended for most environments even in earlier versions) for several reasons:

1) This parameter is generally overly restrictive in what it actually allows to be shared. SIMILAR tells oracle to try and share cursors by replacing all literals with binds for legacy applications, but directs that sharing only be performed when all the replaced literal values were exactly the same (in the case of predicates referencing columns with histograms or using inequality operators such as BETWEEN, <, and !=)
2) This parameter seems to bypass a lot of the improvements made with Oracle Database 11g Adaptive Cursor Sharing feature and other abilities in the Cost Based Optimizer code to make better decisions on what execution plans should and should not be shared.
3) Having many child cursors all associated with 1 parent cursor could perform much worse than having many parent cursors that would be seen with having the default setting of cursor_sharing = EXACT (or FORCE). The scenario of many thousands of child cursors associated with 1 parent results in a potential bottleneck for searches for matching cursors (soft parsing) within the library cache.

The cursor_sharing parameter was introduced as a workaround for legacy applications that could not scale because they had not yet been redesigned to use bind variables. It has been presumed that most applications have been redesigned since then. If you are still using such an application, our recommendation is to set cursor_sharing = FORCE. This setting maximizes cursor sharing while leveraging the Adaptive Cursor Sharing framework to generate multiple execution plans based on different literal value ranges if necessary.
Note: In 11.2.0.3 and 11.2.0.4, although setting the parameter to SIMILAR will still be allowed, it will effectively behave as though cursor_sharing was set to FORCE.

ACTIONS

Change the cursor_sharing to either FORCE or EXACT, keeping in mind the effects of either.

REFERENCES

BUG:5177766 - ENCOUNTER ORA-600 [17059] WITH CURSOR_SHARING=SIMILAR

Courtesy: oracle-base.com & oracledbacr.blogspot.com: Oracle Midlands Birmingham.


Date: Tuesday 07 July
Time: 18:00 - 21:00  
Seating: 50
Sponsor: Red Stack Technology
Location: Innovation Birmingham, Faraday Wharf, Holt St, Birmingham B7 4BB  
Register: Here

Five Hints for Optimizing SQL - Jonathan Lewis
Adding hints to production code is a practice to be avoided if possible, though it's easy to make the case for emergency patching, and also as the basis for a method of generating SQL Plan Baselines. However, notwithstanding (and sometimes because of) the continuing enhancements to the optimizer, there are cases where the only sensible option is to constrain the broad brush strategy that the optimizer can take in a way that allows it to find a reasonable execution plan in a reasonable time. In this presentation we examine five of the "classic" hints that I believe are reasonable tactical weapons in the battle to beat the optimizer - (no_)merge, (no)_unnest, (no_)_subq, (no_)push_pred, and driving_site(). We will also glance briefly at a couple of other useful hints along the way.

Creating Test Data To Model Production - Jonathan Lewis
In this presentation we cover a few topics that you need to consider when setting up a framework for testing. First, how to generate large amounts of data quickly and repeatably; then how to ensure that the data content and pattern is a reasonable match to the system you want to emulate. We’ll examine a couple of cases to show that you can be caught out by such simple errors as creating indexes at the wrong point in your testing, and the differences between using CTAS (create table as select) and PL/SQL loops (especially run concurrently) to generate data.

Although it takes a lot of effort to create realistic models of production activity, we’ll also look at simple ways of modelling some aspects of concurrency, and show how concurrency can make a massive difference to what goes on inside the database – time permitting we will take a look at a few dumps of internal structures (disk and memory) to highlight some of the effects of concurrency.

Speaker Profiles
Jonathan is a well-known figure in the Oracle world with more than 25 years experience of using the database (and several years on other products). He has published three books, contributed to three others, runs a couple of websites and contributes fairly regularly to newsgroups, forums, User Group magazines, as well as speaking at events around the world. He has been self-employed for most of his time in the IT industry. He specialises in short-term assignments, typically of a design, review, or trouble-shooting nature.

Oracle: On-Premises &Cloud with the push of a button.!!

Cloud and on-premises IT: Ready for a 'decade of coexistence'?


Competencia: Virtual Forge lanza el primer escáner de códigos SAP HANA

Business Wire
http://www.eleconomista.es

La novedad más emocionante dentro del mercado del software empresarial viene hoy de la mano de SAP: HANA y permitirá crear aplicaciones que revolucionarán el mundo de los negocios. La palabra clave es «predictivo», es decir, contar con la habilidad de anticipar acontecimientos y reaccionar en consecuencia lo antes posible.

Ya existen varios casos en los que las empresas pueden usar SAP HANA para realizar análisis predictivos. En el lanzamiento de producto de HANA, parte del SAP Business Suite 4, sus creadores presentaron una aplicación predictiva de mantenimiento diseñada para supervisar infraestructuras clave. Parece que el software está destinado también al análisis predictivo de la atención médica y la vigilancia.

También han aparecido otras aplicaciones interesantes en el contexto de los negocios. De acuerdo con el director general de SAP, Bill McDermott, «La red empresarial de SAP es dos veces mayor que la de Amazon, eBay y Alibaba juntos». Ahora las empresas podrán predecir las necesidades de los clientes y abarcar el potencial de negocio mucho más rápido. Esto supone el siguiente paso en la evolución de la comercialización de productos y servicios.

Por eso el éxito de HANA dependerá en gran medida de las aplicaciones que se desarrollen para conseguir materializar ese nuevo potencial empresarial. Las aplicaciones de HANA procesan datos de extremada importancia y están conectadas al mundo exterior a través de múltiples interfaces, por lo que estas nuevas soluciones tendrán que funcionar, no solo de manera estable y eficaz, sino, con la seguridad suficiente.

«El típico desarrollador de SAP que trabaja con la plataforma HANA tiene que enfrentarse a lenguajes de programación nuevos y tecnología muy diferente desde el principio», explica Andreas Wiegenstein, director de tecnología de Virtual Forge. «Por ese motivo es muy importante facilitar a los desarrolladores directrices sólidas para la escritura de código seguro, eficaz y resistente. También incluimos pruebas para prevenir errores lo antes posible, formar a los desarrolladores y minimizar los costes a largo plazo que suponen los fallos».

Virtual Forge son pioneros en el campo de la seguridad SAP y desarrollaron hace ocho años el primer escáner de códigos para SAP. Desde entonces, han aprovechado esa experiencia única para el desarrollo de productos y servicios. La empresa ha presentado CodeProfiler 4 para SAP HANA, la primera herramienta independiente concebida especialmente para desarrolladores de HANA. Esta novedad se podrá ver en directo en el próximo webinario de Virtual Forge.