Re: Enterprise Manager frustration

Peter - Yep.

• Kurt, as a guideline, use the following
  1. Install Oracle8i into it's own ORACLE_HOME. Set listener.ora and tnsnames.ora. Check that you can connect with SQL*Plus from the ora81 bin directory.
  2. Preferably install OEM onto a separate box - it's difficult to perform node management on the database server when the OEM Server is also on the same node ! If you do install on the same box as Oracle8i, install OEM into a separate ORACLE_HOME. Update the tnsnames.ora in this ORACLE_HOME to point to the database server. Check that you can connect with plus80 from the OEM bin directory.
  3. Then install WebDB into yet another new ORACLE_HOME. Before starting the WebDB installer, go into a DOS window and set a ORACLE_SID variable to point to your 8i database (set ORACLE_SID=xyz). Then run the WebDB installer from this DOS window (i.e with the variable set) by typing orainst from the WebDB CDROM. Note that WebDB will use plus80, and the tnsnames.ora, from your OEM directory for your install (the OEM bin should be the first in your path). WebDB should install correctly. Once installed, change the default DAD (WebDB) to use the connect string for the Oracle8i database.

Complicated I know, but WebDB is an 8.0.5 image, so you need to jump through a few small hoops when installing on the same box as Oracle8i. This will resolved when WebDB moves to the new installer technology used by Oracle8i and OEM 2

Pete Sharman wrote:
>
> Kurt
>
> I don't know a great deal about WebDB, but my understanding (which someone else
> will undoubtedly correct if I'm wrong) is that WebDB runs on 8.0.5, rather than
> 8.1. In that case you will need two ORACLE_HOME's. That may explain why the
> two aren't talking to each other. Can anyone else confirm this?
>
> Pete
>
> Kurt wrote:
>
> > First the bad news:
> >
> > I don't have that information...
> >
> > Next the worse news:
> >
> > My NT Server died (had to reinstall).
> >
> > Now the good news:
> >
> > I had to reinstall my NT server...did a complete format.
> >
> > Now the (new) question. I have received (for testing) the 8i Enterprise
> > Edition, the Enterprise Manager, and Web DB.
> >
> > When I reinstall this stuff, is there a "preferred" order to install
> > everything?
> >
> > I am running IIS. By default, the IIS runs on port 80. Do I install the
> > WebDB on 80 or do I need to use a different port?
> >
> > The last errors I received before the crash was TNS checksumming error. It
> > looks to me as the WebDB and 8i database never connected. When I tried to
> > go to the gateway.htm file, it said my tnsnames and DAD didn't jive. I
> > should probably learn more about the tnsnames.ora and listner files. (can
> > you tell I'm a newby at this?)
> >
> > Any help would be appreciated.
> >
> > Thanks,
> >
> > -=Kurt=-
> >
> > -----Original Message-----
> > From: Pete Sharman <psharman_at_us.oracle.com>
> > Newsgroups: comp.databases.oracle.server
> > Date: Monday, July 12, 1999 10:45 PM
> > Subject: Re: Enterprise Manager frustration
> >
> > >Kurt
> > >
> > >We need more information. What sort of errors are you getting? Without
> > having
> > >those, and the version numbers of the software (I assume you mean OEM2?)
> > it's
> > >very difficult to diagnose or resolve the problem.
> > >
> > >Pete
> > >
> > >Kurt wrote:
> > >
> > >> I have installed the Enterprise Manager for Oracle 8i on an NT sp5
> > server.
> > >>
> > >> Immediately after the install, I have no problems using the EM.
> > >>
> > >> If, for some reason, I need to reboot, the EM server will not start. I
> > have
> > >> tried to bring it up using NT services, and from the command prompt, but
> > it
> > >> will not load.
> > >>
> > >> The 8i database is running fine as is the Listener. I can run the
> > >> individual pieces of the EM (scema, security, etc), but no the EM
> > itsself.
> > >>
> > >> I have tried uninstalling/reinstalling the EM. I have created and
> > deleted
> > >> repositories. I'm running out of ideas and patience!
> > >>
> > >> ...maybe I should go back to Lotus Notes. Hmmmmmm.......
> > >>
> > >> Any ideas???
> > >>
> > >> -=Kurt=-
> > >
> > >--
> > >Regards
> > >
> > >Pete
> > >
> > >
>
> --
> Regards
>
> Pete

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com