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