Hi All,
While connecting from BW server to Portal database server via RSA1, am getting the below error
"Database error 12154 at CON
ORA -12154:TNS :could not resolve the connect identifier
Initialization DB connect failed,Return code 000256"
Kindly provide me a solution to this issue.
Below is the list of tnsnames and listener files.
more tnsnames.ora
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/640-2_COR/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
XXX.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST =abcdefgsh)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = XXX)
(GLOBAL_NAME = XXX.WORLD)
)
)
EPDBW.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = 10.143.1.xxx) ------>This is Portal dev server ip
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = N01)
(GLOBAL_NAME = EPDBW.WORLD)
)
)
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
more listener.ora
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/640-2_COR/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = XXX.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = XXX)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = alllssssk)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = XXX)
(ORACLE_HOME = /oracle/XXX/112_64)
)
)
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.