In working with SQL Server, you may have encountered errors related to unresolved deadlock and scheduler deadlock. Many people blend these errors together, but they are actually separate issues. In this post, we provide a high-level explanation of both types of deadlock errors. Unresolved Deadlock In general, an unresolved deadlock is a SQL Server product […]
A great database appliance can be critical for the optimum functioning of your company. After all, databases provide storage for large volumes of data, and data is highly important for many companies. Three of the best database appliances on the market are the Oracle Database Appliance (ODA) X6-S, X6-2M, and X5-2 High Availability (HA). In […]
As business needs change and the focus on security increases, the landscape of data storage and analytics options is growing more complex. Discover the common database management challenges businesses face and how to avoid them by selecting an effective database management solution. 5 Challenges Companies Have with Database Management: And How to Choose the Right Solution […]
Trends may come and go, but many new concepts in database management have staying power, as well as the ability to greatly impact the organizations that integrate them. Every organization wants to stay updated with the latest trends in database management as well as how to best take advantage of them to benefit their business. Database Management […]
Oracle was a late entrant to the cloud business, launching that just in 2015. Larry Ellison and Mark Hurd were reluctant as they saw the cloud as something that could cut into their revenue stream for traditional software licenses. But now they, like the vast majority of the industry, have embraced the cloud model. Here, […]
Let’s face it, Oracle’s licensing policies around its various software product suites are not known for being straightforward. Between core factors, VM restrictions, version upgrade limitations, and user minimums, it can be difficult to tell whether or not your organization is compliant with Oracle’s database licensing requirements. Oracle’s complex licensing policies, along with the fact […]
RMAN cross-platform database transport is ability to migrate the entire database from one operating system platform to another, so long as the two endian formats are the same. In this post, we provide a step-by-step guide for using RMAN to perform cross-platform Oracle database migration from Windows to Linux. When converting the database from one […]
Corporate information is a critical differentiator for organizations and their customers. Financial intelligence, personally identifiable information (PII), trade secrets and other proprietary information are common forms of data stored in databases. In order to protect this information from internal and external misuse or attack, businesses must implement security measures as close to the data as […]
In our last post, we shared the 4 most important areas of database security and discussed how to safeguard your Oracle environment with best practices for Authentication and Access Controls. In this post, we continue with a breakdown of Oracle database security best practices for Secure Oracle Configuration and Database Auditing. Secure Oracle Configuration Secure Listener Configuration Listener authentication should be local OS user. Implement […]
The purpose of this post is to provide a step-by-step guide to the migration of OBIEE 11g to OBIEE 12c. The method outlined in this documentation is “Out-of-place”: were a new OBIEE 12c installation is performed followed by a migration of relevant files to the new installation using the BI Migration Tool. This new tool generates […]