RE: Sseperate external procedure listeneers for 2 SIDS - Correcti
Once you create two separate listeners for each SID, you can start and stop each listener separately from command line lsnrctl start/stop -Original Message- Sent: Thursday, April 12, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Correcti But for each SID I need an external proedure listener that I can start seperately from the standard listener. John > -Original Message- > From: Terry Ball [SMTP:[EMAIL PROTECTED]] > Sent: 12 April 2001 19:21 > To: Multiple recipients of list ORACLE-L > Subject: Re: Sseperate external procedure listeneers for 2 SIDS - > Correction > > We do that by creating a listener for each SID. So listener would look > like: > > LISTENER_SID1 = > (ADDRESS_LIST = > (ADDRESS = > (PROTOCOL = TCP) > (Host = hostname) > (Port = 1521) > ) > ) > STARTUP_WAIT_TIME_LISTENER_SID1 = 0 > CONNECT_TIMEOUT_LISTENER_SID1 = 0 > TRACE_LEVEL_LISTENER_SID1 = OFF > SID_LIST_LISTENER_SID1 = > (SID_LIST = > (SID_DESC = > (SID_NAME = SID1) > (ORACLE_HOME = /opt/app/oracle/product/8.0.6) > (PRESPAWN_MAX = 10) > ) > ) > > LISTENER_SID2 = > (ADDRESS_LIST = > (ADDRESS = > (PROTOCOL = TCP) > (Host = hostname) > (Port = 1526) > ) > ) > STARTUP_WAIT_TIME_LISTENER_SID2 = 0 > CONNECT_TIMEOUT_LISTENER_SID2 = 0 > TRACE_LEVEL_LISTENER_SID2 = OFF > SID_LIST_LISTENER_SID2 = > (SID_LIST = > (SID_DESC = > (SID_NAME = SID2) > (ORACLE_HOME = /opt/app/oracle/product/8.0.6) > (PRESPAWN_MAX = 10) > ) > ) > > > And tnsnames.ora would have entries for both SIDs with the corresponding > port. > > Terry > > John Dunn wrote: > > > Correction > > > > I have 2 SIDS running on my machine. I want to have a seperate external > > procedure listener for each SID. > > > > Can someone tell me what my listener.ora amd tnsnames.ora files should > look > > like? > > > > Oracle is 8.1.7 > > > > John > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Dunn > > 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: Terry Ball > 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: John Dunn 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: Pampati, Kiran 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).
Performance issue
HI, I have a table with 1 million records, If I search for one value of a column it comes very fast and if I do the same query for a different value on the same column it takes more time. I did not understand why it behaves like that. Any ideas.. Thanks kiran -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pampati, Kiran 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: identifying shared memory segments
ipcs -b should give you details of shared memory segments -Original Message- Sent: Wednesday, March 21, 2001 8:02 AM To: Multiple recipients of list ORACLE-L Me too! Thanks,Ruth B. Gramolini ORACLE & DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 21, 2001 10:00 AM > A while back someone posted a method for determining which shared memory segments belonged to an instance. Can someone repost that and CC me? Thanks. > > > - > Do You Yahoo!? > Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Pampati, Kiran 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: Conversion of man (unix) into Txt file
Ignore if it is already answered man ls >ls.txt --kiran -Original Message- Sent: Sunday, March 18, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Hi All, Does anyone know how to convert unix MAN into a text file ? -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chandan 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: Pampati, Kiran 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).