Todos los Sábados a las 8:00PM

Ahora a suscribirse y seguir el contenido de este blog.

miércoles, 14 de noviembre de 2018

dbForge Studio 2018: Práctico, simple de usar y muy útil


Comentarios:

"Actualmente trabajo como arquitecto de información en una compañía financiera. Tengo más de 25 años de ser Oracle DBA y otros motores de base de datos. Durante estos años, he conocido muchas herramientas.
Durante el último año he usado dbForge Studio para Oracle.

  • Interfaz agradablemente cómoda.
  • Perfecta conectividad a nuevos sistemas como legado. 
  • Funcionalidad para creación de instantáneas de esquemas y comparación de esquemas, 
  • Además de todas las herramientas necesarias para el día a día.
  • Fácil de instalar y menos consumidor de recursos que otras herramientas.

En comparación con los recursos de SQL Developer, es un minicompacto con provisiones de un 4x4.

Recomendado en todos los sentidos. "

dbForge Studio 2018: Practice, simple to use and very useful.



Comments:

"I currently work as an Information Architect in a finance company. I have more than 25 years of being Oracle DBA and other database engines. During these years, I have known many tools. Some free and others pay.
For the last year I have used dbForge Studio for Oracle. Interface pleasantly comfortable. Perfect connectivity to new systems as a legacy. Functionality seen as creation of snapshots of schemes and comparison of schemes, plus all the tools required for day to day.

Easy to install and less resource consumption than other tools.

In comparison to the consumption of resources by SQL Developer, it is a mini-compact in consumption, with provisions of a 4x4.
Recommended in every way."

jueves, 8 de noviembre de 2018

Oracle Hot Topics: ORA-600 [KTECGETSH-INC] WHEN INSERTING INTO A TABLE



Bugs

Bug
Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
22855193
Thu, 8 Nov 2018 09:29 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database - Enterprise Edition
Wed, 7 Nov 2018 00:19 GMT-06:00

Court Orders Rimini Street to Comply with Permanent Injunction Prohibiting Further Infringement


Press Release 

Redwood Shores, Calif.—Nov 7, 2018 

On Monday, a federal appeals court rejected Rimini Street’s motion to stay and effectively delay a permanent injunction issued by the Federal District Court in Nevada. That injunction prohibits Rimini Street from engaging in specific unlawful practices in connection with its core business practices as found in Oracle’s 2015 copyright infringement trial against Rimini Street and its founder, Seth Ravin. 

The trial court had determined earlier that the more than $100 million that Rimini Street paid to Oracle in damages following trial was inadequate to fully compensate Oracle for Rimini Street’s copyright infringement, citing “Rimini Street’s conscious disregard for Oracle’s software copyrights” and the fact that Rimini Street’s business model “was built entirely on its infringement of Oracle’s copyrighted software.” The Court ruled that Rimini Street can only provide support for Oracle’s PeopleSoft, J.D. Edwards, Siebel, and Database software subject to certain court-mandated restrictions, as set forth in the injunction.

While Rimini Street made public statements suggesting that it can comply with the injunction without changing its business model, it told the federal appeals court a different story in court filings. Rimini Street instead argued that the “injunction goes far beyond the changes that Rimini Street [already] made in response” to the Nevada court’s rulings, and would therefore harm its business. Rimini Street must now comply with all the terms of the injunction while its latest appeal is pending.

“We are grateful that the Ninth Circuit Court of Appeals denied Rimini Street’s latest attempt to delay justice. The federal courts in this country have appropriately recognized that the only way to stop serial infringers such as Rimini Street is to subject them to detailed, court-ordered prohibitions against unlawful practices and subject them to contempt of court penalties for any breach. Oracle will continue to be unrelenting in its mission to stop the infringement of its intellectual property rights,” said Dorian Daley, Oracle’s Executive Vice President and General Counsel. 

Contact Info 

Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935

lunes, 5 de noviembre de 2018

Public Utilities Enhance Energy Efficiency Programs with Oracle


Press Release

Redwood Shores, Calif.—Nov 5, 2018

Elizabethtown Gas and Riverside Public Utilities (RPU) join a growing list of utilities using Oracle Opower Home Energy Reports to educate customers on energy efficiency and related savings. With Oracle Opower, these utilities have the potential to increase savings and engagement for more than 179,000 households. 

"We are proud to be working with Riverside Public Utilities and Elizabethtown Gas to enhance their energy efficiency education and drive increased efficiency solutions amongst their customers," said Rodger Smith, SVP and general manager of Oracle Utilities. "Our behavioral Energy Efficiency programs have contributed significant bill savings for consumers, and we continue to innovate to bring our utility customers the best in home energy management solutions." 

Since Elizabethtown Gas launched the program in December 2017, participating customer savings continue to trend upward. The utility also implemented Oracle's energy efficiency web portal to provide online tools including bill comparison insights and an online audit. 

