ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12514: TNS:listener does not currently know of service requested in co

ORA-12514: TNS:listener does not currently know of service requested in co

原创 Linux操作系统 作者:vcdog 时间:2011-08-26 12:51:32 0 删除 编辑

配置data guard网络监听的时候,连接测试报错如下:

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

出错原因是由于,在修改init$ORACLE_SID.ora文件时,在主库里面新添加了一项db_unique_name=10gpri;

备库上新添加一项db_unique_name=10gstandby.

在配置监听文件和客户端tnsnames.ora时,就要修改GLOBAL_DBNAME 成相应的10gpri或10standby.

[oracle@dg01 admin]$ cat listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.30)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1 )
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = 10gpri)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
      (SID_NAME = dg01)
    )
  )

[oracle@dg01 admin]$ cat tnsnames.ora

10gpri=
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.30)(PORT = 1521))
    (CONNECT_DATA =
        (server=dedicated)
        (service_name = 10gpri)
    )
  )

10gstandby=
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.31)(PORT = 1521))
    (CONNECT_DATA =
        (server=dedicated)
        (service_name = 10gstandby)
    )
  )

在两个节点上测试如下:

节点dg01:

[oracle@dg01 dbs]$ sqlplus scott/tiger@10gstandby

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SCOTT_S:138_P:28085_10gstandby> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      dg01
db_unique_name                       string      10gstandby
global_names                         boolean     FALSE
instance_name                        string      dg01
lock_name_space                      string
log_file_name_convert                string
service_names                        string      10gstandby

节点dg02:

[oracle@dg02 dbs]$ sqlplus scott/tiger@10gpri

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SCOTT_S:145_P:22710_10gpri> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      dg01
db_unique_name                       string      10gpri
global_names                         boolean     FALSE
instance_name                        string      dg01
lock_name_space                      string
log_file_name_convert                string
service_names                        string      10gpri

作者:my_zoner 发表于2011-8-24 15:57:24 原文链接
阅读:11 评论:0 查看评论


Link URL: http://blog.csdn.net/my_zoner/article/details/6715326

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

请登录后发表评论 登录
全部评论

注册时间:2011-08-21

  • 博文量
    28
  • 访问量
    33771