Lunar的oracle实验室 - 世间所有相遇都是久别重逢

将一个linux下的pdb插入到windows下的cdb

发表于 2013 年 8 月 11 日由 Lunar

ORACLE 12C引进了pdb的概念，确实非常强大，这里通过试验测试简单的测试完成了从linux平台unplug一个pdb，然后顺利的插入到win的cdb中，整个过程简洁方便，具体操作见将一个linux下的pdb插入到windows下的cdb

发表在 ORACLE 12C | 标签为 12c, pdb | 留下评论

expdp导出数据到asm中

发表于 2013 年 8 月 10 日由 Lunar

asm中创建目录

ASMCMD> pwd
+
ASMCMD> cd data
ASMCMD> pwd
+data
ASMCMD>  mkdir expdptest
ASMCMD> ls -l    
Type      Redund  Striped  Time             Sys  Name
                                            Y    ASM/
                                            Y    CDB/
                                            Y    ORA11G/
                                            Y    _MGMTDB/
                                            N    expdptest/
PASSWORD  UNPROT  COARSE   JUN 28 22:00:00  N    orapwasm => +DATA/ASM/PASSWORD/pwdasm.256.819326571
                                            Y    lunar-cluster/

数据库创建目录

SYS% cdb1>  create or replace directory lunardump as '+DATA/expdptest';

Directory created.

SYS% cdb1>  create table lunartest as select * from dba_users;

Table created.

expdp导出数据到asm

[oracle@lunar tmp]$ expdp "'/ as sysdba'" DUMPFILE=lunar.dmp DIRECTORY=LUNARDUMP CONTENT=METADATA_ONLY logfile=DATA_PUMP_DIR:expdp01.log

Export: Release 12.1.0.1.0 - Production on Fri Aug 9 01:55:15 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting "C##LUNAR"."SYS_EXPORT_SCHEMA_01": "'/ as sysdba'" DUMPFILE=lunar.dmp DIRECTORY=LUNARDUMP CONTENT=METADATA_ONLY logfile=DATA_PUMP_DIR:expdp01.log 
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Master table "C##LUNAR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for C##LUNAR.SYS_EXPORT_SCHEMA_01 is:
  +DATA/expdptest/lunar.dmp
Job "C##LUNAR"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 9 01:59:51 2013 elapsed 0 00:03:47

检查expdp导出文件

ASMCMD> cd expdptest
ASMCMD> ls -l
Type     Redund  Striped  Time             Sys  Name
DUMPSET  UNPROT  COARSE   AUG 09 01:00:00  N    lunar.dmp => +DATA/CDB/DUMPSET/CLUNARSYS_EXPORT_SCHEMA_01_92142_1.302.822966973

补充说明
如果有rac，可以使用cluster=y，parallel=10…………这样就在整个集群parallel，在xd就用dbfs，本质就是这个原理的

发表在 ASM | 标签为 asm, expdp, rac | 留下评论

asmcmd中cp文件的测试

发表于 2013 年 8 月 10 日由 Lunar

[grid@lunar ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 9 15:59:23 2013

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Automatic Storage Management option

SQL> set pages 999
SQL> set linesize 122
SQL> select group_number, name, state, type, total_mb/1024 total_gb, free_mb/1024 free_gb, offline_disks from gv$asm_diskgroup;

GROUP_NUMBER NAME                           STATE       TYPE     TOTAL_GB    FREE_GB OFFLINE_DISKS
———— —————————— ———– —— ———- ———- ————-
2 RECO                           MOUNTED     EXTERN          5 4.71386719             0
1 DATA                           MOUNTED     EXTERN         10 3.58300781             0

SQL>
[oracle@lunar ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 9 15:41:32 2013

Connected to an idle instance.

SQL>
SQL> show parameter db_create_file_dest

NAME TYPE VALUE
———————————— ———– ——————————
db_create_file_dest string +DATA
SQL>
SQL> create tablespace lunartest datafile size 10M;

Tablespace created.

SQL> set pages 999
SQL> select file#,name,(bytes/1024/1024)MB from v$datafile;

FILE# NAME                                                            MB
———- ——————————————————- ———-
1 +DATA/LUNARBB/DATAFILE/system.261.818251295                    790
2 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE        260
/system.262.818251355

3 +DATA/LUNARBB/DATAFILE/sysaux.263.818251381 820
4 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 675
/sysaux.264.818251441

5 +DATA/LUNARBB/DATAFILE/undotbs1.265.818251465                  675
6 +DATA/LUNARBB/DATAFILE/users.268.818251547                       5
7 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE        260
/system.270.818261387

8 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 705
/sysaux.271.818261387

9 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 5
/users.273.818261503

10 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 260
/system.275.819174909

11 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 705
/sysaux.276.819174909

12 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 5
/users.274.819174909

30 +DATA/LUNARBB/DATAFILE/lunartest.281.823017791 10

13 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> alter database datafile 30 offline;

Database altered.

SQL>

跟踪一下，看看它到底怎么来cp的，o(∩_∩)o 哈哈

ASMCMD> cp +DATA/LUNARBB/DATAFILE/lunartest.281.823017791 +RECO/LUNARBB/lunartest.dbf
    <- prepare(‘/* ASMCMD */ select group_number, state from v$asm_diskgroup_stat where name=’DATA”)= ( DBI::st=HASH(0x33e2a68) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e27f8)2keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33f3648))= ( undef ) [1 items] at asmcmdshare.pm line 1633
   <- prepare(‘/* ASMCMD */ select reference_index from v$asm_alias where group_number=1 and parent_index=16777216 and upper(name)=’LUNARBB”)= ( DBI::st=HASH(0x33e2a20) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e2708)1keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e2a80))= ( undef ) [1 items] at asmcmdshare.pm line 1469
   <- prepare(‘/* ASMCMD */ select reference_index from v$asm_alias where group_number=1 and parent_index=16777428 and upper(name)=’DATAFILE”)= ( DBI::st=HASH(0x33e28e8) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e26d8)1keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e29a8))= ( undef ) [1 items] at asmcmdshare.pm line 1469
<- prepare(‘/* ASMCMD */ select reference_index from v$asm_alias where group_number=1 and parent_index=16777587 and upper(name)=’LUNARTEST.281.823017791”)= ( DBI::st=HASH(0x33e2990) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e26c0)1keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e2978))= ( undef ) [1 items] at asmcmdshare.pm line 1469
<- prepare(‘/* ASMCMD */ select group_number, state from v$asm_diskgroup_stat where name=’RECO”)= ( DBI::st=HASH(0x33e2810) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e2678)2keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e2b10))= ( undef ) [1 items] at asmcmdshare.pm line 1633
<- prepare(‘/* ASMCMD */ select reference_index from v$asm_alias where group_number=2 and parent_index=33554432 and upper(name)=’LUNARBB”)= ( DBI::st=HASH(0x33e2840) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33e2588)1keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e2c30))= ( undef ) [1 items] at asmcmdshare.pm line 1469
<- prepare(‘/* ASMCMD */ select reference_index from v$asm_alias where group_number=2 and parent_index=33554485 and upper(name)=’LUNARTEST.DBF”)= ( DBI::st=HASH(0x33e2708) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( undef ) [1 items] at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33e26d8))= ( undef ) [1 items] at asmcmdshare.pm line 1469
<- prepare(‘
        begin
          dbms_diskgroup.getfileattr(:fileName, :fileType, :fileSz, :blkSz);
        end;
        ‘)= ( DBI::st=HASH(0x33e29f0) ) [1 items] at asmcmdbase.pm line 3588
    <- bind_param(‘:fileName’, ‘+DATA/LUNARBB/DATAFILE/lunartest.281.823017791’)= ( 1 ) [1 items] at asmcmdbase.pm line 3595
<- bind_param_inout(‘:fileType’, SCALAR(0x33e3260), …)= ( 1 ) [1 items] at asmcmdbase.pm line 3598
<- bind_param_inout(‘:fileSz’, SCALAR(0x33e33e0), …)= ( 1 ) [1 items] at asmcmdbase.pm line 3599
<- bind_param_inout(‘:blkSz’, SCALAR(0x33e88f0), …)= ( 1 ) [1 items] at asmcmdbase.pm line 3600
<- execute= ( 1 ) [1 items] at asmcmdbase.pm line 3603
    <- prepare(‘
        begin
        dbms_diskgroup.copy(”, ”, ”, :src_path, :src_ftyp, :src_blksz,
                            :src_fsiz, ”,”,”, :dst_path, 1);
        end;
        ‘)= ( DBI::st=HASH(0x33e28d0) ) [1 items] at asmcmdbase.pm line 3721
<- DESTROY(DBI::st=HASH(0x33e2a08))= ( undef ) [1 items] at asmcmdbase.pm line 3728
<- bind_param(‘:src_path’, ‘+DATA/LUNARBB/DATAFILE/lunartest.281.823017791’)= ( 1 ) [1 items] at asmcmdbase.pm line 3728
<- bind_param(‘:src_ftyp’, 12)= ( 1 ) [1 items] at asmcmdbase.pm line 3729
<- bind_param(‘:src_blksz’, 8192)= ( 1 ) [1 items] at asmcmdbase.pm line 3730
<- bind_param(‘:src_fsiz’, ‘1280’)= ( 1 ) [1 items] at asmcmdbase.pm line 3731
<- bind_param(‘:dst_path’, ‘+RECO/LUNARBB/lunartest.dbf’)= ( 1 ) [1 items] at asmcmdbase.pm line 3732
copying +DATA/LUNARBB/DATAFILE/lunartest.281.823017791 -> +RECO/LUNARBB/lunartest.dbf
<- execute= ( 1 ) [1 items] at asmcmdbase.pm line 3739
<- DESTROY(DBI::st=HASH(0x33e2a80))= ( undef ) [1 items] at asmcmdbase.pm line 2188
<- disconnect= ( 1 ) [1 items] at asmcmdbase.pm line 5169
-> DBI->connect(dbi:Oracle:, , ****, HASH(0x33e2ac8))
<- default_user(undef, undef, …)= ( undef undef ) [2 items] at DBI.pm line 653
<- DESTROY(DBI::st=HASH(0x33dd2e8))= ( undef ) [1 items] at Oracle.pm line 285
<- connect(”, undef, …)= ( DBI::db=HASH(0x33dd318) ) [1 items] at DBI.pm line 665
<- STORE(‘PrintError’, 0)= ( 1 ) [1 items] at DBI.pm line 717
<- STORE(‘AutoCommit’, 1)= ( 1 ) [1 items] at DBI.pm line 717
<- STORE(‘Username’, undef)= ( 1 ) [1 items] at DBI.pm line 720
$h->{‘ora_session_mode’}=32768 ignored for invalid driver-specific attribute
<- STORE(‘ora_session_mode’, 32768)= ( ” ) [1 items] at DBI.pm line 720
<- connected(‘dbi:Oracle:’, undef, …)= ( undef ) [1 items] at DBI.pm line 727
<- connect= DBI::db=HASH(0x33dd318)
<- STORE(‘dbi_connect_closure’, CODE(0x33e8440))= ( 1 ) [1 items] at DBI.pm line 736
<- prepare(‘/* ASMCMD */ select instance_name from v$instance’)= ( DBI::st=HASH(0x33dd018) ) [1 items] at asmcmdshare.pm line 3003
    <- execute= ( ‘0E0’ ) [1 items] at asmcmdshare.pm line 3022
<- fetchrow_hashref= ( HASH(0x33dce50)1keys ) [1 items] row1 at asmcmdshare.pm line 3055
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3076
<- DESTROY(DBI::st=HASH(0x33dd300))= ( undef ) [1 items] at asmcmdbase.pm line 5143
<- DESTROY(DBI::db=HASH(0x33e32f0))= ( undef ) [1 items] at asmcmdcore line 1445
ASMCMD>
ASMCMD> pwd
+reco/lunarbb
ASMCMD> ls -lt
Type      Redund Striped Time             Sys Name
Y    ONLINELOG/
Y    CONTROLFILE/
Y    AUTOBACKUP/
Y    ARCHIVELOG/
DATAFILE UNPROT COARSE   AUG 09 16:00:00 N    lunartest.dbf => +RECO/ASM/DATAFILE/lunartest.dbf.268.823018117
ASMCMD>
SQL> alter database rename file ‘+DATA/LUNARBB/DATAFILE/lunartest.281.8230177911’ to ‘+RECO/LUNARBB/lunartest.dbf’;
alter database rename file ‘+DATA/LUNARBB/DATAFILE/lunartest.281.8230177911’ to ‘+RECO/LUNARBB/lunartest.dbf’
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
“+DATA/LUNARBB/DATAFILE/lunartest.281.8230177911”
SQL>

郁闷，看了下都有呀：

ASMCMD> ls -lt +DATA/LUNARBB/DATAFILE/lunartest.281.823017791
Type      Redund Striped Time             Sys Name
DATAFILE UNPROT COARSE   AUG 09 16:00:00 Y    lunartest.281.823017791
ASMCMD>
ASMCMD> ls -lt +RECO/LUNARBB/lunartest.dbf
Type      Redund Striped Time             Sys Name
DATAFILE UNPROT COARSE   AUG 09 16:00:00 N    lunartest.dbf => +RECO/ASM/DATAFILE/lunartest.dbf.268.823018117
ASMCMD>

