Configuring Oracle 8.1.6 in XP
Date: Sat, 18 Jan 2003 10:55:38 +0100
Message-ID: <b0b7an$eqr$2_at_titan.bt.es>
Hello,
[Quoted] 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 Received on Sat Jan 18 2003 - 10:55:38 CET