RPU selected Opower Home Energy Reports to help improve customer experience, increase energy efficiency savings, and drive more digital engagement. The implementation of the Home Energy Reports represents an expanding relationship between RPU and Oracle Utilities. The utility currently utilizes Oracle’s Work and Asset Management solution to manage asset lifecycles, streamline maintenance operations and improve regulatory compliance. 

"Working with Oracle, we are now able to deliver new, cutting-edge tools that allow our customers to gain a better understanding of their energy use at home and make educated decisions regarding their electric bill," said RPU account manager, Ryan McManus. 

Ranked number one in Navigant Research's Leaderboard report on Home Energy Management systems, Oracle Opower Home Energy Reports provide residential customers personalized feedback and actionable insights about their energy consumption to help motivate them to lower their usage. 

Oracle Utilities recently announced that its Opower Home Energy Reports and Energy Efficiency programs achieved a total of $2 billion in utility bill savings for consumers over the past decade and have reached more than 20 TWh in energy savings. The reports include a neighbor comparison, energy usage trends, seasonal disaggregation, and personalized energy saving tips that are powered by an intelligent recommendation engine. 
Follow us on Twitter and the Oracle Utilities blog 

Contact Info 

Valerie Beaudett
Oracle Corporation
+1 650.400.7833

martes, 23 de octubre de 2018

AI transforms chatbots into true digital assistants that help employees simplify user engagement, boost efficiency and improve productivity

Press Release 
Oracle Delivers Personalized Digital Assistants for the Enterprise 
Oracle OpenWorld, San Francisco, Calif.—Oct 23, 2018 

Oracle delivers personalized digital assistants for the enterprise. 

Oracle today announced the availability of Oracle Digital Assistant, enabling companies to build personalized digital assistants to help employees work smarter and more productively. With Oracle Digital Assistant, employees leverage one comprehensive digital assistant that can be trained to support domain skills from multiple applications such as HR, ERP, CRM and CX. Leveraging AI, Oracle Digital Assistant understands context, derives intent, and identifies and learns user behaviors and patterns to automate routine tasks proactively, such as expense approvals and meeting reschedules, on behalf of the user. 

Built on Oracle Cloud Infrastructure, Oracle Digital Assistant goes well beyond standard chatbots available today that provide simple, single skilled, linear responses. By applying AI for natural language processing (NLP), natural language understanding (NLU) and machine learning (ML), Oracle is in a unique position to leverage its breadth and depth in enterprise applications, and offer a digital assistant that can truly span the enterprise. See Oracle Digital Assistant in action here

“This is the next evolution of chatbots and a major milestone in delivering a smart digital assistant for the enterprise,” said Suhas Uliyar, vice president of AI, Bots, Mobile, Product Management, Oracle. “Oracle Digital Assistant has the power to transform organizations, helping our customers achieve greater productivity and enriched user experiences.” 

Users can converse with the Oracle Digital Assistant via the voice interface but it is platform agnostic and is equally optimized to support popular messaging platforms including Slack, Facebook Messenger, WeChat, and Alexa. Analytics are built-in so businesses can monitor usage to gain real time insights into user behavior and app performance, for continued analysis and improvements. 
Industry Accolades 

Multiple independent industry analyst reports have recognized Oracle for its multi-channel and digital experience development platforms. Following are some of those reports: 
According to Ovum’s Decision Matrix: Selecting an Enterprise Mobile Application Development Platform, 2018-19 report, “Oracle is well placed to take advantage of the MADP marketplace where chatbots are becoming the norm for many customer interactions. Having a chatbot platform powered by AI will be looked upon favorably by both enterprise and SMB clients. Some of the AI technology, such as voice recognition, is now standard from providers such as Apple with Siri and Android with Google Voice, and Oracle seamlessly integrates with these services. Furthermore, Oracle's heritage in the back office means that it will be well placed to help clients integrate the data emanating from the apps into the systems of record.” 
Organizations Create Unique Customer Experiences 

“With Oracle Digital Assistant, we were able to really improve the guest experience at our Bahia Principe hotels,” said Mateo Ramón Sastre, CIO, Corporativo Grupo Piñero. “The new Guest Service assistant significantly streamlines the experience for visitors and makes their stay more enjoyable. The 24x7 assistant makes it easier to get everything guests need during their stay – beginning with finding availability and booking a room to checking in, ordering room service, and concierge services while at our properties.” 

Mutua Madrid Open became the first ATP World Tour Masters 1000 and Premier WTA tournament to incorporate an AI-equipped chatbot to improve communication with tennis fans. Implemented with Oracle Cloud Platform, the chatbot, named “MatchBot,” used AI to maintain natural conversations that provided fans with information on the event, players, and results, as well as details on hospitality services, discounts on merchandise, ticket sales, access, and parking. 

