ITPub博客

首页 > 数据库 > Oracle > oracle客户端同sap冲突的问题

oracle客户端同sap冲突的问题

原创 Oracle 作者:trigger_lau 时间:2010-04-17 22:11:00 0 删除 编辑

本机装了两套ECC6,分别为IDES和标准版,自从装了oracle的客户端以后,ides系统就不能正常使用了,查找原因是连接oracle的ides数据库时报ora 12154的错误。

删除以后重新调整配置,搞定。

[@more@]

# listener.ora Network Configuration File: G:oracleERP102networkadminlistener.ora
# Generated by Oracle configuration tools.

################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ER1)
(ORACLE_HOME = G:oracleERP102)
)

(SID_DESC =
(SID_NAME = ID1)
(ORACLE_HOME = G:oracleERP102)
)
)

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = trigger)(PORT = 1527))
)
)

################
# Filename......: sqlnet.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
NAMES.DEFAULT_DOMAIN = WORLD
# 05.01.06 unsorported parameter now
#NAME.DEFAULT_ZONE = WORLD
# 05.01.06 set the default to 10
SQLNET.EXPIRE_TIME = 10
SQLNET.AUTHENTICATION_SERVICES = (NTS)
# 05.01.06 set to default
#TCP.NODELAY=YES
# 05.01.06 set to 32768
DEFAULT_SDU_SIZE=32768

################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
ER1.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = trigger)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = ER1)
(GLOBAL_NAME = ER1.WORLD)
)
)

ID1.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = trigger)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = ID1)
(GLOBAL_NAME = ID1.WORLD)
)
)

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

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

注册时间:2008-03-13

  • 博文量
    192
  • 访问量
    1412683