Re:Multiple Listeners for Different Versions - Help Please

--0__=852568F6005352D38f9e8a93df938690918c852568F6005352D3 Content-type: text/plain; charset=us-ascii

Ditto. I got the same advice and it has been working fine for me for years.

-Greg

dgoulet_at_vicr.com_at_fatcity.com on 06/06/2000 10:43:31 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Re:Multiple Listeners for Different Versions - Help Please

I'll go with the advice I got from Oracle on the matter. Use the latest listener for both databases. I use an 8.0.5 listener for 2 8.0.5 instances and
one 7.3.4 instance on the same HP-UX box. Works just great.

____________________Reply Separator____________________
Author: "Maheshwara Rao; L.; Teki" <teki01_at_mediaone.net>
Date:       6/5/00 5:03 PM

Hi

Our set up is as follows:

Platform : Solaris 2.7
Oracle Versions : 8.0.4 & 8.0.6

I need to configure multiple listeners for 8.0.4 and 8.0.6. Could any body send me the copy of a listener.ora which will have multiple listeners to accomodate the two different versions of Oracle running. Do I need to change tnsnames.ora settings?

I will be thankful to your help.

Thanks,

Maheshwara Rao, L., Teki
E Mail : teki01_at_mediaone.net

--
Author: Maheshwara Rao, L., Teki
  INET: teki01_at_mediaone.net

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: ListGuru_at_fatcity.com (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).
--
Author:
  INET: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).


--0__=852568F6005352D38f9e8a93df938690918c852568F6005352D3
Content-type: application/octet-stream; 
	name="$RFC822.eml"
Content-Disposition: attachment; filename="$RFC822.eml"
Content-transfer-encoding: base64

