Re: TOAD and Personal Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 02 Mar 2001 18:16:39 +0100
Message-ID: <h6lv9t8oegon1jjncrbkg13dab2l7ejv7q@4ax.com>

On Fri, 2 Mar 2001 09:53:01 -0500, "eleong" <leong_at_strato.net> wrote:

>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
>
>
>
>
>
>
>

Correct listener.ora is

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

TRACE_FILE_LISTENER = LISTENER.trc

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 2481))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = Oracle)
      (ORACLE_HOME = c:\oracle\ora81)
      (SID_NAME = ORCL)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = EXTPROC0)
      (PROGRAM = extproc.exe)
      (SID_NAME = PlsExtproc)

    )
  )

And a correct tnsnames.ora

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

ORACLE1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = NMP)(SERVER = 13382)(PIPE = ORAPIPE))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (ORACLE_HOME = c:\oracle\ora81)

    )
  )

ORACLEIPC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (ORACLE_HOME = c:\oracle\ora81)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

ORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (ORACLE_HOME = c:\oracle\ora81)

    )
  )

#USE_PLUG_AND_PLAY_LISTENER = ON TRACE_DIRECTORY_LISTENER = c:\oracle\ora81\network\admin

Hth

Sybrand Bakker, Oracle DBA Received on Fri Mar 02 2001 - 11:16:39 CST