Re: I can't login to OEM now--"SID given in connect descriptor could not be resolved"

From: fish <zuohong.f.yu_at_bigfoot.com>
Date: Sat, 27 Jul 2002 18:59:19 +0800
Message-ID: <ahtu9a$77d$1@mail.cn99.com>

Hi Sybrand,

I couldn't find anything wrong in these two files. Please take a look. SID=local

---

---

# TNSNAMES.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

LOCAL.FISH.HOME.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = local)

    )
  )

EXTPROC_CONNECTION_DATA.FISH.HOME.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

INST1_HTTP.FISH.HOME.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = local)
(PRESENTATION = http://admin)

    )
  )

---

---

# LISTENER.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/8.1.7)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = local)
(ORACLE_HOME = /home/oracle/product/8.1.7)
(SID_NAME = local)

    )
  ) Received on Sat Jul 27 2002 - 05:59:19 CDT