The problem is with lsnrctl START LISTENER

I just reinstalled Oracle PE 8.1.7, and trying to see if there was anything I could pick up from the installation process.

Upon closer examinatin, Net8 Configuration Assistant actually got stuck when the Universal Install was trying to run "lsnrctl START LISTENER" command.

Once I killed lsnrctl process, the Universal Installer went on to the next step (creating database using Database Configuration Assistant), and of course that failed as usual.

I tried to run lsnrctl manually, and found a few interesting things.

If I stop the listener service (using MMC) before running the command, all I get is "waiting..." from lsnrctl. It never exited from the program (and thus why the Installer hang).

If I started the service beforehand, lsnrctl would complain of the service already running.

When I try to tsnping, I may or may not get a positive response. However, if I stop and restart listener service from MMC, tnsping definitely would work.

Thus, it appears to me that lsnrctl is the culprit. "CW" <calvin_woodno.spam_at_hotmail.com> wrote in message news:3f37664c_at_dnews.tpgi.com.au...
> Still no luck trying to create a DB using Database Configuration
Assistant.
>
> "CW" <calvin_woodno.spam_at_hotmail.com> wrote in message
> news:3f357a81_at_dnews.tpgi.com.au...
> > 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 Mon Aug 11 2003 - 08:36:52 CDT