If this was Oracle-generated you must have put in some unusual values, when
asked. Your net service names currently include the host names. You
probably want ORACLE for the top entry and ORCL for the bottom. Or do a
little more reading about Oracle Net.
"Tong Li" <tongli_at_unagi.cis.upenn.edu> wrote in message
news:ak0vdr$6h3$1_at_netnews.upenn.edu...
> Thanks for your response. I don't have separate tnsnames.ora file but the
> content in my tnsnames.ora is as below.
> # TNSNAMES.ORA Network Configuration File:
> F:\oracle\ora92\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORACLE_TINA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = tina)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = oracle)
> (SERVER = DEDICATED)
> )
> )
>
> ORCL_ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> (SERVER = DEDICATED)
> )
> )
>
>
>
> So there are two databases actually, but I can only see the sencond one
and cannot
> expend it.
> Any solution ? Thanks again!!!
> Tina
>
>
>
>
>
>
> Van Messner (vmessner_at_bestweb.net) wrote:
> : Check to see if you have a separate tnsnames.ora for OEM and add an
entry
> : there if you need it.
>
>
> : "Tong Li" <tongli_at_unagi.cis.upenn.edu> wrote in message
> : news:ak0qpv$mje$2_at_netnews.upenn.edu...
> : >
> : > Hello there,
> : > I'm using Oracle 9.2 on Windows 2000. I could't access my database
from
> : OEM
> : > with
> : > standalone mode. When I tried to expend the database tree as sysdba, I
> : > encountered ORA-12545:Connect failed because target host or object
does
> : not
> : > exit. But I had no trouble to access my DB from sqlplus command line.
> : >
> : > Thanks in advance for any help!
> : >
> : > Tina
>
>
Received on Wed Aug 21 2002 - 18:27:10 CDT
