Working case – 第 20 页

写正确了tnsnames文件却tnsping无法ping通

2010-01-06 一条评论

今天遇到个问题比较奇怪，tnsnames.ora明明配置正确，在其中写的IP是10.1.2.40，但是在tnsping中却解析到10.1.2.45：

[oracle@si_adm02 admin]$ cat tnsnames.ora
# TNSNAMES.ORA.SI_WWW01 Network Configuration File: /ora9i/app/oracle/product/9.2.0/network/admin/tnsnames.ora.si_www01
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

dev2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.40)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME =misc1)
    )
  )
[oracle@si_adm02 admin]$

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

[oracle@si_adm02 admin]$ cat tnsnames.ora

# TNSNAMES.ORA.SI_WWW01 Network Configuration File: /ora9i/app/oracle/product/9.2.0/network/admin/tnsnames.ora.si_www01

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

dev2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.40)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME =misc1)

)

[oracle@si_adm02 admin]$

[oracle@si_adm02 admin]$ tnsping dev2

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 06-1Ղ -2010 15:03:15

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/oracle/product/9.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.54)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ora9i)))
OK (0 msec)
[oracle@si_adm02 admin]$

1

2

3

4

5

6

7

8

9

10

11

12

13

14

[oracle@si_adm02 admin]$ tnsping dev2

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 06-1Ղ -2010 15:03:15

Used parameter files:

/oracle/product/9.2.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.54)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ora9i)))

OK (0 msec)

[oracle@si_adm02 admin]$

而且我把tnsna […]

..experience, Working case

legato备份时不执行备份直接写index

2010-01-05 没有评论

今天某省的同事来找，说备份有问题。从log上看备份似乎成功了，但是在legato的界面中看还是一个红叉。于是登录上legato的界面再次测试了备份，发现monitor中日志如下：

01/05/10 16:46:23 nsrd: savegroup info: starting  OracleArch (with 1 client(s))
01/05/10 16:46:42 savegrp: jx_db:/oracle/app/oracle/product/9.2.0/bin/oraclearch will retry 1 more time(s)
01/05/10 16:46:56 savegrp: jx_db:/oracle/app/oracle/product/9.2.0/bin/oraclearch will retry 0 more time(s)
01/05/10 16:46:56 nsrd: media info: suggest mounting 000700L2 on jx_bak01 for writing  to pool 'index'
01/05/10 16:46:56 nsrd: media waiting event: Waiting for 1 writable volumes to backup pool 'index' tape(s) on jx_bak01
01/05/10 16:46:56 nsrd: media info: loading volume 000700L2 into \\.\Tape0
01/05/10 16:47:06 nsrmmd #13: Start nsrmmd #13, with PID 8020, at HOST jx_bak01
01/05/10 16:47:13 nsrd: \\.\Tape0 1:Verify label operation in progress
01/05/10 16:47:34 nsrd: \\.\Tape0 1:Mount operation in progress
01/05/10 16:48:00 nsrd: media event cleared: Waiting for 1 writable volumes to backup pool 'index' tape(s) on jx_bak01
01/05/10 16:48:00 nsrd: jx_bak01:index:jx_db saving to pool 'index' (000700L2)
01/05/10 16:48:01 nsrd: jx_bak01:index:jx_db done saving to pool 'index' (000700L2) 93 KB
01/05/10 16:48:06 nsrd: jx_bak01:bootstrap saving to pool 'index' (000700L2)
01/05/10 16:48:07 nsrmmdbd: media db is saving its data.  This may take a while.
01/05/10 16:48:07 nsrmmdbd: media db is open for business.
01/05/10 16:48:08 nsrd: jx_bak01:bootstrap done saving to pool 'index' (000700L2) 2645 KB
01/05/10 16:48:15 nsrd: savegroup info: Added 'jx_bak01' to the group 'OracleArch' for bootstrap backup.
01/05/10 16:48:15 nsrd: savegroup alert: OracleArch completed, total 2 client(s), 0 Hostname(s) Unresolved, 1 Failed, 1 Succeeded. (jx_db Failed)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

01/05/10 16:46:23 nsrd: savegroup info: starting OracleArch (with 1 client(s))

01/05/10 16:46:42 savegrp: jx_db:/oracle/app/oracle/product/9.2.0/bin/oraclearch will retry 1 more time(s)

01/05/10 16:46:56 savegrp: jx_db:/oracle/app/oracle/product/9.2.0/bin/oraclearch will retry 0 more time(s)

01/05/10 16:46:56 nsrd: media info: suggest mounting 000700L2 on jx_bak01 for writing to pool 'index'

01/05/10 16:46:56 nsrd: media waiting event: Waiting for 1 writable volumes to backup pool 'index' tape(s) on jx_bak01

01/05/10 16:46:56 nsrd: media info: loading volume 000700L2 into \\.\Tape0

