TOAD doesn't works without services.
So you have to configure Your database in the net8assistant config
--
By
Fabio.
U¿ytkownik "eleong" <leong_at_strato.net> napisa³ w wiadomo¶ci
news:QmOn6.340$BU1.71351_at_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 - 09:10:52 CST
