Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tns-12545
Some questions for you:
What are you using to try to connect to Oracle?
Are you trying to use SQL*PLUS or and application that uses ODBC?
Is the user who can successfully connect on the same domain as you or
different domain?
Does you connection go through an oracle names server?
Can you post an entry from the sqlnet.log file that shows what happens when
the connection fails?
For starters, back up your tnsnames.ora file, get a copy of the tnsnames.ora from machine that connects and copy to your machine and try to connect. (Never mind that your tnsnames is correct... just try it). Some machines can have multiple copies of tnsnames.ora. Make sure you got the right one.
If the tnsnames has a hostname in the HOST= paramter then try using the IP address of the target machine instead.
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1) <====<<< hostname
(Port = 1521)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 172.16.17.100) <====<<< use IP address instead.
(Port = 1521)
)
__ _ ================================= -o)/ / (_)__ __ ____ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
| Tel: (407) 859-7410 x2708 | =================================Supporter of the coalition for grumpiness where grumpiness is due
-----Original Message-----
Sent: Friday, December 14, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L
hi,
can anybody help me w/ this error:
TNS-12545: Connect failed because target host or object does not exist
this message pops up when i try to login into my nt database .
i've already checked the tnsnames and the entry is correct.
thanks.
Best Regards,
Grace Lim
Suy Sing Comm'l Corp.
(632)-2474134
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: mglim_at_softhome.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: shermanej_at_eccic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Dec 18 2001 - 11:03:38 CST
![]() |
![]() |