Oracle database with linux

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

Check the spelling of your keyword search.
Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
Try one of the popular searches shown below.
Start a new search.

Oracle Database Runs Best on Oracle Linux

Oracle Database on Oracle Linux helps customers lower IT costs while delivering high quality of service. With Oracle Database 12c and Oracle Linux, customers benefit from the joint development and testing done by Oracle to deliver the best features, stability and performance to enable the next generation of cloud computing.

Performance Leadership

Oracle Linux is optimized for the Oracle Database and continues to set world record benchmarks on x86 servers. Oracle Linux and the Oracle Database set the world record for x86 system on Oracle’s Sun X2-8 server, beating the competition by 68 percent and showing performance number 3X faster than the best published eight CPU result. Oracle Linux and the Database also hold the record TPC-C Benchmark for a 2 processor system with Cisco UCS™ C240 M3 Rack server with two Intel® Xeon® E5-2690 2.9 GHz processors, delivering 34 percent more performance at 32 percent less cost per transaction.

It is no wonder with Oracle Linux database performance and scalability is greatly increased. Our model is unmatched by any competitor in scope or scale. The joint development and testing between Oracle Linux and the Oracle Database ensures the operating system is optimized and tuned to provide the best performance for the Oracle Database.

One great example is the Database Smart Flash Cache (PDF) feature which was introduced in Oracle Database 11g Release 2. It allows customers to expand the database buffer cache beyond the main memory to a second level cache on flash memory thereby greatly increasing transaction throughput and improving application response times for IO-intensive applications. This feature is only available on Oracle Linux and Oracle Solaris (Oracle Solaris 11 or Oracle Solaris 10 10/08 or later).

«SEI values Oracle, which is helping us drive an industry-leading departure from legacy, mainframe-based solutions to a more modern infrastructure. Oracle Linux gives SEI the stability and performance our business processes require. Additionally, it allows us to scale to meet company growth and customer demands, while increasing efficiency and effectiveness. As a result, we’ve built a fully-integrated, reliable infrastructure on the Oracle stack, which has enabled us to provide the next-generation wealth-management offering, unlike anything available in the market today.”

—Martin Breslin, Senior Infrastructure Architect, SEI

Mission Critical Reliability, Availability and Serviceability

You can reduce downtime costs by protecting your business from all common causes of planned and unplanned downtime, by running your database on Oracle Linux. Oracle Linux Basic and Premier Support subscriptions include Oracle Clusterware at no additional charge. Oracle Clusterware is a powerful solution for high availability and redundancy in the data center. As the foundation for Oracle Real Application Cluster (RAC), Clusterware is a highly scalable, agile solution supporting both physical and virtual environments.

Mission critical workloads depend on the latest innovations in technology to protect business critical information. Silent data corruption can be catastrophic and cost a company millions in lost revenue and incurred expenses. Oracle Linux and the Oracle Database teams collaborate with leading technology partners, like EMC and Emulex, to develop standards-based end-to-end data Integrity solutions implementing the T10 Protection Information (T10 PI) standard with the objective of eliminating silent data corruption.

Integrated Solutions with Unparalleled Performance with Oracle Engineered Systems

Customers will experience extreme performance and scalability when they leverage the features found in Oracle’s Engineered System, featuring Oracle Linux. Engineered to work together, these integrated solution are unmatched in the industry, allowing customers to reduce IT costs through consolidation and rapid deployments.

With Oracle Exadata Database machines, customers can store up to ten times more data, improving performance of all applications and delivering a faster time-to-market by eliminating systems integration trial and error and with Oracle Exalogic Elastic Cloud, customers rapidly deploy business applications in an integrated, finely tuned environment.

Oracle Linux is optimizedto support the high performance standards and critical business objectives for Oracle Engineered Systems. This is the reason that the majority of engineered systems deployed today are running Oracle Linux.

“Epsilon offers a broad array of data-driven, multichannel marketing solutions for many of the biggest brands in the world. Our information systems have been experiencing substantial growth year-over-year, with increased demand for real-time reporting, and high performance transaction processing. To enable customers to interact with a brand in a more dynamic real-time manner, we knew our infrastructure had to be comprehensive, well integrated and scalable. With our Oracle Exadata Database Machines running Oracle Linux, we are achieving transactional processing speeds that were previously not attainable. Oracle’s technologies and world-class support have been instrumental in enabling us to deliver new value-add services and greater efficiency for clients.”

—Jeff White, Vice President, Technology, Strategic Database Services, Epsilon.

“Because we advocate an Oracle stack, we leapt at the opportunity to use Oracle Database Appliance to underpin our business systems,” said Walters. “The idea of a high-performance, fully integrated storage, server, and database solution was very appealing. We get the best of Oracle’s three technologies, one support contract, one service organization, and no issues due to incompatible systems.”

Essential Security and Accountability

Advanced security features found in Oracle Database 12c and available on Oracle Linux provide a comprehensive portfolio of security solutions to ensure data privacy, protect against insider threats, and enable regulatory compliance.