“We wanted to position the Mutua Madrid Open as the tournament of the 21st century,” said Gerard Tsobanian, president and CEO of Mutua Madrid Open. “Development of the MatchBot positions us at the forefront of technology and innovation. With this new technology, we were able to provide visitors with an amazing experience—a pleasant, simpler, and faster way to get the information they wanted about the tournament.” 

“Here in Sant Just, we have implemented a virtual assistant (public officer) available 24 hours a day for citizens. We’ve been very happy with the speed of implementation and the increased engagement with our community,” said Pere Galindo, IT technician, Sant Just Desvern Local Council. “Now with a digital assistant that can answer questions across multiple knowledge domains, the only limit is our imagination.” 


Connect with Oracle Mobile Cloud on Twitter, LinkedIn and via the Oracle Mobile Blog

Contact Info 
Nicole Maloney
Oracle
+1.650.506.0806

Oracle Unveils Business-Ready Blockchain Applications

Press Release 

Oracle Blockchain Applications enhance traceability and transparency throughout the value chain 
Oracle OpenWorld, San Francisco, Calif.—Oct 23, 2018 

To help customers increase trust and provide agility in transactions across their business networks, Oracle has launched Oracle Blockchain Applications Cloud. The new suite of use-case-specific SaaS applications enhance traceability and transparency throughout the supply chain. Oracle Blockchain Applications are built with Oracle Blockchain Cloud Service and seamlessly connect with Oracle Supply Chain Management (SCM) Cloud, Oracle Enterprise Resource Management (ERP) Cloud and other Oracle Cloud Applications

Modern supply chains generate millions of data points and thousands of daily transactions that need to be validated and confirmed. This limits the pace of business and exposes organizations to risk. Oracle Blockchain Applications enable customers to track products through the supply chain on a distributed ledger to increase trust in business transactions, get better visibility across a multi-tier supply chain, accelerate product delivery and contract execution, and improve customer satisfaction. 

“Consumers are better informed than ever before and are increasingly interested in what is in the products they consume,” said Kyle Bozicevic, owner and brewer at Alpha Acid Brewing in Belmont, California. “We can now track materials and premium ingredients from our suppliers and analyze sensor data from the production process for each batch. Oracle Intelligent Track and Trace blockchain application helps ensure that we are getting the highest quality hops, malt, and yeast, and enables us to create a strong narrative around our products for customers.” 

· Learn more about Alpha Acid Brewing’s use of Oracle Intelligent Track and Trace blockchain application here: https://youtu.be/qz7Mj_tjyXk

Oracle’s business-ready blockchain applications reduce barriers to adoption of blockchain and provide immediate business benefits to customers by improving trust and transparency in their business network and transforming their supply chains. Oracle Blockchain Applications include: 

· Intelligent Track and Trace – Enables end-to-end traceability of goods and transactions in supply chains to reduce delays and automate record keeping. The application creates a digital trail of each step in the business network, during procurement, manufacturing, and transportation. It provides better visibility for easier root-cause analysis and faster dispute resolution. This helps customers execute targeted product recalls, resolve disputes, reduce counterfeits, improve regulatory compliance, and protect against fraud. 

· Lot Lineage and Provenance – Enables product genealogy, serialization, and provenance by managing the lifecycle of hierarchical serial numbers, recording origin and authenticity of product components, and tracking all transformations of the product. It helps in regulatory compliance, targeted recalls, and preventing counterfeit components. 

· Intelligent Cold Chain – Helps monitor and track the temperature-controlled supply chain, creating recommendations to optimize processes and ensure the quality and safety of refrigerated products in pharmaceutical and food and beverage industries. 

· Warranty and Usage Tracking – Removes paper-based processes and automates usage tracking for high-value assets. An auditable and verifiable log for warranty, liability claims, and insurance helps expedite settlements and claim processing and prevents abuse of assets. 

These applications are built with Oracle Blockchain Cloud Service, which was launched earlier this year. It helps organizations build blockchain networks to drive more secure and efficient transactions with their trading partners. Oracle’s blockchain platform has experienced tremendous momentum and has been adopted by many global organizations spanning a wide range of industries and verticals including transportation, supply chain and logistics, energy, retail and ecommerce, financial services, telecommunications, and public sector. A few of the many organizations already using Oracle Blockchain Cloud Service include Arab Jordan Investment Bank, CargoSmart, SERES, Certified Origins, Indian Oil, Intelipost, MTO, Neurosoft, Nigeria Customs, Sofbang, Solar Site Design, and TradeFin. 

“We are using Oracle Blockchain as our digital platform for shipment documentation, which helps us easily track and trace shipping transactions,” said Lionel Louie, chief commercial officer, CargoSmart. “Our goal is to help bring more trust and transparency into the industry. In fact, we expect a 65 percent reduction in the amount of time required to collect, consolidate, and confirm data from multiple parties. We also hope to streamline data from different documents by leveraging Oracle Intelligent Track and Trace.” 

