Hi there,

I have a small test database on my laptop, which I connect to through a local TNSNAMES.ORA file and LISTENER.ORA file.

When I am connected to the network I can access this (and all the other) database fine, however when I disconnect from the network and try to connect to the local test database I get the following error.

"ORA-12230:Unable to connect to destination"

I suspect it's something to do with my settings in the TNSNAMES file but I can't see what.

It's an Oracle7.3.3 database on NT4 laptop.

This is the part of my TNSNAMES which referenced this particular database....

ateolq.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = tonnera)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = tonnera)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = eolq)
)
)

Any help would be appreciated, I am in the process of studying for my OCP exams and want to work from home.

Cheers

Alison