Re: Oracle Listener problem

Hi Daniel

Thanks for the response, and here is what I have found out.

(1) Yes, w2kadv is the correct netbios name as well as dns name as far as the private tcp/ip network is concerned.

(2) I don't have a tnsnames.ora file in my orahome80\network\admin directory. I do have a sample tnsnames.ora in my orahome80\network\admin\sample directory, as well as in orahome80\hs\admin directory (though these are files have no contents at all). I do have listener.ora as well as sqlnet.ora in the network\admin directory. Tnsping produces the following output:
"TNS Ping Utililty ....blah blah...

Atempting to contact <ADDRESS=<PROTOCOL=TCP><HOST=w2kadv><PORT=1521>> TNS-12541: TNS:no listener

(3) I renamed sqlnet.ora to sqlnet.bak, and reconfigured using Net8 Configuration Assistant (I assume that's what you mean by retrying). The screen still got stuck at the finish step, and no additional sqlnet.ora file was produced.

(4)There is only 1 listener service called OracleOraHome80TNSListener service in the services MMC, and it is up and running. As I mentioned in my original post, if I configure additional listener in the Net8 Configuration Assistant, I will get additional listener service in the Services MMC.

(5) and (6) My database directory is empty other than a oradba.exe and archive directory.

Thanks for the help.

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F35248A.A1517BB8_at_exxesolutions.com...
> 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)
>
>
Received on Sat Aug 09 2003 - 17:48:48 CDT