-
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)
)
)
-
Client Files
# SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = admissionpros.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ROCKY.ADMISSIONPROS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rocky.rocky)
)
)
-
change the default domain and the service name, they point to .com not to the new one
-
I did change this and yet I get the same results.
-
-
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ADMISSIONPROS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rocky.rocky)
)
)
# SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = admissionpros.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-
look at your tnsnames file now, you took the work rocky out.
also your service is rocky.rocky - is that correct?
-
ok, maybe im confused by your instructions then. You said
change the default domain and the service name, they point to .com not to the new one
So, I removed ROCKY from ROCKY.ADMISSIONPROS.COM in the client tnsnames.ora to match the default domain in sqlnet.ora. Yes rocky.rocky is correct.
-
in the server tnsnames.ora you have
ROCKY.ADMISSIONS.MVK.EDU
and sqlnet.ora
NAMES.DEFAULT_DOMAIN = admissions.mvk.edu
in the client you had tnsnames.ora
ROCKY.ADMISSIONPROS.COM
and sqlnet.ora
NAMES.DEFAULT_DOMAIN = admissionpros.com
See they don't match up.
Change the client to be ROCKY.ADMISSIONS.MVK.EDU and NAMES.DEFAULT_DOMAIN = admissions.mvk.edu
(or just copy the entry from the server)
-
# SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = ADMISSIONS.MVC.EDU
# i tried both above and below
# NAMES.DEFAULT_DOMAIN = ROCKY.ADMISSIONS.MVC.EDU
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ROCKY.ADMISSIONS.MVC.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rocky.rocky)
)
)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|