Re: ARS+Oracle InstantClient information
Well, it turns out the problems were a configuration thing on my end. I removed our sqlnet.ora and was able to connect. So... sorry for dragging this through the mud for everyone. Final verdict, instantclient 10.2.0.2.0 connects just fine with everything (9i, 10g, 10g RAC etc.) -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Tony Worthington/Corp/Kohls 02/07/2007 01:07 PM To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Well... the quick version is... We use 10.2.0.3.0 instantclient to connect to 9.2.0.7.0 instance no problemo. Our Remedy server is running with this now. I can't get same 10.2.0.3.0 instantclient to connect to 10.2.0.1.0 RAC cluster, but the 10.2.0.1.0 fat client works. I wonder if there is an old 10.2.0.1.0 instanclient... This is an Oracle thing, not a Remedy thing. -t -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Axton.. Me and Tony were just discussing this.. Hopefully Tony will figure this out.. but he has just figured out it works with one scenario, but not another.. So I am guessing.. Configuration issues are too mind boggling.. and thus we (remedy) just decided .. Fat client only... I will wait for Tony's Answeres.. FYI On 2/1/07, Axton [EMAIL PROTECTED] wrote: ** I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent
Re: ARS+Oracle InstantClient information
Axton.. Me and Tony were just discussing this.. Hopefully Tony will figure this out.. but he has just figured out it works with one scenario, but not another.. So I am guessing.. Configuration issues are too mind boggling.. and thus we (remedy) just decided .. Fat client only... I will wait for Tony's Answeres.. FYI On 2/1/07, Axton [EMAIL PROTECTED] wrote: ** I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE
Re: ARS+Oracle InstantClient information
you would still have to DST patch the oracle Client as well .. though. have you looked at the INSANE documentation from Oracle on the DST patch.. I think it is ridiculous On 2/7/07, Tony Worthington [EMAIL PROTECTED] wrote: Well... the quick version is... We use 10.2.0.3.0 instantclient to connect to 9.2.0.7.0 instance no problemo. Our Remedy server is running with this now. I can't get same 10.2.0.3.0 instantclient to connect to 10.2.0.1.0 RAC cluster, but the 10.2.0.1.0 fat client works. I wonder if there is an old 10.2.0.1.0 instanclient... This is an Oracle thing, not a Remedy thing. -t -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Axton.. Me and Tony were just discussing this.. Hopefully Tony will figure this out.. but he has just figured out it works with one scenario, but not another.. So I am guessing.. Configuration issues are too mind boggling.. and thus we (remedy) just decided .. Fat client only... I will wait for Tony's Answeres.. FYI On 2/1/07, Axton [EMAIL PROTECTED] wrote: ** I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including
ARS+Oracle InstantClient information
I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS+Oracle InstantClient information
Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS+Oracle InstantClient information
Reduced maintenance and storage. No X session required to install. No extra fluff is installed. Axton Grams On 2/1/07, Bruce Scott [EMAIL PROTECTED] wrote: Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS+Oracle InstantClient information
Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS+Oracle InstantClient information
Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS+Oracle InstantClient information
I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent
Re: ARS+Oracle InstantClient information
I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created
