ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Recently our company moved an Oracle 9i db on a Linux Redhat 8.0 box
from one domain to another.
We've always had access to this box via Toad(or any other tool) from
our office or anywhere outside the network when it was on it's
original
domain. Since we moved the box to it's new domain, we have only been
able to see the box from within the physical network itself. No
connections from outside have been successful yet.
We changed the global db_domain to the correct value, and the
listener
to the new instance name (changed the instance name to reflect the
new
domain.)
When we do a tnsping on the box from the outside we get an OK
returned.
When I try to connect through Toad from the outside I get ORA-12514:
TNS: Listener could not resolve Service_Name given in connect
descriptor. I made sure my tnsnames.ora file reflected the new
service
name and host too.
db <-- inside = OK
db <--firewall <-- outside NOT OK
One other thing is that the db instance used to be named something different as you can see commented out below.
If you have any ideas or suggestions they would be much appr**eciated.
# LISTENER.ORA Network Configuration File:/usr/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = rocky.ROCKY)
(ORACLE_HOME = /usr/oracle)
(SID_NAME = rocky)
)
)
# SQLNET.ORA Network Configuration File: /usr/oracle/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = admissions.mvk.edu
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# TNSNAMES.ORA Network Configuration File: /usr/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
#ROCKY.ROCKY =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SID = rocky)
# )
# )
ROCKY.ADMISSIONS.MVK.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
)
(CONNECT DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rocky.rocky)
)
)
#OEMREP.RESEARCH.MVK.EDU =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = OEMREP.research)
# )
# )
EXTPROC_CONNECTION_DATA.ADMISSIONS.MVK.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
INST1_HTTP.ROCKY.ADMISSIONS.MVK.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
