Welcome to vcdog's blog vcdog.blog.chinaunix.net

白天和黑夜只交替没交换无法想像对方的世界。。。

  • 博客访问: 1225194
  • 博文数量: 222
  • 博客积分: 4378
  • 博客等级: 上校
  • 技术积分: 4043
  • 用 户 组: 普通用户
  • 注册时间: 2007-09-09 11:37
个人简介

白天和黑夜只交替没交换无法想像对方的世界

文章分类

全部博文(222)

文章存档

2014年(3)

2013年(32)

2012年(20)

2011年(113)

2010年(18)

2009年(6)

2008年(25)

2007年(5)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

分类: Oracle

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

配置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

阅读(14218) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册