Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news-out.visi.com!petbe.visi.com!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!news.globalcrossing.net!dnews.tpgi.com.au!tpg.com.au!not-for-mail
From: "CW" <calvin_woodno.spam@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Oracle Listener problem
Date: Sat, 9 Aug 2003 13:37:23 +1000
Organization: Global Crossing Internet
Lines: 70
Message-ID: <3f346ca0@dnews.tpgi.com.au>
NNTP-Posting-Host: nnrp1.phx1.gblx.net
X-Trace: node21.cwnet.roc.gblx.net 1060400370 31932 64.214.31.40 (9 Aug 2003 03:39:30 GMT)
X-Complaints-To: abuse@gblx.net
NNTP-Posting-Date: Sat, 9 Aug 2003 03:39:30 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 203.213.56.235
X-Original-Trace: 9 Aug 2003 13:38:08 +1000, 203.213.56.235
Cache-Post-Path: nnrp1.phx1.gblx.net!203.12.160.33
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130397

A word of warning: I am totally new to Oracle, and thus my problem may sound
rudimentary to some of the gurus here.

I have been having trouble installing Oracle 8i Personal Edition on a w2k
server (advanced edition).

After choosing typical installation, everything ran OK until it hit the
optional steps. The installation always became stuck at "Net8 Configuration
Assistant" step with the progress message of "in progress". Attempting to
stop this step elicited no response from the Universal Installer.
Invariably, I would have to exit out of the Universal Installer.

Well, since these are optional configuration steps, I thought I might as
well do it manually. I notice that there is a OracleOraHome80TNSListener
service in the services MMC, except that it is not started. I ran through
the Net8 Configuration Assistant screen by reconfiguring it, and this
service would be started. The only problem is that after I hit next on the
screen where it says whether I want to add another Listener (and I selected
no), the configuration would be stuck as well. I would have to kill jrew.exe
from task manager in order to close that screen. I have also added
additional listeners using the same set of procedures, and I observed that
additional services being added, and started, and configuration screen
getting stuck as per usual.

I thought, ok, the configuration screen is probably buggy. However, seeing
that services are started, I could keep going with manual installation.
Thus, Database Configuration Assistant was the next step. I would choose
typical, and copy from CD as the option of creating a new database.
Everything ran OK, and installation was at 90% complete until I hit the
following error message:

ORA-12560: TNS: protocol adapter error.

Without a database, I can't go any further at all. I would appreciate some
help.

I have pasted in the contents of listener.ora file from the
orahome80\network\admin directory:

# LISTENER.ORA Network Configuration File:
c:\orahome80\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = w2kadv)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\orahome80)
      (PROGRAM = extproc)
    )
  )

I suppose what the configuration assistant actually does is to configure
this ora file. If the net8 configuration assistant is buggy, I can simply
edit this file to fix any problems.

I'd appreciate any help on this and possible other problems I may run into.

Thanks in advance