Oracle Blockchain Applications also leverage Internet of Things (IoT) connectivity and use embedded artificial intelligence (AI) features to leverage real time data to improve the accuracy of data flowing in a customer’s business network. Oracle develops emerging technologies in unison to provide intelligent recommendations and better user experiences across the SaaS applications for supply chain, finance, human resources and customer experience. 

“Many technology companies are offering a blockchain platform for customers to build on, but we wanted to go one step further. We use our domain expertise to create business, user-friendly, domain-specific solutions so customers can get immediate value from blockchain technologies by transforming existing business processes,” said Rick Jewell, Senior Vice President, Supply Chain & Manufacturing Cloud Applications, Oracle. “Oracle Blockchain Applications make it easy for customers to create a trusted network of partners to improve the agility, accuracy, and visibility of their supply chain. These blockchain applications work seamlessly with existing Oracle Cloud Applications and are out-of-the-box ready with pre-built integrations and business network templates for common business processes.” 

For additional information on Oracle Supply Chain Management (SCM) Cloud, visit Facebook, Twitter or the Oracle SCM blog


Follow Oracle Platform via Blog, Facebook and Twitter
 
Contact Info 
Vanessa Johnson
Oracle
+1.925.768.0294 

lunes, 22 de octubre de 2018

Oracle Code One now covers more technologies and reaches new communities

Press Release
Oracle Code One Expands Support for Developers

Redwood Shores, Calif.—Oct 16, 2018
Code One

Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card. 

To support and empower the developer community, Oracle Code One will take place alongside Oracle OpenWorld on October 22 to 25 at Moscone West in San Francisco. Oracle’s premier event for developers has expanded to include more languages, technologies and developer communities. Oracle Code One will cover a wide range of topics from AI, blockchain, digital assistants and containers to Java and more languages such as Go, Rust and Python. Registration is still open to all developers and available at oracle.com/code-one

Oracle Code One features daily keynotes at 5:00 PM in Moscone North’s Hall D. In the Java technical keynote on Monday, October 22, Georges Saab, Vice President of Development at Oracle, will share Java SE updates from the last twelve months including recent enhancements made in the latest Java 11 release. They will also share a glimpse into future projects aimed at accelerating user productivity such as Java in container environments and exploration of new code review options for the JDK. This year’s Duke’s Choice Award winners will also be announced during the keynote. 

The Oracle Code One keynote on Tuesday, October 23, will explore topics ranging from managed Kubernetes and serverless functions to blockchain and intelligent digital assistants powered by chatbot technology. The keynote will be presented by Matt Thompson, Vice President of Developer Engagement and Evangelism at Oracle; Amit Zavery, Executive, Vice President of Fusion Middleware and PaaS Development at Oracle; and Siddhartha Agarwal, Group Vice President of Product Management and Strategy for Oracle Cloud Platform. The Code One Meetup at 5:00 PM lets developers not registered for Oracle Code attend the keynote, join a fireside chat with iconic leaders who have made groundbreaking developer innovations and explore evening sessions. 

The Java Community Keynote will take place October 24 and feature special guest, James Gosling, creator of Java, together with Stephen Chin, Director of Developer Marketing and Heather VanCura, Director at Oracle and Chair of the Java Community Process, the keynote will also include developer groundbreakers from Canoo Engineering AG, Gluon, IT-Beratung, Snyk. 

“As developers look to build increasingly complex cloud native applications, Oracle continues to provide new, innovative capabilities like AI and Machine Learning, blockchain and Kubernetes support for developers to leverage,” said Siddhartha Agarwal, Group Vice President of Product Management and Strategy at Oracle. “Oracle Code One is where developers can engage with Oracle’s technical experts and the larger developer ecosystem to learn how to build the next generation of these applications and services. The event features an unrivalled variety of technical sessions and a community of peers with expertise in the tools, tricks and technologies relevant to building for the cloud. Oracle is engaging with developers wherever they are located around the world to enable innovation via learning resources, developer-focused events, hands on hackfests and free Oracle Cloud Trials to help them get started.” 

Throughout Oracle Code One, developers will find more of the Java content they expect with extended workshops, talks, sessions and Hands-on-Labs to explore technologies from Oracle and the broader developer ecosystem, including GraalVM, Oracle JET, the Fn Project, OpenJFX and GraphPipe. Developers at Oracle Code One can also expect unexpected demos based on the latest emerging technologies, from AI to blockchain. 

Among this year’s exciting demos, sessions and keynotes, attendees will get to experience: 

· The Code Card – With Wi-Fi, buttons and an e-link screen, developers can design their own Code Card IoT device. Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card and join a workshop to learn how to program it using Oracle Cloud Functions, serverless technology powered by the Fn Project. 