UmVjZWl2ZWQ6IGZyb20gR2F0ZWtlZXBlci4gKFsxOTIuMTY4LjEzLjY5XSkNCiAgICAgICAgICBi
eSBub3Rlc2dhdGUxLm1hbnUuY29tIChMb3R1cyBEb21pbm8gUmVsZWFzZSA1LjAuMykNCiAgICAg
ICAgICB3aXRoIFNNVFAgaWQgMjAwMDA2MDYxMTEzMTMxMjoxODY1NyA7DQogICAgICAgICAgVHVl
LCA2IEp1biAyMDAwIDExOjEzOjEzIC0wNDAwIA0KUmVjZWl2ZWQ6IGZyb20gZmF0Y2l0eS5VVUNQ
ICh1dWNwQGxvY2FsaG9zdCkNCglieSBuZXdzZmVlZC5jdHMuY29tICg4LjkuMy84LjkuMykgd2l0
aCBVVUNQIGlkIElBQTA3MjMzOw0KCVR1ZSwgNiBKdW4gMjAwMCAwODowOTozNSAtMDcwMCAoUERU
KQ0KUmVjZWl2ZWQ6IGJ5IGZhdGNpdHkuY29tICgwNC1NYXktMjAwMC92MS4wZi1iNjkvYmFiKSB2
aWEgVVVDUCBpZCAwMDE3MjYwRTsgVHVlLCAwNiBKdW4gMjAwMCAwNjo0MzozMSAtMDgwMA0KTWVz
c2FnZS1JRDogPEYwMDEuMDAxNzI2MEUuMjAwMDA2MDYwNjQzMzFAZmF0Y2l0eS5jb20+DQpEYXRl
OiBUdWUsIDA2IEp1biAyMDAwIDA2OjQzOjMxIC0wODAwDQpUbzogTXVsdGlwbGUgcmVjaXBpZW50
cyBvZiBsaXN0IE9SQUNMRS1MIDxPUkFDTEUtTEBmYXRjaXR5LmNvbT4NClgtQ29tbWVudDogT3Jh
Y2xlIFJEQk1TIENvbW11bml0eSBGb3J1bQ0KWC1TZW5kZXI6IGRnb3VsZXRAdmljci5jb20NClNl
bmRlcjogcm9vdEBmYXRjaXR5LmNvbQ0KUmVwbHktVG86IE9SQUNMRS1MQGZhdGNpdHkuY29tDQpF
cnJvcnMtVG86IE1MLUVSUk9SU0BmYXRjaXR5LmNvbQ0KRnJvbTogZGdvdWxldEB2aWNyLmNvbQ0K
U3ViamVjdDogUmU6TXVsdGlwbGUgTGlzdGVuZXJzIGZvciBEaWZmZXJlbnQgVmVyc2lvbnMgLSBI
ZWxwIFBsZWFzZQ0KT3JnYW5pemF0aW9uOiBGYXQgQ2l0eSBOZXR3b3JrIFNlcnZpY2VzLCBTYW4g
RGllZ28sIENhbGlmb3JuaWENClgtTGlzdFNlcnZlcjogdjEuMGYsIGJ1aWxkIDY5OyBMaXN0R3Vy
dSAoYykgMTk5Ni0yMDAwIEJydWNlIEEuIEJlcmdtYW4NClByZWNlZGVuY2U6IGJ1bGsNCk1pbWUt
VmVyc2lvbjogMS4wDQpYLU1JTUVUcmFjazogSXRlbWl6ZSBieSBTTVRQIFNlcnZlciBvbiBOb3Rl
c0dhdGUxL01BTlVHSVNUSUNTKFJlbGVhc2UgNS4wLjMgfE1hcmNoIDIxLCAyMDAwKSBhdA0KIDA2
LzA2LzIwMDAgMTE6MTM6MTMgQU0sDQoJU2VyaWFsaXplIGJ5IFJvdXRlciBvbiBOb3Rlc0dhdGUx
L01BTlVHSVNUSUNTKFJlbGVhc2UgNS4wLjMgfE1hcmNoIDIxLCAyMDAwKSBhdA0KIDA2LzA2LzIw
MDAgMTE6MTM6MTQgQU0sDQoJU2VyaWFsaXplIGNvbXBsZXRlIGF0IDA2LzA2LzIwMDAgMTE6MTM6
MTQgQU0NClgtTm90ZXMtSXRlbTogMjI7DQogdHlwZT0zMDA7IG5hbWU9JEhvcHMNClgtTm90ZXMt
SXRlbTogTWVtbzsNCiBuYW1lPUZvcm0NClgtTm90ZXMtSXRlbTogQ049Tm90ZXNHYXRlMS9PPU1B
TlVHSVNUSUNTOw0KIHR5cGU9NTAxOyBmbGFncz00NDsgbmFtZT0kVXBkYXRlZEJ5DQpDb250ZW50
LVRyYW5zZmVyLUVuY29kaW5nOiA3Yml0DQpDb250ZW50LVR5cGU6IHRleHQvcGxhaW47IGNoYXJz
ZXQ9VVMtQVNDSUkNCg0KSSdsbCBnbyB3aXRoIHRoZSBhZHZpY2UgSSBnb3QgZnJvbSBPcmFjbGUg
b24gdGhlIG1hdHRlci4gIFVzZSB0aGUgbGF0ZXN0DQpsaXN0ZW5lciBmb3IgYm90aCBkYXRhYmFz
ZXMuICBJIHVzZSBhbiA4LjAuNSBsaXN0ZW5lciBmb3IgMiA4LjAuNSBpbnN0YW5jZXMgYW5kDQpv
bmUgNy4zLjQgaW5zdGFuY2Ugb24gdGhlIHNhbWUgSFAtVVggYm94LiAgV29ya3MganVzdCBncmVh
dC4NCg0KX19fX19fX19fX19fX19fX19fX19SZXBseSBTZXBhcmF0b3JfX19fX19fX19fX19fX19f
X19fXw0KQXV0aG9yOiAiTWFoZXNod2FyYSBSYW87IEwuOyBUZWtpIiA8dGVraTAxQG1lZGlhb25l
Lm5ldD4NCkRhdGU6ICAgICAgIDYvNS8wMCA1OjAzIFBNDQoNCkhpDQoNCk91ciBzZXQgdXAgaXMg
YXMgZm9sbG93czoNCg0KUGxhdGZvcm0gOiBTb2xhcmlzIDIuNw0KT3JhY2xlIFZlcnNpb25zIDog
OC4wLjQgJiA4LjAuNg0KDQpJIG5lZWQgdG8gY29uZmlndXJlIG11bHRpcGxlIGxpc3RlbmVycyBm
b3IgOC4wLjQgYW5kIDguMC42LiBDb3VsZCBhbnkgYm9keQ0Kc2VuZCBtZSB0aGUgY29weSBvZiBh
IGxpc3RlbmVyLm9yYSB3aGljaCB3aWxsIGhhdmUgbXVsdGlwbGUgbGlzdGVuZXJzIHRvDQphY2Nv
bW9kYXRlIHRoZSB0d28gZGlmZmVyZW50IHZlcnNpb25zIG9mIE9yYWNsZSBydW5uaW5nLiAgRG8g
SSBuZWVkIHRvDQpjaGFuZ2UgdG5zbmFtZXMub3JhIHNldHRpbmdzPw0KDQpJIHdpbGwgYmUgdGhh
bmtmdWwgdG8geW91ciBoZWxwLg0KDQpUaGFua3MsDQoNCk1haGVzaHdhcmEgUmFvLCBMLiwgVGVr
aQ0KRSBNYWlsIDogdGVraTAxQG1lZGlhb25lLm5ldA0KDQotLSANCkF1dGhvcjogTWFoZXNod2Fy
YSBSYW8sIEwuLCBUZWtpDQogIElORVQ6IHRla2kwMUBtZWRpYW9uZS5uZXQNCg0KRmF0IENpdHkg
TmV0d29yayBTZXJ2aWNlcyAgICAtLSAoODU4KSA1MzgtNTA1MSAgRkFYOiAoODU4KSA1MzgtNTA1
MQ0KU2FuIERpZWdvLCBDYWxpZm9ybmlhICAgICAgICAtLSBQdWJsaWMgSW50ZXJuZXQgYWNjZXNz
IC8gTWFpbGluZyBMaXN0cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NClRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9tIHRo
aXMgbWFpbGluZyBsaXN0LCBzZW5kIGFuIEUtTWFpbCBtZXNzYWdlDQp0bzogTGlzdEd1cnVAZmF0
Y2l0eS5jb20gKG5vdGUgRVhBQ1Qgc3BlbGxpbmcgb2YgJ0xpc3RHdXJ1JykgYW5kIGluDQp0aGUg
bWVzc2FnZSBCT0RZLCBpbmNsdWRlIGEgbGluZSBjb250YWluaW5nOiBVTlNVQiBPUkFDTEUtTA0K
KG9yIHRoZSBuYW1lIG9mIG1haWxpbmcgbGlzdCB5b3Ugd2FudCB0byBiZSByZW1vdmVkIGZyb20p
LiAgWW91IG1heQ0KYWxzbyBzZW5kIHRoZSBIRUxQIGNvbW1hbmQgZm9yIG90aGVyIGluZm9ybWF0
aW9uIChsaWtlIHN1YnNjcmliaW5nKS4NCi0tIA0KQXV0aG9yOiANCiAgSU5FVDogZGdvdWxldEB2
aWNyLmNvbQ0KDQpGYXQgQ2l0eSBOZXR3b3JrIFNlcnZpY2VzICAgIC0tICg4NTgpIDUzOC01MDUx
ICBGQVg6ICg4NTgpIDUzOC01MDUxDQpTYW4gRGllZ28sIENhbGlmb3JuaWEgICAgICAgIC0tIFB1
YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzDQotLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KVG8gUkVN
T1ZFIHlvdXJzZWxmIGZyb20gdGhpcyBtYWlsaW5nIGxpc3QsIHNlbmQgYW4gRS1NYWlsIG1lc3Nh
Z2UNCnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlz
dEd1cnUnKSBhbmQgaW4NCnRoZSBtZXNzYWdlIEJPRFksIGluY2x1ZGUgYSBsaW5lIGNvbnRhaW5p
bmc6IFVOU1VCIE9SQUNMRS1MDQoob3IgdGhlIG5hbWUgb2YgbWFpbGluZyBsaXN0IHlvdSB3YW50
IHRvIGJlIHJlbW92ZWQgZnJvbSkuICBZb3UgbWF5DQphbHNvIHNlbmQgdGhlIEhFTFAgY29tbWFu
ZCBmb3Igb3RoZXIgaW5mb3JtYXRpb24gKGxpa2Ugc3Vic2NyaWJpbmcpLg0K

--0__=852568F6005352D38f9e8a93df938690918c852568F6005352D3--




------------------------------

 From: George.Brennan_at_warnermusic.com
 Date: Tue, 6 Jun 2000 15:22:25 GMT
 Subject: RE: Re:RE: Equivalent of Access autonumber

Using a date column will only work if you specify that updates are >1 second apart.

George



> -----Original Message-----

> From: <dgoulet_at_vicr.com> [mailto:dgoulet_at_vicr.com]

> Sent: Tuesday, June 06, 2000 4:10 PM

> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"

> <ORACLE-L_at_fatcity.com>]

> Subject: Re:RE: Equivalent of Access autonumber

> 

> 

> I cannot see where a date field will not work, unless your 

> intentionally

> truncating the date during insert.  We process 100,000 data