Heterogeneous services
Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Heterogeneous services
John, Ensure you have your oracle environment variables properly set (ORACLE_HOME, ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here: $ORACLE_HOME/bin. Hope that helps. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Heterogeneous services
My Variable is set to C:\oracle\product\10.2.0\client_1\BIN That lsnrctl file is not in the Bin Folder. Do know how I can install it? John Kelley Sr IT Analyst 130 Royall Street Canton, MA 02021 Work: 781-737-3564 Cell: 781-915-9063 john.kel...@dunkinbrands.com Soria, Joe jso...@bresnan.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/28/2009 01:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Heterogeneous services John, Ensure you have your oracle environment variables properly set (ORACLE_HOME, ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here: $ORACLE_HOME/bin. Hope that helps. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Heterogeneous services
If you are running Oracle on Windows you can stop and start the Listener from the Control Panel of the machine that Oracle is running on. Fred --Original Message-- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 12:02 PM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK
Re: Heterogeneous services
Try lstnrctl --- On Thu, 5/28/09, John Kelley john.kel...@dunkinbrands.com wrote: From: John Kelley john.kel...@dunkinbrands.com Subject: Heterogeneous services To: arslist@ARSLIST.ORG Date: Thursday, May 28, 2009, 11:02 AM Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Heterogeneous services
Hi, The listener is part of the oracle installation, referred as oracle client. If not installed, you can run the installation and select the client only. In windows you will see it as a service - OracleXETNSListener or similar. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Soria, Joe Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 28, 2009 1:15 PM Subject: Re: Heterogeneous services John, Ensure you have your oracle environment variables properly set (ORACLE_HOME, ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here: $ORACLE_HOME/bin. Hope that helps. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK *This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are