June 5, 2008
使用kudzu命令查看网卡型号
作者:eygle
出处:http://blog.eygle.com
kudzu 是Linux下检测硬件变化的命令，这个命令可以用于检查系统中网卡的型号等信息：kudzu(1) kudzu(1)以下是这个命令执行的输出示例：
NAME
kudzu - detects and configures new and/or changed hardware on a system
SYNOPSIS
kudzu
DESCRIPTION
kudzu detects and configures new and/or changed hardware on a system.
When started, kudzu detects the current hardware, and checks it against
a database stored in /etc/sysconfig/hwconf, if one exists. It then
determines if any hardware has been added or removed from the system.
If so, it gives the users the opportunity to configure any added hard-
ware, and unconfigure any removed hardware. It then updates the
database in /etc/sysconfig/hwconf.
If no previous database exists, kudzu attempts to determine what
devices have already been configured, by looking at /etc/modules.conf,
/etc/sysconfig/network-scripts/, and /etc/X11/XF86Config.
[root@wapdbrac1 ~]# kudzu --probe --class=network
-
class: NETWORK
bus: PCI
detached: 0
device: eth1
driver: bnx2
desc: "Broadcom Corporation NetXtreme II BCM5708 Gigabit Ethernet"
network.hwaddr: 00:1B:78:97:E4:EA
vendorId: 14e4
deviceId: 164c
subVendorId: 103c
subDeviceId: 7038
pciType: 1
pcidom: 0
pcibus: 5
pcidev: 0
pcifn: 0
-
class: NETWORK
bus: PCI
detached: 0
device: eth0
driver: bnx2
desc: "Broadcom Corporation NetXtreme II BCM5708 Gigabit Ethernet"
network.hwaddr: 00:1B:78:97:E4:EC
vendorId: 14e4
deviceId: 164c
subVendorId: 103c
subDeviceId: 7038
pciType: 1
pcidom: 0
pcibus: 3
pcidev: 0
pcifn: 0
Posted by eygle at 9:12 PM | Comments (4)
Oracle 10gR2 软件下载网址收藏
作者:eygle
出处:http://blog.eygle.com
记录一下ORACLE 10gR2的软件下载地址，备用。
下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip
收藏备忘！
Posted by eygle at 4:31 PM | Comments (9)
这是一个Oracle普及的时代
作者:eygle
出处:http://blog.eygle.com
今天上午，一个朋友在QQ上求助，说一个生产数据库起不来了，问能不能想办法恢复。
我说，办法肯定是有的，只要文件还在，我们都有办法恢复。
看了一下他的告警日志文件，最初出现的错误是ORA-00600 4194号错误：
Sun Jun 01 12:32:11 2008
SMON: enabling cache recovery
Sun Jun 01 12:32:19 2008
Errors in file d:\oracle\admin\ffair\udump\ffair_ora_356.trc:
ORA-00600: ?????????: [4194], [12], [23], [], [], [], [], []Sun Jun 01 12:32:23 2008
Doing block recovery for fno: 1 blk: 388
Sun Jun 01 12:32:23 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 101 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ffair\REDO01.LOG
Doing block recovery for fno: 1 blk: 9
Sun Jun 01 12:32:24 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 101 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ffair\REDO01.LOG
Sun Jun 01 12:32:25 2008
Errors in file d:\oracle\admin\ffair\udump\ffair_ora_356.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-00607: ?????????????
ORA-00600: ?????????: [4194], [12], [23], [], [], [], [], []Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 356
ORA-1092 signalled during: alter database open...
Dump file d:\oracle\admin\ffair\bdump\alert_ffair.log
然后他们经过一系列的特殊参数尝试，最终以失败告终。
这些都不重要，当我问他是什么客户时，他说：是发廊的数据库！
我不禁感叹，这真是一个Oracle普及的时代，发廊都开始用Oracle的数据库系统了，也许我们真的离用Oracle管理养猪不远了！
-The End-
Posted by eygle at 3:39 PM | Comments (12)
数据字典视图之：v$database 结构
作者:eygle
出处:http://blog.eygle.com
以下是Oracle视图v$database的创建语句，数据提取来自Oracle 10g 10.2.0.4版本数据库，供参考：SELECT di.inst_id, di.didbi, di.didbn,
TO_DATE (di.dicts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
TO_NUMBER (di.dirls),
TO_DATE (di.dirlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
TO_NUMBER (di.diprs),
TO_DATE (di.diprc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
DECODE (di.dimla, 0, 'NOARCHIVELOG', 1, 'ARCHIVELOG', 'MANUAL'),
TO_NUMBER (di.discn), TO_NUMBER (di.difas),
DECODE (BITAND (di.diflg, 256),
256, 'CREATED',
DECODE (BITAND (di.diflg, 1024),
1024, 'STANDBY',
DECODE (BITAND (di.diflg, 32768),
32768, 'CLONE',
DECODE (BITAND (di.diflg, 4096),
4096, 'BACKUP',
'CURRENT'
)
)
)
),
TO_DATE (di.dicct, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
di.dicsq, TO_NUMBER (di.dickp_scn),
TO_DATE (di.dickp_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
DECODE (BITAND (di.diflg, 4),
4, 'REQUIRED',
DECODE (di.diirs, 0, 'NOT ALLOWED', 'ALLOWED')
),
TO_DATE (di.divts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
DECODE (di.didor,
0, 'MOUNTED',
DECODE (di.didor, 1, 'READ WRITE', 'READ ONLY')
),
DECODE (BITAND (di.diflg, 65536),
65536, 'MAXIMUM PROTECTION',
DECODE (BITAND (di.diflg, 128),
128, 'MAXIMUM AVAILABILITY',
DECODE (BITAND (di.diflg, 134217728),
134217728, 'RESYNCHRONIZATION',
DECODE (BITAND (di.diflg, 8),
8, 'UNPROTECTED',
'MAXIMUM PERFORMANCE'
)
)
)
),
DECODE (di.diprt,
1, 'MAXIMUM PROTECTION',
2, 'MAXIMUM AVAILABILITY',
3, 'RESYNCHRONIZATION',
4, 'MAXIMUM PERFORMANCE',
5, 'UNPROTECTED',
'UNKNOWN'
),
DECODE (di.dirae,
0, 'DISABLED',
1, 'SEND',
2, 'RECEIVE',
3, 'ENABLED',
'UNKNOWN'
),
TO_NUMBER (di.diacid), TO_NUMBER (di.diacid),
DECODE (BITAND (di.diflg, 33554432),
33554432, 'LOGICAL STANDBY',
DECODE (BITAND (di.diflg, 1024),
1024, 'PHYSICAL STANDBY',
'PRIMARY'
)
),
TO_NUMBER (di.diars),
DECODE (BITAND (difl2, 1), 1, 'ENABLED', 'DISABLED'),
DECODE (di.disos,
0, 'IMPOSSIBLE',
1, 'NOT ALLOWED',
2, 'SWITCHOVER LATENT',
3, 'SWITCHOVER PENDING',
4, 'TO PRIMARY',
5, 'TO STANDBY',
6, 'RECOVERY NEEDED',
7, 'SESSIONS ACTIVE',
8, 'PREPARING SWITCHOVER',
9, 'PREPARING DICTIONARY',
10, 'TO LOGICAL STANDBY',
'UNKNOWN'
),
DECODE (di.didgd, 0, 'DISABLED', 'ENABLED'),
DECODE (BITAND (di.diflg, 1048576),
1048576, 'ALL',
DECODE (BITAND (di.diflg, 2097152),
2097152, 'STANDBY',
'NONE'
)
),
DECODE (BITAND (diflg, 1073741824),
1073741824, 'YES',
DECODE (BITAND (diflg, 131072 + 262144 + 524288),
0, DECODE (BITAND (difl2, 2), 0, 'NO', 'IMPLICIT'),
'IMPLICIT'
)
),
DECODE (BITAND (di.diflg, 131072), 131072, 'YES', 'NO'),
DECODE (BITAND (di.diflg, 262144), 262144, 'YES', 'NO'),
DECODE (BITAND (di.diflg, 268435456), 268435456, 'YES', 'NO'),
di.diplid, di.dipln, di2.di2rdi, di2.di2inc, TO_NUMBER (di.dicur_scn),
DECODE (BITAND (di2.di2flag, 1),
1, 'YES',
DECODE (di2.di2rsp_oldest, 0, 'NO', 'RESTORE POINT ONLY')
),
DECODE (BITAND (diflg, 524288), 524288, 'YES', 'NO'),
DECODE (BITAND (difl2, 2), 2, 'YES', 'NO'), di.didbun,
TO_NUMBER (di2.di2actiscn),
DECODE (di.difsts,
0, 'DISABLED',
1, 'BYSTANDER',
2, 'SYNCHRONIZED',
3, 'UNSYNCHRONIZED',
4, 'SUSPENDED',
5, 'STALLED',
6, 'LOADING DICTIONARY',
7, 'PRIMARY UNOBSERVED',
8, 'REINSTATE REQUIRED',
9, 'REINSTATE IN PROGRESS',
10, 'REINSTATE FAILED',
''
),
di.diftgt, di.difths,
DECODE (di.difopr, 1, 'YES', 2, 'NO', 3, 'UNKNOWN', ''), di.difobs
FROM x$kccdi di, x$kccdi2 di2
Posted by eygle at 12:15 PM | Comments (0)