Ahh, you're experiencing the "advantage" of using multiple Oracle Homes.
What Oracle fails to tell you in any documentation (maybe because they
didn't test this well) is that every Net8 configuration you make in the
actual database home, you have to duplicate in the OEM (and other) home(s).
Bascially, this means that you pretty much have to copy over the
tnsnames.ora and sqlnet.ora files from one home to another. You'd think
they would've thought of this, but then again, you'd think they would've
tested it too.
<ajmayo_at_my-deja.com> wrote in message news:86n3s7$djb$1_at_nnrp1.deja.com...
> In article <5A3i4.39985$475.1036423_at_news4.giganews.com>,
> "Mike Carter" <mike_at_delriotech.com> wrote:
> > That's exactly my point. Oracle's GUI is useless.
>
> [snip]
> Well, worse than that. I had Oracle 8.0.5 up on NT4 on my other laptop
> and decided to download 8i for NT. Installed it and found that Schema
> manager, security manager etc. had disappeared. So I downloaded Oracle
> Enterprise Manager for 8i and installed that. The tools are there but
> no way can I get them to connect to my main Oracle instance.
>
> In fact after installing OEM the Oracle TNS listener decided it wasn't
> willing to accept requests any more, so even ODBC connectivity failed.
> If I purge OEM and Oracle 8i, then just reinstall Oracle 8i, all is
> well, but then reinstalling OEM roaches it again. I am damned if I know
> what I am doing wrong but I am just doing a standard install. Why won't
> it work (and if Larry thinks this competes with SQL Server 7, may I beg
> to differ).
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 26 2000 - 11:33:52 CST
