Re: Enterprise Manager frustration

Sorry, giving up is not allowed! ;)

Can you send us a copy of your tnsnames.ora, sqlnet.ora and listener.ora to look at? Also, make sure you tell us the connect string you used so we can try and diagnose the problem.

Pete

Kurt wrote:

> OK, OK...I give up! I installed the Oracle8i and ran the SQL*Plus from my
> ORACLE_HOME Bin directory with no problem. I then installed the OEM (one
> the same box, different home). I TRIED to edit the tnsnames.ora file (in
> the OEM-Network-Admin directory) to what I THOUGHT was correct...apparently,
> I was wrong. When I run the plus80 from the OEM Bin directory, I get the
> following error:
>
> ORA-12203: TNS:unable to connect to destination
>
> I'm just not sure what I need to edit on my tnsnames.ora file.
>
> Here's what I have so far:
>
> for 8i:
> Home: ora81
> Global: rusty.amsrv.net
> SID: rusty
> Host: kschwarz
> Port: 1521
> Internal, System, and Sys passwords are still defaulted.
>
> For OEM:
> Home: EntrMgr
>
> Listener, Database, and OEM Server services are all running.
>
> Is it wrong for me to not like .ora files? :-)
>
> Any and all help is GREATLY appreciated !!!!!!!!!!!!!!!!!!!
>
> -=Kurt=-
>
> -----------------------------------------------
>
> Mark Townsend wrote in message <378F6113.4BC56141_at_us.oracle.com>...
> >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
> >Regards,
> >
> >
> >Mark Townsend
> >
> >Senior Product Manager Ph: (650) 633 5764
> >Server Division Fx: (650) 506 7222
> >Oracle Corporation Email: mtownsen_at_us.oracle.com

--
Regards

Pete

Received on Mon Jul 19 1999 - 11:31:44 CDT