天天學習ORACLE（三）-11G新特性

anycall2010發表於2009-03-21
原文網址 : http://blog.itpub.net/8334342/viewspace-573291/
Oracle

ORACLE 11G的 automatic diagnostic repository 的新特性比較好，前天在AS5.0上安裝了ORACLE 11G，感覺效能還不錯。感覺ORACLE的LINUX 5.2做的還不錯，速度比5.1快多了，可能加入不少的優化。ORACLE 11G的診斷功能加強不少：

SQL> show parameter diag;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      /oracle

SQL> select * from V$diag_info;

   INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 Diag Enabled
TRUE

         1 ADR Base
/oracle

         1 ADR Home
/oracle/diag/rdbms/orcl/orcl


   INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 Diag Trace
/oracle/diag/rdbms/orcl/orcl/trace

         1 Diag Alert
/oracle/diag/rdbms/orcl/orcl/alert

         1 Diag Incident
/oracle/diag/rdbms/orcl/orcl/incident


   INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 Diag Cdump
/oracle/diag/rdbms/orcl/orcl/cdump

         1 Health Monitor
/oracle/diag/rdbms/orcl/orcl/hm

         1 Default Trace File
/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_16475.trc


   INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 Active Problem Count
0

         1 Active Incident Count
0

並且引入了一個新的功能ADRCI，很方便的一個東東。

[oracle@rac1 ~]$ adrci

ADRCI: Release 11.1.0.6.0 - Beta on Sat Mar 21 01:08:01 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/oracle"
adrci> show alert

Choose the alert log from the following homes to view:

1: diag/clients/user_oracle/host_1874443374_11
2: diag/clients/user_unknown/host_411310321_11
3: diag/tnslsnr/rac1/listener
4: diag/rdbms/orcl/orcl
Q: to quit

Please select option: 1
Output the results to file: /tmp/alert_16587_3086_host_1874443374_11_1.ado
2009-03-20 23:00:21.208000 -08:00
Create Relation ADR_CONTROL
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS


***********************************************************************

Fatal NI connect error 12505, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=emagent@rac1)(HOST=rac1)(USER=oracle))))

  VERSION INFORMATION:
TNS for Linux: Version 11.1.0.6.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
  Time: 20-MAR-2009 23:00:21
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12564

TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

adrci> show incident

ADR Home = /oracle/diag/clients/user_oracle/host_1874443374_11:
*************************************************************************
0 rows fetched

ADR Home = /oracle/diag/clients/user_unknown/host_411310321_11:
*************************************************************************
0 rows fetched

ADR Home = /oracle/diag/tnslsnr/rac1/listener:
*************************************************************************
0 rows fetched

ADR Home = /oracle/diag/rdbms/orcl/orcl:
*************************************************************************
0 rows fetched


而且在ASM中，又增加了一個CP功能，大大方便ASM的管理。

[oracle@rac1 ~]$ asmcmd
ASMCMD-08103: failed to connect to ASM; ASMCMD running in non-connected mode
ASMCMD> help
        asmcmd [-v] [-a ] [-p] [command]

        The environment variables ORACLE_HOME and ORACLE_SID determine the
        instance to which the program connects, and ASMCMD establishes a
        bequeath connection to it, in the same manner as a SQLPLUS / AS
        SYSDBA.  The user must be a member of the SYSDBA group.

        Specifying the -v option prints the asmcmd version number and
        exits immediately.

        Specify the -a option to choose the type of connection. There are
        only two possibilities: connecting as "sysasm" or as "sysdba".
        The default value if this option is unspecified is "sysasm".

        Specifying the -p option allows the current directory to be displayed
        in the command prompt, like so:

        ASMCMD [+DATAFILE/ORCL/CONTROLFILE] >

        [command] specifies one of the following commands, along with its
        parameters.

        Type "help [command]" to get help on a specific ASMCMD command.

        commands:
        --------
        help

        cd
        cp
        du
        find
        ls
        lsct
        lsdg
        mkalias
        mkdir
        pwd
        rm
        rmalias

        md_backup
        md_restore

        lsdsk
        remap

ASMCMD>

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8334342/viewspace-573291/，如需轉載，請註明出處，否則將追究法律責任。

相關文章