2009年 – 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 […]

Study note

OCM考试-Create the database

2009-11-25 9条评论

登录机器后，先检查电源是否插牢鼠标键盘是否没问题 oralce用户的环境变量：ORACLE_BASE，ORACLE_HOME，ORACLE_SID， oracle 10g的软件是否已经安装联机文档是否能读取我们假设奇数机（ODD）的主机名叫ocmdb1，偶数机（EVEN）的主机名叫ocmdb […]

Study note

OCM考试-培训和考试费用

2009-11-11 2条评论

ocm至少需要参加2门的培训，在中国，可以在广州、北京和上海参加oracle大学的原厂培训，中国OU开设的OCM的培训课程为：

Oracle Database 10g: RAC for Administrators	 5 Days
Oracle Database 10g: Performance Tuning	 4 Days
Oracle Database 10g: OCM Exam Preparation	 4 Days
Oracle Database 10g: SQL Tuning Workshop	 3 Days
Oracle Database 10g: Data Guard Administration	 3 Days
Oracle Enterprise Manager 10g Grid Control 	 5 Days
Oracle Database 10g: Backup and Recovery	 3 Days
Oracle Database 10g: New Features for Administrators	 5 Days
Oracle Database 10g: New Features for Oracle8i DBAs	 5 Days
Oracle Database 10g: Program with PL/SQL 	 5 Days
Oracle Database 10g: Advanced PL/SQL 	 2 Days
Oracle Database 10g: Security 	 3 Days
Oracle Database 10g: Implement Streams	 5 Days
Oracle Database 10g: Implement and Administer Data Warehouse	 4 Days

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Oracle Database 10g: RAC for Administrators 5 Days

Oracle Database 10g: Performance Tuning 4 Days

Oracle Database 10g: OCM Exam Preparation 4 Days

Oracle Database 10g: SQL Tuning Workshop 3 Days

Oracle Database 10g: Data Guard Administration 3 Days

Oracle Enterprise Manager 10g Grid Control 5 Days

Oracle Database 10g: Backup and Recovery 3 Days

Oracle Database 10g: New Features for Administrators 5 Days

Oracle Database 10g: New Features for Oracle8i DBAs 5 Days

Oracle Database 10g: Program with PL/SQL 5 Days

Oracle Database 10g: Advanced PL/SQL 2 Days

Oracle Database 10g: Security 3 Days

Oracle Database 10g: Implement Streams 5 Days

Oracle Database 10g: Implement and Administer Data Warehouse 4 Days

目前的最近的几个月的安排如下： 2009年11月： Oracle北京培训中心 DBA Oracle Dat […]

Study note

OCM 考试概述

2009-11-09 3条评论

驾照考完了，接下来的一段时间，是该静下来学习一下ocm的相关知识，为ocm考试准备了。在这里，我会记录下准备ocm考试的相关知识，和大家一起分享。考试科目：10G OCM（其他各个科目如9i，11g的oca，ocp，ocm等考试计划，可参见这里）考试价格：RMB:7720/人考试时间：2天，早 […]

Study note

RAC ONE NODE

2009-10-29 6条评论

之前，一直对rac one node、Single Instance HA(SIHA)、Oracle Restart的概念没搞清楚，今天和 @jarodwang和@ricky_zhu聊了之后，才明白了其中的概念： SIHA = Oracle Restart = Oracle Grid Infrast […]

Study note

oracle 11g R2 新特性学习

2009-10-10 4条评论

oracle 11g R2的新特性，简单说明如下：一、新的Grid架构安装选项新的Grid架构包含了ASM、侦听和Oracle重启（Oracle Restart）。——值得一提的是oracle重启这个特性，他类似像HP service guard，能提供数据库实例、asm、侦听的监控、管理和自 […]

Study note, Useful script

DSI 之lock学习

2009-09-15 没有评论

锁的申请： 1.使用hash算法将资源做hash，做完hash得到一个结果值将对应一个hash bucket 2.申请enqueue hash chain以访问hash bucket。 3.此时，将资源放到hash bucket的hash chain上。如果在hash chain上没有找到对应的资源 […]

..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上，但是侦听就是起不来，检查 […]

Study note

DML LOCK兼容性表的一个比喻

2009-08-19 没有评论

今天看到ZALBB和jeffli73讨论的文章《oracle多粒度封锁机制研究》，觉得比喻的很有意思，不过jeffli73在坛子上只是比喻了单粒度的封锁机制，没继续比喻多粒度的封锁，这里，我狗尾续貂，按照jeffli73的意思也打个比方吧。一个艺术中心占地很广（我们把它类比做数据库），有许多独立的 […]