· Demo: Alpha Zero AI Algorithm Connect Four – The Meet the Experts Lounge on Monday, October 22 at 4:00 PM will feature an interactive demonstration of a neural network trained to play Connect Four using the AlphaZero algorithm and deployed using Oracle’s open source GraphPipe. 

· Demo: Blockchain Beer – An exclusive demo of how a micro-brewery outcompetes big brands with the blockchain. 

· Panel: Groundbreaker Icons – A discussion by thought leaders in software development and open source, including Doug Cutting, (Hadoop), Neha Narkhede (Kafka), Graeme Rocher (Grails), Guido Van Rossum (Python) and Charles Nutter (JRuby). 

· AR Scavenger Hunt Game – Guests in the Developer Lounge can win money for charity by searching for chess pieces with their phone cameras, by downloading a special app. Find the scavenger hunt image and a 3D Java Duke appears on the screen with a quiz on the JavaFX 11 platform. For each correct answer on the scavenger hunt, Oracle will donate money to Iridescent, a science, engineering and technology education nonprofit organization that empowers underrepresented young people to become self-motivated learners, inventors and leaders. A leaderboard in the Oracle Code One Developer Lounge will show the number of players, the number of correct answers and how much money has been raised for Iridescent. 

Oracle Code One is also an opportunity for developers to learn about the wide range of open source and open standards which Oracle champions. Since joining the Cloud Native Computing Foundation last year, Oracle has continued to advance key serverless and container projects, including announcing new open serverless standard support on its open source Fn Project and critical new features for Oracle Container Engine for Kubernetes to address key Kubernetes issues. Oracle also contributed many of its Kubernetes projects to the open source community, including JenkinsX Supported Cloud Provider for OKE, Flexvolume Driver, Volume Provisioner, Cloud Controller Manager and Terraform Kubernetes Installer. These announcements follow last year’s announcement that Oracle open sourced several container utilities. For developers working on machine learning, Oracle recently announced that it open sourced GraphPipe, to simplify how enterprises deploy and query machine learning models from any framework. Earlier this year, Oracle also released GraalVM, a polyglot virtual machine to run Java and JVM languages with full support for JavaScript and Node.JS, plus early support for Ruby, Python, R and LLVM bitcode. 

In 2019, Oracle will host over 300 events around the world to connect with and educate developers with workshops, sessions and keynotes featuring prominent experts. To learn more about Oracle Developer Events, please visit: https://developer.oracle.com/events
Oracle Cloud Platform Momentum 

At last year’s OpenWorld, Oracle announced new integrated cloud offerings that made it easier for developers to leverage transformative technologies and create modern applications. These included the launch of the Oracle Container Native Application Development Platform and the Oracle Blockchain Cloud Service, as well as the expansion of the Oracle Mobile Cloud portfolio to include artificial intelligence-powered chatbots. 

To accelerate mobile and web application development and deployment, Oracle announced the availability of Oracle Visual Builder Cloud, which enables both business users and developers to build applications with little to no coding. Oracle API Platform Cloud provides full lifecycle API management services. Finally, Oracle Integration Cloud now brings pre-built application integration and process automation to the Oracle Cloud Platform, making the deployment and integration of these applications more seamless than ever. 

Contact Info 

Alex Shapiro
Oracle
+1 405.608.5044

domingo, 21 de octubre de 2018

Oracle 18c Nuevas Características: Activación INMEMORY Database y Redimensionamiento Dinámico.

Al igual que en la versión 12c R2 12.2.0.1, la opción de almacenamiento columnar en memoria, no viene activada de facto en 18c 18.3.0

Para habilitar dicha característica, es necesario configurar el parámetro INMEMORY_SIZE a un tamaño distinto de 0.

Cuando el valor es 0, indica que esta opción es deshabilitada.

El mínimo de tamaño que se puede asignar es de 100MB.

En un contenedor de base de datos 18c 18.3 si la opción de administración de memoria automática ha sido activada, a la hora de configurar 100MB, el tamaño del las áreas variables ( en donde se encuentra el SHARED_POOL ) se verá afectada negativamente en un 2.5%, mientras que el área de DATABASE_BUFFER, lo hará en un 6.5%.

En números estamos hablando, que al configurar 100MB para el almacenamiento columnar en memoria, 17MB y 100MB ( por temas de la asignación por nivel granular ) respectivamente de los tamaños de áreas compartidas y del BUFFER CACHE, serán tomadas para la nueva configuración del BUFFER de memoria.

Para repasar, en las revisiones 1 y 2 ( 12.1 y 12.2 ) de Oracle 12c, la memoria para el buffer chace, el shared pool, large pool y Java Pool, es definido a través de unidades de granularidad.

