TOAD and Personal Oracle 8i

From: eleong <leong_at_strato.net>
Date: Fri, 2 Mar 2001 09:53:01 -0500
Message-ID: <QmOn6.340$BU1.71351@e3500-chi1.usenetserver.com>

I am having trouble with TOAD connecting to the sample database installed with Personal Oracle 8i. I can connect to the sample database with SQL*Plus.

The message that I am getting with TOAD is ORA-12541: TNS:no listener.

The only entry in the tnsnames.ora file is for EXTPROC_CONNECTION_DATA, and I am using SCOTT / TIGER or DEMO / DEMO to make my connection.

The following are the contents of my tnsnames.ora and listener.ora files.

---

# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

---

# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:c:\Oracle\Ora81\network\admin\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)

    )
  )

any help would be appreciated.

thanks,

Ernest Received on Fri Mar 02 2001 - 08:53:01 CST