OracleBlog – 第 31 页 – 笑看数据库江湖的那些事儿……

操作系统内核参数限制导致ora-4030

2010-02-28 一条评论

最近同事遇到一个问题，某个报表程序报错ora-4030的错误：

错误信息：[Error] **** Dbupdate.sqlUpdateSubs Function:begin ? := trt_subs_1_i_update_target (?, ?, ?, ?, ?); end;, Execute GD:1li run finished with error, errcode:-4030,errmsg:ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pmucalm coll),errlog:GD_1li TableA_S.(SCS or ADS) Update TableP_S, circle= 2.

1

错误信息：[Error] **** Dbupdate.sqlUpdateSubs Function:begin ? := trt_subs_1_i_update_target (?, ?, ?, ?, ?); end;, Execute GD:1li run finished with error, errcode:-4030,errmsg:ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pmucalm coll),errlog:GD_1li TableA_S.(SCS or ADS) Update TableP_S, circle= 2.

通过trace，发现是以下语句的问题：

declare
  type subs_mobile_no_arr is table of trt_subs_GD_1li_wap_S.subs_mobile_no%type index by pls_integer;
  type icp_id_arr is table of trt_subs_GD_1li_wap_S.icp_id%type index by pls_integer;
  type icp_code_arr is table of trt_subs_GD_1li_wap_S.icp_code%type index by pls_integer;
  type channel_id_arr is table of trt_subs_GD_1li_wap_S.channel_id%type index by pls_integer;
  type serv_id_arr is table of trt_subs_GD_1li_wap_S.serv_id%type index by pls_integer;
  type brand_id_arr is table of trt_subs_GD_1li_wap_S.brand_id%type index by pls_integer;
  type fee_mobile_no_arr is table of trt_subs_GD_1li_wap_S.fee_mobile_no%type index by pls_integer;
  type action_id_arr is table of trt_subs_GD_1li_wap_S.action_id%type index by pls_integer;
  type crt_his_date_arr is table of trt_subs_GD_1li_wap_S.crt_his_date%type index by pls_integer;
  type city_id_arr is table of trt_subs_GD_1li_wap_S.city_id%type index by pls_integer;
  type attr_arr is table of trt_subs_GD_1li_wap_S.attr%type index by pls_integer;
  type srh_channel_id_arr is table of trt_subs_GD_1li_wap_S.srh_channel_id%type index by pls_integer;
  arr_subs_mobile_no subs_mobile_no_arr;
  arr_icp_id         icp_id_arr;
  arr_icp_code       icp_code_arr;
  arr_channel_id     channel_id_arr;
  arr_serv_id        serv_id_arr;
  arr_brand_id       brand_id_arr;
  arr_fee_mobile_no  fee_mobile_no_arr;
  arr_action_id      action_id_arr;
  arr_crt_his_date   crt_his_date_arr;
  arr_city_id        city_id_arr;
  arr_attr           attr_arr;
  arr_srh_channel_id srh_channel_id_arr;
begin
  select subs_mobile_no,
         icp_id,
         icp_code,
         channel_id,
         serv_id,
         brand_id,
         fee_mobile_no,
         decode(action_id, 'SCS', 'C', 'ADS', 'D') action_id,
         crt_his_date,
         city_id,
         attr,
         srh_channel_id bulk collect
    into arr_subs_mobile_no,
         arr_icp_id,
         arr_icp_code,
         arr_channel_id,
         arr_serv_id,
         arr_brand_id,
         arr_fee_mobile_no,
         arr_action_id,
         arr_crt_his_date,
         arr_city_id,
         arr_attr,
         arr_srh_channel_id
    from trt_subs_GD_1li_wap_S
   where action_id = 'SCS'
      or action_id = 'ADS';
  if arr_subs_mobile_no.last > 0 then
    arr_srh_channel_id srh_channel_id_arr;
    begin
      select subs_mobile_no,
             icp_id,
             icp_code,
             channel_id,
             serv_id,
             brand_id,
             fee_mobile_no,
             decode(action_id, 'SCS', 'C', 'ADS', 'D') action_id,
             crt_his_date,
             city_id,
             attr,
             srh_channel_id bulk collect
        into arr_subs_mobile_no,
             arr_icp_id,
             arr_icp_code,
             arr_channel_id,
             arr_serv_id,
             arr_brand_id,
             arr_fee_mobile_no,
             arr_action_id,
             arr_crt_his_date,
             arr_city_id,
             arr_attr,
             arr_srh_channel_id
        from trt_subs_GD_1li_wap_S
       where action_id = 'SCS'
          or action_id = 'ADS';
      if arr_subs_mobile_no.last > 0 then
        forall i in arr_subs_mobile_no.first .. arr_subs_mobile_no.last
          update f_wap_subs_GD_p_s c
             set c.city_id                = arr_city_id(i),
                 c.icp_id                 = arr_icp_id(i),
                 c.icp_code               = arr_icp_code(i),
                 c.subs_cancel_channel_id = arr_channel_id(i),
                 c.brand_id               = arr_brand_id(i),
                 c.subs_status_id         = arr_action_id(i),
                 c.fee_mobile_no          = arr_fee_mobile_no(i),
                 c.usubs_date             = arr_crt_his_date(i),
                 c.usubs_day              = to_char(arr_crt_his_date(i),
                                                    'YYYYMMDD'),
                 c.idx_day                = to_char(arr_crt_his_date(i),
                                                    'YYYYMMDD'),
                 c.is_subs_valid          = 0,
                 c.flow_time              = sysdate,
                 c.srh_channel_id         = arr_srh_channel_id(i)
           where subs_mobile_no = arr_subs_mobile_no(i)
             and serv_id = arr_serv_id(i)
             and is_subs_valid = 1;
      end if;
    end;

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

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

