Re: Oracle Listener problem

CW wrote:

> 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

Perform the following steps.

1. in c:\winnt\system32 ping w2kadv and see if that is truly the name of your machine.
2. in c:\oracle\ora81\bin tnsping the name of the database as identified in the tnsnames.ora file
3. if this doesn't work rename sqlnet.ora to sqlnet.bak and try again
4. go into the control panel services and see if there are services similar to the following: Oracle<SID name>Listener OracleService<SID name> if these services are not set to automatic and started ... change the setting and start them
5. go to c:\oracle\ora81\database and see if a file named something like PWD<SID name>.ora exists
6. in the same directory look for init<SID name>.ora

Report back what you find.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)