Re: Configuring Oracle 8.1.6 in XP

Sergio wrote:

> Hello,
>
> I'm trying to configure Listner.ora, tnsnames.ora and sqlnet.ora files:
>
> I'm tired doing changes in these files, and always I get the ORA-12571
> (writer packet
> failure) and ORA-12560 (Protocol adapter error) errors. Please, help!!!
>
> I'm looking for a person who has installed Oracle 8i in a XP platform,
> because maybe, I could get the same configuration in these files
> (Listener.ora, tnsnames.ora and sqlnet.ora).
>
> Thanks in advance,
> Sergio.
>
> # LISTENER.ORA Network Configuration File:
> C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
>
> # Generated by Oracle configuration tools.
>
> LISTENER =
>
> (DESCRIPTION_LIST =
>
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>
> )
>
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = 213.254.88.120)(PORT = 1521))
>
> )
>
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = 213.254.88.120)(PORT = 2481))
>
> (PROTOCOL_STACK =
>
> (PRESENTATION = GIOP)
>
> (SESSION = RAW)
>
> )
>
> )
>
> )
>
> SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (SID_NAME = PLSExtProc)
>
> (ORACLE_HOME = C:\Oracle\Ora81)
>
> (PROGRAM = extproc)
>
> )
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = orcl)
>
> (ORACLE_HOME = C:\Oracle\Ora81)
>
> (SID_NAME = ORCL)
>
> )
>
> )
>
> # TNSNAMES.ORA Network Configuration File:
> C:\Oracle\Ora81\network\admin\tnsnames.ora
>
> # Generated by Oracle configuration tools.
>
> ORCL =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = 213.254.88.120)(PORT = 1521))
>
> )
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = 213.254.88.120)(PORT = 2481))
>
> )
>
> (CONNECT_DATA =
>
> (SERVICE_NAME = ORCL)
>
> )
>
> )
>
> EXTPROC_CONNECTION_DATA =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>
> )
>
> (CONNECT_DATA =
>
> (SID = PLSExtProc)
>
> (PRESENTATION = RO)
>
> )
>
> )
>
> # SQLNET.ORA Network Configuration File:
> C:\Oracle\Ora81\network\admin\sqlnet.ora
>
> # Generated by Oracle configuration tools.
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> Part of the trace.trc file is like following:
>
> ntnans: entry
>
> ntnans: accepting connection on \\.\pipe\EXTPROCipc
>
> ntnans: replacing pipe handle in listen context
>
> ntnans: listening on pipe 248
>
> ntnans: Error: Inconsistent trace parameters line: 987
>
> ntnans: exit
>
> nsopen: transport is open

There may be something wrong with your config files ... I don't have time to dissect them now. But why are you trying to install an outdated unsupported version of Oracle, one with known major bugs, on an XP machine? Which BTW it was never certified to run on.

[Quoted] I'd drop the CD into the microwave for a few seconds of fun and get CDs for 8.1.7 or, preferably, 9.2.

Daniel Morgan Received on Sat Jan 18 2003 - 18:06:14 CET