| Weird ora-12154 TNS:could not resolve service name [message #367820] |
Thu, 14 September 2000 11:35  |
Brett Mayer
Messages: 2
Registered: September 2000
|
Junior Member |
|
|
I get this only when I load the svrmgr30. ora-12154 TNS:could not resolve service name, but I can TNS ping all 4 of my instances and set instance to them all and all seem to work. where is this coming from? is this a IPC problem so I think I can assume that my TCP settings are ok. I also assume that IPC which has a listner heat_lsnr and an alias with the key heat_lsnr which points to the instance heat, that these are correct? any help is greatly appreciated..
HEAT-IPC.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = ipc.world)
(PROTOCOL = IPC)
(KEY = HEAT_LSNR)
)
)
(CONNECT_DATA =
(SID = HEAT)
)
)
TEST-IPC.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = ipc.world)
(PROTOCOL = IPC)
(KEY = TEST_LSNR)
)
)
(CONNECT_DATA =
(SID = TEST)
)
)
RMIW-IPC.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = ipc.world)
(PROTOCOL = IPC)
(KEY = RMIW_LSNR)
)
)
(CONNECT_DATA =
(SID = RMIW)
)
)
TEST.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1526)
)
)
(CONNECT_DATA =
(SID = TEST)
)
)
ORCL.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1526)
)
)
(CONNECT_DATA =
(SID = ORCL)
)
)
HEAT.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1526)
)
)
(CONNECT_DATA =
(SID = HEAT)
)
)
RMIW.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.1.14)
(Port = 1526)
)
)
(CONNECT_DATA =
(SID = RMIW)
)
)
ORCL-IPC.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = ipc.world)
(PROTOCOL = IPC)
(KEY = ORCL_LSNR)
)
)
(CONNECT_DATA =
(SID = ORCL)
)
)
#EZCFG_VER=1.1.0.0.0
#This is a Net8 Configuration file generated by Net8 Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your Net8 Easy Configuration may not function properly.
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = HEAT_LSNR)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = TEST_LSNR)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = RMIW_LSNR)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = ORCL_LSNR)
)
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.1.1.14)
(PORT = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TEST)
(ORACLE_HOME = ORACLE8:ORANW803)
)
(SID_DESC =
(SID_NAME = HEAT)
(ORACLE_HOME = ORACLE8:ORANW803)
)
(SID_DESC =
(SID_NAME = RMIW)
(ORACLE_HOME = ORACLE8:ORANW803)
)
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = ORACLE8:ORANW803)
)
)
#EZCFG_VER=1.1.0.0.0
#
# $Header: sqlnet.ora 1.2 95/08/14 17:10:47 llarsh Osd<desktop/netware> $ Copyr (c) 1995 Oracle
#
AUTOMATIC_IPC = OFF
sqlnet.expire_time = 0
TRACE_LEVEL_CLIENT = OFF
TRACE_LEVEL_SERVER = OFF
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
#
# To use Oracle Names when makeing outbound or loopback connections from
# this server, add ONAMES to the NAMES.DIRECTORY_PATH below
#
NAMES.DIRECTORY_PATH = (TNSNAMES,NOVELL)
SQLNET.AUTHENTICATION_SERVICES = (NDS)
#EZCFG_VER=1.1.0.0.0
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
