Start Oracle Database Administration

Oracle Database Administration

Index:

1. Managing Your Database: A Roadmap

2. Introduction to Oracle Enterprise Manager Database Control
3. Configuring the Operating System Environment Variables

4. Starting and Stopping the Database Control Console Process

5. Accessing the Database Home Page

6. Granting Access to Database Control for Nonadministrative Users

7. Creating Database Control Administrative Users

8. Setting Database Control Preferences

9. Administering the Database with SQL-Based Management Tools

10. Getting Started with Oracle Enterprise Manager: Oracle By Example Series

Installation and Creation of Oracle Database

    Installing Oracle Database and Creating a Database

Index:

Overview of Installing Oracle Database Software and Creating a Database
Installing Oracle Database Software
Creating and Managing a Database with DBCA
Installation: Oracle By Example Series

Upgradation  of Oracle Database Release 11.2.0.3.0 to 11.2.0.4.0

Tablespace Management - Troubleshoot Different Issues

Troubleshooting Oracle Tablespace Management

1. Introduction

2. SYSTEM Tablespace Issues

3. SYSAUX Tablespace Issues
4. Temporary Tablespace Issues
5. UNDO Tablespace Issues

Identify - Oracle Database Software Release

Identifying Your Oracle Database Software Release

Because Oracle Database continues to evolve and can require maintenance, Oracle periodically produces new releases. Not all customers initially subscribe to a new release or require specific maintenance for their existing release. As a result, multiple releases of the product exist simultaneously.

As many as five numbers may be required to fully identify a release. The significance of these numbers is discussed in the sections that follow.

Release Number Format

To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled "Release 10.1.0.1.0".

Figure 1-1 Example of an Oracle Database Release Number

Description of Figure 1-1 follows

Description of "Figure 1-1 Example of an Oracle Database Release Number"

Note:

Starting with release 9.2, maintenance releases of Oracle Database are denoted by a change to the second digit of a release number. In previous releases, the third digit indicated a particular maintenance release.

Major Database Release Number

The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.

Database Maintenance Release Number

The second digit represents a maintenance release level. Some new features may also be included.

Application Server Release Number

The third digit reflects the release level of the Oracle Application Server (OracleAS).

Component-Specific Release Number

The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

Platform-Specific Release Number

The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.

Checking Your Current Release Number

To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION. A sample query follows. (You can also query the V$VERSION view to see component-level information.) Other product release levels may increment independent of the database server.

COL PRODUCT FORMAT A35

COL VERSION FORMAT A15

COL STATUS FORMAT A15

SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT                                  VERSION     STATUS

---------------------------------------- ----------- -----------

NLSRTL                                   10.2.0.1.0  Production

Oracle Database 10g Enterprise Edition   10.2.0.1.0  Prod

PL/SQL                                   10.2.0.1.0  Production

...

Screenshot

It is important to convey to Oracle the results of this query when you report problems with the software.

Oracle Database Storage Structures

Oracle Database Storage Structures

Happy Friendship Day

A True friend is hard to find... They are rare & one of kind.. I don't care if I have only few.. at least I have one of the best YOU.