declare

type subs_mobile_no_arr is table of trt_subs_GD_1li_wap_S.subs_mobile_no%type index by pls_integer;

type icp_id_arr is table of trt_subs_GD_1li_wap_S.icp_id%type index by pls_integer;

type icp_code_arr is table of trt_subs_GD_1li_wap_S.icp_code%type index by pls_integer;

type channel_id_arr is table of trt_subs_GD_1li_wap_S.channel_id%type index by pls_integer;

type serv_id_arr is table of trt_subs_GD_1li_wap_S.serv_id%type index by pls_integer;

type brand_id_arr is table of trt_subs_GD_1li_wap_S.brand_id%type index by pls_integer;

type fee_mobile_no_arr is table of trt_subs_GD_1li_wap_S.fee_mobile_no%type index by pls_integer;

type action_id_arr is table of trt_subs_GD_1li_wap_S.action_id%type index by pls_integer;

type crt_his_date_arr is table of trt_subs_GD_1li_wap_S.crt_his_date%type index by pls_integer;

type city_id_arr is table of trt_subs_GD_1li_wap_S.city_id%type index by pls_integer;

type attr_arr is table of trt_subs_GD_1li_wap_S.attr%type index by pls_integer;

type srh_channel_id_arr is table of trt_subs_GD_1li_wap_S.srh_channel_id%type index by pls_integer;

arr_subs_mobile_no subs_mobile_no_arr;

arr_icp_id icp_id_arr;

arr_icp_code icp_code_arr;

arr_channel_id channel_id_arr;

arr_serv_id serv_id_arr;

arr_brand_id brand_id_arr;

arr_fee_mobile_no fee_mobile_no_arr;

arr_action_id action_id_arr;

arr_crt_his_date crt_his_date_arr;

arr_city_id city_id_arr;

arr_attr attr_arr;

arr_srh_channel_id srh_channel_id_arr;

begin

select subs_mobile_no,

icp_id,

icp_code,

channel_id,

serv_id,

brand_id,

fee_mobile_no,

decode(action_id, 'SCS', 'C', 'ADS', 'D') action_id,

crt_his_date,

city_id,

attr,

srh_channel_id bulk collect

into arr_subs_mobile_no,

arr_icp_id,

arr_icp_code,

arr_channel_id,

arr_serv_id,

arr_brand_id,

arr_fee_mobile_no,

arr_action_id,

arr_crt_his_date,

arr_city_id,

arr_attr,

arr_srh_channel_id

from trt_subs_GD_1li_wap_S

where action_id = 'SCS'

or action_id = 'ADS';

if arr_subs_mobile_no.last > 0 then

arr_srh_channel_id srh_channel_id_arr;

begin

select subs_mobile_no,

icp_id,

icp_code,

channel_id,

serv_id,

brand_id,

fee_mobile_no,

decode(action_id, 'SCS', 'C', 'ADS', 'D') action_id,

crt_his_date,

city_id,

attr,

srh_channel_id bulk collect

into arr_subs_mobile_no,

arr_icp_id,

arr_icp_code,

arr_channel_id,

arr_serv_id,

arr_brand_id,

arr_fee_mobile_no,

arr_action_id,

arr_crt_his_date,

arr_city_id,

arr_attr,

arr_srh_channel_id

from trt_subs_GD_1li_wap_S

where action_id = 'SCS'

