【DataGuard】传递归档日志是遇到ORA-12514

查看dataguard 备库报警日志的时候发现有ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 错误~！

错误的意思是listener 不知道连接解析器中的请求服务，这里要说静态监听和动态监听了。

动态注册是在instance启动的时候PMON进程根据init.ora中的instance_name,service_names两个参数将实例和服务动态注册到listener中。

静态注册就是实例启动时读取listener.ora文件的配置，将实例和服务注册到监听程序。无论何时启动一个数据库，默认地都有两条信息注册到监听器中：数据库服务器对应的实例和服务。

搭建dataguard过程中，先启动的数据库，没有在listener.ora 中设置静态监听。重新设置后。

# listener.ora Network Configuration File: /opt/oracle/10.2.0/orcl/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = orclpdg)

      (ORACLE_HOME = /opt/oracle/10.2.0/orcl)

    )

 --增加如下内容

    (SID_DESC =  

      (SID_NAME  = PLSExtProc)   

      (ORACLE_HOME = /opt/oracle/10.2.0/orcl)          

      (PROGRAM   =  extproc) 

    )   

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.250.7.230 )(PORT = 1521))

    )

  )                                                                                                                                               

"listener.ora" 24L, 609C 已写入                                                

oracle@yangDB2:/opt/oracle/10.2.0/orcl/network/admin>lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-AUG-2011 09:50:13

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                24-AUG-2011 21:13:15

Uptime                    0 days 12 hr. 37 min. 2 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /opt/oracle/10.2.0/orcl/network/admin/listener.ora

Listener Log File         /opt/oracle/10.2.0/orcl/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.230)(PORT=1521)))

Services Summary...

Service "orclpdg" has 1 instance(s).

  Instance "orclpdg", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> reload

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

The command completed successfully

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                24-AUG-2011 21:13:15

Uptime                    0 days 12 hr. 37 min. 12 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /opt/oracle/10.2.0/orcl/network/admin/listener.ora

Listener Log File         /opt/oracle/10.2.0/orcl/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.230)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "orclpdg" has 1 instance(s).

  Instance "orclpdg", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> exit

再次查看告警日志文件

oracle@yangDB2:/opt/oracle/std_arch>tf

Fetching gap sequence in thread 1, gap sequence 46-46

FAL[client, MRP0]: Error 12514 connecting to orcl for fetching gap sequence

Thu Aug 25 09:24:32 2011

Errors in file /opt/oracle/admin/orcl/bdump/orclpdg_mrp0_10763.trc:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor --修改之前的

Thu Aug 25 09:24:57 2011

RFS[1]: Archived Log: '/opt/oracle/std_arch/log1_46_758478551.arc'

Thu Aug 25 09:25:02 2011

Media Recovery Log /opt/oracle/std_arch/log1_46_758478551.arc

Media Recovery Waiting for thread 1 sequence 47 (in transit)

Thu Aug 25 09:51:15 2011

Primary database is in MAXIMUM PERFORMANCE mode

RFS[2]: Successfully opened standby log 4: '/opt/oracle/oradata/orclpdg/redo04.log'

Thu Aug 25 09:51:18 2011

Media Recovery Log /opt/oracle/std_arch/log1_47_758478551.arc

Media Recovery Waiting for thread 1 sequence 48 (in transit)

Thu Aug 25 10:02:08 2011

Primary database is in MAXIMUM PERFORMANCE mode

RFS[2]: Successfully opened standby log 5: '/opt/oracle/oradata/orclpdg/redo05.log'

Thu Aug 25 10:02:08 2011

没有 ORA-12514报错了！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-706047/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22664653/viewspace-706047/