Re: TOAD CONNECTION

From: Sancho <joseharvey_at_my-deja.com>
Date: Mon, 04 Dec 2000 10:03:53 GMT
Message-ID: <90fq68$jo3$1@nnrp1.deja.com>

Hi Murat,
ceck your entry in the tnsnames.ora, this must equal the SID name (murat rather than murat.arslan).

Cheers,

Jose

> Much thanks in advance...
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = murat.arslan)
> (ORACLE_HOME = d:\oracle\ora81)
> (SID_NAME = murat)
> )
> )
>
> and TNSNAMES.ORA are;
>
> MURAT.ARSLAN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = murat.arslan)
> )
> )
>

Should be:

 MURAT.ARSLAN =
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = murat)
     )

   )

--
-=[ Sancho ]=-


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Dec 04 2000 - 04:03:53 CST