ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 天天学习ORACLE(三)-11G新特性

天天学习ORACLE(三)-11G新特性

原创 Linux操作系统 作者:anycall2010 时间:2009-03-21 13:49:20 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-24

  • 博文量
    182
  • 访问量
    562964