oracle asm版本,Oracle 10gR2:ASM透明的多版本支持

Oracle 10gR2:ASM透明的多版本支持

SQL> col instance_name for a10

SQL> select * from v$asm_client;

GROUP_NUMBER INSTANCE_N DB_NAME STATUS

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

1 +ASM mmsdb CONNECTED

在Oracle10gR2中，通过ASM实例我们可以看到ASM上连接数据库的版本及兼容性信息:

[oracle@danaly ~]$ export ORACLE_SID=+ASM

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 6 20:46:44 2006

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> col compatible_version for a18

SQL> col software_version for a16

SQL> select * from v$asm_client;

GROUP_NUMBER INSTANCE_N DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION

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

1 danaly danaly CONNECTED 10.2.0.1.0 10.2.0.1.0

SQL>

SQL> set linesize 120

SQL> show parameter compatible

NAME TYPE VALUE

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

compatible string 10.2.0

在Oracle10gR2中，通过Database实例我们可以看到ASM版本及兼容性信息:

[oracle@danaly ~]$ export ORACLE_SID=danaly

[oracle@danaly ~]$ sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 6 20:53:43 2006

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> col software_version for a16

SQL> col compatible_version for a18

SQL> set linesize 120

SQL> col instance_name for a13

SQL> select * from v$asm_client;

GROUP_NUMBER INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION

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

1 +ASM danaly CONNECTED 10.2.0.1.0 10.2.0.0.0

SQL> show parameter compatible

NAME TYPE VALUE

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

compatible string 10.2.0.1.0

SQL>

历史上的今天...

>>

2011-09-06文章:

2010-09-06文章:

2008-09-06文章:

2007-09-06文章:

By eygle on 2005-09-06 20:44 |

Comments (0) |

Oracle12c/11g | 421 |