2015-07-02 – OracleBlog

asm alertlog大量报错Voting file relocation is required in diskgroup

2015-07-02 没有评论

客户将asm的实例配置错了主机，asm1运行在节点2，asm2运行在节点1，在进行de-config和re-config之后，asm的alertlog大量报错： SYMPTOMS:

NOTE: Attempting voting file refresh on diskgroup GRID
NOTE: Voting file relocation is required in diskgroup GRID
NOTE: Attempting voting file relocation on diskgroup GRID
NOTE: Attempting voting file refresh on diskgroup GRID
NOTE: Voting file relocation is required in diskgroup GRID
NOTE: Attempting voting file relocation on diskgroup GRID
NOTE: Attempting voting file refresh on diskgroup GRID

1

2

3

4

5

6

7

NOTE: Attempting voting file refresh on diskgroup GRID

NOTE: Voting file relocation is required in diskgroup GRID

NOTE: Attempting voting file relocation on diskgroup GRID

NOTE: Attempting voting file refresh on diskgroup GRID

NOTE: Voting file relocation is required in diskgroup GRID

NOTE: Attempting voting file relocation on diskgroup GRID

NOTE: Attempting voting file refresh on diskgroup GRID

CAUSE: [crayon-661e0d5418d […]

..experience, Working case

高IO下的library cache lock 和cursor pin S wait on X

2015-07-02 没有评论

今天，客户端某数据库遭遇大量library cache lock 和cursor pin S wait on X的问题，经诊断发现是由于他们底层的ASM存储是多个库共享的，故障时间段别的库占用大量的IO，导致paitsm库的IO响应变慢，db file sequential read从平时的20多毫 […]

..experience, Working case

配置odbc透明网关实现oracle访问postgres DB

2015-07-02 没有评论

最近帮客户配置了一下通过odbc透明网关，实现在oracle内通过db link访问postgres DB。简单记录一下：（1）listener.ora和tnsnames.ora的配置：

[wsj81@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /wsj/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_ORCL =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = pgdb)
      (ORACLE_HOME = /wsj/oracle/app/product/11.2.0/dbhome_1)
      (ENV="LD_LIBRARY_PATH=/usr/lib64:/wsj/oracle/app/product/11.2.0/dbhome_1/lib:usr/local/lib")
      (PROGRAM=dg4odbc)
    )
  )

ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 19.89.64.111)(PORT = 1531))
      )
    )
  ) 


[wsj81@localhost admin]$ 
[wsj81@localhost admin]$ cat  tnsnames.ora
pgdb =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=19.89.64.111)(PORT=1521))
    (CONNECT_DATA=(SID=pgdb))
    (HS=OK)
  )

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

[wsj81@localhost admin]$ cat listener.ora

# listener.ora Network Configuration File: /wsj/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_ORCL =

(SID_LIST =

(SID_DESC =

(SID_NAME = pgdb)

(ORACLE_HOME = /wsj/oracle/app/product/11.2.0/dbhome_1)

(ENV="LD_LIBRARY_PATH=/usr/lib64:/wsj/oracle/app/product/11.2.0/dbhome_1/lib:usr/local/lib")

(PROGRAM=dg4odbc)

)

ORCL =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 19.89.64.111)(PORT = 1531))

)

[wsj81@localhost admin]$

[wsj81@localhost admin]$ cat tnsnames.ora

pgdb =

(DESCRIPTION=

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

(CONNECT_DATA=(SID=pgdb))

(HS=OK)

)

（2）透明网关的配置，这2个文件在$ORA […]