邪门。。
SQL> select file#,name,(bytes/1024/1024)MB,status from v$datafile;

FILE# NAME MB
———- ——————————————————- ———-
STATUS
——-
1 +DATA/LUNARBB/DATAFILE/system.261.818251295 790
SYSTEM

2 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 260
/system.262.818251355
SYSTEM

3 +DATA/LUNARBB/DATAFILE/sysaux.263.818251381 820
ONLINE

4 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 675
/sysaux.264.818251441
ONLINE

5 +DATA/LUNARBB/DATAFILE/undotbs1.265.818251465 675
ONLINE

6 +DATA/LUNARBB/DATAFILE/users.268.818251547 5
ONLINE

7 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 260
/system.270.818261387
SYSTEM

8 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 705
/sysaux.271.818261387
ONLINE

9 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 5
/users.273.818261503
ONLINE

10 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 260
/system.275.819174909
SYSTEM

11 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 705
/sysaux.276.819174909
ONLINE

12 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 5
/users.274.819174909
ONLINE

30 +DATA/LUNARBB/DATAFILE/lunartest.281.823017791 10
RECOVER
13 rows selected.

SQL> recover datafile 30;
Media recovery complete.
SQL> select file#,name,(bytes/1024/1024)MB,status from v$datafile;

FILE# NAME MB
———- ——————————————————- ———-
STATUS
——-
1 +DATA/LUNARBB/DATAFILE/system.261.818251295 790
SYSTEM

2 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 260
/system.262.818251355
SYSTEM

3 +DATA/LUNARBB/DATAFILE/sysaux.263.818251381 820
ONLINE

4 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 675
/sysaux.264.818251441
ONLINE

5 +DATA/LUNARBB/DATAFILE/undotbs1.265.818251465 675
ONLINE

6 +DATA/LUNARBB/DATAFILE/users.268.818251547 5
ONLINE

7 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 260
/system.270.818261387
SYSTEM

8 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 705
/sysaux.271.818261387
ONLINE

9 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 5
/users.273.818261503
ONLINE

10 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 260
/system.275.819174909
SYSTEM

11 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 705
/sysaux.276.819174909
ONLINE

12 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 5
/users.274.819174909
ONLINE

30 +DATA/LUNARBB/DATAFILE/lunartest.281.823017791 10
OFFLINE
13 rows selected.

SQL>

文件名写错了，把91，写成911了，汗。。。。
SQL> alter database rename file ‘+DATA/LUNARBB/DATAFILE/lunartest.281.823017791’ to ‘+RECO/ASM/DATAFILE/lunartest.dbf.268.823018117’;

Database altered.

SQL>
alert中：
alter database rename file ‘+DATA/LUNARBB/DATAFILE/lunartest.281.823017791’ to ‘+RECO/ASM/DATAFILE/lunartest.dbf.268.823018117’
Fri Aug 09 16:27:20 2013
Deleted Oracle managed file +DATA/LUNARBB/DATAFILE/lunartest.281.823017791
Completed: alter database rename file ‘+DATA/LUNARBB/DATAFILE/lunartest.281.823017791’ to ‘+RECO/ASM/DATAFILE/lunartest.dbf.268.823018117’
SQL> alter database datafile 30 online;
alter database datafile 30 online
*
ERROR at line 1:
ORA-01113: file 30 needs media recovery
ORA-01110: data file 30: ‘+RECO/ASM/DATAFILE/lunartest.dbf.268.823018117’
SQL> alter database recover datafile 30;

Database altered.

SQL> alter database datafile 30 online;

Database altered.

SQL>
SQL> select file#,name,(bytes/1024/1024)MB from v$datafile;

3 +DATA/LUNARBB/DATAFILE/sysaux.263.818251381 820
4 +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE 675
/sysaux.264.818251441

8 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 705
/sysaux.271.818261387

9 +DATA/LUNARBB/DF40E2A7FBA43CF9E0430100007FA44B/DATAFILE 5
/users.273.818261503

10 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 260
/system.275.819174909

11 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 705
/sysaux.276.819174909

12 +DATA/LUNARBB/E01585ADCBBD27D9E0430100007F8BF8/DATAFILE 5
/users.274.819174909

30 +RECO/ASM/DATAFILE/lunartest.dbf.268.823018117 10

13 rows selected.

SQL>
[grid@lunar ~]$ asmcmd lsof
Use of uninitialized value in subroutine entry at /u01/app/12.1/grid/lib/asmcmdbase.pm line 571.
Use of uninitialized value in subroutine entry at /u01/app/12.1/grid/lib/asmcmdbase.pm line 571.
Use of uninitialized value in subroutine entry at /u01/app/12.1/grid/lib/asmcmdbase.pm line 571.
Use of uninitialized value $what_print[2] in sprintf at /u01/app/12.1/grid/lib/asmcmdbase.pm line 607.
Use of uninitialized value $what_print[2] in sprintf at /u01/app/12.1/grid/lib/asmcmdbase.pm line 607.
Use of uninitialized value $what_print[2] in sprintf at /u01/app/12.1/grid/lib/asmcmdbase.pm line 607.
DB_Name Instance_Name Path
+ASM     +ASM
+ASM     +ASM
+ASM     +ASM
lunarbb lunarbb        +DATA/LUNARBB/CONTROLFILE/current.257.818251245
lunarbb lunarbb        +DATA/LUNARBB/DATAFILE/sysaux.263.818251381
lunarbb lunarbb        +DATA/LUNARBB/DATAFILE/system.261.818251295
lunarbb lunarbb        +DATA/LUNARBB/DATAFILE/undotbs1.265.818251465
lunarbb lunarbb        +DATA/LUNARBB/DATAFILE/users.268.818251547
lunarbb lunarbb        +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE/sysaux.264.818251441
lunarbb lunarbb        +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/DATAFILE/system.262.818251355
lunarbb lunarbb        +DATA/LUNARBB/DF3E8911E1142763E0430100007FCDF1/TEMPFILE/temp.267.818251487
lunarbb lunarbb        +DATA/LUNARBB/ONLINELOG/group_1.258.818251257
lunarbb lunarbb        +DATA/LUNARBB/ONLINELOG/group_2.259.818251267
lunarbb lunarbb        +DATA/LUNARBB/ONLINELOG/group_3.260.818251277
lunarbb lunarbb        +DATA/LUNARBB/TEMPFILE/temp.266.818251485
lunarbb lunarbb        +RECO/ASM/DATAFILE/lunartest.dbf.268.823018117
lunarbb lunarbb        +RECO/LUNARBB/CONTROLFILE/current.256.818251251
lunarbb lunarbb        +RECO/LUNARBB/ONLINELOG/group_1.257.818251261
lunarbb lunarbb        +RECO/LUNARBB/ONLINELOG/group_2.258.818251273
lunarbb lunarbb        +RECO/LUNARBB/ONLINELOG/group_3.259.818251283
[grid@lunar ~]$

/u01/app/12.1/grid/lib/asmcmdbase.pm对于asmcmd的N多至关重要

发表在 ASM | 标签为 asm, asmcmd, cp, dbms_diskgroup | 留下评论

Flashcache WriteBack的常用Metric和event

发表于 2013 年 6 月 30 日由 Lunar

User guide上列出了全部的Metric，这里只说些一般比较关注的：

CellCLI> list metriccurrent FC_BY_USED, FC_BY_DIRTY
         FC_BY_USED      FLASHCACHE      307,012 MB
         FC_BY_DIRTY     FLASHCACHE      250,320 MB

FC_BY_USED – number of MB cached (total)
FC_BY_DIRTY – number of dirty MB cached (data written only to FlashCache but not to disks)

CellCLI> list metriccurrent GD_BY_FC_DIRTY
         GD_BY_FC_DIRTY  DATA_CD_00_cel14    7,214 MB
         GD_BY_FC_DIRTY  DATA_CD_01_cel14    6,698 MB
              . . . 

CellCLI> list metriccurrent CD_BY_FC_DIRTY where metricObjectName=FD_05_cel14
         CD_BY_FC_DIRTY  FD_05_cel14       19,430 MB

GD_BY_FC_DIRTY – number of dirty MB cached for the griddisk
CD_BY_FC_DIRTY – number of dirty MB cached on the flash celldisk

通常我们测试一个应用的flashcache的负载，可以参考如下过程：
1，重置flashcache的统计信息：

CellCLI> alter cell events="immediate cellsrv.cellsrv_flashcache(resetStats,0,0,0)"

2，应用测试增加负载

3，dump统计信息:
看 cellsrv 的ADR…/trace/下面的svtrc开头的trace文件，比如我的环境：


export CELL_ADR=/opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/log/diag/asm/cell

CellCLI> alter cell events="immediate cellsrv.cellsrv_flashcache(dumpStats,0,0,L)"
  L – is any non-negative number to be used as a result Label

动态调整从griddisk重读的频率：

CellCLI> alter cell events = "immediate cellsrv.cellsrv_setparam ('_cell_flashcache_diag_reads_frequency ','20')"

下面是查看flashcache的控制块的结构的方法：
首先在cellsrv的alert中找到类似下面的信息：

。。。
Sun Jun 30 10:24:28 2013
<strong>Caching enabled on FlashCache Part dm01cel01_FLASHCACHE guid=67d1e918-7455-4afa-9b6f-7ecb2da11b82 (504684860), size=816MB, cdisk=FD_02_dm01cel01</strong>
Caching enabled on FlashCache Part dm01cel01_FLASHCACHE guid=d6400f21-abcc-4ea3-a09c-79425619ef36 (1922598212), size=816MB, cdisk=FD_01_dm01cel01
Caching enabled on FlashCache Part dm01cel01_FLASHCACHE guid=decfc31a-e1ba-4d63-9161-50f6db206572 (1710125700), size=816MB, cdisk=FD_03_dm01cel01
Caching enabled on FlashCache Part dm01cel01_FLASHCACHE guid=4dec16e9-1559-468d-9cfe-39443ac18ddc (1241609148), size=816MB, cdisk=FD_00_dm01cel01
FlashCache: allowing client IOs (mode=Writeback)
Sun Jun 30 10:24:52 2013
Smart Flash Logging enabled on FlashLog dm01cel01_FLASHLOG (2124647276), size=128MB, cdisk=FD_00_dm01cel01
Sun Jun 30 10:24:52 2013
Smart Flash Logging enabled on FlashLog dm01cel01_FLASHLOG (885498860), size=128MB, cdisk=FD_03_dm01cel01
Sun Jun 30 10:24:53 2013
Smart Flash Logging enabled on FlashLog dm01cel01_FLASHLOG (1996959724), size=128MB, cdisk=FD_02_dm01cel01


。。。

dump这个flashcache的控制块结构：

CellCLI> list cell detail
         name:                   dm01cel01
         bbuTempThreshold:       60
         bbuChargeThreshold:     800
         bmcType:                absent
         cellVersion:            OSS_11.2.3.2.1_LINUX.X64_130109
         cpuCount:               2
         diagHistoryDays:        7
         fanCount:               1/1
         fanStatus:              normal
         flashCacheMode:         WriteBack
         id:                     ef56a78d-a9cc-4c04-baac-648a18370eb7
         interconnectCount:      1
         interconnect1:          eth0
         iormBoost:              0.0
         ipaddress1:             192.168.56.11/24
         kernelVersion:          2.6.18-274.el5xen
   <strong>      makeModel:              Fake hardware</strong>
         metricHistoryDays:      7
         offloadEfficiency:      1,000.0
         powerCount:             1/1
         powerStatus:            normal
         releaseVersion:         11.2.3.2.1
         releaseTrackingBug:     14522699
         status:                 online
         temperatureReading:     0.0
         temperatureStatus:      normal
         upTime:                 0 days, 0:09
         cellsrvStatus:          running
         msStatus:               running
         rsStatus:               running

<strong>CellCLI> alter cell events="immediate cellsrv.cellsrv_flashcache(dumpctrlblock, 504684860,0,L)"</strong>
Dump sequence #1 has been written to <strong><strong>/opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/log/diag/asm/cell/dm01cel01/trace/svtrc_2312_58.trc</strong>
Cell dm01cel01 successfully altered

CellCLI>

trace内容如下：

Trace file /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/log/diag/asm/cell/dm01cel01/trace/svtrc_2312_58.trc
ORACLE_HOME = /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109
System name:    Linux
Node name:      dm01cel01
Release:        2.6.18-274.el5xen
Version:        #1 SMP Mon Jul 25 14:24:57 EDT 2011
Machine:        x86_64
CELL SW Version:        OSS_11.2.3.2.1_LINUX.X64_130109

