Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enterprise Manager frustration
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
Received on Sat Jul 17 1999 - 05:28:34 CDT