Si el tamaño máximo del SGA es menor a 1GB, la unidad de granularidad es de de 4MB. Si el SGA es mayor a 1GB, la unidad de granularidad es de 16MB.

Los requisitos para activar IM en 18c son:

  • Habilitada la opción de almacenamiento columnar IM
  • El parámetro de compatiblidad debe ser configurado a 12.2.0 o superior
  • La base de datos debe ser arrancada con el archivo de configuración de parámetros binario (SPFILE)
  • El valor del parámetro INMEMORY_SIZE debe ser configurado al menos a 128MB
Vamos a la configuración


SQL> connect sys/oracle@cdb1 as sysdba
Connected.

SQL> ALTER SYSTEM SET INMEMORY_SIZE =100M scope=both;
ALTER SYSTEM SET INMEMORY_SIZE =100M scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02095: specified initialization parameter cannot be modified


SQL> ALTER SYSTEM SET INMEMORY_SIZE =100M scope=spfile;

System altered.

[oracle@lab01 ~]$ sqlplus /nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Oct 15 13:46:01 2018
Version 18.3.0.0.0

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

SQL> connect / as sysdb
SQL> startup
ORACLE instance started.

Total System Global Area 2516580872 bytes
Fixed Size                  8899080 bytes
Variable Size             654311424 bytes
Database Buffers         1728053248 bytes
Redo Buffers                7876608 bytes
In-Memory Area            117440512 bytes
Database mounted.
Database opened.


SQL> show parameter buffer

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------
buffer_pool_keep                     string
buffer_pool_recycle                  string
db_block_buffers                     integer     0
log_buffer                           big integer 7360K
SQL> show parameter shared

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 24326963
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1
SQL> show parameter compatib

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------
compatible                           string      18.0.0
noncdb_compatible                    boolean     FALSE
plsql_v2_compatibility               boolean     FALSE
SQL> show parameter in-memory
SQL> show parameter INMEMORY

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------
inmemory_adg_enabled                 boolean     TRUE
inmemory_automatic_level             string      OFF
inmemory_clause_default              string
inmemory_expressions_usage           string      ENABLE
inmemory_force                       string      DEFAULT
inmemory_max_populate_servers        integer     2
inmemory_optimized_arithmetic        string      DISABLE
inmemory_prefer_xmem_memcompress     string
inmemory_prefer_xmem_priority        string
inmemory_query                       string      ENABLE
inmemory_size                        big integer 112M
inmemory_trickle_repopulate_servers_ integer     1
percent
inmemory_virtual_columns             string      MANUAL
inmemory_xmem_size                   big integer 0
optimizer_inmemory_aware             boolean     TRUE

Configuración dinámica del tamaño de INMEMORY CACHE.

SQL> alter system set inmemory_size=120M scope=both;
alter system set inmemory_size=120M scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02095: specified initialization parameter cannot be modified


Recuerden el valor del parámetro debe ser configurado a un valor superior a 128MB en el parámetro INMEMORY_SIZE

SQL> alter system set inmemory_size=250M scope=both;

System altered.

SQL>