*** 2013-06-30 10:24:25.763
UserThread: LWPID: 2648 userId: 58 kernelId: 58 pthreadID: 0x6641a940
FCC: Control block memory dump for Flash ID 504684860:
2013-06-30 10:33:35.042335*: Dump sequence #1:
2AAB6BD00000 A624DCC2 00000000 54434346 4B4C424C  [..$.....FCCTLBLK]
2AAB6BD00010 64373600 31396531 34372D38 342D3535  [.67d1e918-7455-4]
2AAB6BD00020 2D616661 66366239 6365372D 61643262  [afa-9b6f-7ecb2da]
2AAB6BD00030 38623131 03050032 00000002 00000000  [11b82...........]
2AAB6BD00040 00280000 00000000 33000000 00000000  [..(........3....]
2AAB6BD00050 5B0B8A32 0000013F 1E14E13C 00000002  [2..[?...<.......]
2AAB6BD00060 00000010 00000000 54434346 4B4C424C  [........FCCTLBLK]
2AAB6BD00070 00000000 00000000                    [........]
<strong>FCC: Control block formatted dump for Flash ID 504684860:
  fid=504684860, head/tail FCCTLBLK/FCCTLBLK, mdSize=2621440, chksum=2787433666,
  flashSz=855638016, flags=5, cacheline size shift 16,   creation_timestamp=1371622050354,
  version=2, guid=67d1e918-7455-4afa-9b6f-7ecb2da11b82, pers_mode=Writeback,
  verif_level=crc.
</strong><strong>FCC: Control block for flashID=504684860 is located on cdisk='FD_02_dm01cel01' at offset 184549376
FCC: Primary FC metadata for flashID=504684860 is located on cdisk='FD_02_dm01cel01', offset/size: 184614912 1261568
FCC: Shadow FC metadata for flashID=504684860 is located on cdisk='FD_02_dm01cel01', offset/size: 185876480 1261568
</strong>

检查某个griddisk是否被cache，并dump其cache-line header的信息

首先看alert
。。。
Sun Jun 30 10:24:26 2013
CellDisk v0.7 name=CD_disk01_dm01cel01 status=NORMAL confine status=NONE confine reason=CD_GOOD guid=55031178-14e1-49f8-b080-ce4293b5c683 found on dev=/opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/disks/raw/disk01
  GridDisk name=data_CD_disk01_dm01cel01 guid=6065c05e-8eae-461c-9b43-02b5c46fd6bb (542754140), cached by these FlashCache parts:  504684860
  GridDisk name=reco_CD_disk01_dm01cel01 guid=6d40fc07-34e3-4e71-9fd8-a51a98e68769 (709161532), cached by these FlashCache parts:  504684860
Initialization of celldisk CD_disk01_dm01cel01 on /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/disks/raw/disk01 completed.
  GridDisk name=data_CD_disk12_dm01cel01 guid=0fb93c36-a5b5-431a-aa7b-025b52f7cbe4 (2820417692), cached by these FlashCache parts:  1241609148
  GridDisk name=reco_CD_disk12_dm01cel01 guid=bba5ae9b-dc0f-4515-94f1-2104e8d0bc44 (1611296652), cached by these FlashCache parts:  1241609148
。。。

使用griddisk id和griddisk offset从FC中dump相关的cache的元数据：

SQL> conn lunar/lunar
Connected.
SQL> create table lunartest as select * from dba_objects;

Table created.

SQL> alter table lunartest STORAGE (CELL_FLASH_CACHE keep);

Table altered.

SQL> select object_id from user_objects;

 OBJECT_ID
----------
     17852

SQL> select count(*) from lunartest;

  COUNT(*)
----------
     17580

SQL> 

CellCLI> LIST FLASHCACHECONTENT WHERE objectNumber=17852 DETAIL
         cachedKeepSize:         0
         cachedSize:             966656
         dbID:                   3118431096
         dbUniqueName:           BBFF
         hitCount:               0
         missCount:              0
         objectNumber:           17852
         tableSpaceNumber:       4

CellCLI>

SQL> select count(*) from lunartest;

  COUNT(*)
----------
     17580

SQL> 
CellCLI> LIST FLASHCACHECONTENT WHERE objectNumber=17852 DETAIL
         cachedKeepSize:         1925120
         cachedSize:             1925120
         dbID:                   3118431096
         dbUniqueName:           BBFF
         hitCount:               25
         hoursToExpiration:      24
         missCount:              2
         objectNumber:           17852
         tableSpaceNumber:       4

CellCLI> 
CellCLI> alter cell events="immediate cellsrv.cellsrv_flashcache(dumpmdchunk,1,542754140,1)"

Cell dm01cel01 successfully altered

CellCLI>

[root@dm01cel01 trace]# cat svtrc_2312_80.trc
Trace file /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/log/diag/asm/cell/dm01cel01/trace/svtrc_2312_80.trc
ORACLE_HOME = /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109
System name: Linux
Node name: dm01cel01
Release: 2.6.18-274.el5xen
Version: #1 SMP Mon Jul 25 14:24:57 EDT 2011
Machine: x86_64
CELL SW Version: OSS_11.2.3.2.1_LINUX.X64_130109

*** 2013-06-30 10:24:25.608
UserThread: LWPID: 2670 userId: 80 kernelId: 80 pthreadID: 0x74030940
2013-06-30 10:24:26.061175*: For GridDisk data_CD_disk05_dm01cel01 set these caching FlashIDs: 1922598212
2013-06-30 10:24:26.061175*: For GridDisk reco_CD_disk05_dm01cel01 set these caching FlashIDs: 1922598212
2013-06-30 10:24:26.139905*: [CDP] initCDPers – found persdata for guid: fb9bb908-044e-44a1-afa1-2428c065b9bc
dmgType: DMG_UNKNOWN dmgSlot: 255 predFailStat: 0 ioTimeIndex: 0 lastIOCompTime: 1372559066070289 lastIOSubmitTime: 0 histIOLatIndex: 0
CellDisk UUID: fb9bb908-044e-44a1-afa1-2428c065b9bc CellDiskPersObj File offset: 7360
confTransIdx: 0 Current confine state: NONE Health incarnation number: 0 ConfineTransIndex cstate ccause activeForced activeAlertSent inactiveForced inactiveAlertSent asmRespond testsFailed testOutcomeForced noneTime activeTime inactiveTime finalTime
0 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
1 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
2 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
3 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
4 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
5 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
6 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
7 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
8 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0
9 NONE CD_GOOD 0 0 0 0 0 0 0 0 0 0 0

2013-06-30 10:25:15.733434*: New info from MS for CD CD_disk09_dm01cel01: diskMediaGroup: DMG_UNKNOWN, disk slot number: 1, predictive failure on disk: 0
No Cache header ID=1, loc=542703616
[root@dm01cel01 trace]#

不知道是否因为我的是VM，因此，这个命令实际上并没有令我满意的结果…………

发表在 FAQ, POC和性能调整, 体系架构, 硬件配置 | 标签为 Exadata, flashcache, writeback | 留下评论

关于Exadata的万兆网的配置初级篇

发表于 2013 年 6 月 29 日由 Lunar

今天忽然好多人问起来万兆模块的事情，微博上写不下，我放在这里。

首先，万兆模块通常的作用有两个：
1，作为备份和灾备的网络，高效快速。有人问为啥不用Infiniband，那个说来话长，用不用都可以，关键看客户的整体架构，从技术上没啥不行的，直接插一根线到IB switch就行了…………

2，作为public ip，用于client的访问，比如地台eth1和eth0，做绑定，这个有N个文档都说了，比如owner guide，还比如MOS等等，这里不赘述，只是一点稍微嘱咐下，如果是初始配置，那么只要按部就班的用onecommand就搞定，如果是后面更改，除了考虑物理的网络连线，客户的交换机是否有万兆模块或者支持万兆，还要考虑软件本身的因素，其实配置好了以后（如果需要可以做绑定，也可以不绑定，根据客户需要），就是参考mos的文档做更改public ip和vip，scan ip等的设置。

在补充一句，在每个Exadata自带的机器上有document文档，其中owner guide上“Changing from 1 GbE Connections to 10 GbE Connections”是专门的一个章节，写的非常详细。

具体就是如下的配置文件，配置万兆使用命令: ethtool

[root@dm01db01 ~]# dcli -l root -g dbs_group “ethtool eth4”
dm01db01: Settings for eth4:
dm01db01: Supported ports: [ FIBRE ]
dm01db01: Supported link modes: 1000baseT/Full
dm01db01: 10000baseT/Full
dm01db01: Supports auto-negotiation: Yes
dm01db01: Advertised link modes: 1000baseT/Full
dm01db01: 10000baseT/Full
dm01db01: Advertised auto-negotiation: Yes
dm01db01: Speed: 10000Mb/s
dm01db01: Duplex: Full
dm01db01: Port: FIBRE
dm01db01: PHYAD: 0
dm01db01: Transceiver: external
dm01db01: Auto-negotiation: on
dm01db01: Supports Wake-on: d
dm01db01: Wake-on: d
dm01db01: Current message level: 0x00000007 (7)
dm01db01: Link detected: yes
dm01db02: Settings for eth4:
dm01db02: Supported ports: [ FIBRE ]
dm01db02: Supported link modes: 1000baseT/Full
dm01db02: 10000baseT/Full
dm01db02: Supports auto-negotiation: Yes
dm01db02: Advertised link modes: 1000baseT/Full
dm01db02: 10000baseT/Full
dm01db02: Advertised auto-negotiation: Yes
dm01db02: Speed: 10000Mb/s
dm01db02: Duplex: Full
dm01db02: Port: FIBRE
dm01db02: PHYAD: 0
dm01db02: Transceiver: external
dm01db02: Auto-negotiation: on
dm01db02: Supports Wake-on: d
dm01db02: Wake-on: d
dm01db02: Current message level: 0x00000007 (7)
dm01db02: Link detected: yes
dm01db03: Settings for eth4:
dm01db03: Supported ports: [ FIBRE ]
dm01db03: Supported link modes: 1000baseT/Full
dm01db03: 10000baseT/Full
dm01db03: Supports auto-negotiation: Yes
dm01db03: Advertised link modes: 1000baseT/Full
dm01db03: 10000baseT/Full
dm01db03: Advertised auto-negotiation: Yes
dm01db03: Speed: 10000Mb/s
dm01db03: Duplex: Full
dm01db03: Port: FIBRE
dm01db03: PHYAD: 0
dm01db03: Transceiver: external
dm01db03: Auto-negotiation: on
dm01db03: Supports Wake-on: d
dm01db03: Wake-on: d
dm01db03: Current message level: 0x00000007 (7)
dm01db03: Link detected: yes
dm01db04: Settings for eth4:
dm01db04: Supported ports: [ FIBRE ]
dm01db04: Supported link modes: 1000baseT/Full
dm01db04: 10000baseT/Full
dm01db04: Supports auto-negotiation: Yes
dm01db04: Advertised link modes: 1000baseT/Full
dm01db04: 10000baseT/Full
dm01db04: Advertised auto-negotiation: Yes
dm01db04: Speed: 10000Mb/s
dm01db04: Duplex: Full
dm01db04: Port: FIBRE
dm01db04: PHYAD: 0
dm01db04: Transceiver: external
dm01db04: Auto-negotiation: on
dm01db04: Supports Wake-on: d
dm01db04: Wake-on: d
dm01db04: Current message level: 0x00000007 (7)
dm01db04: Link detected: yes
dm01db05: Settings for eth4:
dm01db05: Supported ports: [ FIBRE ]
dm01db05: Supported link modes: 1000baseT/Full
dm01db05: 10000baseT/Full
dm01db05: Supports auto-negotiation: Yes
dm01db05: Advertised link modes: 1000baseT/Full
dm01db05: 10000baseT/Full
dm01db05: Advertised auto-negotiation: Yes
dm01db05: Speed: 10000Mb/s
dm01db05: Duplex: Full
dm01db05: Port: FIBRE
dm01db05: PHYAD: 0
dm01db05: Transceiver: external
dm01db05: Auto-negotiation: on
dm01db05: Supports Wake-on: d
dm01db05: Wake-on: d
dm01db05: Current message level: 0x00000007 (7)
dm01db05: Link detected: yes
dm01db06: Settings for eth4:
dm01db06: Supported ports: [ FIBRE ]
dm01db06: Supported link modes: 1000baseT/Full
dm01db06: 10000baseT/Full
dm01db06: Supports auto-negotiation: Yes
dm01db06: Advertised link modes: 1000baseT/Full
dm01db06: 10000baseT/Full
dm01db06: Advertised auto-negotiation: Yes
dm01db06: Speed: 10000Mb/s
dm01db06: Duplex: Full
dm01db06: Port: FIBRE
dm01db06: PHYAD: 0
dm01db06: Transceiver: external
dm01db06: Auto-negotiation: on
dm01db06: Supports Wake-on: d
dm01db06: Wake-on: d
dm01db06: Current message level: 0x00000007 (7)
dm01db06: Link detected: yes
dm01db07: Settings for eth4:
dm01db07: Supported ports: [ FIBRE ]
dm01db07: Supported link modes: 1000baseT/Full
dm01db07: 10000baseT/Full
dm01db07: Supports auto-negotiation: Yes
dm01db07: Advertised link modes: 1000baseT/Full
dm01db07: 10000baseT/Full
dm01db07: Advertised auto-negotiation: Yes
dm01db07: Speed: 10000Mb/s
dm01db07: Duplex: Full
dm01db07: Port: FIBRE
dm01db07: PHYAD: 0
dm01db07: Transceiver: external
dm01db07: Auto-negotiation: on
dm01db07: Supports Wake-on: d
dm01db07: Wake-on: d
dm01db07: Current message level: 0x00000007 (7)
dm01db07: Link detected: yes
dm01db08: Settings for eth4:
dm01db08: Supported ports: [ FIBRE ]
dm01db08: Supported link modes: 10000baseT/Full
dm01db08: Supports auto-negotiation: No
dm01db08: Advertised link modes: 10000baseT/Full
dm01db08: Advertised auto-negotiation: No
dm01db08: Speed: Unknown!
dm01db08: Duplex: Unknown! (255)
dm01db08: Port: Unknown! (255)
dm01db08: PHYAD: 0
dm01db08: Transceiver: external
dm01db08: Auto-negotiation: off
dm01db08: Supports Wake-on: d
dm01db08: Wake-on: d
dm01db08: Current message level: 0x00000007 (7)
dm01db08: Link detected: no
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# dcli -l root -g dbs_group “ethtool eth5”
dm01db01: Settings for eth5:
dm01db01: Supported ports: [ FIBRE ]
dm01db01: Supported link modes: 1000baseT/Full
dm01db01: 10000baseT/Full
dm01db01: Supports auto-negotiation: Yes
dm01db01: Advertised link modes: 1000baseT/Full
dm01db01: 10000baseT/Full
dm01db01: Advertised auto-negotiation: Yes
dm01db01: Speed: 10000Mb/s
dm01db01: Duplex: Full
dm01db01: Port: FIBRE
dm01db01: PHYAD: 0
dm01db01: Transceiver: external
dm01db01: Auto-negotiation: on
dm01db01: Supports Wake-on: d
dm01db01: Wake-on: d
dm01db01: Current message level: 0x00000007 (7)
dm01db01: Link detected: yes
dm01db02: Settings for eth5:
dm01db02: Supported ports: [ FIBRE ]
dm01db02: Supported link modes: 1000baseT/Full
dm01db02: 10000baseT/Full
dm01db02: Supports auto-negotiation: Yes
dm01db02: Advertised link modes: 1000baseT/Full
dm01db02: 10000baseT/Full
dm01db02: Advertised auto-negotiation: Yes
dm01db02: Speed: 10000Mb/s
dm01db02: Duplex: Full
dm01db02: Port: FIBRE
dm01db02: PHYAD: 0
dm01db02: Transceiver: external
dm01db02: Auto-negotiation: on
dm01db02: Supports Wake-on: d
dm01db02: Wake-on: d
dm01db02: Current message level: 0x00000007 (7)
dm01db02: Link detected: yes
dm01db03: Settings for eth5:
dm01db03: Supported ports: [ FIBRE ]
dm01db03: Supported link modes: 1000baseT/Full
dm01db03: 10000baseT/Full
dm01db03: Supports auto-negotiation: Yes
dm01db03: Advertised link modes: 1000baseT/Full
dm01db03: 10000baseT/Full
dm01db03: Advertised auto-negotiation: Yes
dm01db03: Speed: 10000Mb/s
dm01db03: Duplex: Full
dm01db03: Port: FIBRE
dm01db03: PHYAD: 0
dm01db03: Transceiver: external
dm01db03: Auto-negotiation: on
dm01db03: Supports Wake-on: d
dm01db03: Wake-on: d
dm01db03: Current message level: 0x00000007 (7)
dm01db03: Link detected: yes
dm01db04: Settings for eth5:
dm01db04: Supported ports: [ FIBRE ]
dm01db04: Supported link modes: 1000baseT/Full
dm01db04: 10000baseT/Full
dm01db04: Supports auto-negotiation: Yes
dm01db04: Advertised link modes: 1000baseT/Full
dm01db04: 10000baseT/Full
dm01db04: Advertised auto-negotiation: Yes
dm01db04: Speed: 10000Mb/s
dm01db04: Duplex: Full
dm01db04: Port: FIBRE
dm01db04: PHYAD: 0
dm01db04: Transceiver: external
dm01db04: Auto-negotiation: on
dm01db04: Supports Wake-on: d
dm01db04: Wake-on: d
dm01db04: Current message level: 0x00000007 (7)
dm01db04: Link detected: yes
dm01db05: Settings for eth5:
dm01db05: Supported ports: [ FIBRE ]
dm01db05: Supported link modes: 1000baseT/Full
dm01db05: 10000baseT/Full
dm01db05: Supports auto-negotiation: Yes
dm01db05: Advertised link modes: 1000baseT/Full
dm01db05: 10000baseT/Full
dm01db05: Advertised auto-negotiation: Yes
dm01db05: Speed: 10000Mb/s
dm01db05: Duplex: Full
dm01db05: Port: FIBRE
dm01db05: PHYAD: 0
dm01db05: Transceiver: external
dm01db05: Auto-negotiation: on
dm01db05: Supports Wake-on: d
dm01db05: Wake-on: d
dm01db05: Current message level: 0x00000007 (7)
dm01db05: Link detected: yes
dm01db06: Settings for eth5:
dm01db06: Supported ports: [ FIBRE ]
dm01db06: Supported link modes: 1000baseT/Full
dm01db06: 10000baseT/Full
dm01db06: Supports auto-negotiation: Yes
dm01db06: Advertised link modes: 1000baseT/Full
dm01db06: 10000baseT/Full
dm01db06: Advertised auto-negotiation: Yes
dm01db06: Speed: 10000Mb/s
dm01db06: Duplex: Full
dm01db06: Port: FIBRE
dm01db06: PHYAD: 0
dm01db06: Transceiver: external
dm01db06: Auto-negotiation: on
dm01db06: Supports Wake-on: d
dm01db06: Wake-on: d
dm01db06: Current message level: 0x00000007 (7)
dm01db06: Link detected: yes
dm01db07: Settings for eth5:
dm01db07: Supported ports: [ FIBRE ]
dm01db07: Supported link modes: 10000baseT/Full
dm01db07: Supports auto-negotiation: No
dm01db07: Advertised link modes: 10000baseT/Full
dm01db07: Advertised auto-negotiation: No
dm01db07: Speed: Unknown!
dm01db07: Duplex: Unknown! (255)
dm01db07: Port: Unknown! (255)
dm01db07: PHYAD: 0
dm01db07: Transceiver: external
dm01db07: Auto-negotiation: off
dm01db07: Supports Wake-on: d
dm01db07: Wake-on: d
dm01db07: Current message level: 0x00000007 (7)
dm01db07: Link detected: no
dm01db08: Settings for eth5:
dm01db08: Supported ports: [ FIBRE ]
dm01db08: Supported link modes: 10000baseT/Full
dm01db08: Supports auto-negotiation: No
dm01db08: Advertised link modes: 10000baseT/Full
dm01db08: Advertised auto-negotiation: No
dm01db08: Speed: Unknown!
dm01db08: Duplex: Unknown! (255)
dm01db08: Port: Unknown! (255)
dm01db08: PHYAD: 0
dm01db08: Transceiver: external
dm01db08: Auto-negotiation: off
dm01db08: Supports Wake-on: d
dm01db08: Wake-on: d
dm01db08: Current message level: 0x00000007 (7)
dm01db08: Link detected: no
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# dcli -l root -g dbs_group “ifconfig eth4”
dm01db01: eth4 Link encap:Ethernet HWaddr 90:E2:BA:15:BD:5C
dm01db01: inet6 addr: fe80::92e2:baff:fe15:bd5c/64 Scope:Link
dm01db01: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db01: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db01: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db01: collisions:0 txqueuelen:1000
dm01db01: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db01:
dm01db02: eth4 Link encap:Ethernet HWaddr 90:E2:BA:17:68:7C
dm01db02: inet6 addr: fe80::92e2:baff:fe17:687c/64 Scope:Link
dm01db02: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db02: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db02: TX packets:1 errors:0 dropped:0 overruns:0 carrier:0
dm01db02: collisions:0 txqueuelen:1000
dm01db02: RX bytes:0 (0.0 b) TX bytes:90 (90.0 b)
dm01db02:
dm01db03: eth4 Link encap:Ethernet HWaddr 90:E2:BA:15:2A:98
dm01db03: inet6 addr: fe80::92e2:baff:fe15:2a98/64 Scope:Link
dm01db03: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db03: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db03: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db03: collisions:0 txqueuelen:1000
dm01db03: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db03:
dm01db04: eth4 Link encap:Ethernet HWaddr 90:E2:BA:17:69:10
dm01db04: inet6 addr: fe80::92e2:baff:fe17:6910/64 Scope:Link
dm01db04: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db04: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db04: TX packets:1 errors:0 dropped:0 overruns:0 carrier:0
dm01db04: collisions:0 txqueuelen:1000
dm01db04: RX bytes:0 (0.0 b) TX bytes:90 (90.0 b)
dm01db04:
dm01db05: eth4 Link encap:Ethernet HWaddr 90:E2:BA:17:60:B4
dm01db05: inet6 addr: fe80::92e2:baff:fe17:60b4/64 Scope:Link
dm01db05: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db05: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db05: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db05: collisions:0 txqueuelen:1000
dm01db05: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db05:
dm01db06: eth4 Link encap:Ethernet HWaddr 90:E2:BA:17:6C:98
dm01db06: inet6 addr: fe80::92e2:baff:fe17:6c98/64 Scope:Link
dm01db06: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db06: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db06: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db06: collisions:0 txqueuelen:1000
dm01db06: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db06:
dm01db07: eth4 Link encap:Ethernet HWaddr 90:E2:BA:17:67:20
dm01db07: inet6 addr: fe80::92e2:baff:fe17:6720/64 Scope:Link
dm01db07: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db07: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db07: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db07: collisions:0 txqueuelen:1000
dm01db07: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db07:
dm01db08: eth4 Link encap:Ethernet HWaddr 90:E2:BA:15:B7:F8
dm01db08: UP BROADCAST MULTICAST MTU:1500 Metric:1
dm01db08: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db08: TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
dm01db08: collisions:0 txqueuelen:1000
dm01db08: RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
dm01db08:
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# dcli -l root -g dbs_group “ifconfig eth5”
dm01db01: eth5 Link encap:Ethernet HWaddr 90:E2:BA:15:BD:5D
dm01db01: inet6 addr: fe80::92e2:baff:fe15:bd5d/64 Scope:Link
dm01db01: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db01: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db01: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db01: collisions:0 txqueuelen:1000
dm01db01: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db01:
dm01db02: eth5 Link encap:Ethernet HWaddr 90:E2:BA:17:68:7D
dm01db02: inet6 addr: fe80::92e2:baff:fe17:687d/64 Scope:Link
dm01db02: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db02: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db02: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db02: collisions:0 txqueuelen:1000
dm01db02: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db02:
dm01db03: eth5 Link encap:Ethernet HWaddr 90:E2:BA:15:2A:99
dm01db03: inet6 addr: fe80::92e2:baff:fe15:2a99/64 Scope:Link
dm01db03: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db03: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db03: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db03: collisions:0 txqueuelen:1000
dm01db03: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db03:
dm01db04: eth5 Link encap:Ethernet HWaddr 90:E2:BA:17:69:11
dm01db04: inet6 addr: fe80::92e2:baff:fe17:6911/64 Scope:Link
dm01db04: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db04: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db04: TX packets:1 errors:0 dropped:0 overruns:0 carrier:0
dm01db04: collisions:0 txqueuelen:1000
dm01db04: RX bytes:0 (0.0 b) TX bytes:90 (90.0 b)
dm01db04:
dm01db05: eth5 Link encap:Ethernet HWaddr 90:E2:BA:17:60:B5
dm01db05: inet6 addr: fe80::92e2:baff:fe17:60b5/64 Scope:Link
dm01db05: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db05: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db05: TX packets:1 errors:0 dropped:0 overruns:0 carrier:0
dm01db05: collisions:0 txqueuelen:1000
dm01db05: RX bytes:0 (0.0 b) TX bytes:90 (90.0 b)
dm01db05:
dm01db06: eth5 Link encap:Ethernet HWaddr 90:E2:BA:17:6C:99
dm01db06: inet6 addr: fe80::92e2:baff:fe17:6c99/64 Scope:Link
dm01db06: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
dm01db06: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db06: TX packets:2 errors:0 dropped:0 overruns:0 carrier:0
dm01db06: collisions:0 txqueuelen:1000
dm01db06: RX bytes:0 (0.0 b) TX bytes:180 (180.0 b)
dm01db06:
dm01db07: eth5 Link encap:Ethernet HWaddr 90:E2:BA:17:67:21
dm01db07: UP BROADCAST MULTICAST MTU:1500 Metric:1
dm01db07: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db07: TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
dm01db07: collisions:0 txqueuelen:1000
dm01db07: RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
dm01db07:
dm01db08: eth5 Link encap:Ethernet HWaddr 90:E2:BA:15:B7:F9
dm01db08: UP BROADCAST MULTICAST MTU:1500 Metric:1
dm01db08: RX packets:0 errors:0 dropped:0 overruns:0 frame:0
dm01db08: TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
dm01db08: collisions:0 txqueuelen:1000
dm01db08: RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
dm01db08:
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# dcli -l root -g dbs_group “cat /etc/sysconfig/network-scripts/ifcfg-eth4”
dm01db01: #### DO NOT REMOVE THESE LINES ####
dm01db01: #### %GENERATED BY CELL% ####
dm01db01: DEVICE=eth4
dm01db01: BOOTPROTO=none
dm01db01: ONBOOT=no
dm01db01: HOTPLUG=no
dm01db01: IPV6INIT=no
dm01db01: HWADDR=90:e2:ba:15:bd:5c
dm01db02: #### DO NOT REMOVE THESE LINES ####
dm01db02: #### %GENERATED BY CELL% ####
dm01db02: DEVICE=eth4
dm01db02: BOOTPROTO=none
dm01db02: ONBOOT=no
dm01db02: HOTPLUG=no
dm01db02: IPV6INIT=no
dm01db02: HWADDR=90:e2:ba:17:68:7c
dm01db03: #### DO NOT REMOVE THESE LINES ####
dm01db03: #### %GENERATED BY CELL% ####
dm01db03: DEVICE=eth4
dm01db03: BOOTPROTO=none
dm01db03: ONBOOT=no
dm01db03: HOTPLUG=no
dm01db03: IPV6INIT=no
dm01db03: HWADDR=90:e2:ba:15:2a:98
dm01db04: #### DO NOT REMOVE THESE LINES ####
dm01db04: #### %GENERATED BY CELL% ####
dm01db04: DEVICE=eth4
dm01db04: BOOTPROTO=none
dm01db04: ONBOOT=no
dm01db04: HOTPLUG=no
dm01db04: IPV6INIT=no
dm01db04: HWADDR=90:e2:ba:17:69:10
dm01db05: #### DO NOT REMOVE THESE LINES ####
dm01db05: #### %GENERATED BY CELL% ####
dm01db05: DEVICE=eth4
dm01db05: BOOTPROTO=none
dm01db05: ONBOOT=no
dm01db05: HOTPLUG=no
dm01db05: IPV6INIT=no
dm01db05: HWADDR=90:e2:ba:17:60:b4
dm01db06: #### DO NOT REMOVE THESE LINES ####
dm01db06: #### %GENERATED BY CELL% ####
dm01db06: DEVICE=eth4
dm01db06: BOOTPROTO=none
dm01db06: ONBOOT=no
dm01db06: HOTPLUG=no
dm01db06: IPV6INIT=no
dm01db06: HWADDR=90:e2:ba:17:6c:98
dm01db07: #### DO NOT REMOVE THESE LINES ####
dm01db07: #### %GENERATED BY CELL% ####
dm01db07: DEVICE=eth4
dm01db07: BOOTPROTO=none
dm01db07: ONBOOT=no
dm01db07: HOTPLUG=no
dm01db07: IPV6INIT=no
dm01db07: HWADDR=90:e2:ba:17:67:20
dm01db08: #### DO NOT REMOVE THESE LINES ####
dm01db08: #### %GENERATED BY CELL% ####
dm01db08: DEVICE=eth4
dm01db08: BOOTPROTO=none
dm01db08: ONBOOT=no
dm01db08: HOTPLUG=no
dm01db08: IPV6INIT=no
dm01db08: HWADDR=90:e2:ba:15:b7:f8
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# dcli -l root -g dbs_group “cat /etc/sysconfig/network-scripts/ifcfg-eth5”
dm01db01: #### DO NOT REMOVE THESE LINES ####
dm01db01: #### %GENERATED BY CELL% ####
dm01db01: DEVICE=eth5
dm01db01: BOOTPROTO=none
dm01db01: ONBOOT=no
dm01db01: HOTPLUG=no
dm01db01: IPV6INIT=no
dm01db01: HWADDR=90:e2:ba:15:bd:5d
dm01db02: #### DO NOT REMOVE THESE LINES ####
dm01db02: #### %GENERATED BY CELL% ####
dm01db02: DEVICE=eth5
dm01db02: BOOTPROTO=none
dm01db02: ONBOOT=no
dm01db02: HOTPLUG=no
dm01db02: IPV6INIT=no
dm01db02: HWADDR=90:e2:ba:17:68:7d
dm01db03: #### DO NOT REMOVE THESE LINES ####
dm01db03: #### %GENERATED BY CELL% ####
dm01db03: DEVICE=eth5
dm01db03: BOOTPROTO=none
dm01db03: ONBOOT=no
dm01db03: HOTPLUG=no
dm01db03: IPV6INIT=no
dm01db03: HWADDR=90:e2:ba:15:2a:99
dm01db04: #### DO NOT REMOVE THESE LINES ####
dm01db04: #### %GENERATED BY CELL% ####
dm01db04: DEVICE=eth5
dm01db04: BOOTPROTO=none
dm01db04: ONBOOT=no
dm01db04: HOTPLUG=no
dm01db04: IPV6INIT=no
dm01db04: HWADDR=90:e2:ba:17:69:11
dm01db05: #### DO NOT REMOVE THESE LINES ####
dm01db05: #### %GENERATED BY CELL% ####
dm01db05: DEVICE=eth5
dm01db05: BOOTPROTO=none
dm01db05: ONBOOT=no
dm01db05: HOTPLUG=no
dm01db05: IPV6INIT=no
dm01db05: HWADDR=90:e2:ba:17:60:b5
dm01db06: #### DO NOT REMOVE THESE LINES ####
dm01db06: #### %GENERATED BY CELL% ####
dm01db06: DEVICE=eth5
dm01db06: BOOTPROTO=none
dm01db06: ONBOOT=no
dm01db06: HOTPLUG=no
dm01db06: IPV6INIT=no
dm01db06: HWADDR=90:e2:ba:17:6c:99
dm01db07: #### DO NOT REMOVE THESE LINES ####
dm01db07: #### %GENERATED BY CELL% ####
dm01db07: DEVICE=eth5
dm01db07: BOOTPROTO=none
dm01db07: ONBOOT=no
dm01db07: HOTPLUG=no
dm01db07: IPV6INIT=no
dm01db07: HWADDR=90:e2:ba:17:67:21
dm01db08: #### DO NOT REMOVE THESE LINES ####
dm01db08: #### %GENERATED BY CELL% ####
dm01db08: DEVICE=eth5
dm01db08: BOOTPROTO=none
dm01db08: ONBOOT=no
dm01db08: HOTPLUG=no
dm01db08: IPV6INIT=no
dm01db08: HWADDR=90:e2:ba:15:b7:f9
[root@dm01db01 ~]#

发表在安装和升级, 硬件配置 | 标签为 Exadata, 万兆 | 留下评论

Exadata X2的硬件配置清单

发表于 2013 年 6 月 19 日由 Lunar

最近询问是否可以山寨XD的有不少人了，特别是客户关心的是过了1年的质保，怎么办？

比如一个FULL RACK，如果续服务费，list的22%，你懂的…………

今天刚发现，这里有个SUN服务器海外渠道 http://sunmicrosystems.taobao.com/ ：具体什么情况，真心未知，o(∩_∩)o 哈哈

下面是X2的硬件清单，具体还可以参考ORACLE 官网的白皮书和机器自带的文档，文档位置： http://blog.csdn.net/lunar2000/article/details/7881896

别的不担心，这东西越来越觉得可以山寨（readme中有明确方法告诉你跳过硬件检测的参数），但是估计法律风险很大，慎重……

计算节点：


====START SERIAL NUMBERS====
==Motherboard, from dmidecode==
--System serial--
1217FMM0WB
--Motherboard serial--
0328MSL-1215BA34J9
--Chassis serial--
1217FMM0WB
==Infiniband HCA==
ID: qFalcon QDR
PN: 375-3696-01
EC: 51
SN: 1388FMH-1211500115
V0: PCIe Gen2 x8
==InfiniBand Switch==
Use the /opt/oracle.SupportTools/CheckSWProfile.sh -S option to get the switch serial numbers
==Disk Controller==
Product Name    : LSI MegaRAID SAS 9261-8i
Serial No       : SV21207873
==Disks==
Enclosure:Slot Type Make Model Serial
252:0 SAS HITACHI H106030SDSUN300G 1216NDXKJB
252:1 SAS HITACHI H106030SDSUN300G 1216ND4YAB
252:2 SAS HITACHI H106030SDSUN300G 1216NAMY0B
252:3 SAS HITACHI H106030SDSUN300G 1216NEDLKB
==Motherboard, RAM etc from ipmitool==
FRU Device Description : Builtin FRU Device (LUN 0, ID 0)
Product Manufacturer  : Oracle Corporation
Product Name          : ILOM INTEGRATED SP

FRU Device Description : /SYS (LUN 0, ID 3)
Board Product         : ASSY,MOTHERBOARD,X4170/X4270,M2
Board Serial          : 0328MSL-1215BA34J9
Board Part Number     : 511-1213-07
Board Extra           : 02
Board Extra           : X4170/X4270_M2
Product Manufacturer  : ORACLE CORPORATION
Product Name          : SUN FIRE X4170 M2 SERVER
Product Part Number   : 7013703
Product Serial        : 1217FMM0WB
Product Extra         : 080020FFFFFFFFFFFFFF002128FB7D70

FRU Device Description : MB (LUN 0, ID 4)
Board Product         : ASSY,MOTHERBOARD,X4170/X4270,M2
Board Serial          : 0328MSL-1215BA34J9
Board Part Number     : 511-1213-07
Board Extra           : 02
Board Extra           : X4170/X4270_M2
Product Manufacturer  : ORACLE CORPORATION
Product Name          : SUN FIRE X4170 M2 SERVER
Product Part Number   : 7013703
Product Serial        : 1217FMM0WB
Product Extra         : 080020FFFFFFFFFFFFFF002128FB7D70

FRU Device Description : MB/BIOS (LUN 0, ID 5)
Product Manufacturer  : AMERICAN MEGATRENDS
Product Name          : SYSTEM BIOS
Product Part Number   : AMIBIOS8
Product Version       : 08080102

FRU Device Description : MB/NET0 (LUN 0, ID 43)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FB:7D:70
Product Extra         : 01
Product Extra         : 00:21:28:FB:7D:70

FRU Device Description : MB/NET1 (LUN 0, ID 44)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FB:7D:71
Product Extra         : 01
Product Extra         : 00:21:28:FB:7D:71

FRU Device Description : MB/NET2 (LUN 0, ID 45)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FB:7D:72
Product Extra         : 01
Product Extra         : 00:21:28:FB:7D:72

FRU Device Description : MB/NET3 (LUN 0, ID 46)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FB:7D:73
Product Extra         : 01
Product Extra         : 00:21:28:FB:7D:73

FRU Device Description : CPLD (LUN 0, ID 8)
Product Name          : CPLD
Product Version       : FW:1.5

FRU Device Description : /UUID (LUN 0, ID 6)
Product Extra         : 080020FFFFFFFFFFFFFF002128FB7D70

FRU Device Description : SP/NET0 (LUN 0, ID 1)
Product Manufacturer  : ASPEED
Product Name          : ETHERNET CONTROLLER
Product Part Number   : AST2100
Product Serial        : 00:21:28:fb:7d:74

FRU Device Description : SP/NET1 (LUN 0, ID 2)
Product Manufacturer  : ASPEED
Product Name          : ETHERNET CONTROLLER
Product Part Number   : AST2100
Product Serial        : 00:21:28:fb:7d:75

FRU Device Description : MB/P0 (LUN 0, ID 16)
Product Manufacturer  : INTEL
Product Name          : INTEL(R) XEON(R) CPU           X5675  @ 3.07GHZ
Product Part Number   : 060C
Product Version       : 02

FRU Device Description : MB/P1 (LUN 0, ID 17)
Product Manufacturer  : INTEL
Product Name          : INTEL(R) XEON(R) CPU           X5675  @ 3.07GHZ
Product Part Number   : 060C
Product Version       : 02

FRU Device Description : MB/P0/D0 (LUN 0, ID 24)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D1 (LUN 0, ID 25)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C31

FRU Device Description : MB/P0/D2 (LUN 0, ID 26)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C37

FRU Device Description : MB/P0/D3 (LUN 0, ID 27)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D4 (LUN 0, ID 28)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C33

FRU Device Description : MB/P0/D5 (LUN 0, ID 29)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C38

FRU Device Description : MB/P0/D6 (LUN 0, ID 30)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D7 (LUN 0, ID 31)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C34

FRU Device Description : MB/P0/D8 (LUN 0, ID 32)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C39

FRU Device Description : MB/P1/D0 (LUN 0, ID 33)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D1 (LUN 0, ID 34)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C35

FRU Device Description : MB/P1/D2 (LUN 0, ID 35)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C3A

FRU Device Description : MB/P1/D3 (LUN 0, ID 36)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D4 (LUN 0, ID 37)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88C36

FRU Device Description : MB/P1/D5 (LUN 0, ID 38)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88CC0

FRU Device Description : MB/P1/D6 (LUN 0, ID 39)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D7 (LUN 0, ID 40)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88CC8

FRU Device Description : MB/P1/D8 (LUN 0, ID 41)
Product Manufacturer  : SAMSUNG
Product Name          : 8GB DDR3 SDRAM 666
Product Part Number   : M393B1K70CH0-YH9
Product Version       : 00
Product Serial        : 83C88CC1

FRU Device Description : PCIE0/F20CARD (LUN 0, ID 224)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : PCIE1/F20CARD (LUN 0, ID 225)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : PCIE2/F20CARD (LUN 0, ID 226)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : PS0 (LUN 0, ID 63)
Board Mfg             : Delta Energy Systems
Board Product         : A247
Board Serial          : 465824T+1208B52514
Board Part Number     : 300-2233-02
Power Supply Record
Capacity                   : 760 W
Peak VA                    : 862 VA
Inrush Current             : 25 A
Inrush Interval            : 200 ms
Input Voltage Range 1      : 90-264 V
Input Voltage Range 2      : 0-0 V
Input Frequency Range      : 47-63 Hz
A/C Dropout Tolerance      : 12 ms
Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin assertion'
Peak capacity              : 760 W
Peak capacity holdup       : 15 s
Combined capacity          : not specified
Fan lower threshold        : 0 RPS
DC Output Record
Output Number              : 1
Standby power              : No
Nominal voltage            : 12.00 V
Max negative deviation     : 11.88 V
Max positive deviation     : 12.12 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.050 A
Maximum current draw       : 6.230 A
DC Output Record
Output Number              : 2
Standby power              : Yes
Nominal voltage            : 3.35 V
Max negative deviation     : 3.25 V
Max positive deviation     : 3.45 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.000 A
Maximum current draw       : 0.360 A

FRU Device Description : PS1 (LUN 0, ID 64)
Board Mfg             : Delta Energy Systems
Board Product         : A247
Board Serial          : 465824T+1208B52521
Board Part Number     : 300-2233-02
Power Supply Record
Capacity                   : 760 W
Peak VA                    : 862 VA
Inrush Current             : 25 A
Inrush Interval            : 200 ms
Input Voltage Range 1      : 90-264 V
Input Voltage Range 2      : 0-0 V
Input Frequency Range      : 47-63 Hz
A/C Dropout Tolerance      : 12 ms
Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin assertion'
Peak capacity              : 760 W
Peak capacity holdup       : 15 s
Combined capacity          : not specified
Fan lower threshold        : 0 RPS
DC Output Record
Output Number              : 1
Standby power              : No
Nominal voltage            : 12.00 V
Max negative deviation     : 11.88 V
Max positive deviation     : 12.12 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.050 A
Maximum current draw       : 6.230 A
DC Output Record
Output Number              : 2
Standby power              : Yes
Nominal voltage            : 3.35 V
Max negative deviation     : 3.25 V
Max positive deviation     : 3.45 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.000 A
Maximum current draw       : 0.360 A

FRU Device Description : DBP (LUN 0, ID 210)
Board Product         : FRUID,PRG,8DISK,1U,M2,SATA
Board Part Number     : 541-4294-02
Board Extra           : 1U,M2,DBP

FRU Device Description : PDB (LUN 0, ID 211)
Board Product         : BD,THELMA,PDB
Board Serial          : 0226LHF-1212012213
Board Part Number     : 511-1489-02
Board Extra           : 52
Board Extra           : THELMA,PDB
Product Name          : SUN FIRE X4170 M2 SERVER
Product Part Number   : 7013703
Product Serial        : 1217FMM0WB

FRU Device Description : PADCRD (LUN 0, ID 222)
Board Product         : BD,THELMA,PADDLE_BRD
Board Serial          : 0226LHF-1215G301EH
Board Part Number     : 541-4275-01
Board Extra           : 51
Board Extra           : THELMA,PADDLE_BD

FRU Device Description : FB (LUN 0, ID 212)
Board Product         : BD,THELMA,FAN_BRD
Board Serial          : 0226LHF-1215G40134
Board Part Number     : 541-4274-01
Board Extra           : 54
Board Extra           : THELMA,FAN_BRD

FRU Device Description : DBP/HDD0 (LUN 0, ID 47)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD1 (LUN 0, ID 48)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD2 (LUN 0, ID 49)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD3 (LUN 0, ID 50)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD4 (LUN 0, ID 51)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD5 (LUN 0, ID 52)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD6 (LUN 0, ID 53)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD7 (LUN 0, ID 54)
Device not present (Requested sensor, data, or record not found)

====END SERIAL NUMBERS====

存储节点


====START SERIAL NUMBERS====
==Motherboard, from dmidecode==
--System serial--
1221FMM0P5
--Motherboard serial--
0328MSL-1219BA37FX
--Chassis serial--
1221FMM0P5
==Infiniband HCA==
ID: qFalcon QDR
PN: 375-3696-01
EC: 51
SN: 1388FMH-1214500017
V0: PCIe Gen2 x8
==InfiniBand Switch==
Use the /opt/oracle.SupportTools/CheckSWProfile.sh -S option to get the switch serial numbers
==Disk Controller==
Product Name    : LSI MegaRAID SAS 9261-8i
Serial No       : SV21603094
==Disks==
Enclosure:Slot Type Make Model Serial
20:0 SAS HITACHI HUS1560SCSUN600G 1213KB3DJM
20:10 SAS HITACHI HUS1560SCSUN600G 1216KP088M
20:11 SAS HITACHI HUS1560SCSUN600G 1216KNZUSM
20:1 SAS HITACHI HUS1560SCSUN600G 1216KNXMTM
20:2 SAS HITACHI HUS1560SCSUN600G 1213KB3J8M
20:3 SAS HITACHI HUS1560SCSUN600G 1216KYK8MM
20:4 SAS HITACHI HUS1560SCSUN600G 1213K9DT8M
20:5 SAS HITACHI HUS1560SCSUN600G 1213KB25EM
20:6 SAS HITACHI HUS1560SCSUN600G 1213KB2KGM
20:7 SAS HITACHI HUS1560SCSUN600G 1216KP7WPM
20:8 SAS HITACHI HUS1560SCSUN600G 1216KNZTLM
20:9 SAS HITACHI HUS1560SCSUN600G 1216KNZUTM
==Motherboard, RAM etc from ipmitool==
FRU Device Description : Builtin FRU Device (LUN 0, ID 0)
Product Manufacturer  : Oracle Corporation
Product Name          : ILOM INTEGRATED SP

FRU Device Description : /SYS (LUN 0, ID 3)
Board Product         : ASSY,MOTHERBOARD,X4170/X4270,M2
Board Serial          : 0328MSL-1219BA37FX
Board Part Number     : 511-1213-07
Board Extra           : 02
Board Extra           : X4170/X4270_M2
Product Manufacturer  : ORACLE CORPORATION
Product Name          : SUN FIRE X4270 M2 SERVER
Product Part Number   : 7042372
Product Serial        : 1221FMM0P5
Product Extra         : 080020FFFFFFFFFFFFFF002128FFB6B8

FRU Device Description : MB (LUN 0, ID 4)
Board Product         : ASSY,MOTHERBOARD,X4170/X4270,M2
Board Serial          : 0328MSL-1219BA37FX
Board Part Number     : 511-1213-07
Board Extra           : 02
Board Extra           : X4170/X4270_M2
Product Manufacturer  : ORACLE CORPORATION
Product Name          : SUN FIRE X4270 M2 SERVER
Product Part Number   : 7042372
Product Serial        : 1221FMM0P5
Product Extra         : 080020FFFFFFFFFFFFFF002128FFB6B8

FRU Device Description : MB/BIOS (LUN 0, ID 5)
Product Manufacturer  : AMERICAN MEGATRENDS
Product Name          : SYSTEM BIOS
Product Part Number   : AMIBIOS8
Product Version       : 08080102

FRU Device Description : MB/NET0 (LUN 0, ID 43)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FF:B6:B8
Product Extra         : 01
Product Extra         : 00:21:28:FF:B6:B8

FRU Device Description : MB/NET1 (LUN 0, ID 44)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FF:B6:B9
Product Extra         : 01
Product Extra         : 00:21:28:FF:B6:B9

FRU Device Description : MB/NET2 (LUN 0, ID 45)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FF:B6:BA
Product Extra         : 01
Product Extra         : 00:21:28:FF:B6:BA

FRU Device Description : MB/NET3 (LUN 0, ID 46)
Product Manufacturer  : INTEL
Product Name          : GIGABIT ETHERNET CONTROLLERS
Product Part Number   : 82576EB
Product Serial        : 00:21:28:FF:B6:BB
Product Extra         : 01
Product Extra         : 00:21:28:FF:B6:BB

FRU Device Description : CPLD (LUN 0, ID 8)
Product Name          : CPLD
Product Version       : FW:1.5

FRU Device Description : /UUID (LUN 0, ID 6)
Product Extra         : 080020FFFFFFFFFFFFFF002128FFB6B8

FRU Device Description : SP/NET0 (LUN 0, ID 1)
Product Manufacturer  : ASPEED
Product Name          : ETHERNET CONTROLLER
Product Part Number   : AST2100
Product Serial        : 00:21:28:ff:b6:bc

FRU Device Description : SP/NET1 (LUN 0, ID 2)
Product Manufacturer  : ASPEED
Product Name          : ETHERNET CONTROLLER
Product Part Number   : AST2100
Product Serial        : 00:21:28:ff:b6:bd

FRU Device Description : MB/P0 (LUN 0, ID 16)
Product Manufacturer  : INTEL
Product Name          : INTEL(R) XEON(R) CPU           L5640  @ 2.27GHZ
Product Part Number   : 060C
Product Version       : 02

FRU Device Description : MB/P1 (LUN 0, ID 17)
Product Manufacturer  : INTEL
Product Name          : INTEL(R) XEON(R) CPU           L5640  @ 2.27GHZ
Product Part Number   : 060C
Product Version       : 02

FRU Device Description : MB/P0/D0 (LUN 0, ID 24)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D1 (LUN 0, ID 25)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D2 (LUN 0, ID 26)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4B502E4F

FRU Device Description : MB/P0/D3 (LUN 0, ID 27)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D4 (LUN 0, ID 28)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D5 (LUN 0, ID 29)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4B602E70

FRU Device Description : MB/P0/D6 (LUN 0, ID 30)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D7 (LUN 0, ID 31)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P0/D8 (LUN 0, ID 32)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4B902E5F

FRU Device Description : MB/P1/D0 (LUN 0, ID 33)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D1 (LUN 0, ID 34)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D2 (LUN 0, ID 35)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4BC02E6B

FRU Device Description : MB/P1/D3 (LUN 0, ID 36)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D4 (LUN 0, ID 37)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D5 (LUN 0, ID 38)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4B702E40

FRU Device Description : MB/P1/D6 (LUN 0, ID 39)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D7 (LUN 0, ID 40)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : MB/P1/D8 (LUN 0, ID 41)
Product Manufacturer  : HYNIX SEMICONDUCTOR INC.
Product Name          : 4GB DDR3 SDRAM 666
Product Part Number   : HMT351R7BFR4A-H9
Product Version       : 5437
Product Serial        : 4B502E7C

FRU Device Description : PCIE0/F20CARD (LUN 0, ID 224)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : PCIE1/F20CARD (LUN 0, ID 225)
Board Product         : ASY,BD,PCIE_FLASH,F20 M2
Board Serial          : 465769T+1218A413JL
Board Part Number     : 511-1646-03
Board Extra           : 02
Board Extra           : F20 M2

FRU Device Description : PCIE2/F20CARD (LUN 0, ID 226)
Board Product         : ASY,BD,PCIE_FLASH,F20 M2
Board Serial          : 465769T+1218A4138C
Board Part Number     : 511-1646-03
Board Extra           : 02
Board Extra           : F20 M2

FRU Device Description : PCIE3/F20CARD (LUN 0, ID 227)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : PCIE4/F20CARD (LUN 0, ID 228)
Board Product         : ASY,BD,PCIE_FLASH,F20 M2
Board Serial          : 465769T+1218A4139X
Board Part Number     : 511-1646-03
Board Extra           : 02
Board Extra           : F20 M2

FRU Device Description : PCIE5/F20CARD (LUN 0, ID 229)
Board Product         : ASY,BD,PCIE_FLASH,F20 M2
Board Serial          : 465769T+1218A413D3
Board Part Number     : 511-1646-03
Board Extra           : 02
Board Extra           : F20 M2

FRU Device Description : MB/R1 (LUN 0, ID 220)
Board Product         : ASSY,ACTIVE_RISER,X4270/X4275
Board Serial          : 0328MSL-12155K30A6
Board Part Number     : 511-1139-02
Board Extra           : 50
Board Extra           : ACTIVE_RISER

FRU Device Description : MB/R2 (LUN 0, ID 221)
Board Product         : ASSY,ACTIVE_RISER,X4270/X4275
Board Serial          : 0328MSL-12155K2YRN
Board Part Number     : 511-1139-02
Board Extra           : 50
Board Extra           : ACTIVE_RISER

FRU Device Description : PS0 (LUN 0, ID 63)
Board Mfg             : Delta Energy Systems
Board Product         : A249
Board Serial          : 465824T+1209B71250
Board Part Number     : 300-2235-03
Power Supply Record
Capacity                   : 1200 W
Peak VA                    : 1360 VA
Inrush Current             : 25 A
Inrush Interval            : 200 ms
Input Voltage Range 1      : 90-264 V
Input Voltage Range 2      : 200-264 V
Input Frequency Range      : 47-63 Hz
A/C Dropout Tolerance      : 12 ms
Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin assertion'
Peak capacity              : 1200 W
Peak capacity holdup       : 15 s
Combined capacity          : not specified
Fan lower threshold        : 0 RPS
DC Output Record
Output Number              : 1
Standby power              : No
Nominal voltage            : 12.00 V
Max negative deviation     : 11.88 V
Max positive deviation     : 12.12 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.050 A
Maximum current draw       : 9.920 A
DC Output Record
Output Number              : 2
Standby power              : Yes
Nominal voltage            : 3.35 V
Max negative deviation     : 3.25 V
Max positive deviation     : 3.45 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.000 A
Maximum current draw       : 0.400 A

FRU Device Description : PS1 (LUN 0, ID 64)
Board Mfg             : Delta Energy Systems
Board Product         : A249
Board Serial          : 465824T+1209B71257
Board Part Number     : 300-2235-03
Power Supply Record
Capacity                   : 1200 W
Peak VA                    : 1360 VA
Inrush Current             : 25 A
Inrush Interval            : 200 ms
Input Voltage Range 1      : 90-264 V
Input Voltage Range 2      : 200-264 V
Input Frequency Range      : 47-63 Hz
A/C Dropout Tolerance      : 12 ms
Flags                      : 'Predictive fail' 'Power factor correction' 'Hot swap' 'Failure on pin assertion'
Peak capacity              : 1200 W
Peak capacity holdup       : 15 s
Combined capacity          : not specified
Fan lower threshold        : 0 RPS
DC Output Record
Output Number              : 1
Standby power              : No
Nominal voltage            : 12.00 V
Max negative deviation     : 11.88 V
Max positive deviation     : 12.12 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.050 A
Maximum current draw       : 9.920 A
DC Output Record
Output Number              : 2
Standby power              : Yes
Nominal voltage            : 3.35 V
Max negative deviation     : 3.25 V
Max positive deviation     : 3.45 V
Ripple and noise pk-pk     : 100 mV
Minimum current draw       : 0.000 A
Maximum current draw       : 0.400 A

FRU Device Description : DBP (LUN 0, ID 210)
Board Product         : ASSY,BKPL,2U,12-DISK,3.5IN,M2
Board Part Number     : 541-4363-01
Board Extra           : 12DBP_M2

FRU Device Description : PDB (LUN 0, ID 211)
Board Product         : BD,LOUISE,HPDB
Board Serial          : 0226LHF-1215F6001M
Board Part Number     : 541-4223-03
Board Extra           : 51
Board Extra           : PDB
Product Name          : SUN FIRE X4270 M2 SERVER
Product Part Number   : 7042372
Product Serial        : 1221FMM0P5

FRU Device Description : SAS_EXP (LUN 0, ID 218)
Board Product         : BD,2U,M2,36PRT SAS2 EXPNDR
Board Serial          : 0226LHF-1215GC005V
Board Part Number     : 541-4305-01
Board Extra           : 52
Board Extra           : 2U,M2,SAS2XDC

FRU Device Description : FB (LUN 0, ID 212)
Board Product         : BD,LOUISE,FAN_BRD
Board Serial          : 0226LHF-1215F50352
Board Part Number     : 541-4124-04
Board Extra           : 50
Board Extra           : FANBD

FRU Device Description : DBP/HDD0 (LUN 0, ID 47)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD1 (LUN 0, ID 48)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD2 (LUN 0, ID 49)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD3 (LUN 0, ID 50)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD4 (LUN 0, ID 51)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD5 (LUN 0, ID 52)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD6 (LUN 0, ID 53)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD7 (LUN 0, ID 54)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD8 (LUN 0, ID 55)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD9 (LUN 0, ID 56)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD10 (LUN 0, ID 57)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : DBP/HDD11 (LUN 0, ID 58)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : RHDD0 (LUN 0, ID 145)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : RHDD1 (LUN 0, ID 146)
Device not present (Requested sensor, data, or record not found)

FRU Device Description : CONN_BD (LUN 0, ID 223)
Board Product         : BD,2U,M2,CONNECTOR CARD
Board Serial          : 0226LHF-1215G9001P
Board Part Number     : 541-4306-01
Board Extra           : 50
Board Extra           : 2U,M2,CONN

发表在硬件配置 | 标签为 Exadata, X2 | 留下评论

ASM磁盘头被fdisk损坏的修复过程

发表于 2013 年 6 月 16 日由 Lunar

一大早起来折腾昨天的12c（我装的是standalone），发现使用文件虚拟成设备的方法，磁盘IO效率很低（我猜是这个原因），于是铲掉打算重新安装
铲掉12c RAC跟铲掉11.2 RAC没啥区别，参考前面的文章 5分钟内搞定。

安装完grid，感觉磁盘不够用，于是把vm停了，加一块新的盘，然后启动后，fdisk /dev/sde
悲剧了，刚弄完就想起来，这个是ASM的DATADG…………于是，你懂的……

查看has的状态：
[root@lunar ~]# crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               OFFLINE OFFLINE      lunar                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       lunar                    STABLE
ora.asm
               ONLINE  OFFLINE      lunar                    Instance Shutdown,ST
                                                             ABLE
ora.ons
               OFFLINE OFFLINE      lunar                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  OFFLINE      lunar                    STARTING
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  INTERMEDIATE lunar                    STABLE
--------------------------------------------------------------------------------
[root@lunar ~]#

查看日志,ora.DATA.dg 资源状态异常：

[root@lunar ~]# vi /u01/app/12.1/grid/log/lunar/agent/ohasd/oraagent_grid/oraagent_grid.log

Oracle Database 12c Clusterware Release 12.1.0.1.0 - Production Copyright 1996, 2013 Oracle. All rights reserved.
2013-06-16 09:28:33.678: [    AGFW][274839072] Starting the agent: /u01/app/12.1/grid/log/lunar/agent/ohasd/oraagent_grid/
2013-06-16 09:28:33.678: [   AGENT][274839072] Agent framework initialized, Process Id = 7389
2013-06-16 09:28:33.693: [ USRTHRD][274839072] ConnectionPool::initMutex

...

2013-06-16 09:59:05.391: [ora.DATA.dg][1111324992] {0:0:123} [clean] (:CLSN00106:) clsn_agent::clean }
2013-06-16 09:59:05.391: [    AGFW][1111324992] {0:0:123} Command: clean for resource: ora.DATA.dg lunar 1 completed with status: SUCCESS
2013-06-16 09:59:05.392: [    AGFW][1100106048] {0:0:123} Agent sending reply for: RESOURCE_CLEAN[ora.DATA.dg lunar 1] ID 4100:606
2013-06-16 09:59:05.398: [    GPNP][1082648896]clsgpnpwu_walletfopen: [at clsgpnpwu.c:379] Result: (66) CLSGPNP_WALLET_NONE. (:GPNP01603:)Wallet file not found: '/u01/app/12.1/grid/gpnp/lunar/wallets/prdr/cwallet.sso'
2013-06-16 09:59:05.398: [    GPNP][1082648896]clsgpnpwu_walletfopen: [at clsgpnpwu.c:497] Result: (66) CLSGPNP_WALLET_NONE. (:GPNP01610:)Cannot open wallet: '/u01/app/12.1/grid/gpnp/lunar/wallets/prdr/cwallet.sso'
2013-06-16 09:59:05.399: [    GPNP][1082648896]clsgpnp_getCK: [at clsgpnp0.c:2472] (:GPNP00233:)Fatal error: failed to get local gpnp security keys (wallet). Gpnp profiles cannot be verified. ***LOCAL GPNP SETUP INVALID***.>
2013-06-16 09:59:05.399: [    GPNP][1082648896]clsgpnp_InitIdSetCtxCK: [at clsgpnp0.c:5151] Result: (66) CLSGPNP_WALLET_NONE. (:GPNP00267:)Cannot get stored certkey for id=1
2013-06-16 09:59:05.399: [    GPNP][1082648896]clsgpnp_Init: [at clsgpnp0.c:1003] Result: (66) CLSGPNP_WALLET_NONE. (:GPNP00211:)Error getting certkeys.
2013-06-16 09:59:05.399: [    GPNP][1082648896]clsgpnp_Init init failed. Error: CLSGPNP_ERR (1) .
2013-06-16 09:59:05.601: [ default][1082648896](:CLSUG0001:)Failed to initialize clsgpnp context grv CLSGPNP_ERR (1). Return GPNP [12]
2013-06-16 09:59:05.602: [ default][1082648896]clsugam:3: Failed to get gpnp profile. Return GPNP [12].
2013-06-16 09:59:05.602: [ora.DATA.dg][1082648896] {0:0:123} [check] CrsCmd::ClscrsCmdData::stat entity 1 statflag 1 useFilter 0

使用kfed可以清晰的看到，盘头损坏了：

[grid@lunar ~]$ kfed dev=/dev/sde op=READ
kfbh.endian:                          0 ; 0x000: 0x00
kfbh.hard:                            0 ; 0x001: 0x00
kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt:                          0 ; 0x003: 0x00
kfbh.block.blk:                       0 ; 0x004: blk=0
kfbh.block.obj:                       0 ; 0x008: file=0
kfbh.check:                           0 ; 0x00c: 0x00000000
kfbh.fcn.base:                        0 ; 0x010: 0x00000000
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
000000000 00000000 00000000 00000000 00000000  [................]
        Repeat 30 times
0000001F0 00000000 00000000 00000000 AA550000  [..............U.]
000000200 00000000 00000000 00000000 00000000  [................]
  Repeat 223 times
KFED-00322: Invalid content encountered during block traversal: [kfbtTraverseBlock][Invalid OSM block type][][0]

[grid@lunar ~]$ 

正常的盘头应该是：   kfbh.type=KFBTYP_DISKHEAD

在ASM中也可以看到，/dev/sdb原本是DATA DG的设备（HEADER_STATU应为 MEMBER），现在确变成“CANDIDATE”：

SQL> set pages 999
SQL> set linesize 122
SQL> select DISK_NUMBER,HEADER_STATUS,substr(PATH,1,20),label from v$asm_disk;

DISK_NUMBER HEADER_STATU SUBSTR(PATH,1,20)    LABEL
----------- ------------ -------------------- -------------------------------
          1 CANDIDATE    /dev/sde
          0 CANDIDATE    /dev/sdb

SQL>

我们知道，每个ASM磁盘的UNIT 1，块254（Allocation unit# 1, Block# 254）是盘头的备份，因此查看下，这个块是否是好的：

[grid@lunar ~]$ kfed read /dev/sde aun=1 blkn=254 |grep KFBTYP
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
[grid@lunar ~]$ 

行了，可以使用repair进行修复了（10.2.0.5以后的版本可以使用这个方法）：
1
[grid@lunar ~]$  kfed  repair /dev/sde
[grid@lunar ~]$ 

修复后，再次查看，已经正常了：
[grid@lunar ~]$ kfed read /dev/sde aun=0 blkn=0 | grep KFBTYP
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
[grid@lunar ~]$ 

SQL> select DISK_NUMBER,HEADER_STATUS,substr(PATH,1,20),label from v$asm_disk;

DISK_NUMBER HEADER_STATU SUBSTR(PATH,1,20)    LABEL
----------- ------------ -------------------- -------------------------------
          1 MEMBER       /dev/sde
          0 CANDIDATE    /dev/sdb

SQL> 

[grid@lunar ~]$ asmcmd lsdsk -p
Group_Num  Disk_Num      Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path
        1         0  3916001478  CACHED      MEMBER       ONLINE     NORMAL  /dev/sde
[grid@lunar ~]$

[grid@lunar ~]$ kfed dev=/dev/sde op=READ
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                       0 ; 0x004: blk=0
kfbh.block.obj:              2147483648 ; 0x008: disk=0
kfbh.check:                  2821357814 ; 0x00c: 0xa82a80f6
kfbh.fcn.base:                        0 ; 0x010: 0x00000000
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr:         ORCLDISK ; 0x000: length=8
kfdhdb.driver.reserved[0]:            0 ; 0x008: 0x00000000
kfdhdb.driver.reserved[1]:            0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]:            0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]:            0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]:            0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]:            0 ; 0x01c: 0x00000000
kfdhdb.compat:                202375168 ; 0x020: 0x0c100000
kfdhdb.dsknum:                        0 ; 0x024: 0x0000
kfdhdb.grptyp:                        1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts:                        3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname:               DATA_0000 ; 0x028: length=9
kfdhdb.grpname:                    DATA ; 0x048: length=4
kfdhdb.fgname:                DATA_0000 ; 0x068: length=9
kfdhdb.capname:                         ; 0x088: length=0
kfdhdb.crestmp.hi:             32987657 ; 0x0a8: HOUR=0x9 DAYS=0x10 MNTH=0x6 YEAR=0x7dd
kfdhdb.crestmp.lo:           2046686208 ; 0x0ac: USEC=0x0 MSEC=0x37d SECS=0x1f MINS=0x1e
kfdhdb.mntstmp.hi:             32987657 ; 0x0b0: HOUR=0x9 DAYS=0x10 MNTH=0x6 YEAR=0x7dd
kfdhdb.mntstmp.lo:           2072964096 ; 0x0b4: USEC=0x0 MSEC=0x3bb SECS=0x38 MINS=0x1e
kfdhdb.secsize:                     512 ; 0x0b8: 0x0200
kfdhdb.blksize:                    4096 ; 0x0ba: 0x1000
kfdhdb.ausize:                  1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize:                   10240 ; 0x0c4: 0x00002800
kfdhdb.pmcnt:                         3 ; 0x0c8: 0x00000003
kfdhdb.fstlocn:                       1 ; 0x0cc: 0x00000001
kfdhdb.altlocn:                       2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn:                     10 ; 0x0d4: 0x0000000a
kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]:                0 ; 0x0da: 0x0000
kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0x0000
kfdhdb.redomirrors[3]:                0 ; 0x0de: 0x0000
kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi:             32987657 ; 0x0e4: HOUR=0x9 DAYS=0x10 MNTH=0x6 YEAR=0x7dd
kfdhdb.grpstmp.lo:           2046528512 ; 0x0e8: USEC=0x0 MSEC=0x2e3 SECS=0x1f MINS=0x1e
kfdhdb.vfstart:                       0 ; 0x0ec: 0x00000000
kfdhdb.vfend:                         0 ; 0x0f0: 0x00000000
kfdhdb.spfile:                       59 ; 0x0f4: 0x0000003b
kfdhdb.spfflg:                        1 ; 0x0f8: 0x00000001
kfdhdb.flags:                         1 ; 0x0fc: 0x00000001
kfdhdb.f1b1fcn.base:                  0 ; 0x100: 0x00000000
kfdhdb.f1b1fcn.wrap:                  0 ; 0x104: 0x00000000
kfdhdb.ub4spare[0]:                   0 ; 0x108: 0x00000000
kfdhdb.ub4spare[1]:                   0 ; 0x10c: 0x00000000
kfdhdb.ub4spare[2]:                   0 ; 0x110: 0x00000000
kfdhdb.ub4spare[3]:                   0 ; 0x114: 0x00000000
kfdhdb.ub4spare[4]:                   0 ; 0x118: 0x00000000
kfdhdb.ub4spare[5]:                   0 ; 0x11c: 0x00000000
kfdhdb.ub4spare[6]:                   0 ; 0x120: 0x00000000
kfdhdb.ub4spare[7]:                   0 ; 0x124: 0x00000000
kfdhdb.ub4spare[8]:                   0 ; 0x128: 0x00000000
kfdhdb.ub4spare[9]:                   0 ; 0x12c: 0x00000000
kfdhdb.ub4spare[10]:                  0 ; 0x130: 0x00000000
kfdhdb.ub4spare[11]:                  0 ; 0x134: 0x00000000
kfdhdb.ub4spare[12]:                  0 ; 0x138: 0x00000000
kfdhdb.ub4spare[13]:                  0 ; 0x13c: 0x00000000
kfdhdb.ub4spare[14]:                  0 ; 0x140: 0x00000000
kfdhdb.ub4spare[15]:                  0 ; 0x144: 0x00000000
kfdhdb.ub4spare[16]:                  0 ; 0x148: 0x00000000
kfdhdb.ub4spare[17]:                  0 ; 0x14c: 0x00000000
kfdhdb.ub4spare[18]:                  0 ; 0x150: 0x00000000
kfdhdb.ub4spare[19]:                  0 ; 0x154: 0x00000000
kfdhdb.ub4spare[20]:                  0 ; 0x158: 0x00000000
kfdhdb.ub4spare[21]:                  0 ; 0x15c: 0x00000000
kfdhdb.ub4spare[22]:                  0 ; 0x160: 0x00000000
kfdhdb.ub4spare[23]:                  0 ; 0x164: 0x00000000
kfdhdb.ub4spare[24]:                  0 ; 0x168: 0x00000000
kfdhdb.ub4spare[25]:                  0 ; 0x16c: 0x00000000
kfdhdb.ub4spare[26]:                  0 ; 0x170: 0x00000000
kfdhdb.ub4spare[27]:                  0 ; 0x174: 0x00000000
kfdhdb.ub4spare[28]:                  0 ; 0x178: 0x00000000
kfdhdb.ub4spare[29]:                  0 ; 0x17c: 0x00000000
kfdhdb.ub4spare[30]:                  0 ; 0x180: 0x00000000
kfdhdb.ub4spare[31]:                  0 ; 0x184: 0x00000000
kfdhdb.ub4spare[32]:                  0 ; 0x188: 0x00000000
kfdhdb.ub4spare[33]:                  0 ; 0x18c: 0x00000000
kfdhdb.ub4spare[34]:                  0 ; 0x190: 0x00000000
kfdhdb.ub4spare[35]:                  0 ; 0x194: 0x00000000
kfdhdb.ub4spare[36]:                  0 ; 0x198: 0x00000000
kfdhdb.ub4spare[37]:                  0 ; 0x19c: 0x00000000
kfdhdb.ub4spare[38]:                  0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare[39]:                  0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare[40]:                  0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare[41]:                  0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare[42]:                  0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare[43]:                  0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare[44]:                  0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare[45]:                  0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare[46]:                  0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare[47]:                  0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare[48]:                  0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare[49]:                  0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare[50]:                  0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents:                     0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare:                 0 ; 0x1de: 0x0000
[grid@lunar ~]$ 

