RE: TNS errors
The Citrix ica calls a program called sams.exe and I don't know how it accesses the db. I haven't tried the console from the remote machine, just the citrix .ica file. More stuff for me to read... Ken -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Saturday, August 09, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: TNS errorsKen, I don't see your connection string in here, but I'm going to guess that it does not include '@TNS_NAME', which is what you will have to do when connecting via a client such as citrix. Remember, you're not really on the console, though it may look like it. Don't know how many times I did this with Terminal Services on Win2k before it finally sunk in. Jared "Ken Hitchcox" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/08/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: TNS errorsHi everyone,Been a very long time since I posted, but finally running into a problem.New system:Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run thePowerbuilder executable on the server, it connects to Oracle just fine.When I try to connect using Citrix (from this machine or a differentmachine) on the same network, I get TNS-12560, When I look at the nmi.log,I see:Fatal NI connect error 12560, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PROGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEMVERSION INFORMATION:TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NTProtocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - ProductionTime: 07-AUG-2003 10:48:22Tracing not turned on.Tns error struct:nr err code: 0ns main err code: 12560TNS-12560: TNS:protocol adapter errorns secondary err code: 0nt main err code: 530TNS-00530: Protocol adapter errornt secondary err code: 2nt OS err code: 0I'm STILL a newbie, you would think that after 5 years of managing my rinkydink database, I'd know something, but...Anyway, can anyone help me to resolve this problem? Yes, I will turntracing on as soon as I figure out how to for DBSNMP.Thanks,Ken HitchcoxPS Hi Rachael C still have DBA101 on my desk.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ken Hitchcox INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: TNS errors
I just wanted to report progress. It was @tns:name that solved this problem. Next step is resolving all the print problems that citrix is know for. Ken -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Saturday, August 09, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: TNS errorsKen, I don't see your connection string in here, but I'm going to guess that it does not include '@TNS_NAME', which is what you will have to do when connecting via a client such as citrix. Remember, you're not really on the console, though it may look like it. Don't know how many times I did this with Terminal Services on Win2k before it finally sunk in. Jared "Ken Hitchcox" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/08/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: TNS errorsHi everyone,Been a very long time since I posted, but finally running into a problem.New system:Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run thePowerbuilder executable on the server, it connects to Oracle just fine.When I try to connect using Citrix (from this machine or a differentmachine) on the same network, I get TNS-12560, When I look at the nmi.log,I see:Fatal NI connect error 12560, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PROGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEMVERSION INFORMATION:TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NTProtocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - ProductionTime: 07-AUG-2003 10:48:22Tracing not turned on.Tns error struct:nr err code: 0ns main err code: 12560TNS-12560: TNS:protocol adapter errorns secondary err code: 0nt main err code: 530TNS-00530: Protocol adapter errornt secondary err code: 2nt OS err code: 0I'm STILL a newbie, you would think that after 5 years of managing my rinkydink database, I'd know something, but...Anyway, can anyone help me to resolve this problem? Yes, I will turntracing on as soon as I figure out how to for DBSNMP.Thanks,Ken HitchcoxPS Hi Rachael C still have DBA101 on my desk.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ken Hitchcox INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: TNS errors
Well now that makes sense. How did I miss that? must be the newbie thing. Thank you, I'll be reading now... Ken -Original Message- Mladen Gogala Sent: Friday, August 08, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Me thinks that you shouldn't be using BEQ adapter. Try with TCP. -- Mladen Gogala Oracle DBA -Original Message- Hitchcox Sent: Friday, August 08, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi everyone, Been a very long time since I posted, but finally running into a problem. New system: Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run the Powerbuilder executable on the server, it connects to Oracle just fine. When I try to connect using Citrix (from this machine or a different machine) on the same network, I get TNS-12560, When I look at the nmi.log, I see: Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS ='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PR OGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 07-AUG-2003 10:48:22 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 2 nt OS err code: 0 I'm STILL a newbie, you would think that after 5 years of managing my rinky dink database, I'd know something, but... Anyway, can anyone help me to resolve this problem? Yes, I will turn tracing on as soon as I figure out how to for DBSNMP. Thanks, Ken Hitchcox PS Hi Rachael C still have DBA101 on my desk. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Hitchcox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ken Hitchcox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 errors
Ken, I don't see your connection string in here, but I'm going to guess that it does not include '@TNS_NAME', which is what you will have to do when connecting via a client such as citrix. Remember, you're not really on the console, though it may look like it. Don't know how many times I did this with Terminal Services on Win2k before it finally sunk in. Jared "Ken Hitchcox" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/08/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: TNS errors Hi everyone, Been a very long time since I posted, but finally running into a problem. New system: Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run the Powerbuilder executable on the server, it connects to Oracle just fine. When I try to connect using Citrix (from this machine or a different machine) on the same network, I get TNS-12560, When I look at the nmi.log, I see: Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS ='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PR OGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 07-AUG-2003 10:48:22 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 2 nt OS err code: 0 I'm STILL a newbie, you would think that after 5 years of managing my rinky dink database, I'd know something, but... Anyway, can anyone help me to resolve this problem? Yes, I will turn tracing on as soon as I figure out how to for DBSNMP. Thanks, Ken Hitchcox PS Hi Rachael C still have DBA101 on my desk. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Hitchcox INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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 errors
Me thinks that you shouldn't be using BEQ adapter. Try with TCP. -- Mladen Gogala Oracle DBA -Original Message- Hitchcox Sent: Friday, August 08, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi everyone, Been a very long time since I posted, but finally running into a problem. New system: Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run the Powerbuilder executable on the server, it connects to Oracle just fine. When I try to connect using Citrix (from this machine or a different machine) on the same network, I get TNS-12560, When I look at the nmi.log, I see: Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS ='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PR OGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 07-AUG-2003 10:48:22 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 2 nt OS err code: 0 I'm STILL a newbie, you would think that after 5 years of managing my rinky dink database, I'd know something, but... Anyway, can anyone help me to resolve this problem? Yes, I will turn tracing on as soon as I figure out how to for DBSNMP. Thanks, Ken Hitchcox PS Hi Rachael C still have DBA101 on my desk. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Hitchcox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).