or action_id = 'ADS';

if arr_subs_mobile_no.last > 0 then

forall i in arr_subs_mobile_no.first .. arr_subs_mobile_no.last

update f_wap_subs_GD_p_s c

set c.city_id = arr_city_id(i),

c.icp_id = arr_icp_id(i),

c.icp_code = arr_icp_code(i),

c.subs_cancel_channel_id = arr_channel_id(i),

c.brand_id = arr_brand_id(i),

c.subs_status_id = arr_action_id(i),

c.fee_mobile_no = arr_fee_mobile_no(i),

c.usubs_date = arr_crt_his_date(i),

c.usubs_day = to_char(arr_crt_his_date(i),

'YYYYMMDD'),

c.idx_day = to_char(arr_crt_his_date(i),

'YYYYMMDD'),

c.is_subs_valid = 0,

c.flow_time = sysdate,

c.srh_channel_id = arr_srh_channel_id(i)

where subs_mobile_no = arr_subs_mobile_no(i)

and serv_id = arr_serv_id(i)

and is_subs_valid = 1;

end if;

end;

这个sql在执行的时候，pga的内存被迅速的消耗，通过v$ses […]

..experience, Working case

新版本的opatch使用lsinventory报错

2010-01-25 没有评论

今天在给一个省打一个9208侦听内存泄漏的patch，打的时候，没有报错，但是在opatch lsinventory的时候，却报错了：

oracle@tj_dc01:/oracle/app/oracle/product/9.2.0 > opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.63
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /oracle/app/oracle/product/9.2.0
Oracle Home Inventory : /oracle/app/oracle/oraInventory
Central Inventory     : /oracle/app/oracle/oraInventory
   from               : /var/opt/oracle/oraInst.loc
OUI location          : /oracle/app/oracle/oui
OUI shared library    : /oracle/app/oracle/oui/bin/hpunix/liboraInstaller.so
Java location         : /oracle/app/oracle/jre/1.3.1/bin/java
Log file location     : /oracle/app/oracle/product/9.2.0/.patch_storage/<patch ID>/*.log

Creating log file "/oracle/app/oracle/product/9.2.0/.patch_storage/LsInventory__01-25-2010_16-25-28.log"

Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/transform/Source
        at opatch.LsInventory.getOneOffList(LsInventory.java:675)
        at opatch.LsInventory.main(LsInventory.java:247)
Result: 


There is no Interim Patch




OPatch succeeded.

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

29

30

31

32

33

34

oracle@tj_dc01:/oracle/app/oracle/product/9.2.0 > opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.63

Oracle recommends you to use the latest OPatch version

and read the OPatch documentation available in the OPatch/docs

directory for usage. For information about the latest OPatch and

other support-related issues, refer to document ID 293369.1

available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /oracle/app/oracle/product/9.2.0

Oracle Home Inventory : /oracle/app/oracle/oraInventory

Central Inventory : /oracle/app/oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OUI location : /oracle/app/oracle/oui

OUI shared library : /oracle/app/oracle/oui/bin/hpunix/liboraInstaller.so

Java location : /oracle/app/oracle/jre/1.3.1/bin/java

Log file location : /oracle/app/oracle/product/9.2.0/.patch_storage/<patch ID>/*.log

Creating log file "/oracle/app/oracle/product/9.2.0/.patch_storage/LsInventory__01-25-2010_16-25-28.log"

Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/transform/Source

at opatch.LsInventory.getOneOffList(LsInventory.java:675)

at opatch.LsInventory.main(LsInventory.java:247)

Result:

There is no Interim Patch

OPatch succeeded.

这个opatch是从metalink上下载的最新的opatch，而且也是对应了HP IA的os平台 […]

..experience, Working case

在hp pa 11.23上安装9206patch

2010-01-17 4条评论

hp pa算是一个比较老版本的hpux操作系统，目前hp已经不出hp pa的版本，只出hp ia的版本。目前ia的os版本为11.23和11.31，在之前的hp pa的主要os版本是11.00和11.11。这次在某省安装的机器比较奇怪，是hp pa的机器，却是安装11.23的操作系统版本。在正常安 […]

Study note

修改vmware rac的IP网段

2010-01-17 没有评论

之前在vmware上搭了一个rac，在配置rac的时候，由于当时的电脑是接在路由器上的，因此将public和vip配置在了需要连接路由器的IP上，用的是bridge的连接方式。但是也造成了一个不便，就是在没有连接路由的情况下，public和vip无法连接，因此我希望用host only而不是brid […]

..experience, Working case

写正确了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 […]

Study note

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