[grid@lunar ~]$ kfed dev=/dev/sde op=READ| egrep "kfdhdb.vf|ausize"
kfdhdb.ausize:                  1048576 ; 0x0bc: 0x00100000
kfdhdb.vfstart:                       0 ; 0x0ec: 0x00000000
kfdhdb.vfend:                         0 ; 0x0f0: 0x00000000
[grid@lunar ~]$

手工把ASM磁盘组DATA挂载上：

[root@lunar ~]# srvctl start diskgroup -diskgroup data
[root@lunar ~]# crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       lunar                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       lunar                    STABLE
ora.asm
               ONLINE  ONLINE       lunar                    Started,STABLE
ora.ons
               OFFLINE OFFLINE      lunar                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       lunar                    STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       lunar                    STABLE
--------------------------------------------------------------------------------
[root@lunar ~]#

好了，可以安装db软件，然后建库了…………

发表在 ASM, backup&recovery | 标签为 asm, kfed | 一条评论

记一次低级错误——dbca找不到ASM磁盘组

发表于 2013 年 6 月 15 日由 Lunar

今天忽然想起来装一个12c，首先声明，12c中，创建CDB和PDB的功能是一个选项，可以在创建数据库的时候，选择是否创建成这个模式，或者沿用以前的模式：
在标准创建中可以选择“Create as container database”：

