天天學習ORACLE(三)-11G新特性
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 天天學習oracle(一)Oracle
- 天天學習ORACLE(二)Oracle
- 【ORACLE新特性】11G 分割槽新特性Oracle
- Oracle 11g 新特性Oracle
- oracle 11g 的新特性Oracle
- Oracle11新特性——PLSQL新特性(三)OracleSQL
- Oracle 11g SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- Oracle 11g 新特性簡介Oracle
- Oracle 11g 新特性之DRCPOracle
- Oracle 11g新特性:Result CacheOracle
- Oracle 11g 新特性(轉載)Oracle
- Oracle 11g新特性之SecureFilesOracle
- oracle DG 11g新特性彙總Oracle
- ORACLE 11G新特性之列新增操作Oracle
- Oracle 11g 新特性 -- SecureFiles 說明Oracle
- oracle 11g 新特性 表壓縮Oracle
- Oracle 12c 新特性(三)Oracle
- 【DBA】Oracle 11g 針對SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- Oracle 11g 新特性 -- SQL Plan Management 示例OracleSQL
- oracle 11g 新特性 磁碟組檢查Oracle
- Oracle 11G 新特性 Automatic block repairOracleBloCAI
- ORACLE 10G 新特性(INCREMENTALLY UPDATED BACKUPS)學習Oracle 10gREM
- 好好學習,天天向上
- Oracle 11g DG新特性--Automatic block repairOracleBloCAI
- Oracle 11g 新特性 – HM(Hang Manager)簡介Oracle
- ORACLE 11g新特性-統計值掛起Oracle
- oracle 11g 新特性 data recover AdvisorOracle
- oracle 11g 新特性 Flashback Data Archive 說明OracleHive
- Oracle 11g的新特性分割槽:System PartitionOracle
- JDK 1.8 新特性學習(Stream)JDK
- Java1.8新特性學習Java
- java8新特性學習Java
- 11g新特性--Oracle 11g 閃回資料歸檔Oracle
- OceanBase學習之路11|體驗 DDL 新特性(Oracle 模式)Oracle模式
- 新特性:/dev/shm對Oracle 11g的影響devOracle
- 【11g新特性】Oracle 加密表空間-可下載Oracle加密
- oracle 11G新特性--SYSASM 角色--用來管理ASMOracleASM
- oracle 11g R1 asm 磁碟組新特性OracleASM