Oracle Xe 18c, que trae consigo la nueva versión de base de datos de uso gratuito.?

    Mañana oficialmente el OOW18 abre sus puertas al público. Por primera vez en muchos años, el acto inaugural no es un día domingo, sino un día lunes. El día de mañana a las 13:45 en el centro Moscone, Larry Ellison brindará su keynote y dará el punto de inicio para la reunión anual que se extenderá hasta el próximo 25 de octubre.

    Siempre hay anuncios que hacen moverse a las redes sociales y a la prensa. La previa de este OOW18, ha dado como resultado la liberación de la versión Oracle Database Xe 18c, esperada por mucha gente.

    Pero que contiene la nueva versión de Xe 18c ?

    Definitivamente haciendo la comparación entre las anteriores versiones 10g XE y 11g XE, esta es la versión que más características suma, para un producto.

    Importante de considerar: Oracle no le proporcionará soporte técnico, soporte telefónico ni actualizaciones para esta versión.

    Además debe cumplir con los requisitos previos establecidos por la aceptación de uso, descrito en el siguiente link: https://www.oracle.com/technetwork/licenses/db18c-express-license-5137264.html

    Salvo que pertenezcas a una red terrorista, que vayas a utilizar la versión de base de datos para utilizar con un sistema que soporte el control para construcción de armas de destrucción masiva como las nucleares, misiles o biológicas; no existe impedimento de utilizarla, siempre y cuando cumplas con los requisitos del uso de la licencia correspondiente a este producto.

    Derechos de licencia
    Oracle le otorga una licencia limitada no exclusiva e intransferible para utilizar los programas para: 

    (a) propósitos de desarrollo, creación de prototipos y ejecución de sus aplicaciones para sus propias operaciones internas de procesamiento de datos; 

    (b) también puede distribuir los programas con sus aplicaciones; 

    (c) puede utilizar los programas para proporcionar demostraciones y capacitación de terceros; y 

    d) puede copiar y distribuir los programas a sus licenciatarios siempre que cada uno de los licenciatarios acepte los términos de este Acuerdo.

    "En el punto A, indica que el uso se limita al procesamiento de datos interno. La versión XE no tiene soporte consigo. Los PSU y CPU, no pueden ser aplicados a dicha versión. Por tanto existe un riesgo asociado a nivel de seguridad y funcionalidad, que usted debe asumir."

    En cuanto a características operativas, XE 18c 18.3.0.0 viene con:

    Multitenant: aislamiento, agilidad mediante la administración de múltiples bases de datos acopladas dentro de su base de datos de contenedor multitenant. Máximo 3 PDBs por contendor.

    No incluye en características de CDB, los snapshot carrusel, ni la característica de switchover para PDB actualizables. 

    Tampoco dispone de Oracle NoSQL Database Basic Edition.

    Plataformas de desarrollo soportadas: SQLJ, Microsoft Distributed Transaction Coordinator, .NET Data Provider, .NET procedimientos almacenados.

    Caraterísticas de alta disponibilidad: Recreación de indices en línea, tablas organizadas al índice, redefinición de tablas en línea, flashback table y database, Cross-plataform Backup and Recovery (*). No soporta ni RAC, Data Guard, ni la opción Sharding Database.

    A nivel de administración automática, Xe 18c no dispone de ningún tipo de paquete administrativo ( por ejemplo, Data Masking, Diagnostic Pack, etc. )

    Xe 18c, soporta compresión a nivel de red.

    IN-Memory Database : análisis en tiempo real, inteligencia empresarial e informes manteniendo sus datos importantes en un caché de memoria columnar de la base de datos de Oracle.

    Xe 18c, soporta planes adaptativos y cache de resultados.

    Particionamiento y Analítica avanzada: obtenga información y envíe predicciones a partir de sus datos utilizando Data Mining SQL, programación R y la interfaz de usuario de Oracle Data Miner.

    Xe 18c, soporta compresión avanzada, compresión a nivel de índices. Creación de segmentos diferidos. Tablespaces transportables entre múltiples plataformas. Re-escritura de consultas a través de Vistas Materializadas.

    No soporta compresión columnar híbrida, ni heat map, ADO ( automatic data optimizaction ), ni consultas en paralelo.

    Seguridad avanzada: protección a los datos confidenciales en la fuente y creación de aplicaciones cifradas de extremo a extremo con capas de seguridad que incluyen Oracle Transparent Data Encryption y Data Redaction.

    Con Xe 18c, puedes utilizar, encriptación a nivel de columna, tablespace, Database Vault, Label Security, Auditoría Fina Granulada (FGA), análisis de privilegios, Redacción de datos, VPD. No soporta el almacenamiento de llaves para cada base de datos acoplada.

    En la parte espacial y gráfica, XE 18c, dispone de Oracle Spatial and Graph, Indices particionados espaciales.

    Uso de recursos aceptados a través de control interno:
  • Hasta 12 GB de datos de usuario.
  • Hasta 2 GB de RAM de base de datos
  • Hasta 2 hilos de CPU
  • Hasta 3 bases de datos acopladas

jueves, 18 de octubre de 2018

Urgent: Disable pstack Called From Diagsnap After Applying PSU/RU released between October 2017 and July 2018 to Grid Infrastructure (GI) Home on 12.1.0.2 and 12.2.



Alerts

Alert
Product Area
Last Updated
Oracle Database Exadata Cloud Machine Oracle Database Exadata Express Cloud Service Oracle Database Cloud Service Oracle Database Cloud Exadata Service Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service
Wed, 17 Oct 2018 16:46 GMT-06:00

Bugs

Bug
Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
28719804
Thu, 18 Oct 2018 06:29 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database Exadata Cloud Machine Oracle Database Exadata Express Cloud Service Oracle Database Cloud Service Oracle Database Cloud Exadata Service Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service
Wed, 17 Oct 2018 16:46 GMT-06:00

Como solucionar ORA-01439 modificando el tipo o precisión de una columna en una tabla con datos

Veamos la siguiente situación:

"Tienes una tabla en donde el tipo de dato definido para una columna específica, no corresponde con el modelaje que habías hecho. La tabla ya tiene tiempo en producción y la columna en cuestión, ya tiene datos.

Problema: Requieres cambiar el tipo de dato obligatoriamente, pero al ejecutar la modificación sobre la tabla, obtienes el siguiente error:"

SQL> ALTER TABLE CND_FACTURA MODIFY CODIGO_SEGURIDAD VARCHAR2(8 byte);

MODIFY CODIGO_SEGURIDAD VARCHAR2(8 byte)
       *