01/05/10 16:47:06 nsrmmd #13: Start nsrmmd #13, with PID 8020, at HOST jx_bak01

01/05/10 16:47:13 nsrd: \\.\Tape0 1:Verify label operation in progress

01/05/10 16:47:34 nsrd: \\.\Tape0 1:Mount operation in progress

01/05/10 16:48:00 nsrd: media event cleared: Waiting for 1 writable volumes to backup pool 'index' tape(s) on jx_bak01

01/05/10 16:48:00 nsrd: jx_bak01:index:jx_db saving to pool 'index' (000700L2)

01/05/10 16:48:01 nsrd: jx_bak01:index:jx_db done saving to pool 'index' (000700L2) 93 KB

01/05/10 16:48:06 nsrd: jx_bak01:bootstrap saving to pool 'index' (000700L2)

01/05/10 16:48:07 nsrmmdbd: media db is saving its data. This may take a while.

01/05/10 16:48:07 nsrmmdbd: media db is open for business.

01/05/10 16:48:08 nsrd: jx_bak01:bootstrap done saving to pool 'index' (000700L2) 2645 KB

01/05/10 16:48:15 nsrd: savegroup info: Added 'jx_bak01' to the group 'OracleArch' for bootstrap backup.

01/05/10 16:48:15 nsrd: savegroup alert: OracleArch completed, total 2 client(s), 0 Hostname(s) Unresolved, 1 Failed, 1 Succeeded. (jx_db Failed)

从日志上看，legato的备份在没有进行rman的备份 […]

..experience, Working case

Legato备份还原测试

2010-01-04 没有评论

最近的一段时间，某省的备份出了点问题，legato的备份在还原时检查不到索引，通过scanner扫描之后还是检查不到，问题已经开case提交到emc那边，目前还在处理。为了防止万一，还是对全网用legato备份的省进行了一次还原测试。以下是还原测试中遇到的一些问题小结。目前现网大部分机器都是采用h […]

..experience, Working case

9i不能实现silent安装

2009-12-14 没有评论

今天尝试在一个hp 安腾的机器上安装9202的数据库，并且升级到9206的版本，但是当安装的时候，配置好了response file，还是会有报错：

$ ./runInstaller -silent -responseFile /opt/ora_soft/Disk1/response/IA_custom.rsp
$ Initializing Java Virtual Machine from /tmp/OraInstall2009-12-11_04-43-32PM/jre/bin/java. Please wait...
Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using '211.137.180.5:0.0' as the value of the DISPLAY variable.
        at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
        at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:58)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:53)
        at java.awt.Window.<init>(Window.java:183)
        at java.awt.Frame.<init>(Frame.java:310)
        at java.awt.Frame.<init>(Frame.java:289)
        at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)
        at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)
        at oracle.sysman.oii.oiif.oiifm.OiifmMainFrame.<init>(OiifmMainFrame.java:296)
        at oracle.sysman.oii.oiic.OiicInstaller.<init>(OiicInstaller.java:231)
        at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:599)
$

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

$ ./runInstaller -silent -responseFile /opt/ora_soft/Disk1/response/IA_custom.rsp

$ Initializing Java Virtual Machine from /tmp/OraInstall2009-12-11_04-43-32PM/jre/bin/java. Please wait...

Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using '211.137.180.5:0.0' as the value of the DISPLAY variable.

at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)

at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:58)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:53)

at java.awt.Window.<init>(Window.java:183)

at java.awt.Frame.<init>(Frame.java:310)

at java.awt.Frame.<init>(Frame.java:289)

at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)

at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)

at oracle.sysman.oii.oiif.oiifm.OiifmMainFrame.<init>(OiifmMainFrame.java:296)

at oracle.sysman.oii.oiic.OiicInstaller.<init>(OiicInstaller.java:231)

at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:599)

$

从报错的log中，我们看到，虽然使用搜silent模式安装，但是还是去启动的xser […]

..experience, Working case

rac修改异步IO导致挂死

2009-12-04 3条评论

今天遇到个rac的异步IO的问题，环境是oracle 10201的双节点rac，存储使用ASM，机器是HP 的PA的机器，操作系统是11.23. 在udump下的日志中有大量的报错：

oracle@rp8440a:/oracle/oracle/admin/gzxnh/bdump> cat gzxnh1_ora_19552.trc
/oracle/oracle/admin/gzxnh/bdump/gzxnh1_ora_19552.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /oracle/oracle/product/10.2.0/db_2
System name:    HP-UX
Node name:      rp8440a
Release:        B.11.23
Version:        U
Machine:        9000/800
Instance name: gzxnh1
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 19552, image: oracle@rp8440a

Ioctl ASYNC_CONFIG error, errno = 1

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

oracle@rp8440a:/oracle/oracle/admin/gzxnh/bdump> cat gzxnh1_ora_19552.trc

