background preloader


Facebook Twitter

Mise en oeuvre d'ASM avec UDEV sous linux - ArKZoYd. ORACLE-BASE - Tracking Database Feature Usage (DBA_FEATURE_USAGE_STATISTICS) Avoid Licensing Traps. It’s easy to run into licensing issues with the Oracle database.

Avoid Licensing Traps

A “wrong” SQL command – and you’ve used an additional option of the database and you can get in trouble at the next licensing audit. This blog post lists some basic steps that can help to avoid such problems. Disclaimer: the aspects listed here are by no means exhaustive and complete and cannot replace license consulting. The most important information on Oracle database licensing is available in the following documents: The following procedure may help in avoiding licensing issues: ORACLE-BASE - Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1 (ADRCI) Auto Start/Shutdown Oracle Database 11g R2 on Linux. Installing Oracle Database 11g R2 on a Linux Server (you can check my previous post) does not provide the database the possibility to preform an automatic startup/shutdown when the system is starts or shutdown, we need to do it manually!

Auto Start/Shutdown Oracle Database 11g R2 on Linux

So here is a few steps to make it happen automatically. The automatic startup and shutdown of the Oracle database can be achieved with the files dbstart and dbshut both provided by Oracle. These files rely on the existence of the file /etc/oratab to work. Stopping and Starting Oracle Software. This chapter describes how to identify Oracle Database processes, and provides basic information about how to stop and restart them.

Stopping and Starting Oracle Software

It also describes how to set up automatic startup and shutdown of the Oracle Database. It contains the following sections: Note: When using Oracle Restart, you can use Service Control Utility (SRVCTL), a command-line interface, to manage Oracle processes (database instance, listener, Oracle ASM instance). Managing Initscripts with Red Hat's chkconfig. I love discovering new UNIX commands, especially those with a system administration flavor.

Managing Initscripts with Red Hat's chkconfig

When I learned Red Hat distributed the chkconfig utility, it brought back fond memories of chkconfig under IRIX, a UNIX variant from Silicon Graphics, Inc. IRIX's chkconfig was designed to enable/disable services for automatic launch during system initialization without editing, renaming or moving initscripts in /etc. Similarly, Red Hat designed chkconfig to help manage services launched during system initialization. C Creating Operating System Groups and Users Requirements. The appendix explains what operating system groups and users you need to create and how to create them.

C Creating Operating System Groups and Users Requirements

In particular, this appendix covers the following: What Operating System Groups and Users Are Required? The following operating system group and user are required for all installation types: The Oracle Inventory Group (oinstall)You must create this group the first time you install Oracle software on the system. Options and Packs. This chapter describes the separately licensed Oracle Database options, management packs, and other products you can purchase to enhance the capabilities of Oracle Database in specific application environments.

Options and Packs

This chapter contains the following sections: You may not use the options, packs, or products described below without separately purchased licenses. The fact that these options, packs, or products may be included in product CDs or downloads or described in documentation that you receive does not authorize you to use them without purchasing appropriate licenses. Oracle Database Options. Why Not Consider Oracle Standard Edition? The dramatic price differential between Oracle Standard Edition and Oracle Enterprise Edition creates a compelling case for considering Standard Edition as an alternative to Enterprise Edition.

Why Not Consider Oracle Standard Edition?

With the addition of third-party technology, Oracle Standard Edition can deliver enterprise-class performance at a substantially reduced cost. How does Oracle Standard Edition compare to Enterprise Edition?