或者在高级选项中选择“Create as container database”

本次发现一个问题，使用dbca建库，找不到磁盘组，但是从grid用户看disk和diskgroup都是正常的：

SQL> select group_number,disk_number,mode_status from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MODE_ST
------------ ----------- -------
           2           0 ONLINE
           1           3 ONLINE
           1           2 ONLINE
           1           1 ONLINE
           1           0 ONLINE

SQL> 
SQL> select group_number,disk_number,mode_status,name from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MODE_ST NAME
------------ ----------- ------- ------------------------------
           2           0 ONLINE  RECO_0000
           1           3 ONLINE  DATA_0003
           1           2 ONLINE  DATA_0002
           1           1 ONLINE  DATA_0001
           1           0 ONLINE  DATA_0000

SQL>

检查一圈，发现原来是orace用户组设置错误：

 [root@lunar app]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[root@lunar app]#

检查grid：

 [root@lunar app]# id grid
uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(asmadmin),54324(asmdba)
[root@lunar app]#

修改oracle组为以下：

 [root@lunar app]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(asmadmin),54324(asmdba)
[root@lunar app]#

可以正常建库了：

发表在 ASM | 标签为 asm, dbca | 留下评论

Linux下手工卸载11.2 RAC(非MOS的deinstall方法)

发表于 2013 年 6 月 13 日由 Lunar

