Message-Id: <10744.126904@fatcity.com> From: "Michael Ray" Date: Wed, 17 Jan 2001 09:51:35 -0800 Subject: Re: URGENT: ORA-12560 error, More Info --=_AFF4FD46.A2C3AE75 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline According to Metalink 91109.1, prespawn servers are not supported on NT. = Perhaps your listener.ora file has been modified since the last reboot? Make sure you don't have prespawn_max, protocol, pool_size, or timeout = parameters in the SID_DESC sections of the listener.ora file. Michael Ray Oracle DBA TRW, Marshall, IL 217-826-3011 x2438 >>> v.schoen@inplan.de 01/17/01 10:07AM >>> -- WARNING - PRESPAWN_MAX servers have already been started. Volker Sch=F6n E-Mail: mailto:v.schoen@inplan.de http://www.inplan.de -----Urspr=FCngliche Nachricht----- Von: Schoen Volker=20 Gesendet: 17. January 2001 11:56 An: Multiple recipients of list ORACLE-L Betreff: URGENT: ORA-12560 error Hi list, I have a curious problem. I have installed Oracle 7.3.4.5.0 and Oracle 8.1.5 on same NT 4.0 Server, SP5. I have two listeners, one for Oracle 7 and one for Oracle 8. This configuration works fine since 1,5 years, but today, after rebooting the = NT server, I got the following problem: When I start the Oracle 7 instance and listener I can connect one time to the database, but only once. If I restart sqlplus and try to connect the second time to Oracle 7 instance, I get ORA-12560 error. At the NT server I get know error in listener.log, alert.log, event = protocol or system protocol. This is very urgent, cause users are waiting for this instance. TIA Volker Sch=F6n E-Mail: mailto:v.schoen@inplan.de http://www.inplan.de --=_AFF4FD46.A2C3AE75 Content-Type: TEXT/HTML Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="TEXT.htm" PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjkxOS42MzA3IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iRk9O VDogOHB0IE1TIFNhbnMgU2VyaWY7IE1BUkdJTi1MRUZUOiAycHg7IE1BUkdJTi1UT1A6IDJweCI+ DQo8RElWPkFjY29yZGluZyB0byBNZXRhbGluayA5MTEwOS4xLCBwcmVzcGF3biBzZXJ2ZXJzIGFy ZSBub3Qgc3VwcG9ydGVkIG9uIE5ULiANClBlcmhhcHMgeW91ciBsaXN0ZW5lci5vcmEgZmlsZSBo YXMmbmJzcDtiZWVuIG1vZGlmaWVkIHNpbmNlIHRoZSBsYXN0IA0KcmVib290PzwvRElWPg0KPERJ Vj4mbmJzcDs8L0RJVj4NCjxESVY+TWFrZSBzdXJlIHlvdSBkb24ndCBoYXZlIHByZXNwYXduX21h eCwgcHJvdG9jb2wsIHBvb2xfc2l6ZSwgb3IgdGltZW91dCANCnBhcmFtZXRlcnMgaW4gdGhlIFNJ RF9ERVNDIHNlY3Rpb25zIG9mIHRoZSBsaXN0ZW5lci5vcmEgZmlsZS48L0RJVj4NCjxESVY+Jm5i c3A7PC9ESVY+DQo8RElWPk1pY2hhZWwgUmF5PEJSPk9yYWNsZSBEQkE8QlI+VFJXLCBNYXJzaGFs bCwgSUw8QlI+MjE3LTgyNi0zMDExIA0KeDI0Mzg8QlI+PEJSPiZndDsmZ3Q7Jmd0OyB2LnNjaG9l bkBpbnBsYW4uZGUgMDEvMTcvMDEgMTA6MDdBTSANCiZndDsmZ3Q7Jmd0OzxCUj4tJmx0O0VSUk9S Jmd0Oy0gV0FSTklORyAtIFBSRVNQQVdOX01BWCBzZXJ2ZXJzIGhhdmUgYWxyZWFkeSBiZWVuIA0K c3RhcnRlZC48QlI+PEJSPjxCUj5Wb2xrZXIgU2No9m48QlI+RS1NYWlsOiA8QSANCmhyZWY9Im1h aWx0bzp2LnNjaG9lbkBpbnBsYW4uZGUiPm1haWx0bzp2LnNjaG9lbkBpbnBsYW4uZGU8L0E+PEJS PjxBIA0KaHJlZj0iaHR0cDovL3d3dy5pbnBsYW4uZGUiPmh0dHA6Ly93d3cuaW5wbGFuLmRlPC9B PjxCUj48QlI+PEJSPjxCUj4tLS0tLVVyc3By/G5nbGljaGUgDQpOYWNocmljaHQtLS0tLTxCUj5W b246IFNjaG9lbiBWb2xrZXIgPEJSPkdlc2VuZGV0OiAxNy4gSmFudWFyeSAyMDAxIDExOjU2PEJS PkFuOiANCk11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUtTDxCUj5CZXRyZWZmOiBV UkdFTlQ6IE9SQS0xMjU2MCANCmVycm9yPEJSPjxCUj48QlI+SGkgbGlzdCw8QlI+PEJSPkkgaGF2 ZSBhIGN1cmlvdXMgcHJvYmxlbS48QlI+SSBoYXZlIGluc3RhbGxlZCANCk9yYWNsZSA3LjMuNC41 LjAgYW5kIE9yYWNsZSA4LjEuNSBvbiBzYW1lIE5UIDQuMCBTZXJ2ZXIsPEJSPlNQNS4gSSBoYXZl IHR3byANCmxpc3RlbmVycywgb25lIGZvciBPcmFjbGUgNyBhbmQgb25lIGZvciBPcmFjbGUgOC4g VGhpczxCUj5jb25maWd1cmF0aW9uIHdvcmtzIA0KZmluZSBzaW5jZSAxLDUgeWVhcnMsIGJ1dCB0 b2RheSwgYWZ0ZXIgcmVib290aW5nIHRoZSBOVDxCUj5zZXJ2ZXIsIEkgZ290IHRoZSANCmZvbGxv d2luZyBwcm9ibGVtOjxCUj48QlI+V2hlbiBJIHN0YXJ0IHRoZSBPcmFjbGUgNyBpbnN0YW5jZSBh bmQgbGlzdGVuZXIgSSBjYW4gDQpjb25uZWN0IG9uZSB0aW1lIHRvPEJSPnRoZSBkYXRhYmFzZSwg YnV0IG9ubHkgb25jZS4gSWYgSSByZXN0YXJ0IHNxbHBsdXMgYW5kIHRyeSANCnRvIGNvbm5lY3Qg dGhlPEJSPnNlY29uZCB0aW1lIHRvIE9yYWNsZSA3IGluc3RhbmNlLCBJIGdldCBPUkEtMTI1NjAg DQplcnJvci48QlI+PEJSPkF0IHRoZSBOVCBzZXJ2ZXIgSSBnZXQga25vdyBlcnJvciBpbiBsaXN0 ZW5lci5sb2csIGFsZXJ0LmxvZywgDQpldmVudCBwcm90b2NvbDxCUj5vciBzeXN0ZW0gcHJvdG9j b2wuPEJSPjxCUj5UaGlzIGlzIHZlcnkgdXJnZW50LCBjYXVzZSB1c2VycyANCmFyZSB3YWl0aW5n IGZvciB0aGlzIGluc3RhbmNlLjxCUj48QlI+VElBPEJSPjxCUj5Wb2xrZXIgU2No9m48QlI+RS1N YWlsOiA8QSANCmhyZWY9Im1haWx0bzp2LnNjaG9lbkBpbnBsYW4uZGUiPm1haWx0bzp2LnNjaG9l bkBpbnBsYW4uZGU8L0E+PEJSPjxBIA0KaHJlZj0iaHR0cDovL3d3dy5pbnBsYW4uZGUiPmh0dHA6