2009年6月 – OracleBlog

安腾平台的legato的lib link

2009-06-29 2条评论

某省新上安腾平台的oracle，备份软件是legato，首先在安腾的机器上安装了networker.pkg和nmo.pkg，配置好client后，发现备份失败。查/nsr/applogs/msglog.log发现：

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 06/29/2009 11:55:45
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27211: Failed to load Media Management Library
Additional information: 25

1

2

3

4

5

6

7

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on t1 channel at 06/29/2009 11:55:45

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 25

对于这个报错，我已 […]

..experience, Working case

rac安装报错和修复小结

2009-06-27 2条评论

一、rac安装步骤主要分以下几步： 1、安装操作系统。 2、配置时间同步，如ntp 3、创建oracle用户和配置rsa和dsa 4、配置hosts文件 5、配置hangcheck-timer 6、配置共享存储（ocr和voting disk） 7、安装clusterware（crs） 8、配置as […]

..oracle service, Working case

跨平台的DATAGUARD组合列表

2009-06-22 一条评论

oracle允许在同一个oracle platform下安装dataguard，要求尽量的同样的操作系统版本。 oracle platform可以用以下的语句查看（9i的v$database没有PLATFORM_ID和PLATFORM_NAME字段）： [crayon-662a22d7e327407 […]

It's my life

养鱼心得

2009-06-19 3条评论

婚前装修房子的时候，为了给房子增加一点生气，不显得太呆板，特地去养了一缸鱼。一开始养鱼的时候，几乎是一天死一条，心疼的哟～～～唉，俗话说久病成医，养鱼死的多了，也总结了一些养鱼的经验，现在1个多月下来，没死过鱼。 1、养鱼最好是只养一种鱼，或者习性比较类似的鱼。有些鱼好动好斗，就不宜和喜静的鱼养一 […]

..experience, Working case

swap空间不够导致连接侦听失败

2009-06-16 3条评论

早上4点多就被叫起来，说某现网的数据库侦听挂了。数据库连不上去，报以下的错误：

$ sqlplus user/pwd@sid

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jun 12 04:58:05 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

1

2

3

4

5

6

7

8

$ sqlplus user/pwd@sid

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jun 12 04:58:05 2009

ERROR:

ORA-12500: TNS:listener failed to start a dedicated server process

登录后检查数据库的侦听进程还在，检查lsnrctl status的状态也是正常。检查侦听的log发现，有大量连接拒连： [crayon-662a22d7 […]

..experience, Working case

修改hosts后，rac通讯失败

2009-06-15 没有评论

今天收到个告警某省的一个数据库的一个节点down了，重启后，只能到started状态，数据库无法open，登录上去后，看到alertlog中：

Mon Jun 15 15:38:28 2009
Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_26950.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:gethostbyname failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: sskgxpmyip2
ORA-27303: additional information: nodename FJ_DB02
 Mon Jun 15 15:41:19 2009
Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27062.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:gethostbyname failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: sskgxpmyip2
ORA-27303: additional information: nodename FJ_DB02
Mon Jun 15 15:42:37 2009
Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27147.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:gethostbyname failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: sskgxpmyip2
ORA-27303: additional information: nodename FJ_DB02
 Mon Jun 15 15:46:19 2009
Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27362.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context

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

Mon Jun 15 15:38:28 2009

Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_26950.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27504: IPC error creating OSD context

ORA-27300: OS system dependent operation:gethostbyname failed with status: 3

ORA-27301: OS failure message: No such process

ORA-27302: failure occurred at: sskgxpmyip2

ORA-27303: additional information: nodename FJ_DB02

Mon Jun 15 15:41:19 2009

Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27062.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27504: IPC error creating OSD context

ORA-27300: OS system dependent operation:gethostbyname failed with status: 3

ORA-27301: OS failure message: No such process

ORA-27302: failure occurred at: sskgxpmyip2

ORA-27303: additional information: nodename FJ_DB02

Mon Jun 15 15:42:37 2009

Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27147.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27504: IPC error creating OSD context

ORA-27300: OS system dependent operation:gethostbyname failed with status: 3

ORA-27301: OS failure message: No such process

ORA-27302: failure occurred at: sskgxpmyip2

ORA-27303: additional information: nodename FJ_DB02

Mon Jun 15 15:46:19 2009

Errors in file /oracle/app/oracle/admin/fjmisc/udump/fjmisc2_ora_27362.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27504: IPC error creating OSD context

当时第一个反映是gethostbyname failed 应该是主机名解析有问题了。但是p […]

..experience, Working case

主机安全加固导致dp分发客户端失败

2009-06-14 没有评论

今年的315晚会，曝光了某省移动的一些违规操作后，移动集团公司对各地分公司都进行了安全检查。在进行一系列的安全加固操作后，我们发现，还是有部分之前很顺利的操作会受到影响。问题的起因是这样的，某省的备份软件是HP的DP。DP能对数据库进行备份，也能对文件系统进行备份（这样的功能，我想一般的备份软件都 […]

..dba script, Useful script

侦听加密后的停止脚本

2009-06-11 一条评论

在oracle 9i下，如果对于未加密码的侦听，我们只需在在本地配一个listener的地址为远程的IP地址，就能关闭远程的侦听了。因此，为了防止这样的情况，我们往往会对侦听加密。在加密之后的侦听，如果我们配置了HP-SG，且在SG的package中配置了对侦听的监控——当侦听crash时，进行M […]