用了下11.2的deinstall卸载慢的很，熬人，自创了一个，感觉很好，5分钟内搞定，可以稍微改改，写成脚本，o(∩_∩)o 哈哈

思路来自于经典的《How to Proceed From a Failed 10g or 11.1 Oracle Clusterware (CRS) Installation (Doc ID 239998.1)》
补充了一些11.2特有的内容。

下载11.2 RAC的官方方法：
How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation (Doc ID 942166.1)
本次没有采用这个方法，其主要是执行deintall脚本，但是我的环境中，执行时间很久，不喜欢………………

以下是一个节点的，2个节点也一样：

最好先执行这个：

crsctl stop crs -f

当然，按照我下面的，不执行也没有问题……

cd /etc/oracle/
rm -rf scls_scr oprocd lastgasp o* setasmgid

vi  /etc/inittab
去掉ohas的那一行（通常是最后一行）

rm -f /etc/init.d/init.cssd 
rm -f /etc/init.d/init.crs 
rm -f /etc/init.d/init.crsd 
rm -f /etc/init.d/init.evmd 
rm -f /etc/rc2.d/K96init.crs 
rm -f /etc/rc2.d/S96init.crs 
rm -f /etc/rc3.d/K96init.crs 
rm -f /etc/rc3.d/S96init.crs 
rm -f /etc/rc5.d/K96init.crs 
rm -f /etc/rc5.d/S96init.crs 
rm -Rf /etc/oracle/scls_scr 
rm -f /etc/inittab.crs 
cp /etc/inittab.orig /etc/inittab

