Re: Oracle error messages

"George" <divined2000_at_hotmail.com> wrote in message news:e480c22a.0110040427.e958a4_at_posting.google.com...
> Can anyone make sense of the following Oracle 8.0.5. error messages. I
> am running Oracle under Windows 2000 Server and am trying to recover a
> database with nothing but a copy of the working files from a previous
> installation.
>
> H:\>lsnrctl80 start listener
>
> LSNRCTL80 for 32-bit Windows: Version 8.0.5.0.0 - Production on
> 04-&#9575;&#9577;&#9560;-01 15:18:
> 30
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Starting tnslsnr80: please wait...
>
> Service OracleTNSListener80 start pending.
> Service OracleTNSListener80 started.
> TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production
> Log messages written to F:\orant\NET80\log\listener.log
> Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc))
> Attempted to listen on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)
> (PORT=1521)(HOST=Ç&#9472;&#9552;)))
> TNS-12545: Connect failed because target host or object does not exist
> TNS-12560: TNS:protocol adapter error
> TNS-00515: Connect failed because target host or object does not
> exist
> 32-bit Windows Error: 1004: Unknown system error

It fails to open the named pipe in the connect string. This is reasonable as Named Pipes is using Netbeui, and Microsoft dropped netbeui in Win2k.
Also you need to use (KEY=<any string>) in conjunction with IPC, not PIPE=

Other than that Oracle didn't certify 8.0.5 for Win2k, as it was desupported more than a year ago.
Please upgrade to 8.1.7 asap.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 12:28:42 CDT