2009年12月 – OracleBlog

OCM考试-listener

2009-12-15 3条评论

启动侦听：

cp一个sample中的listener.ora
去掉以下行的注释：
 LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
这样可以通过动态注册侦听实现service的注册（启动侦听后大约1分钟）。

如果要实现的时候静态注册，建议稍作修改：
LISTENER =
 (ADDRESS_LIST=
   (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
  )

SID_LIST_LISTENER=
    (SID_LIST=
      (SID_DESC=
        (SID_NAME=ocmdb) 
        (ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1)
       )
     )

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

cp一个sample中的listener.ora

去掉以下行的注释：

LISTENER =

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))

(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

这样可以通过动态注册侦听实现service的注册（启动侦听后大约1分钟）。

如果要实现的时候静态注册，建议稍作修改：

LISTENER =

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))

)

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME=ocmdb)

(ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1)

)

这里需要注意的是SID_LIST_LISTENER部分，里面可能还有空格之类的东西，把该行前面的空格删除，再整理下格式，就可以了。如果遇到以下报错：

[oracle@ocmdb1 admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 20-NOV-2009 19:15:13

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

Starting /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
   Linux Error: 29: Illegal seek

1

2

3

4

5

6

7

8

9

10

11

12

[oracle@ocmdb1 admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 20-NOV-2009 19:15:13

Starting /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

检查 […]

..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 […]

Study note

NBU培训杂记

2009-12-11 没有评论

以下这段文字比较乱了，是参加nbu培训时候记的，没有条理，仅作为个人学习笔记了。 nbu component: master server media server san media server emm server-是一个sybase的数据库。 client nom server -用于展示报 […]

..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 […]