oracle客戶端同sap衝突的問題

本機裝了兩套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)
)
)