Oracle Installation

From: Srikanth Goteti <gsns_at_hotmail.com>
Date: 25 Jun 2002 13:53:57 -0700
Message-ID: <d4e79a08.0206251253.6618bdd0@posting.google.com>

I installed Oracle Release 8.1.5 on Windows NT.

I have tried so many times installing and re-installing but I do not get Net8 services to run properly.

I get the following error when I try to do tnsping

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=sandp2)(PORT=1521)) TNS-12571: TNS:packet writer failure

I am displaying the following files for verification

Listener.ORA
# D:\ORANT\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\orant\NETWORK\ADMIN\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sandp2)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sandp2)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\orant)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = d:\orant)
(SID_NAME = TEST)

    )
  )

file: names.ORA
# D:\ORANT\NETWORK\ADMIN\NAMES.ORA Configuration File:d:\orant\NETWORK\ADMIN\names.ora
# Generated by Oracle Net8 Assistant

NAMES.TRACE_UNIQUE = yes

NAMES.TRACE_LEVEL = user

NAMES.LOG_UNIQUE = true

NAMES.FORWARDING_AVAILABLE = off

NAMES.SERVER_NAME = sandp2

# Save changes done through NAMESCTL??
# Trace parameters
# Logging parameters
# Disable forwarding
# Server information

NAMES.DOMAINS =
  (Domain_List =
    (domain =
(min_ttl = 86400)

    )
    (domain =
(min_ttl = 86400)

    )
  )

NAMES.SAVE_CONFIG_ON_STOP = true

NAMES.ADDRESSES =
(address = (protocol = tcp)(host = sandp2)(port = 1575))

NAMES.FORWARDING_DESIRED = false

file: SQLNET.ORA
# D:\ORANT\NETWORK\ADMIN\SQLNET.ORA Configuration File:d:\orant\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle Net8 Assistant

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SANDP2)(PORT = 1575)) )

SQLNET.EXPIRE_TIME = 0 NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

file:TNSNAMES.ORA
# D:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:d:\orant\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sandp2)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = test)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

Thanks in advance

Srikanth Goteti Received on Tue Jun 25 2002 - 15:53:57 CDT