Unanswered: 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
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
to the new instance name (changed the instance name to reflect the
When we do a tnsping on the box from the outside we get an OK
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
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.