Re: Can't expend my DB

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