rm -rf /etc/init.d/ohasd 
rm -rf /etc/init.d/init.ohasd 
rm -rf /etc/oratab
rm -rf /etc/oraInst.loc 

rm -rf /var/tmp/.oracle
rm -rf /tmp/.oracle
rm -rf /u01/app

cd /tmp
rm -rf CVU_11.2.0.3.0_grid logs Logs OraInstall*

mkdir -p /u01/app/11.2.0.3/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
chown -R grid:oinstall /u01/app/11.2.0.3/grid
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01


mkdir -p /u01/app/oracle/product/11.2.0.3/dbhome_1
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle/product/11.2.0.3/dbhome_1

检查是否还有 d.bin 进程：
ps -ef|grep d.bin
如果还有，那么直接kill
系统不会重启的，你想啊，文件都被kill了…………

检查 ifconfig|grep 169.254，如果有类似下面的输出：

eth1:1    Link encap:Ethernet  HWaddr 08:00:27:89:81:66  
          inet addr:169.254.159.3  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

那么需要重启一下eth1网卡：

[root@dm01db01 cell]# ifdown eth1
[root@dm01db01 cell]# ifup eth1
[root@dm01db01 cell]# ifconfig|grep 169.254
[root@dm01db01 cell]#

好了，可以重新安装了，o(∩_∩)o 哈哈