Oracle Database Transparent Data Encryption and Data Redaction provide the tools to encrypt application data in database columns or entire tablespaces and also provide on-the-fly redation to limit exposure of sensitive information in applications.

Oracle Audit Vault and Database Firewall provide a first line of defense for databases and can be used to consolidate audit and event logs from the Oracle Database with those found on Oracle Linux. This expands enterprise auditing capabilities by collecting, consolidating, and managing logs across the data center.

Agile Cloud Environments

Oracle VM combined with Oracle Linux and Oracle Database 12c, provides the perfect combination of solutions and tools for developing the next generation cloud data center. Customers can leverage the latest Oracle VM templates for Oracle Database 12c which can be used to quickly deploy either single instances or RAC clusters with Oracle Linux. In addition, Oracle Enterprise Manager 12c is integrated with Oracle VM and Oracle Linux , allowing customers to easily manage their entire environment through a single tool.

“Our migration to Oracle Linux and Oracle VM on Intel X86 platforms brought performance improvements and financial gains. It also ensured excellent support from a single vendor for quicker issue resolutions. We were able to increase the number of processor cores to meet additional processing power requirements without incurring more license costs.”

Unique Diagnostics and Zero-downtime Kernel Updates

You can troubleshoot performance problems in real time on production systems with Oracle Linux and DTrace. DTrace is designed to safely and quickly identify the root cause of system performance problems without rebooting the kernel or recompiling — or even restarting—applications. It provides a single view of the software stack—from kernel to application— leading to rapid identification of performance bottlenecks.

With Ksplice, Oracle Database 12c customers receive an important maintenance and diagnostic feature which is only available on Oracle Linux. The Oracle Ksplice service allows administrators to conduct critical diagnostics of kernel issues and features to apply patches (critical kernel bug fixes, temporary hot fixes and security updates) without any reboot of the system or downtime to the database or applications.

«The introduction of the Ksplice technology (as part of Oracle Linux), which allows for applying Linux patches with no downtime, was a game changer for the organization. So we targeted our development and production deployments — about 60% of our servers — for premier support»

Fastest Deployment, Lowest Risk

Oracle Linux customers have access to the Oracle Linux Preinstall rpm packages, allowing administrators to quickly prepare an instance of Oracle Linux (physical or virtual) for the Oracle Database 12c installation. This rpm package will automatically verify whether the Oracle Linux system meets the minimum system requirements and recommended installation requirements for Oracle Database 12c and through a completely automated process will install any missing packages as well as modify the necessary system settings and create the required users and groups. This eliminates several manual steps and allows the administrator to move immediately to the database installation.

Oracle Validated Configurations lower the cost of deployment by offering pre-tested, validated architectures which include the software, hardware, storage and networking components. Oracle Validated Configurations are generated through collaborations with other technology partners and are offered at no additional charge.

Источник

How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6

by Ginny Henningsen; updated by Michele Casey
Published September 2012 (updated September 2017)

How to simplify the installation of Oracle Database 12c or 11g on Oracle Linux 6 by installing the oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall RPM package, which automatically performs a number of tasks, such as installing required software packages, resolving package dependencies, and modifying kernel parameters.

READ THIS FIRST: Important Changes Since Publication

While the content in this article is still valid, several details have changed. For example:

For Oracle Database 12c Release 2, the preinstall RPM has a different name than the one used in the article belowpu:

oracle-database-server-12cR2-preinstall

The preinstall RPMs are published on Oracle Linux yum server for both Oracle Linux 6 and 7 in the Latest repositories which are configured and enabled by default in recent releases of Oracle Linux 6 and 7

Introducing the oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPM for Oracle Linux

Before installing Oracle Database 12c or 11g on a system, you need to preconfigure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters. (Be sure to review the appropriate Oracle Database installation guide to familiarize yourself with hardware, software, and operating system requirements.)

Note: This article applies to Oracle Linux 6. A previous article, «How I Simplified Oracle Database Installation on Oracle Linux,» covered performing a similar task on versions of Oracle Linux 5.

On Oracle Linux, I discovered that there is a remarkably easy way to address these installation prerequisites: First, depending on your database version, install either the RPM package called oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall . This RPM performs a number of preconfiguration steps, including the following:

Automatically downloading and installing any additional software packages and specific package versions needed for installing Oracle Grid Infrastructure and Oracle Database 12 c Release 1 (12.1) or 11g Release 2 (11.2.0.3), with package dependencies resolved via yum or up2date capabilities.
Creating the user oracle and the groups oinstall (for OraInventory ) and dba (for OSDBA ), which are used during database installation. (For security purposes, this user has no password by default and cannot log in remotely. To enable remote login, please set a password using the passwd tool.)
Modifying kernel parameters in /etc/sysctl.conf to change settings for shared memory, semaphores, the maximum number of file descriptors, and so on.
Setting hard and soft shell resource limits in /etc/security/limits.conf , such as the locked-in memory address space, the number of open files, the number of processes, and core file size.
Setting numa=off in the kernel for x86_64 machines.

Note that oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall parses the existing /etc/sysctl.conf and /etc/security/limits.conf files and updates values only as needed for database installation. Any precustomized settings not related to database installation are left as is.

The oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPM packages are accessible through the Oracle Unbreakable Linux Network (ULN, which requires a support contract), from the Oracle Linux distribution media, or from the Oracle public yum repository. Thus, whether or not your system is registered with ULN to access Oracle patches and support, you can use oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall to simplify database installation on Oracle Linux. In addition, the Oracle public yum repository now includes all security and bug errata, ensuring systems are secured and stable with the latest security updates and bug fixes.

Installing the oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall RPM

The remainder of this article steps through the procedure that I used for installing oracle-rdbms-server-11gR2-preinstall on Oracle Linux via the Oracle public yum repository. The same steps outlined in the following section can be used for either version of the preinstall RPM package. I started with a system running Oracle Linux Release 6 Update 4 for x86_64, a 64-bit version of Oracle Linux that I downloaded from the Oracle software delivery cloud (requires registration or login). First, I set up a yum configuration file that pointed to the correct repository, and then I installed the oracle-rdbms-server-11gR2-preinstall RPM from that repository.

Here are the steps for preconfiguring a system for Oracle Database installation using oracle-rdbms-server-11gR2-preinstall . Remember, the steps are the same when using the oracle-rdbms-server-12cR1-preinstall package; you simply need to change the name of the RPM package during the yum installation step.

As an authorized user (for example, root ), retrieve the file that configures repository locations:

Using a text editor, modify the file, changing the field enabled=0 to enabled=1 to reflect repositories that correspond to the machine’s operating system release.

Here is an excerpt of public-yum-old6.repo with the changed lines in boldface.

Because the target system is running Oracle Linux Release 6 Update 4 for x86_64, which installs the Oracle Unbreakable Enterprise Kernel by default, there are two repositories to enable, [ol6_latest] and [ol6_UEK_latest] .

Next, install the oracle-rdbms-server-11gR2-preinstall RPM using the yum install command. If you are using Oracle Database 12c, then you would type yum install .

The output in Listing 1 shows how the installation checks dependencies and then downloads and installs the required packages.

Listing 1: Installing the oracle-rdbms-server-11gR2-preinstall RPM

The yum installation logs messages about kernel changes in the file /var/log/oracle-rdbms-server-11gR2-preinstall/results/orakernel.log , and it makes backups of current system settings in the directory /var/log/oracle-rdbms-server-11gR2-preinstall/backup .

At this point, the system is ready for the installation of Oracle Database. For example, to install Oracle Database 11g Release 2, follow the directions in Chapter 4, «Installing Oracle Database,» of the Database Installation Guide for Linux.»

Here are the steps I followed while installing Oracle Database 11g Release 2 in my test environment. Make sure you review all documentation and follow recommended best practices before installing into your production environment.

As root , create a parent directory in a file system that has sufficient space to be the target location for the downloaded files:

The amount of disk space needed in the file system varies according to the specific installation type, but roughly twice the size of the zip archives, or 5 GB, is enough to house the software and data files.

Into this target directory, download the installation media files from the Oracle Database Software Downloads page on Oracle Technology Network.

Extract the files:

Log in as the user oracle . Change directory to the database directory and enter the following command to run the Oracle Universal Installer:

The Oracle Universal Installer performs a number of checks, verifying that the necessary OS packages and versions are installed. In addition, it checks kernel parameters set by the oracle-rdbms-server-11gR2-preinstall installation. During the kernel settings check, the installer might flag a few settings as «failed,» and you should investigate these failures. In some cases, you still might be able to continue with the database installation. If you check kernel settings in /etc/sysctl.conf , you’ll see that oracle-rdbms-server-11gR2-preinstall has modified and added the necessary settings to ensure the minimum requirements are met, as defined in section 2.10.1. Below is the list of requirements:

If necessary, you can (as root ) edit the file /etc/sysctl.conf to specify a setting manually, for example:

The Oracle Universal Installer performs additional checks, such as verifying the glibc version, sufficient disk space, environmental variable and path settings, and sufficient physical memory and swap space. Generally, installing oracle-rdbms-server-11gR2-preinstall takes care of the prerequisites so that you can proceed directly with installing the database.

Final Thoughts

Installing the oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPMs can save time when installing Oracle Database 12c and 11g on Oracle Linux. These RPMs address most Oracle Database installation prerequisites and greatly simplify the installation process.

About the Authors

Ginny Henningsen has worked for the last 15 years as a freelance writer developing technical collateral and documentation for high-tech companies. Prior to that, Ginny worked for Sun Microsystems, Inc. as a Systems Engineer in King of Prussia, PA and Milwaukee, WI. Ginny has a BA from Carnegie-Mellon University and a MSCS from Villanova University.

Michele Casey is the Director of Product Management for Oracle Linux. She has worked with commercial Linux distributions and open source projects as a product manager since 2006. She has also held positions as a system administrator, project manager, and technical support engineer.

Revision 1.1, 07/09/2013; added information about using the
oracle-rdbms-server-12cR1-preinstall package to install
Oracle Database 12c

Источник

Oracle database with linux