Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Configuring Oracle 8.1.6 in XP
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 Received on Sat Jan 18 2003 - 03:55:24 CST