/oracle/oracle/admin/gzxnh/bdump/gzxnh1_ora_19552.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

ORACLE_HOME = /oracle/oracle/product/10.2.0/db_2

System name: HP-UX

Node name: rp8440a

Release: B.11.23

Version: U

Machine: 9000/800

Instance name: gzxnh1

Redo thread mounted by this instance: 1

Oracle process number: 0

Unix process pid: 19552, image: oracle@rp8440a

Ioctl ASYNC_CONFIG error, errno = 1

看到这个报错，觉得很轻松，之前也遇到过，是orac […]

..experience, Working case

sqlnet文件格式导致侦听无法启动

2009-09-04 4条评论

今天凌晨接到某省的一个电话，数据库进行MC service guard的切换，但是切换过去后，发现侦听无法启动，启动时侦听报错信息为：

oracle@ha_dc02:/oracle/app/oracle/product/9.2.0/network/admin > lsnrctl start

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 04-SEP-2009 01:46:07

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

Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.203.41.11)(PORT=1521)))
TNS-12532: TNS:invalid argument
 TNS-12560: TNS:protocol adapter error
  TNS-00502: Invalid argument


Listener failed to start. See the error message(s) above...

oracle@ha_dc02:/oracle/app/oracle/product/9.2.0/network/admin >

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

oracle@ha_dc02:/oracle/app/oracle/product/9.2.0/network/admin > lsnrctl start

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 04-SEP-2009 01:46:07

Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora

Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.203.41.11)(PORT=1521)))

TNS-12532: TNS:invalid argument

TNS-12560: TNS:protocol adapter error

TNS-00502: Invalid argument

Listener failed to start. See the error message(s) above...

oracle@ha_dc02:/oracle/app/oracle/product/9.2.0/network/admin >

检查配置，网络，都没有问题，浮动IP也是启动在10.203.41.11上，但是侦听就是起不来，检查 […]

..experience, Working case

用crs实现single instance的HA

2009-08-06 6条评论

数据库的高可用方案我们通常采用的是双机热备模式，一个机器跑主机，另一个机器进行standby。当发生故障的时候，故障机上的数据库被切换到备机，在备机上起浮动IP和数据库，对应用来讲是透明的，只是发生了短暂的切换。目前行业中常用的高可用软件如HP的Service Guard、IBM的HACMP，价格都 […]

..experience, Working case

启动lnsr需要写tmp权限

2009-07-29 6条评论

今天凌晨被叫醒起来，某省的数据库db01坏了一个cpu，由于有HA架构的保护，切换到了db02，但是在db02上却无法启动侦听，以下是报错信息：

oracle@gz_dc02:/oracle/app/oracle/admin/gzmisc/bdump > lsnrctl start

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 29-JUL-2009 03:53:16

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

Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.203.104.11)(PORT=1521)))
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.203.104.11)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   HPUX Error: 2: No such file or directory

Listener failed to start. See the error message(s) above...

oracle@gz_dc02:/oracle/app/oracle/admin/gzmisc/bdump >

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

oracle@gz_dc02:/oracle/app/oracle/admin/gzmisc/bdump > lsnrctl start

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 29-JUL-2009 03:53:16

Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora

Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.203.104.11)(PORT=1521)))

Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.203.104.11)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

HPUX Error: 2: No such file or directory

Listener failed to start. See the error message(s) above...

oracle@gz_dc02:/oracle/app/oracle/admin/gzmisc/bdump >

看报错很奇怪：Error listening on: (ADDRESS=(PROTOCO […]

..experience, Working case

设置侦听IP鉴权一段时间后侦听挂死

2009-07-24 一条评论

某省的数据库时不时的发生侦听挂死的现象。我们来看看具体的情况：当出现侦听挂死的时候，sqlplus登录会出现如下报错：

$ sqlplus user/pwd@tnsnames

SQL*Plus: Release 9.2.0.6.0 - Production on Sun Jun 28 11:43:32 2009

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


ERROR:
ORA-12535: TNS:operation timed out
$

1

2

3

4

5

6

7

8

9

10

$ sqlplus user/pwd@tnsnames

SQL*Plus: Release 9.2.0.6.0 - Production on Sun Jun 28 11:43:32 2009

ERROR:

ORA-12535: TNS:operation timed out

$

而此时，可以看到listener.log中的内容为： [crayon-67d8880d809e378279127 […]

..experience, Working case

ntp服务的安装

2009-07-04 3条评论

在rac环境中，会要求几个节点之间的时间差不能超时。一般如果超过30秒，节点很可能会重启。我们需要配置一个ntp时钟服务器，来给rac的各个节点进行时间同步。在这里，我们以windows机器（192.168.1.189）做ntp server，以2台虚拟机上的rac节点（192.168.1.131 […]

..experience, Working case

安腾平台的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 […]