Posts categorized “database”
This blog post explores when and how you might restore statistics in Oracle® Database.
You can backup Oracle® databases in Amazon® Web Services (AWS) starting with Oracle Database 9i Release 2 or later. You use the Oracle Secure Backup (OSB) cloud module to do the backup, but remember that OSB does not back up operating system files.
A database backup results when you back up the operational state, architecture, and stored data of a database. It enables you to create a duplicate instance or a copy of your database in case the primary database crashes, gets corrupted, or is lost.
The blog post explains how to integrate Oracle® Application Development Framework (ADF) with E-Business Suite (EBS) Supply Planning Work Area (SWPA).
This blog post discusses the new interesting features introduced in Oracle Database 18c that make the life of DBA a little easier.
This blog explains how to create Oracle® XML Publisher reports with charts.
This blog shows how you can integrate Oracle® Access Manager (OAM) 11g with Oracle E-Business Suite (EBS) by using the WebGate agent.
Have you ever wondered how to convert a standalone database to an Oracle® Real Application Clusters (RAC) database?
This blog explores a scenario where you've lost an Oracle® Cluster Registry (OCR) and voting disk, and the voting disk has no backup. Though a tricky situation, you can restore it from the last automatic backup of the OCR.
This blog provides insight about what relinking is, why it is required, and how you relink Oracle® object files.
This blog discusses how to configure Oracle® Automatic In-Memory (AIM) to manage objects in the In-Memory (IM) Column Store.
Organizations face a major challenge securing sensitive data like social security numbers, bank account and routing numbers, and other similar data.
Oracle® Access Manager (OAM) version 22.214.171.124 provides identity management and an access control system that enables users to access all supported applications. To integrate multiple Oracle E-Business Suites (EBS) version R12.2 with OAM for single sign-on (SSO), you need to perform integration steps on each EBS instance.
This blog explains how to move a Microsoft® SQL Server® database hosted on-premises (or on Amazon® EC2 or Azure®) to Amazon Relational Database Service (RDS). This move requires backing up your SQL database to an AWS S3 bucket and restoring the database on your AWS RDS instance from that S3 bucket.
This post discusses how to set up log shipping, which is a disaster recovery (DR) solution, with existing Microsoft® SQL Server® AlwaysOn-configured databases.
This blog covers the essentials of how to use the advanced security option to secure sensitive data within an Oracle® database by using Transparent Data Encryption (TDE). This feature enables you to encrypt database columns and manage encryption keys.
Microsoft® SQL Server® Query Store, as the name suggests, is like a store that captures the database history of executed queries, query runtime execution statistics, and execution plans. Because the data is stored on a disk, you can retrieve the query store data anytime for troubleshooting purposes, and SQL Server restarts do not affect the data. Use Query Store, which was introduced in SQL Server 2016 and is available in all later editions, to troubleshoot performance issues caused by query plan changes.
The blog describes corruptions that can occur at the database level in Microsoft® SQL Server®, how to detect them, and how to correct them by using advanced restore and repair techniques.
Database backup and recovery is one of the crucial day-to-day activities that a database administrator (DBA) performs. A database backup is a copy of your data that can be used to recover the data in the event of data loss.
This blog shows you how to backup Apache® Cassandra® databases and restore them after a failure.
The Oracle® Exadata® system introduces storage indexes, which improve database performance. A storage index is a structure store in memory that contains key statistics. This storage index enables Exadata to speed up disk I/O operations and queries by checking the index first to find relevant data rather than by reading every row.
Oracle® GoldenGate® supports two architectures: the classic architecture and the Oracle GoldenGate Microservices Architecture (OGG MA).
Classic architecture has standard
and is managed by the GoldenGate Software Command Interpreter (GGSCI).
OGG MA is a restful application program interface (API) microservices-based architecture that enables you to install, configure, monitor, and manage Oracle GoldenGate services through a web-based user interface. OGG MA was introduced in version GoldenGate 12.3 and was designed from the perspective of cloud operations.
Microsoft® introduced a new feature called a hybrid buffer pool in SQL Server® 2019 (Preview) CTP 2.1. This feature enables you to directly access data pages in database files stored in persistent memory (PMEM) devices.
Database compatibility level, one of the database level settings, impacts how a database functions. Each new version of Microsoft® SQL Server® introduces many new features, most of which require new keywords and change certain behaviors that existed in earlier versions. To provide maximum backward compatibility, Microsoft enables us to set the compatibility level according to our needs.
Microsoft® has focused on security in SQL Server®, and almost all releases either have an enhancement to existing features or have introduced new security features. In SQL Server 2016, Microsoft introduced many new security features that help users protect their data, including Row-Level Security, Always Encrypted, and Dynamic Data Masking.
Oracle® OSWatcher is a utility that collects data from commands such as
sar, and Linux®
meminfo. OSWatcher archives the data files, automatically looks for issues, and helps
to determine the root cause of the issues, if possible.
The Oracle® Property Manager is part of the Oracle Real Estate Management solution and is a database that is specifically designed for companies and corporate giants that have large property portfolios. This blog highlights the Oracle Property Manager’s various features and functions.
As IT continues to grow, information systems are becoming more critical in different industries. Service interruptions in information systems can cause economic loss, critical data loss, and impact the brand image in the market, especially for industries such as communication, finance, medical care, e-commerce, logistics, and government. Therefore, service continuity is critical to the construction of information systems. Currently, service continuity is typically improved by building disaster recovery (DR) centers where copies of production data are saved.
If a physical standby database loses or corrupts an archived redo data or has an unresolvable archive gap, which is the result of archive logs getting missed on the primary database or the archives getting corrupted, then no valid backups exists for recovery.
This blog explores a few methods for handling XML data in Oracle® PL/SQL. Learn more about our database services.
To gain access to or to establish a connection with an on-premises, standalone database or Oracle® E-business Suite (EBS) database from the Oracle Integration Cloud Service, you need to install the Oracle Integration Cloud Service connectivity agent on your on-premises host. The Oracle Integration Cloud Service agent installs a WebLogic server with only the AdminServer component.
In recent years, Data Lakes have moved from the technology boondocks to the prime beachfront real estate of the data sciences. Why is this happening, and why are they important? The short answer ... there's value in there.
Oracle® has launched CPADMIN, a concurrent processing command-line utility for E-Business Suite® (EBS) versions R12.1.3 and R12.2.x. CPADMIN is a menu-based utility that wraps multiple existing utilities for concurrent processes and allows you to work on several concurrent process-related tasks under a single menu.
Newly released and user friendly, CPADMIN is the replacement for the cmclean.sql script in EBS Release 12. This blog explores some features of CPADMIN and shows you how to use it to execute multiple tasks with a single command.
This post discusses how to repair multiple or single block corruption of data files, including system data files, in an Oracle® database. Block corruption is a common source of database outages.
A particular SQL query might perform poorly on one database (such as production) but work fine on another database (such as development). This situation might occur if the same query has a different execution plan on each instance. This blog shows how to transfer the execution plan from an instance, where query works fine, to another instance, where query behaves poorly, by using the SQL plan baseline feature that Oracle® Database® first introduced in version 11g.
This blog delves into the details of the Oracle® Exadata® Smart Scan feature, including an explanation of how SQL processing differs with Exadata and usage examples.
Demantra® and advanced Supply Planning Work Area (SPWA) are demand management and supply chain management tools provided by Oracle®. These products integrate with the Oracle E-Business Suite (EBS) and Oracle Advanced Planning Suite (APS) (which are part of the Oracle Advanced Supply Chain Planning (ASCP)) to best leverage Demantra demand management and supply chain management functionalities.
This blog covers Demantra and SPWA configuration with Oracle EBS and APS Value Chain Planning (VCP) from an Oracle database administrator (DBA) and architecture perspective. It also provides high-level installation steps for Demantra and advanced SPWA.
This blog shows you how to install and configure Oracle® Forms and Reports version 126.96.36.199.0 on Oracle Enterprise Linux (OEL) version 7.2 server to ensure high availability.
This blog introduces transport layer security (TLS) and explains how it differs from secure socket layer (SSL). It also includes essential step-by-step instructions to enable TLS in Oracle® E-Business Suite® (EBS) R12.
This blog covers the creation and maintenance of disaster recovery (DR) systems for Oracle® Enterprise Business Suites (EBS) applications and describes a generic process to create a version 12.2 applications DR system by using version 12.2.5 systems in the test area.
Doing performance tuning on your database is one of the most common and yet the most important activity that every database administrator (DBA) must perform on an ongoing and regular basis. Experts recommend that you regularly fine-tune databases to optimized performance. Fine-tuning helps users to run their reports and queries faster and get results quicker. This post shares some techniques for troubleshooting and tuning Oracle® databases.
This blog reviews the importance of running an ADOP (Application DBA Online
Patching Utility) cycle with
fs_clone after any changes or technology patches
are made to the Weblogic Server (WLS) or Oracle® Fusion Middleware (FMW)
home directories on your patch file system. The blog explores a problem scenario
and explains how to handle related issues easily.
This blog covers how to use the Oracle® Data Visualization Desktop (DVD) to analyze data.
If you've ever used Aurora Read Replicas, you may have noticed that there are several different endpoints available. The Cluster Endpoint, the Reader Endpoint, and Instance Endpoints... with all of these options, how do you know which one to use and when? As with any non-trivial system, the answer is... it depends. In this blogpost, we'll look at the different endpoints, use-cases for them, and the trade-offs that come with those design decisions.
If you are reading this, you have probably heard of Amazon Aurora. As you know, Amazon Aurora is a PaaS service provided by AWS as part of the RDS suite of services. It provides a fully managed relational database management system (RDBMS) that comes in two flavors, MySQL and Postgres, while maintaining wire compatibility with both. But, how does this impact your high availability strategies and options?
This blog covers some of the changes and new features of Oracle® WebLogic Server® version 12c.
This blog discusses setting up Transparent Data Encryption (TDE) column-level encryption in Oracle® E-Business Suite® (EBS) R12 environment. You can set up column-level encryption on single-column or multiple-column tables, depending on the user requirement.
This post discusses the Oracle® Real Application Clusters (RAC) One Node feature in the Database Enterprise Edition, which was introduced with the 11g Release 2, provides enhanced high availability for single instance Oracle Databases, protecting them from both planned and unplanned downtime. The post also provides instructions for installing the Oracle Grid infrastructure, which is required to use One Node.
Originally published by TriCore: August 29, 2017
Oracle® version 12c offers multitenant database options for host multiple pluggable databases (PDB) with a single container database (CDB). Sometimes, you need to convert a non-CDB database into a CDB pluggable database. This blog describes methods that you can use to convert a non-CDB database into a CDB database.
There are many approaches to upgrading a multi-node Couchbase® Server cluster. This post describes detailed steps for the rolling online upgrade by using the graceful failover and delta recovery method.
Originally published by TriCore: February 12, 2017
This blog takes you through Subledger Accounting (SLA), which is one of the most important features of Oracle® version R12. SLA is the most robust feature in R12, providing the power to modify accounting according to business needs. This blog outlines the difference between R12 and earlier versions of the Subledger, along with some of its key features and components of SLA.
Sometimes businesses require a requisition in order to raise a purchase order (PO) and restrict manual PO creation. This blog shows you how to restrict a user from manually creating a PO.
This blog outlines the steps to change the password for Oracle®'s E-Business
Suite (EBS) APPS schemas and WebLogic®, which is a routine activity for an
Oracle Applications database administrator (DBA). In EBS version R12.2, you can
change passwords by using the
AFPASSWD option, or by using
by some manual steps.
Getting started with MongoDB® is easy. However, you can run into several hiccups with its new features that emerge on an ongoing basis. One such area of concern is security, which is the focus of this blog.
This blog discusses detaching one pluggable database (PDB) from the source container database (CDB) and attaching it to a target CDB. For the purposes of this blog, the PDB is the database in which we save all our application-related databases.
This blog explores Couchbase®, which is an open-source distributed NoSQL document and key-value database, released under the Apache® 2.0 license.
Originally published by TriCore: April 12, 2017
This two-part blog post series covers new performance-tuning features in Oracle® Database. Part 1 discussed Oracle Database version 188.8.131.52. This follow-up post covers version 184.108.40.206.
Originally published by TriCore: April 11, 2017
This two-part blog post series covers new performance-tuning features of Oracle® Database versions 220.127.116.11 and 18.104.22.168. Part 1 discusses the earlier version.
This blog post reviews how to use Amazon Simple Storage Service (S3), as storage for an Oracle® Database backup. Amazon Web Services (AWS) was the first cloud vendor that Oracle partnered with to enable database backup in the cloud. S3 is the main storage offering of AWS.
This post shows you how to integrate Oracle® Discoverer 11g with the single sign-on (SSO) solution delivered by Oracle Access Manager (OAM) 11g. It helps anyone who is looking for a one-stop login solution across different applications.
Originally published by TriCore: June 6, 2017
Oracle® Data Pump (expdp, impdp) is a utility for exporting and importing database objects in and across databases. Part 1 of this two-part blog post series discussed the introduction of multitenant architecture in Oracle Database 12c and how to use Data Pump to export and import data. Part 2 covers how to take an export of only pluggable databases (PDBs) and the restrictions that Data Pump places on PDBs.
Originally published by TriCore: June 6, 2017
Oracle® Data Pump (expdp, impdp) is a utility for exporting and importing database objects in and across databases. While most database administrators are aware of Data Pump, support for multitenant architecture in Oracle Database 12c introduced changes to how Data Pump exports and imports data.
Originally published by TriCore: May 17, 2017
Oracle® Business Intelligence Discoverer is a tool for ad hoc querying, reporting, data analysis, and web publishing for the Oracle database environment.
Oracle® Enterprise Manager (OEM) 12c and 13c includes many performance analysis tools, including a support tool, called OEM Real-Time Automatic Database Diagnostic Monitor (Real-Time ADDM), for the Oracle DBA to use for troubleshooting or tuning real-time, ongoing performance issues. This blog shares knowledge about practical use of Real-Time ADDM to identify and survive an emergency due to any type of database health problems, such as 100% session, process utilization, or exceeding the predefined critical limits setup for input/output (I/O), memory, or interconnect limits. In such cases, Real-Time ADDM is a very handy tool, and provides the capability to do deeper real-time and realistic ADDM analysis of database health, so let's compare RADDM vs. ADDM.
This blog post explores the basics of Oracle® GoldenGate® and its functions. Because it's decoupled from the database architecture, GoldenGate facilitates heterogeneous and homogeneous real-time capture of transactional change data capture and integration.
Online table redefinition allows you to restructure your Oracle® table in production without making the data unavailable. You might be comfortable using temp tables to move data around, but there is a better solution.
Originally published by Tricore: Aug 24, 2017
In Part 1 of this series, we shared some tips for using MongoDB. In Part 2, we cover several more MongoDB topics, including optimization, performance, speed, indexing, schema design, and data safety.
Originally published by Tricore: Aug 2, 2017
While it's easy to get started with MongoDB, more complex issues emerge when you're building applications. You may find yourself wondering things like:
- How do I re-sync a replica member in replica set?
- How can I recover MongoDB after a crash?
- When should I use MongoDB's GridFS specification to store and retrieve files?
- How do I fix corrupted data?
This blog post shares a few tips for handling these situations when you're using MongoDB.
How do you read execution plans? From right to left, left to right, or by checking out costs? Or what about objects like index scans, table scans, and lookups? This blog discusses how to read a Microsoft® SQL Server execution plan.
This blog covers the process for converting a version 11i database to an Oracle® Applications Tablespace Model (OATM) by using an OATM migration utility that has 12 locally managed tablespaces for all products.
Starting with Oracle® 10g, you can partition tables online without any application downtime by using the DBMS_REDEFINITION package.
Use the following steps to change a non-partition table to a partition table by using DBMS_REDEFINITION. This example changes the non-partition table, TABLEA, to a range interval partition table.
Originally published by Tricore: June 14, 2017
This blog identifies the deprecated Microsoft® SQL Server® Database Engine features that are available in SQL Server 2016 and that will be removed in future releases of SQL Server.
Originally published by Tricore: March 15, 2017
In Part 1 of this two-part series, we introduced License Plate Numbers (LPNs) in the Oracle® Warehouse Management System (WMS). In this follow-up post we describe the various types of inventory transactions that you can perform with LPNs.
This post describes the Oracle® In-Memory Advisor (IMA), a feature of Database 12c, and describes its benefits. This feature is available in Oracle Database version 22.214.171.124 and later.
Originally published by Tricore: July 11, 2017
In Part 1 of this two-part series on Apache™ Hadoop®, we introduced the Hadoop ecosystem and the Hadoop framework. In Part 2, we cover more core components of the Hadoop framework, including those for querying, external integration, data exchange, coordination, and management. We also introduce a module that monitors Hadoop clusters.
Originally published by Tricore: July 10, 2017
Apache™ Hadoop® is an open source, Java-based framework that's designed to process huge amounts of data in a distributed computing environment. Doug Cutting and Mike Cafarella developed Hadoop, which was released in 2005.
Built on commodity hardware, Hadoop works on the basic assumption that hardware failures are common. The Hadoop framework addresses these failures.
In Part 1 of this two-part blog series, we'll cover big data, the Hadoop ecosystem, and some key components of the Hadoop framework.
This blog gives an overview of the non-relational database, Apache Cassandra™. It discusses its components and provides an understanding of how the database operates and manages data.
Minimizing downtime and increasing the database availability are essential objectives that every business aspires to achieve. Database Adminstrators (DBAs) are always looking for new ways to provide a faster recovery solution in case of any data file or complete database corruption failure. Starting with version 10g, the Oracle® Recovery Manager (RMAN) offers a feature called Incremental Merge Backups (IMB), which provides a solution to minimize the recovery time, especially for very large databases (VLDB).
Originally published by Tricore: March 14, 2017
In this two-part series, we'll discuss License Plate Numbers (LPN) in Oracle® Warehouse Management System (WMS), why and how to use them, as well as shortcut keys for Mobile Telnet, which is commonly known as PuTTy.
This blog describes the Oracle ® AD Online Patching (adop) utility phases, the patch process cycle steps, and some useful adop commands and tips.
Originally published by Tricore: Aug 14, 2017
This blog describes the following common issues and solutions for the Oracle ® AD Online Patching (adop) utility:
- Data dictionary corruption error
- adop prepare failure
- Forms object generation failure
- adop cutover hang-up
- Patch abort
Every time an Oracle ® Database reads or writes data to a disk, the database generates disk input and output (I/O) operations. The performance of many software applications is limited by disk I/O, and applications that spend the majority of central processing unit (CPU) time waiting for I/O activity to complete are I/O bound. I/O calibration helps to address this issue.
Parallel Replicat is one of the new features introduced in Oracle ® GoldenGate 12c Release 3 (126.96.36.199). Parallel Replicat is designed to help users to quickly load data into their environments by using multiple parallel mappers and threads.
This blog discusses the Oracle Exadata Smart Flash Cache feature and its architecture, including the write-back flash cache feature.
In an Oracle Real Application Clusters (RAC) environment, all the instances or servers communicate with each other using high-speed interconnects on the private network. If the instance members in a RAC fail to ping or to connect to one other via this private interconnect, all the servers that are physically up and running (and the database instances on those servers) might end up in a condition known as split-brain.
Sitecore has the option of making use of TempDB in Sql Server to speed up your session state operations. What catches people off guard is the fact that tempdb is recreated at service restart of SQL Server. This becomes a problem when you have to recreate the table structure and user permissions inside tempdb.
What is MongoDB?
MongoDB is, among other things, a document-oriented NoSQL database. This means that it deviates from the traditional, relational model to present a flexible, horizontally scaling model for data management and organization.
How does MongoDB work with AEM?
MongoDB integrates with Adobe Experience Manager (AEM) by means of the crx3mongo runmode and JVM options: -Doak.mongo.uri and -Doak.mongo.db
Why would I MongoDB?
Primarily MongoDB provides an alternate HA configuration to the older CRX cluster configuration. In reality, the architecture is more similar to a shared catalog on NFS or to NetApp than true clustering. The authors and publishers using MongoDB are not necessarily aware of each other.
If you are an OpenStack contributor, you likely rely on DevStack for most of your work. DevStack is, and has been for a long time, the de-facto platform that contributors use for development, testing, and reviews. In this article, I want to introduce you to a project I'm a contributor to, called openstack-ansible. For the last few months, I have been using this project as an alternative to DevStack for OpenStack upstream development, and the experience has been very positive.
In the first article of this series, we started installing OpenStack from source. We installed keystone and populated it with some basic information including a Services project and an admin user for our new OpenStack install. Additionally, in an initial script we setup users and directories for the upcoming installs of the Image service (glance), Networking service (neutron), Compute service (nova) and Volume service (cinder). Now, let's continue and install and start the glance process on the controller node.
The goal of this post is to develop an application in an environment that's as close to your remote deployment environment as possible. Let's do this using Docker Machine and Compose to move an app from local development to remote deployment.
The choices and combinations we have available during datastore selection prove that we're no longer in the one-size-fits-all datastore world.
Today, there are compelling reasons to mix and match your SQL datastores (such as MySQL, PostgreSQL, Oracle or SQLServer) with your NoSQL datastores (MongoDB, CouchDB, and Neo4J among others). While Oracle may still be the preferred system of record for enterprises, it's no longer the only game in town.
Developers are starting to use combinations of SQL and NoSQL to solve their problems—sometimes against the wishes of DBAs or IT Departments.