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) ) ) (CONNECT_DATA = (SID = SID1) ) ) Example1.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 172.16.17.100) use IP address instead. (Port = 1521) ) ) (CONNECT_DATA = (SID = SID1) ) ) __ _ = -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: tns-12545
wat do u mean by that the executable for the server exists (perhaps oracle is missing.) i was able to ping the address and other user can login except for me... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 16, 2001 1:15 AM 0:28-sherlock:ts01:jkstill-4 oerr tns 12545 12545, 0, Connect failed because target host or object does not exist // *Cause: The address specified is not valid, or the program being // connected to does not exist. // *Action: Ensure the ADDRESS parameters have been entered correctly; the // most likely incorrect parameter is the node name. Ensure that the // executable for the server exists (perhaps oracle is missing.) // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the // host name to a numeric IP address and try again. [ /home/jkstill/tmp ] 9:15-sherlock:ts01:jkstill-4 The error message indicates that your tnsnames.ora is in all likelihood incorrect. If you post the listener.ora from the server and the relevant portion of the tnsnames.ora file, someone will probably be able to point it out to you. Jared On Friday 14 December 2001 18:20, grace wrote: 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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: tns-12545
0:28-sherlock:ts01:jkstill-4 oerr tns 12545 12545, 0, Connect failed because target host or object does not exist // *Cause: The address specified is not valid, or the program being // connected to does not exist. // *Action: Ensure the ADDRESS parameters have been entered correctly; the // most likely incorrect parameter is the node name. Ensure that the // executable for the server exists (perhaps oracle is missing.) // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the // host name to a numeric IP address and try again. [ /home/jkstill/tmp ] 9:15-sherlock:ts01:jkstill-4 The error message indicates that your tnsnames.ora is in all likelihood incorrect. If you post the listener.ora from the server and the relevant portion of the tnsnames.ora file, someone will probably be able to point it out to you. Jared On Friday 14 December 2001 18:20, grace wrote: 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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
