RE: ORA-12514 TNS names could not resolve service name
Thanks for the tip - we just installed 8.1.6 on NT this afternoon and had the problem. Your solution did the trick!!! Laura H. Myers ATT Solutions-ITS [EMAIL PROTECTED] Phone: (336) 698-2375 Fax: (336) 698-2385 -- From: Ruiz, Mary A (CAP, CDI)[SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-12514 TNS names could not resolve service name Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Ruiz, Mary A (CAP, CDI) 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: Myers, Laura H, SITS 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: ORA-12514 TNS names could not resolve service name
Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Ruiz, Mary A (CAP, CDI) 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: ORA-12514 TNS names could not resolve service name
I want to connect using the @service_name -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-12514 TNS names could not resolve service name So you want to connect without the @string system/password as opposed to system/password@orcl? -Original Message- T (Richard) Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Kevin Kostyszyn 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: Cale, Rick T (Richard) 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: ORA-12514 TNS names could not resolve service name
Try TWO_TASK on Unix, LOCAL on NT or ORA_DFLT_HOSTSTR on the NT predecessor. -Original Message- Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L So you want to connect without the @string system/password as opposed to system/password@orcl? -Original Message- T (Richard) Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Kevin Kostyszyn 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: Gogala, Mladen 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: ORA-12514 TNS names could not resolve service name
Don't forget your domain in tnsnames.ora. A serv.= or serv.mydomain.com should work. oli On Thursday 01 February 2001 19:33, [EMAIL PROTECTED] wrote: Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl To: [EMAIL PROTECTED] [EMAIL PROTECTED] -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).