Oracle/Database

From Omnia
Revision as of 15:43, 15 April 2015 by Kenneth (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Subpage Table of Contents

Oracle Download

Oracle Database Software Downloads

  • Includes Oracle 10g and 11g

Oracle Database 11g for Linux Downloads

Oracle 11g Installation

Oracle Database Online Documentation 11g Release 2 (11.2) - http://www.oracle.com/pls/db112/homepage

Oracle Database Online Documentation 11g Release 1 (11.1) - http://www.oracle.com/pls/db111/homepage

Windows Server

See Oracle/Database/Oracle 11gR2 Windows Server Install

RHEL

See Oracle/Database/Oracle 11g RHEL5 Install

See Oracle/Database/Oracle 11g RHEL6 Install

SLES

See Oracle/Database/Oracle 11g SLES Install

Oracle 10g Installation

Windows Server

See Oracle/Database/Oracle 10g Windows Server Install

RHEL

See Oracle/Database/Oracle 10g RHEL4 Install

See Oracle/Database/Oracle 10g RHEL5 Install

SLES

See Oracle/Database/Oracle 10g SLES Install

Enterprise Manager

Enterprise Manager Database Control URL - (orcl) :

https://[HOSTNAME]:1158/em

Check status of Enterprise Manager:

$ export ORACLE_SID=[orcl]
$ emctl status dbconsole

To start the Enterprise Manager:

$ export ORACLE_SID=[orcl]
$ emctl start dbconsole

ORION

Oracle ORION

ORION (Oracle I/O Calibration Tool) is a standalone tool for calibrating the I/O performance for storage systems that are intended to be used for Oracle databases. The calibration results are useful for understanding the performance capabilities of a storage system, either to uncover issues that would impact the performance of an Oracle database or to size a new database installation. Since ORION is a standalone tool, the user is not required to create and run an Oracle database.

With the goal of closely mimicing the Oracle database, ORION generates a synthetic I/O workload, using the same I/O software stack as Oracle. ORION can be configured to generate a wide range of I/O workloads, including ones that simulate OLTP and data warehouse workloads.

ORION is available for many platforms. Support for additional platforms will be added in the future. The User's Guide provides detailed usage documentation, including a "getting started" section and trouble-shooting tips. A summary of how to use ORION is also available directly from ORION by invoking the "-help" option.

Please note that ORION is not supported by Oracle.

Ignore pre-requisite failures

$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-2.1, UnitedLinux-1.0, redhat-3, SuSE-7 or SuSE-8
                                      Failed <<<<

>>> Ignoring required pre-requisite failures.

Oracle Tools

Ping Oracle DB Server Listener:

tnsping [ORACLE_HOST_ADDRESS]

SQL*Plus

See Oracle/Database/sqlplus

What is SQL*Plus and where does it come from? - http://www.orafaq.com/wiki/SQL*Plus_FAQ

SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database.

Oracle Configuration Manager (OCM)

See Oracle/Database/Oracle OCM


Check:

  • Navigate to the ccr/bin directory and locate the file emCCR. If emCCR exists, OCM has been configured.
  • If emCCR is not present under the ccr/bin directory, OCM has been installed but not configured.
  • If the ccr directory does not exist, Oracle Configuration Manager has not been installed with your Oracle product release.

Usage:

$ORACLE_HOME/ccr/bin/setupCCR.exe
# NOTE: will ask for Oracle support account and password
$ORACLE_HOME/ccr/bin/emCCR status  # service status

$ORACLE_HOME/ccr/bin/emCCR start   # start service
$ORACLE_HOME/ccr/bin/emCCR stop    # stop service

$ORACLE_HOME/ccr/bin/emCCR test    # test each connection

$ORACLE_HOME/ccr/bin/emCCR collect # manually collect and upload
$ORACLE_HOME/ccr/bin/emCCR upload  # manually upload last collection (again?)


DOWNLOAD:

Login to My Oracle Support and click the Collector tab. The Install Configuration Manager page is displayed. Select the appropriate platform on which Oracle Configuration Manager is to be installed and click Download.

WHAT:

The configuration manager centralizes configuration information based on your Oracle technology stack. Oracle uses secure access to your configuration information to help you achieve problem avoidance, faster problem resolution, better system stability, and easier management of your Oracle systems.

WHY:

Faster problem resolution from integrating your configuration information into the service request flow providing Oracle Support the information they need real-time to resolve your problem quickly and efficiently.

Improved systems stability delivered through proactive advice & health checks driven by Oracle best practices and personalized to your system configuration.

Simplified configuration management from a single, comprehensive and personalized dashboard of configurations, projects and inventory.

Get Results. Other customers have reported 40% faster issue resolution, a 30% reduction in the time it takes to log a Service Request, and 25% problem avoidance with Alerts and Health Checks.

HOW:

Installed on your host, the configuration manager continuously tracks key Oracle and system details, providing essential data to help you manage and service your configurations. Collected data is sent via HTTPS to Oracle Support, which maintains a secure view of each configuration. My Oracle Support then provides system health checks, patch advice, and other valuable information about your Oracle products.

Oracle Notes

See Oracle/Database/Notes

keywords

oracle