listener.ora – Adamhuan's Data Center – 【逻辑驱动数据】

Oracle database：ORA-12528: TNS:listener: all appropriate instances are blocking new connections

如题所示的错误，发生在一个DG的环境中。
目前出问题的环境已经修复好了。

接下来本文的内容为在自己的环境中的重演。

下面开始。
——————————————————————

在DG的配置中，DG的备库端，首先是需要进入nomount阶段，然后执行一些操作的。
但是在备库端启动[……]

Install Oracle database 11g on SLES 11 （SUSE Enterprise Linux 11 64bit SP4）

关于安装Oracle数据库，可以参考官方的文档：
http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCGGJAB

本文为我在自己的环境中的搭建过程。

————————————————————————[……]

10g RAC：listener.ora

一样的配置文件罗列，这次是针对Oracle 10g RAC环境的监听器配置文件：$ORACLE_HOME/network/admin/listener.ora。

[oracle@node1 admin]$ ll
total 16
-rw-r--r-- 1 oracle oinstall  575 Sep  5 20:11 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Sep  5 19:27 samples
-rw-r--r-- 1 oracle oinstall  172 Dec 26  2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 1226 Sep  5 20:47 tnsnames.ora
[oracle@node1 admin]$ cat listener.ora 
# listener.ora.zymis1 Network Configuration File: /u01/app/oracle/product/10/dbhome_1/network/admin/listener.ora.zymis1
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_NODE1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10/dbhome_1)
      (PROGRAM = extproc)
    )
  )

LISTENER_NODE1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)(IP = FIRST))
    )
  )

[oracle@node1 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

25

26

27

28

[oracle@node1 admin]$ ll

total 16

-rw-r--r-- 1 oracle oinstall 575 Sep 5 20:11 listener.ora

drwxr-x--- 2 oracle oinstall 4096 Sep 5 19:27 samples

-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst

-rw-r--r-- 1 oracle oinstall 1226 Sep 5 20:47 tnsnames.ora

[oracle@node1 admin]$ cat listener.ora

# listener.ora.zymis1 Network Configuration File: /u01/app/oracle/product/10/dbhome_1/network/admin/listener.ora.zymis1

# Generated by Oracle configuration tools.

SID_LIST_LISTENER_NODE1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/10/dbhome_1)

(PROGRAM = extproc)

)

LISTENER_NODE1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)(IP = FIRST))

(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)(IP = FIRST))

)

[oracle@node1 admin]$

——————————————————————————————
En[……]