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 - 04:47:01 CDT
