Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> tnsnames question
I am required by my employer to install RAS on my Windows PC for support
purposes. I also run linux/oracle 8.0.5 at home for OCP studyiing on a
separate PC into which I telnet via ethernet. I installed the 7.3.4 client
software on the home PC, and can connect to the database in the office just
fine, after configuring tnsnames. I can ping my linux box as well as the
server at the office, so I added the designation for that to tnsnames, but I
can't connect I get the following error. Below that is my tnsnames. Is
there something special I have to do connect to v. 8 database with 7 client
tools?
SQL> connect scott/tiger_at_orcl
ERROR: ORA-12203: TNS:unable to connect to destination# workoffice.world =
#at the office
atwork.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.4.1.20)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.4.1.20)
(Port = 1526)
)
#at home
orcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.254)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.254)
(Port = 1526)
)
![]() |
![]() |