发表在 Installation and Deinstall, RAC, Scripts | 标签为 11.2, deinstall, linux, rac | 2 条评论

站内搜索

Search for:
Oracle证书
分类目录
- ASM (30)
- Database (86)
  - backup&recovery (21)
  - expdp/impdp (5)
  - Installation and Deinstall (31)
  - network (7)
  - ORA-600 or ORA-7445 (6)
  - Performence Tuning (13)
  - troubleshoooting (2)
- Dataguard (7)
- EBS (3)
  - EBS系统管理 (1)
  - 安装、克隆、迁移 (2)
- Exadata (120)
  - FAQ (19)
  - POC和性能调整 (11)
  - 体系架构 (19)
  - 内部机制 (22)
  - 安装和升级 (14)
  - 性能指标 (8)
    - Exadata V1 (1)
    - Exadata V2 (1)
    - Exadata X2-2 (2)
    - Exadata X3-2 (1)
    - Exadata X4-2 (1)
    - FAQ (1)
  - 故障诊断 (3)
  - 日常运维 (15)
  - 硬件配置 (43)
    - Exadata V1 (6)
    - Exadata V2 (6)
    - Exadata X2-2 (6)
    - Exadata X3-2 (8)
    - Exadata X4-2 (8)
    - FAQ (1)
- FAQ (16)
- Internal (21)
  - bbed (2)
  - DUL ODU (4)
- Linux (20)
- MYSQL (8)
  - FAQ (7)
  - 复制 (1)
  - 安装配置 (1)
- OGG (1)
- ORA-600/7445 (2)
- ORA-XXXXX (5)
- Oracle 11.1 & Oracle11.2 (6)
- ORACLE 12C (21)
- Oracle 8 & Oracle 8i (1)
- RAC (47)
- SAP (2)
- Scripts (6)
- 未分类 (1)
- 虚拟化 (1)
2024 年四月

S M T W T F S

« Nov

1 2 3 4 5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30
文章归档
文章归档
近期文章
近期评论
- tom 发表在《exadata巡检报告的模板》
- cyx 发表在《关于我》
- 李科胜发表在《EBS克隆–db和app分开在两个服务器上》
- xiao 发表在《exadata巡检报告的模板》
- Chris Sun 发表在《使用Oracle 11.2的DBMS_RESOURCE_MANAGER.CALIBRATE_IO对Exadata X5（HC）进行测试》

2024 年四月
S	M	T	W	T	F	S
« Nov
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

站内搜索

Oracle证书

分类目录

文章归档

近期文章

近期评论