ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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
db
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.