ERROR at line 2:
ORA-01439: column to be modified must be empty to change datatype

Para resolver este inconveniente, puedes utilizar el siguiente método, para evitar cambiar el orden de las columnas en la tabla.

Pre-requisitos:
  1. La columna a modificar no posee un constraints de NOT NULL. Si fuera así, debe desactivarse inicialmente el mismo.
  2. La modificación en la tabla, puede ocasionar objetos inválidos en el esquema, por dependencias con el objeto. Si es posible, genere una ventana de mantenimiento para evitar errores con el usuario final.
Post-ejecución:
  1. Activar constraints en la tabla que hayan sido deshabilitados.
  2. Verifique que no existen objetos inválidos. Previamente sería adecuado validar las dependencias en el objecto y determinar, cuáles objetos podrían quedar inválidos con el cambio. Para obtener las dependencias en la tabla, puedes utilizar el paquete DBMS_UTILITY, como se detalla a continuación:
set serveroutput on;
exec dbms_utility.get_dependency('TABLE', '&Esquema','&TABLA');
Ahora si, vamos al problema. Nuestra tabla es la siguiente:

SQL> desc CND_FACTURA
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(38)
 ....
 COD_MONEDA                                         VARCHAR2(3)
 IND_IMPRESA                                        VARCHAR2(1)
 COD_FONDO                                          NUMBER(3)
 NOM_INQUILINO                                      VARCHAR2(150)
 TERCERA_PERSONA                                    VARCHAR2(150)
 NUM_RECIBO_IMPRESO                                 NUMBER(38)
 IND_APROBACION                                     VARCHAR2(1)
 CODIGO_SEGURIDAD                                   NUMBER(8)
 NUM_FACTURA_ATV                                    NUMBER(38)

Paso 1: Vamos a agregar una nueva columna con el tipo de dato que necesito migrar.

SQL> alter table CND_FACTURA add codigo_seguridad_original varchar2(8);

Table altered.

Paso 2: Vamos a actualizar los valores ya existentes en la columna que necesito modificar en la columna que hemos agregado.

SQL> update CND_FACTURA set codigo_seguridad_original=codigo_seguridad;

3315 rows updated.

Paso 3: Ahora actualizamos a NULL los valores para la columna que necesito migrar.

SQL> update cnd_factura set codigo_seguridad=null;

3315 rows updated.

Paso 4: Modificar a la nueva precisión o tipo de dato la columna con el problema.

SQL> ALTER TABLE CND_FACTURA MODIFY CODIGO_SEGURIDAD VARCHAR2(8 byte);

Table altered.


Paso 5: Actualizar la columna modificada, con los valores originales que contenía la misma.

SQL> update CND_FACTURA set codigo_seguridad=codigo_seguridad_original;

3315 rows updated.

SQL> commit;

Commit complete.

SQL> select count(*) from  CND_FACTURA where codigo_seguridad is not null;

  COUNT(*)
----------
       132

Paso 6: Remover la columna que habíamos agregado al inicio del ejercicio.

SQL> alter table CND_FACTURA drop column codigo_seguridad_original;

Table altered.

SQL> desc CND_FACTURA
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(38)
 ID_CUOTA_CONDOMINAL                       NOT NULL NUMBER(38)
 FEC_FACTURA                               NOT NULL DATE
 FEC_VENCIMIENTO                           NOT NULL DATE
 FEC_CANCELACION                                    DATE
 IND_ESTADO                                NOT NULL VARCHAR2(1)
 MON_FACTURA                               NOT NULL NUMBER(38,2)
 SALDO_FACTURA                                      NUMBER(38,2)
 INT_MOROCIDAD                                      NUMBER(38,2)
 TIPO_FACTURA                              NOT NULL VARCHAR2(1)
 NUM_RECIBO_CANCELACION                             NUMBER(38)
 ID_USUARIO_MODIFICA                       NOT NULL VARCHAR2(35)
 FEC_MODIFICACION                          NOT NULL DATE
 IND_ENVIADO_CORREO                        NOT NULL VARCHAR2(1)
 OBS_FACTURA                                        VARCHAR2(255)
 ID_INQUILINO                                       NUMBER(38)
 COD_MONEDA                                         VARCHAR2(3)
 IND_IMPRESA                                        VARCHAR2(1)
 COD_FONDO                                          NUMBER(3)
 NOM_INQUILINO                                      VARCHAR2(150)
 TERCERA_PERSONA                                    VARCHAR2(150)
 NUM_RECIBO_IMPRESO                                 NUMBER(38)
 IND_APROBACION                                     VARCHAR2(1)
 CODIGO_SEGURIDAD                                   VARCHAR2(8)
 NUM_FACTURA_ATV                                    NUMBER(38)

SQL>

Estado resuelto.


Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar