2015. 6. 4. 05:40

https://docs.oracle.com/cd/E11882_01/nav/portal_11.htm

 

Oracle Database Online Documentation 11g Release 2 (11.2)

Installing and Upgrading

Installation guides for Oracle Database 11g and accompanying products on various platforms are collected here.

  • Full Installation Guides describe a wider variety of scenarios with more detail.
  • Client Installation Guides describe installing Oracle database client software on hosts where the database server is not installed.
  • Supplementary Installation Guides describe installing products that are included with the database but installed separately.

Essentials

 

Describes Oracle Database licensing. If you have a question about your licensing needs, please contact your Oracle sales representative, or refer to the resources listed in "Related Documents" for more information.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes important last-minute features and changes for releases 11.2.0.1, 11.2.0.2, 11.2.0.3, and 11.2.0.4 not included in Oracle Database Documentation Library.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to manage Oracle and third-party software using the Oracle Universal Installer and OPatch. This guide provides instructions for installing, setting up, and starting the Oracle Universal Installer software. It also provides instructions on cloning and patching Oracle software.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Guides you through the process of planning and performing upgrades for Oracle Database. In addition, this manual provides information about compatibility, upgrading applications, and important changes in the new Oracle Database release, such as initialization parameter changes and data dictionary changes.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Linux Installation Guides

 

Contains important information not included in the Oracle Database documentation for Linux.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Linux x86 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Linux x86-64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Grid Infrastructure for a Single Server on Linux.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Linux x86 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Linux x86-64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Client on Linux.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Z/Linux systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Z/Linux systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Grid Infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Linux.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Microsoft Windows Installation Guides

 

Contains important information not included in the Oracle Database documentation for Windows.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Windows 32-bit systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Windows x64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Grid Infrastructure for a Single Server on Windows.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Windows 32-bit systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Windows x64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Client on Windows.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install the software for Oracle Grid Infrastructure for a cluster, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Microsoft Windows.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Real Application Clusters on the Microsoft Windows platform.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Solaris Installation Guides

 

Contains important information not included in the Oracle Database documentation for Solaris.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Solaris SPARC systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Solaris x86-64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Grid Infrastructure for a Single Server on Solaris.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on Solaris SPARC systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on Solaris x86-64 systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Client on Solaris.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Grid Infrastructure for a Cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Oracle Solaris.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

HP-UX Installation Guides

 

Contains important information not included in the Oracle Database documentation for HP.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on HP Itanium systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on HP-UX PA-RISC systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on HP-UX systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Client on HP-UX systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on HP Itanium systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on HP-UX PA-RISC systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Grid Infrastructure for a Cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running HP-UX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

AIX Installation Guides

 

Contains important information not included in the Oracle Database documentation for AIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database on AIX systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Grid Infrastructure for a Single Server on IBM AIX on POWER Systems (64-Bit).
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to quickly install Oracle Database Client on AIX systems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Client on AIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Grid Infrastructure for a Cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running IBM AIX on POWER Systems (64-Bit).
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Fujitsu BS2000/OSD Installation Guides

 

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Apple Mac OS X

 

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

No summary available.
No summary available.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Supplementary Installation Guides

Products installed separately from the database.

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists in determining hardware and software requirements, installing, configuring, or administering an Oracle Database Gateway for APPC, developing applications that access remote host databases through the gateway using either the SNA communication protocol or the TCP/IP for IMS Connect communication protocol, determining security requirements, and determining and resolving problems.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists Oracle database administrators who are responsible for installing, configuring the components of the Oracle Database Gateway for IMS, VSAM, and Adabas and for diagnosing gateway errors.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists Oracle database administrators who are responsible for installing and configuring Oracle Database Gateways.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes installing the software and configuring Oracle Warehouse Builder (OWB). Part II of this guide provides procedures for administering OWB.
Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

 Describes how to install and configure the products available on the Oracle Database Examples installation media.

Download As...

PDFOpens a new window for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

'DB > oralce' 카테고리의 다른 글

oracle listener error code  (0) 2015.06.07
오라클관련포트  (0) 2015.06.07
Alert Log  (0) 2015.06.04
awr report  (0) 2015.05.25
11g 업그레이드시 방법 결정하는 법  (0) 2015.04.29
Posted by 성장하는yw
2015. 6. 4. 05:30

Fault Diagnosability Infrastructure Components

The following are the key components of the fault diagnosability infrastructure:

 

Automatic Diagnostic Repository (ADR)

The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure across multiple instances and multiple products. Beginning with Release 11g, the database, Oracle Automatic Storage Management (Oracle ASM), the listener, and other Oracle products or components store all diagnostic data in the ADR. Each instance of each product stores diagnostic data underneath its own home directory within the ADR. For example, in an Oracle Real Application Clusters environment with shared storage and Oracle ASM, each database instance and each Oracle ASM instance has an ADR home directory. ADR's unified directory structure, consistent diagnostic data formats across products and instances, and a unified set of tools enable customers and Oracle Support to correlate and analyze diagnostic data across multiple instances.

Note:

Beginning with Release 11g of Oracle Database, because all diagnostic data, including the alert log, are stored in the ADR, the initialization parameters BACKGROUND_DUMP_DEST and USER_DUMP_DEST are deprecated. They are replaced by the initialization parameter DIAGNOSTIC_DEST, which identifies the location of the ADR.

See Also:

"Structure, Contents, and Location of the Automatic Diagnostic Repository" for more information on the DIAGNOSTIC_DEST parameter and on ADR homes.

 

Alert Log

The alert log is an XML file that is a chronological log of database messages and errors. It is stored in the ADR and includes messages about the following:

  • Critical errors (incidents)

  • Administrative operations, such as starting up or shutting down the database, recovering the database, creating or dropping a tablespace, and others.

  • Errors during automatic refresh of a materialized view

  • Other database events

You can view the alert log in text format (with the XML tags stripped) with Enterprise Manager and with the ADRCI utility. There is also a text-formatted version of the alert log stored in the ADR for backward compatibility. However, Oracle recommends that any parsing of the alert log contents be done with the XML-formatted version, because the text format is unstructured and may change from release to release.

 

Trace Files, Dumps, and Core Files

Trace files, dumps, and core files contain diagnostic data that are used to investigate problems. They are stored in the ADR.

 

Trace Files

Each server and background process can write to an associated trace file. Trace files are updated periodically over the life of the process and can contain information on the process environment, status, activities, and errors. In addition, when a process detects a critical error, it writes information about the error to its trace file. The SQL trace facility also creates trace files, which provide performance information on individual SQL statements. You can enable SQL tracing for a session or an instance.

Trace file names are platform-dependent. Typically, database background process trace file names contain the Oracle SID, the background process name, and the operating system process number, while server process trace file names contain the Oracle SID, the string "ora", and the operating system process number. The file extension is .trc. An example of a server process trace file name is orcl_ora_344.trc. Trace files are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation.

Oracle Database includes tools that help you analyze trace files. For more information on application tracing, SQL tracing, and tracing tools, see Oracle Database Performance Tuning Guide.

 

Dumps

A dump is a specific type of trace file. A dump is typically a one-time output of diagnostic data in response to an event (such as an incident), whereas a trace tends to be continuous output of diagnostic data. When an incident occurs, the database writes one or more dumps to the incident directory created for the incident. Incident dumps also contain the incident number in the file name.

 

Core Files

A core file contains a memory dump, in an all-binary, port-specific format. Core file names include the string "core" and the operating system process ID. Core files are useful to Oracle Support engineers only. Core files are not found on all platforms.

 

Other ADR Contents

In addition to files mentioned in the previous sections, the ADR contains health monitor reports, data repair records, SQL test cases, incident packages, and more. These components are described later in the chapter.

'DB > oralce' 카테고리의 다른 글

오라클관련포트  (0) 2015.06.07
설치관련 오라클 공식문서  (0) 2015.06.04
awr report  (0) 2015.05.25
11g 업그레이드시 방법 결정하는 법  (0) 2015.04.29
oracle 설치 참고  (0) 2015.04.06
Posted by 성장하는yw
2015. 5. 25. 20:38

http://wiki.gurubee.net/display/DBSTUDY/AWR

AWR 사용법

1. 아래 경로로 이동

cd /oracle/app/ora/product/11g/db_1/rdbms/admin

=

cd $ORACLE_HOME/rdbms/admin

 

2. sqlplus 접속

sqlplus / as sysdba

 

3. awrrpt.sql 실행

@awrrpt.sql

 

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: text

 

htme/test 모드 중 한가지 선택하면 된다.

 

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name    Instance Host
------------ -------- ------------ ------------ ------------
* 1981839973     1 DBWORKS    DBWORKS db3

Using 1981839973 for database Id
Using        1 for instance number


Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.


Enter value for num_days: 1

 

최근 하루 나는 숫자 1을 입력했다.

 

Listing the last day's Completed Snapshots

       Snap
Instance     DB Name     Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
DBWORKS      DBWORKS  144 25 May 2015 00:00    1
    145 25 May 2015 01:00    1
    146 25 May 2015 02:00    1
    147 25 May 2015 03:00    1
    148 25 May 2015 04:00    1
    149 25 May 2015 05:00    1
    150 25 May 2015 06:00    1
    151 25 May 2015 07:00    1
    152 25 May 2015 08:00    1
    153 25 May 2015 09:00    1
    154 25 May 2015 10:00    1
    155 25 May 2015 11:00    1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 145

 

레포트 분석 시작 구간을 앞 숫자를 보고 입력한다.

문제가 있어서 분석을 원할 경우 당연히, 저 구간이 좁을수록 더 상황분석이 용이하다.

 

Enter value for end_snap: 146
End   Snapshot Id specified: 146

 

분석 끝나는 구간의 숫자 입력

 

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_145_146.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: 0525_145_146_awrreport.txt

 

파일명을 직접 입력하지 않으면 위의 디폴트 명으로 파일이 생성된다.

 

중간내용생략

 


init.ora Multi-Valued Parameters     DB/Inst: DBWORKS/DBWORKS Snaps: 145-146
-> This section only displays parameters that have more one value
->'(NULL)' indicates a missing parameter value
-> A blank in the End Snapshot indicates the same value as the BeginSnapshot

        End value
Parameter Name        Begin value   (if different)
----------------------------- --------------------------------- --------------
control_files        /oradata/DBWORKS/control01.ctl
         /oradata/DBWORKS/control02.ctl
   -------------------------------------------------------------

Dynamic Remastering Stats       DB/Inst: DBWORKS/DBWORKS Snaps: 145-146

    No data exists for this section of the report.
   -------------------------------------------------------------

End of Report
Report written to 0525_145_146_awrreport.txt

 

이 경로에 내가 지정해준 파일명으로 vi나 메모장으로 열어서 분석을 하면 된다.

 

 

'DB > oralce' 카테고리의 다른 글

설치관련 오라클 공식문서  (0) 2015.06.04
Alert Log  (0) 2015.06.04
11g 업그레이드시 방법 결정하는 법  (0) 2015.04.29
oracle 설치 참고  (0) 2015.04.06
정리하기  (0) 2015.04.06
Posted by 성장하는yw