Oracle Listener problem

From: CW <calvin_woodno.spam_at_hotmail.com>
Date: Sat, 9 Aug 2003 13:37:23 +1000
Message-ID: <3f346ca0@dnews.tpgi.com.au>

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 Received on Fri Aug 08 2003 - 22:37:23 CDT