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_at_inplan.de 01/17/01 10:07AM >>>
-<ERROR>- WARNING - PRESPAWN_MAX servers have already been started.

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_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_at_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 Received on Wed Jan 17 2001 - 11:51:35 CST